The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you’ll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence platform to create dashboards and visualizations.
Design and Build a Data Warehouse for Business Intelligence Implementation
This course is part of Data Warehousing for Business Intelligence Specialization
Instructors: Michael Mannino
Sponsored by Louisiana Workforce Commission
13,470 already enrolled
(289 reviews)
Details to know
Add to your LinkedIn profile
5 assignments
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 6 modules in this course
Module 1 introduces the objectives and topics in the course and provides background on the case and software requirements. The capstone course is organized around a realistic case study based on the business situation faced by CPI Card Group in 2015.
What's included
3 videos9 readings
Module 2 presents the requirements of the first part of the case study involving data warehouse design. To provide a context for the case study, you can listen to an executive interview with a CPI Card Group executive.
What's included
1 video4 readings1 assignment
Module 3 presents requirements for the second part of the case study involving data integration. To provide a context for the case study, you can listen to executive interviews with executives from CPI Card Group, First Bank, and Pinnacol Assurance.
What's included
3 videos7 readings3 assignments
Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management.
What's included
1 video4 readings1 assignment
This module continues on the top job responsibilities of BI analysts by focusing on creating data visualizations and dashboards. You will first learn the importance of data visualization and different types of data that can be visually represented. You will then learn about the types of basic and composite charts. This will help you to determine which visualization is most effective to display data for a given data set and to identify best practices for designing data visualizations. In lesson 3, you will learn the common characteristics of a dashboard, the types of dashboards, and the list of attributes of metrics usually included in dashboards. Finally, in lesson 3, you will learn the guidelines for designing a dashboard and the common pitfalls of dashboard design. You will need to use MicroStrategy Desktop Visual Insight to design a dashboard for a Financial Services company in a peer-evaluated exercise.
What's included
2 videos4 readings
This is an extension of Module 5. The peer assessment from module 5 is moved to module 6 to give you more time completing the assignments in prior modules as well as for you to do your peer assessment in this module.
What's included
2 videos1 reading1 peer review
Instructors
Offered by
Why people choose Coursera for their career
Learner reviews
289 reviews
- 5 stars
73.79%
- 4 stars
20%
- 3 stars
2.41%
- 2 stars
1.03%
- 1 star
2.75%
Showing 3 of 289
Reviewed on Jun 27, 2023
Good course. This course teaches you to connect data sources to Microstrategy, wrangle and prepare the data for designing visualizations and building dashboards and tell a story with data.
Reviewed on May 24, 2016
Excellent course..provides hands-on experience on designing a data warehouse for BI implementation
Reviewed on Feb 11, 2017
Very useful,I will Recommend this course to my fellow mates .
Recommended if you're interested in Data Science
University of California, Irvine
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy