Design and Build a Data Warehouse for Business Intelligence Implementation
Data Warehousing for 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. 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.
Get a Reminder
| Rating | 4.1★ based on 30 ratings |
|---|---|
| Length | 7 weeks |
| Effort | 6 weeks of study, 3-5 hours/week |
| Starts | Jul 3 (42 weeks ago) |
| Cost | $79 |
| From | University of Colorado System via Coursera |
| Instructors | Michael Mannino, Jahangir Karimi |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Science Data Analysis Business Business Essentials |
Get a Reminder
Similar Courses
What people are saying
change into exciting career
Recommended for everyone who wants start or change into exciting career in DWBI.
required almost 2 additional
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 Excellent contemporary course content and hands on course.
simulate real world situations
frustratingly, the assignments contained errors, inconsistencies, and vagaries that left me wondering if the professors did this on purpose, to simulate real world situations.
everyone who wants start
excellent course..provides hands-on experience
Excellent course..provides hands-on experience on designing a data warehouse for BI implementation It was very challenging.
discovered such kind
I am thankful to the coursera team, who has discovered such kind of really good course and specialization.
left me wondering
sample dashboards provided
The sample dashboards provided are not well done enough to be used in a professional setting.
1st 4 weeks
I loved the 1st 4 weeks of this capstone course which focused on data warehouse design, data integration and writing queries.
microstrategy excelent softwares
Great specialization, extenuates assessments, Oracle, ETL, and Microstrategy Excelent softwares, great challenge Unclear, ambiguous direction and material that is unhelpful for building the final project Very useful,I will Recommend this course to my fellow mates .
bit sorted as
16 hours
be prepared to spend 8 to 16 hours on the assignments.
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Warehouse Data Specialist $58k
Data Warehouse Marketing $81k
Specialist - Data Warehouse $87k
Data Warehouse Analyst 3 $107k
Data Warehouse Consultant $115k
Data Integration Engineer| Data Warehouse $116k
Data Warehouse Analyst 2 $121k
Data Warehouse - Architecture $147k
Data Warehouse Validation $152k
Data Architect Data Warehouse $167k
Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k
Data Warehouse Development $249k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | 4.1★ based on 30 ratings |
|---|---|
| Length | 7 weeks |
| Effort | 6 weeks of study, 3-5 hours/week |
| Starts | Jul 3 (42 weeks ago) |
| Cost | $79 |
| From | University of Colorado System via Coursera |
| Instructors | Michael Mannino, Jahangir Karimi |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Data Science Business |
| Tags | Data Science Data Analysis Business Business Essentials |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
