
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.
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.
Skills You Will Gain
- Data Warehousing
- Microstrategy
- Data Warehouse
- SQL
Get more details
Visit official programme websiteProgramme Structure
Courses included:
- Course Overview
- 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 official programme websiteKey information
Duration
- Part-time
- 1 months
Start dates & application deadlines
Language
Delivered
Disciplines
Industrial Design Data Science & Big Data View 25 other Short Courses in Industrial Design in United StatesExplore more key information
Visit official programme websiteAcademic 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.
Make sure you meet all requirements
Visit official programme websiteTuition Fee
-
International
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 1 months. -
National
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 1 months.
You can choose from hundreds of free courses, or get a degree or certificate at a breakthrough price. You can now select Coursera Plus, an annual subscription that provides unlimited access.
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.
Studyportals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.