Design and Build a Data Warehouse for Business Intelligence Implementation

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You'll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You'll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI

Created by: Michael Mannino

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a branding course? Or looking for more detail on Michael Mannino's Design and Build a Data Warehouse for Business Intelligence Implementation? Feel free to chat below.
Join CourseDuck's Online Learning Discord Community

icon
Course Description

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.

icon
Instructor Details

Michael Mannino

My involvement with database technology and education spans more than 35 years in academic positions, research, and consulting. I have been a faculty member at the University of Florida, University of Texas at Austin, and University of Washington before joining the Business School at the University of Colorado Denver. My work in this specialization is a culmination of teaching data warehouse development for 15 years along with writing a supporting textbook and conducting research projects. In my teaching, It is my pleasure and privilege to share my excitement and extensive background to help you embark on an adventure towards a rewarding and challenging career as a data warehouse or business intelligence professional.

icon
Reviews

4.2

150 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Shrey P S on 23-Nov-16

I have submitted all my solution long back but the last submission which was suppose to been by mentor is pending from one and the half months.

By Fernando on 6-Feb-17

The course is not very well developed like course 1, 2, 3.

By Ankit M on 9-Dec-16

Course is good but mentor grading needs to be a bit sorted as in they required almost 2 additional weeks to grade one assignment in total that is 1 month to grade an assignment so that needs to be taken care of

By Daniel M on 22-Aug-18

far too few students who rate your work - you always need to wait very long for reviews

By Magorzata J on 11-Feb-17

Excelent course. Much of your time will be needed to do the assignments.

By Carlos P on 17-Oct-17

good and challenge

By Kasani P on 12-Feb-17

Very useful,I will Recommend this course to my fellow mates .

By Roberto T I on 9-Oct-17

Excellent Specialization. I will recommend this course to all my friends.

By Peter S on 13-Aug-16

The best course in the certification path.

By E.Naveen K on 18-Nov-16

Great

By Jordi P L on 12-Aug-16

g

By Sachin G on 15-May-16

Awesome Course!