Online Course – Google Certified Professional Internship in Data Design and Operational Business Intelligence, University of California, Irvine

Business intelligence solutions to improve decision-making in an organization. Discover various techniques for modeling and manipulating data to optimize business processes.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת בעיצוב נתונים ובינה עסקית תפעולית של Google

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Relational databases
  • Data storage
  • Descriptive statistics
  • Data mining
  • Visual analysis
  • Relational database design
  • Data manipulation using extract/transform/load (ETL) processes
  • Gain actionable insights through data analysis
  • Data-driven decision support
  • Data display
  • Hands-on experience with real business intelligence tools
  • Convert business data into an interactive visual dashboard

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Database Administrator
  • BI developer
  • Business Intelligence Analyst
  • Data mining expert
  • Visual Data Analyst
  • Data Engineer
  • Information Project Manager
  • Information Technology Consultant
  • Data Solutions Developer

Internship – 3-course course series

The goal of this specialization is to provide a comprehensive and holistic view of business intelligence and supporting technologies, including:

  • Relational databases
  • Data storage
  • Descriptive statistics
  • Data mining
  • Visual analysis

In this series of courses, you will explore:

  • Relational database design
  • Data manipulation using extract/transform/load (ETL) processes
  • Gain actionable insights through data analysis
  • Data-driven decision support
  • Data display

You will also gain practical experience with real business intelligence tools.

Hands-on Learning Project

In each module, students will take part in an authentic assessment of the module’s concepts and skills. At the end of the internship, students will apply their new skills by converting business data into an interactive visual dashboard.

Details of the courses that make up the specialization

The nature of data and relational database design

Course 1

Duration: 6 hours

Rating: 4.5 (95 ratings)

Course Details

  • Create an ERD showing progression from conceptual to logical to physical design
  • Conduct basic descriptive statistical analysis and explain the findings
  • Write SQL scripts to create a database and related tables

Skills you will gain

  • Business Intelligence
  • Basic descriptive statistics
  • SQL Overview
  • Statistical analysis
  • Relational database

Data warehouses and business intelligence

Course 2

Duration: 6 hours

Rating: 4.5 (104 ratings)

Course Details

  • Explaining different data warehouse architectures and multidimensional data models
  • Develop predictive data mining models, including classification and estimation models
  • Develop models for explanatory data mining, including clustering and association models

Skills you will gain

  • Data clustering algorithms
  • Mining data for clusters and associations
  • Data Warehouses
  • Multidimensional model
  • Data mining for prediction and explanation

Business Intelligence and Visual Analytics

Course 3

Duration: 12 hours

Rating: 4.1 (27 ratings)

Course Details

  • Identify best practices for building data visualizations
  • Developing visual skills in working with data using SAS Viya
  • Explain advanced topics in business intelligence and data warehousing, such as cloud architecture, automation, and machine learning

Skills you will gain

  • Business Intelligence
  • Data Warehouses
  • Data visualizations
  • SAS Visual Analytics
  • SAS Viya

Related products