Latest Courses
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
Learning Path: Java: Natural Language Processing with JavaCheck course
Cloud Migration on AWS and Microsoft AzureCheck course
Cyber Security: Mastering Linux SecurityCheck course
Data Science:Hands-on Covid-19 Data Analysis & VisualizationCheck course
Learn Node.JS from Beginning to Mastery 2020Check course
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
Design and Build a Data Warehouse for Business Intelligence Implementation

Design and Build a Data Warehouse for Business Intelligence Implementation

FREE

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.1/10 (Our Score)
Product is rated as #29 in category Business Intelligence

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. …

Instructor Details

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.

Specification: Design and Build a Data Warehouse for Business Intelligence Implementation

Duration 8 hours
Year 2016
Certificate Yes
Quizzes No

30 reviews for Design and Build a Data Warehouse for Business Intelligence Implementation

4.2 out of 5
18
6
2
1
3
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Ranga

    Well framed capstone project. no less than real project.

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Sachin G

    Awesome Course!

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Florian P

    The capstone project is interesting but requires far too much time compared to the other courses and to what is announced.

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Sergey K

    It was very challenging. Not everything was well prepared. But overall good! Thank you very much!

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Obinna E

    Excellent course..provides hands on experience on designing a data warehouse for BI implementation

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Robert L

    this is an excellent and rigorous course and a valuable preparation for working with data warehouses. frustratingly, the assignments contained errors, inconsistencies, and vagaries that left me wondering if the professors did this on purpose, to simulate real world situations. anyway, the bottom line is that this course offers a great opportunity to learn and practice. they say you get out of it only what you put into it. be prepared to spend 8 to 16 hours on the assignments. but it definitely was worth it. THANK YOU, PROFESSORS!

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Rajat K j

    Very Beneficial !!!

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    DevendraMehra

    Awesome content ,very well drafted and explained course content. I am thankful to the coursera team, who has discovered such kind of really good course and specialization.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Jordi P L

    g

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Peter S

    The best course in the certification path.

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Pratik A

    Excellent course to learn

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    E.Naveen K

    Great

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    Shrey P S

    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.

    Helpful(2) Unhelpful(0)You have already voted this
  14. Avatar

    Ankit M

    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

    Helpful(1) Unhelpful(0)You have already voted this
  15. Avatar

    Prasant k n

    Excellent contemporary course content and hands on course. Recommended for everyone who wants start or change into exciting career in DWBI.

    Helpful(0) Unhelpful(0)You have already voted this
  16. Avatar

    Manmeet S B

    Mentor review for the final project takes long time to be completed.

    Helpful(0) Unhelpful(0)You have already voted this
  17. Avatar

    Rakshit G

    Very good course to enhance BI learning.

    Helpful(0) Unhelpful(0)You have already voted this
  18. Avatar

    Fernando

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

    Helpful(1) Unhelpful(0)You have already voted this
  19. Avatar

    MaBgorzata J

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

    Helpful(0) Unhelpful(0)You have already voted this
  20. Avatar

    Kasani P

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

    Helpful(0) Unhelpful(0)You have already voted this
  21. Avatar

    Daniel B

    Unclear, ambiguous direction and material that is unhelpful for building the final project

    Helpful(0) Unhelpful(0)You have already voted this
  22. Avatar

    abel.saenz@gmail.com

    Great specialization, extenuates assessments, Oracle, ETL, and Microstrategy Excelent softwares, great challenge

    Helpful(0) Unhelpful(0)You have already voted this
  23. Avatar

    Matthew D

    I loved the 1st 4 weeks of this capstone course which focused on data warehouse design, data integration and writing queries. All of the assignments were challenging but fair. Unfortunately, I do not feel the same way about the data visualization module. The sample dashboards provided are not well done enough to be used in a professional setting.

    Helpful(0) Unhelpful(0)You have already voted this
  24. Avatar

    Roberto T I

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

    Helpful(0) Unhelpful(0)You have already voted this
  25. Avatar

    Carlos P

    good and challenge

    Helpful(0) Unhelpful(0)You have already voted this
  26. Avatar

    Qiao D

    Very practical and useful

    Helpful(0) Unhelpful(0)You have already voted this
  27. Avatar

    Paul G

    Very good except for the fact you had to wait for certain course aspects until the mark is officially given

    Helpful(0) Unhelpful(0)You have already voted this
  28. Avatar

    Daniel M

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

    Helpful(1) Unhelpful(0)You have already voted this
  29. Avatar

    BENSON E A

    This module was well presented

    Helpful(0) Unhelpful(0)You have already voted this
  30. Avatar

    Friso S

    Content wise a very good and useful course. But the technical support on the installation and use of the software needed to complete the course is very limited, and the manuals are not up to date, as they refer to older versions of the proposed software.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Design and Build a Data Warehouse for Business Intelligence Implementation
    Design and Build a Data Warehouse for Business Intelligence Implementation

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare