
Overview
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 Design and Build a Data Warehouse for Business Intelligence Implementation course offered by Coursera in partnership with University of Colorado System, 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.
Key facts
- 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.
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
Get more details
Visit programme websiteProgramme Structure
Courses include:
- Data Warehouse Design
- Data Integration
- Analytical Queries and Summary Data Management
- Data Visualization and Dashboard Design Requirements
- Wrap Up and Project Submission
Check out the full curriculum
Visit programme websiteKey information
Duration
- Part-time
- 21 days
- 10 hrs/week
Start dates & application deadlines
Language
Delivered
Campus Location
- Mountain View, United States
Disciplines
Industrial Design Business Intelligence Data Science & Big Data View 14 other Short Courses in Industrial Design in United StatesExplore more key information
Visit programme websiteWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- To obtain additional information about the program, we kindly suggest that you visit the programme website, where you can find further details and relevant resources.
Make sure you meet all requirements
Visit programme websiteTuition Fee
-
International
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 21 days. -
National
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 21 days.
- Coursera Plus: Subscribe to build job-ready skills from world-class institutions.
- $59/month, cancel anytime or $399/year with 14-day money-back guarantee
Funding
Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project.