Data Warehousing and Business Intelligence
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Warehousing and Business Intelligence
This course is part of Database Design and Operational Business Intelligence Specialization
Instructor: Tim Carrington
7,866 already enrolled
Included with
Ask Coursera
131 reviews
Recommended experience
131 reviews
Recommended experience
What you'll 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'll gain
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 4 modules in this course
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.
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.
What's included
7 readings1 assignment1 discussion prompt
7 readings•Total 35 minutes
- Need for Data Warehousing•5 minutes
- Data Warehousing Architectures•5 minutes
- Extract, Transform, Load (ETL)•5 minutes
- Data Marts•5 minutes
- Operational Data Stores•5 minutes
- Data Warehousing in the Cloud•5 minutes
- Supplemental Resources•5 minutes
1 assignment•Total 30 minutes
- Module 1 Knowledge Check•30 minutes
1 discussion prompt•Total 30 minutes
- Activity•30 minutes
Welcome to Module 2, Multidimensional Modeling for Data Warehousing. In this module, we will go over data modeling for data warehousing. We will also learn the steps needed to construct a multidimensional data model and differentiate between star schema and snowflake schema. These will be practiced through a short quiz. Finally, we will create a normalized snowflake schema in our activity.
What's included
6 readings1 assignment1 discussion prompt
6 readings•Total 50 minutes
- Data Modeling for Data Warehousing•5 minutes
- Multidimensional Data Modeling•5 minutes
- Star Schema•5 minutes
- Snowflake Schema•5 minutes
- NoSQL, Big Data, Data Lakes, and Data Warehousing•10 minutes
- Supplemental Resources•20 minutes
1 assignment•Total 30 minutes
- Module 2 Knowledge Check•30 minutes
1 discussion prompt•Total 30 minutes
- Activity•30 minutes
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.
What's included
5 readings1 assignment1 discussion prompt
5 readings•Total 35 minutes
- Overview of Data Mining for BI•5 minutes
- Data Mining Process•5 minutes
- Data Mining Methods•5 minutes
- Data Mining Algorithms for Predictive Modeling•10 minutes
- Supplemental Resources•10 minutes
1 assignment•Total 30 minutes
- Module 3 Knowledge Check•30 minutes
1 discussion prompt•Total 30 minutes
- Activity•30 minutes
Welcome to Module 4, Data Mining for Clustering and Association. In this module, we will go over unsupervised data mining for explanatory modeling. We will also learn the definitions for clustering and segmentation, K-means clustering, association, and market basket analysis and practice these through a short quiz. Finally we will practice identifying clusters in a dataset through our activity.
What's included
4 readings1 assignment1 discussion prompt
4 readings•Total 35 minutes
- Unsupervised Data Mining for Explanatory Modeling•5 minutes
- Clustering and Segmentation•5 minutes
- Association and Market Basket Analysis•5 minutes
- Supplemental Resources•20 minutes
1 assignment•Total 30 minutes
- Module 4 Knowledge Check•30 minutes
1 discussion prompt•Total 30 minutes
- Dataset Clustering•30 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructor
Offered by
Explore more from Data Management
- Status: Free Trial
Course
- Status: Free TrialU
Universidad Nacional Autónoma de México
Course
- Status: Free TrialU
University of Colorado System
Course
- Status: PreviewN
Northeastern University
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
72.51%
- 4 stars
18.32%
- 3 stars
3.81%
- 2 stars
3.05%
- 1 star
2.29%
Showing 3 of 131
Reviewed on Jan 17, 2023
very simple and straight forward course. Ideal for beginners .
Reviewed on Sep 30, 2022
It is Basic course of Date warehousing and learning, which is very much usefull for Begginers.
Reviewed on Aug 27, 2022
Well put together, a concentrated review of the essentials!
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.
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.
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
Financial aid available,
