Design and Build a Data Warehouse for Business Intelligence Implementation
€0, aangeboden door Coursera
About this course: 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. In the first part of the capstone course, you’ll be introduced to a medium-sized firm, learning about their data warehouse and business intelligence requirements and existing data sources. You’ll first architect a warehouse schema and dimensional model for a small data warehouse. You’ll then create data integration workflows using Pentaho Data Integration to refresh your data warehouse. Next, you’ll write SQL statements for analytical query requirements and create materialized views to support summary data management. Finally, you will use MicroStrategy OLAP capabilities to gain insights into your data warehouse. In the completed project, you’ll have built a small data warehouse containing a schema design, data integration workflows, analytical queries, materialized views, dashboards and visualizations that you’ll be proud to show to your current and prospective employers.
Created by:Â Â Â University of Colorado System
Taught by:Â Â Â Â Michael Mannino, Associate Professor
Business School, University of Colorado Denver
Taught by:Â Â Â Â Jahangir Karimi, Professor
Information Systems University of Colorado Denver
Basic Info
Course 5 of 5 in the Data Warehousing for Business Intelligence Specialization.
Commitment
6 weeks of study, 3-5 hours/week
Language
English
How To Pass
Pass all graded assignments to complete the course.
User Ratings
4.6 stars
Average User Rating 4.6See all 10 reviews
Course 5 of Specialization
Harness Business Data. Build a fully-optimized business data warehouse in five courses.
Data Warehousing for Business Intelligence
University of Colorado System
Learn More
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from your peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
About University of Colorado System
The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond.
Syllabus
WEEK 1
Course Overview
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. Â
3 videos, 9 readings
expand
WEEK 2
Data Warehouse Design
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.Â
1 video, 4 readings
expand
Graded: Data warehouse design assignment
WEEK 3
Data Integration
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.Â
3 videos, 5 readings, 1 reading
expand
Graded: Assignment for module 3
WEEK 4
Analytical Queries and Summary Data Management
Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management. Â
1 video, 3 readings
expand
Graded: Analytical Query Assignemnt
WEEK 5
Data Visualization and Dashboard Design Requirements
Module 5 presents the data visualization and dashboard design requirements for the fourth part of the case study. Â
2 videos, 4 readings
expand
WEEK 6
Wrap Up and Project Submission
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.Â
2 videos, 1 reading
expand
Graded: Data Visualization and Dashboard Design Assignment