Design and Build a Data Warehouse for Business Intelligence Implementation - University of Colorado SystemCoursera
What you'll learn on the 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.Online learning plays a key role in lifelong learning. In fact, a recent report by the United States Department of Education found that "the courses that include online education (either completely virtual or blended learning) produce, on average, much stronger learning outcomes for students courses They are conducted exclusively in person. Based on an approach developed by educational psychologist Benjamin Bloom, the mastery learning helps students to fully understand a subject before moving on to a more advanced. In Coursera, usually we give an answer immediately to the concepts that the student does not understand feedback. In many cases, we offer random versions of assessments for the student to return to school and retrying until mastered the concept.