University of Colorado Boulder - Design and Build a Data Warehouse for Business Intelligence Implementation
- Offered byCoursera
Design and Build a Data Warehouse for Business Intelligence Implementation at Coursera Overview
Duration | 13 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Design and Build a Data Warehouse for Business Intelligence Implementation at Coursera Highlights
- Shareable Certificate Earn a Certificate upon completion
- 100% online Start instantly and learn at your own schedule.
- Course 5 of 5 in the Data Warehousing for Business Intelligence Specialization
- Flexible deadlines Reset deadlines in accordance to your schedule.
- Approx. 13 hours to complete
- English Subtitles: Arabic, French, Portuguese (European), Italian, Vietnamese, German, Russian, English, Spanish
Design and Build a Data Warehouse for Business Intelligence Implementation at Coursera Course details
- 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. For data integration workflows and analytical queries, you can use either Oracle or PostgreSQL. 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.
Design and Build a Data Warehouse for Business Intelligence Implementation at Coursera Curriculum
Course Overview
Course introduction
Course topics and assignments video lesson
Executive interview
Slides for lesson 1
Slides for lesson 2
Slides for lesson 3
Background on CPI Card Group
Overview of software requirements
PostgreSQL Installation
Oracle database server installation
Pentaho Data Integration installation
Microstrategy Desktop installation
Database diagramming tools
Data Warehouse Design
Executive interview
Slides for lesson 1
Data warehouse design background
Documents for the module 2 assignment
Documents to review after the assignment
Data Integration
Executive interview
Executive interview
Executive interview
Slides for lesson 1
Slides for lesson 2
Slides for lesson 3
Data integration background
Documents for the module 3 assignment
Extra transformation examples
Practice Quiz for module 3 assignment-Test DW
Quiz for module 3 assignment-Production DW
Analytical Queries and Summary Data Management
Executive Interview with Kellyn Gorman of Oracle
Slides for lesson 1
Documents for the module 4 assignment
Solutions to challenge problems
Data Visualization and Dashboard Design Requirements
Executive Interview with Matthew Caton of Data Source Consulting
Executive Interview with Tyler Wilson on BI Platform Capabilities at CPI Card Group
Slides for executive interview with Matthew Caton
Capstone Project Data Visualizations and Dashboard Design Requirements
Earlier Assignments from Course 4
Q & A and Error Knowledge base
Wrap Up and Project Submission
Executive Interview with James Gualke on the State of BI Maturity and Strategy at PDC Energy
Course conclusion video lecture
Background Information on Data Visualization and Dashboard Design
Design and Build a Data Warehouse for Business Intelligence Implementation at Coursera Admission Process
Important Dates
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Data ScienceData Science BasicsData ExplorationDesign and Build a Data Warehouse for Business Intelligence Implementation