This course is part of the Database Design and Operational Business Intelligence Specialization

4.5
stars
65 ratings

Tim Carrington

2,516 already enrolled

Offered By

Database Design and Operational Business Intelligence SpecializationUniversity of California, Irvine

About this Course

8,021 recent views

This course builds on “The Nature of Data and Relational Database Design” to extend the process of capturing and manipulating data through data warehousing and data mining. Once the transactional data is processed through ETL (Extract, Transform, Load), it is then stored in a data warehouse for use in managerial decision making. Data mining is one of the key enablers in the process of converting data stored in a data warehouse into actionable insight for better and faster decision making. 
By the end of this course, students will be able to explain data warehousing and how it is used for business intelligence, explain different data warehousing architectures and multidimensional data modeling, and develop predictive data mining models, including classification and estimation models. IN addition, students will be able to develop explanatory data mining models, including clustering and association models.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 3 in the

Database Design and Operational Business Intelligence Specialization

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approx. 7 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

Explain different data warehousing architectures and multidimensional data modeling
Develop predictive data mining models, including classification and estimation models
Develop explanatory data mining models, including clustering and association models

Skills you will gain

Data Mining for Clustering and Association
Data Clustering Algorithms
Data Warehousing
Multidimensional Modeling
Data Mining for Prediction and Explanation

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 2 of 3 in the

Database Design and Operational Business Intelligence Specialization

Beginner Level

No experience in BI or database needed. Experience with at least one programming language is recommended.

Approx. 7 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.53/5 (13 Ratings)

Tim Carrington

12,479 Learners

6 Courses

Offered by

University of California, Irvine

Since 1965, the University of California, Irvine has combined the strengths of a major research university with the bounty of an incomparable Southern California location. UCI’s unyielding commitment to rigorous academics, cutting-edge research, and leadership and character development makes the campus a driving force for innovation and discovery that serves our local, national and global communities in many ways.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week

Week 1

2 hours to complete

Overview of Data Warehousing

Welcome to Module 1, Overview of Data Warehousing. In this module, we will overview data warehousing and data warehousing architectures. We will also define the Extract, Transform, Load (ETL) process as well as touch on data warehousing in the cloud and practice these through a short quiz. Finally, in our activity we will differentiate between the Kimball and Inmon design approaches for data warehouse architecture.

2 hours to complete

7 readings

Week

Week 2

2 hours to complete

Multidimensional Modeling for Data Warehousing

2 hours to complete

6 readings

Week

Week 3

2 hours to complete

Data Mining for Prediction and Explanation

Welcome to Module 3, Data Mining for Prediction and Explanation. In this module, we will overview the data mining process and data mining methods. We will also identify the steps in a data mining process and differentiate between data mining methods. We will practice identifying these through a short quiz. In our activity, we will also select what data mining methods are best for a particular data set.

2 hours to complete

5 readings

Week

Week 4

2 hours to complete

Data Mining for Clustering and Association

2 hours to complete

4 readings

Reviews

4.5

15 reviews

5 stars
69.23%
4 stars
18.46%
3 stars
4.61%
2 stars
4.61%
1 star
3.07%

TOP REVIEWS FROM DATA WAREHOUSING AND BUSINESS INTELLIGENCE

by HAJan 17, 2023

very simple and straight forward course. Ideal for beginners .

by JAMar 9, 2022

Managing and organization of data is very important in every organization, so data warehousing help to organise data for easy access and understanding

by SSFeb 19, 2022

This course is an excellent and simple introduction for DWH which is easy to grasp and follow.

by ANNov 29, 2022

There could have been videos to make everything more clear and assignments too!

View all reviews

About the Database Design and Operational Business Intelligence Specialization

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.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Data Warehousing and Business Intelligence

About this Course

What you will learn

Skills you will gain