Checklist

Certification

You will get a certificate on completing this course.

University

The course is not from a very prestigious university.

Price

This course is costly - Rs. 4439/-.

Difficulty

The students of this course have found this course difficult.

Content

The students of this course have liked the content of this course.

Assignments

The students of this course have not liked the assignments of this course.

Teaching

The students of this course have liked how the instructor has taught this course.

Satisfaction

The students of this course are overall satisfied with this course.

Edvicer's Rewards

You can get a cashback of ₹ 300 on buying this course.

Design and Build a Data Warehouse for Business Intelligence Implementation

Design and Build a Data Warehouse for Business Intelligence Implementation

FREE (Audit)
Start anytime
8 hours
English
University of Colorado System
Course by
CourseraCourses from Coursera
Certificate awarded
For Rs. 4439
Mixed
Login to earn ₹ 300

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

The course is not from a very prestigious university.

Price

This course is costly - Rs. 4439/-.

Difficulty

The students of this course have found this course difficult.

Content

The students of this course have liked the content of this course.

Assignments

The students of this course have not liked the assignments of this course.

Teaching

The students of this course have liked how the instructor has taught this course.

Satisfaction

The students of this course are overall satisfied with this course.

Edvicer's Rewards

You can get a cashback of ₹ 300 on buying this course.

Why should you choose this 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. 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.

Syllabus

Course Overview
Data Warehouse Design
Data Integration
Analytical Queries and Summary Data Management
Data Visualization and Dashboard Design Requirements
Wrap Up and Project Submission

What others say about this course

Reviews from Coursera

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.

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

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 take  Read More ...

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.

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 wonderi  Read More ...

Show more reviews

Write your review of Design and Build a Data Warehouse for Business Intelligence Implementation

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer