We may earn an affiliate commission when you visit our partners.

Database Design and Operational Business Intelligence

The goal of this specialization is to provide a comprehensive and holistic view of business intelligence and its enabling technologies, including relational databases, data warehousing, descriptive statistics, data mining, and visual analytics. Through this series of courses, you will explore relational database design, data manipulation through Extract/Transform/Load (ETL), gaining actionable insight through data analytics, data-based decision support, data visualization, and practical, hands-on experience with real-world business intelligence tools.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Help others find Specialization from Coursera by sharing it with your friends and followers:

Facebook

Copy Link

What's inside

Three courses

The Nature of Data and Relational Database Design

(0 hours)

This course provides an overview of data, data types, database design, and data manipulation in databases using SQL. By the end of this course, students will be able to define business intelligence, conduct basic descriptive statistical analysis, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD, and write SQL scripts to create a database and associated tables.

View more details for this course

Data Warehousing and Business Intelligence

(0 hours)

This course extends "The Nature of Data and Relational Database Design" to cover data warehousing and data mining. Once transactional data is processed through ETL (Extract, Transform, Load), it is stored in a data warehouse for managerial decision making. Data mining converts data into actionable insight for better and faster decision making.

View more details for this course

Business Intelligence and Visual Analytics

(0 hours)

Building on “Data Warehousing and Business Intelligence,” this course focuses on data visualization and visual analytics. It covers what data visualization is and what type of visualization is good for a given purpose. The course then dives into development of practical skills and knowledge about visual analytics by way of using one of the most popular visual analytics tools: SAS Viya, a cloud-based analytics platform.

View more details for this course

Learning objectives

Develop an in-depth understanding of data warehouse design and data manipulation
Describe what business intelligence (bi) is and what it does

Gain hands-on experience in sql coding, data mining models, and data visualization

Develop an in-depth understanding of data warehouse design and data manipulation
Describe what business intelligence (bi) is and what it does
Gain hands-on experience in sql coding, data mining models, and data visualization

Save this collection

Save Database Design and Operational Business Intelligence to your list so you can find it easily later:

Save

Time

16 hours

Level

Introductory

Via

Coursera

Institution

University of California, Irvine

Instructor

Tim Carrington

Level

Introductory

Share Specialization from Coursera

Facebook

Link

Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.