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

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.

What's inside

Syllabus

Course Overview

Module 1 introduces the objectives and topics in the course and provides background on the case and software requirements. The capstone course is organized around a realistic case study based on the business situation faced by CPI Card Group in 2015.

Data Warehouse Design

Module 2 presents the requirements of the first part of the case study involving data warehouse design. To provide a context for the case study, you can listen to an executive interview with a CPI Card Group executive.

Data Integration

Module 3 presents requirements for the second part of the case study involving data integration. To provide a context for the case study, you can listen to executive interviews with executives from CPI Card Group, First Bank, and Pinnacol Assurance.

Analytical Queries and Summary Data Management

Module 4 presents requirements for the third part of the case study involving analytical queries and summary data management.

Data Visualization and Dashboard Design Requirements

This module continues on the top job responsibilities of BI analysts by focusing on creating data visualizations and dashboards. You will first learn the importance of data visualization and different types of data that can be visually represented. You will then learn about the types of basic and composite charts. This will help you to determine which visualization is most effective to display data for a given data set and to identify best practices for designing data visualizations. In lesson 3, you will learn the common characteristics of a dashboard, the types of dashboards, and the list of attributes of metrics usually included in dashboards. Finally, in lesson 3, you will learn the guidelines for designing a dashboard and the common pitfalls of dashboard design. You will need to use MicroStrategy Desktop Visual Insight to design a dashboard for a Financial Services company in a peer-evaluated exercise.

Wrap Up and Project Submission

This is an extension of Module 5. The peer assessment from module 5 is moved to module 6 to give you more time completing the assignments in prior modules as well as for you to do your peer assessment in this module.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides a comprehensive understanding of data warehouse design, integration, query, and visualization

Taught by industry experts with real-world experience in data warehousing

Covers the entire data warehousing lifecycle, from design to deployment

Uses industry-standard tools and technologies, such as Pentaho Data Integration and MicroStrategy

Requires students to complete a real-world project, giving them hands-on experience in data warehousing

Suitable for students with a strong foundation in data management and analytics

Reviews summary

Data warehousing for business intelligence

Learners say this course titled Design and Build A Data Warehouse for Business Intelligence Implementation is very practical, challenging, and engaging. Those who enjoyed this course appreciated being able to connect data sources, prepare data, and design visualizations. They also noted the course's timely and relevant content. However, some also mentioned there were issues with assignments being locked and an issue with plagiarism.

Assignments help you learn material.

"Excellent learning through very challenging assignments."

Covers practical data warehousing concepts.

"This course teaches you to connect data sources to Microstrategy, wrangle, and prepare the data for designing visualizations and building dashboards."

"Very practical and useful."

Some learners mentioned plagiarism.

"The great problem of the course... is the number of students with little interest in learning, which is reflected in a great problem of plagiarism in assignments."

Some had issues accessing assignments.

"I am still in the subscription. But the assignment in course 5 is locked and I cannot get access to the assignments until June."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Design and Build a Data Warehouse for Business Intelligence Implementation with these activities:

Review Data Warehousing Fundamentals

Show steps

Refresh understanding of data warehousing concepts and best practices to strengthen the foundation for the course.

Browse courses on Data Warehousing

Show steps

Review textbooks and articles
Attend online tutorials

Develop a Data Warehousing Business Case

Show steps

Solidify understanding of business case development by creating a data warehousing business case for the case study organization.

Browse courses on Data Warehousing

Show steps

Identify business needs and challenges
Develop a data warehousing solution
Estimate project costs and benefits
Present the business case

Design a Dimensional Model

Show steps

Demonstrate understanding of data modeling concepts by creating a dimensional model for the case study business requirements.

Browse courses on Data Warehousing

Show steps

Identify business entities and their relationships
Create fact and dimension tables
Establish relationships between tables
Validate the model using SQL queries

Five other activities

Expand to see all activities and additional details

Show all eight activities

Write SQL Queries

Show steps

Reinforce understanding of SQL syntax and data manipulation techniques used throughout the course.

Browse courses on SQL

Show steps

Create a sample data warehouse schema
Write SELECT queries to extract and filter data
Write INSERT, UPDATE, and DELETE queries to modify data
Join tables using different join types

Collaborate on Data Warehousing Project

Show steps

Foster collaboration and exchange of knowledge by working with peers on a data warehousing project.

Browse courses on Data Warehousing

Show steps

Form a study group with classmates
Set up regular meetings
Assign responsibilities and work on different aspects of the project
Share progress and provide feedback

Analyze Business Intelligence Metrics

Show steps

Develop proficiency in analyzing business intelligence metrics to extract insights and inform decision-making.

Browse courses on Business Intelligence

Show steps

Identify key business metrics
Calculate and interpret metrics
Create visualizations to present insights

Learn MicroStrategy Reporting Tools

Show steps

Enhance proficiency in using MicroStrategy to create dashboards and visualizations for business analysis.

Browse courses on Business Intelligence

Show steps

Access MicroStrategy tutorials and documentation
Create a new project and import data
Design dashboards and reports
Publish and share insights

Build a Mini Data Warehouse

Show steps

Apply knowledge and skills to a practical project by building a small-scale data warehouse using industry-standard tools.

Browse courses on Data Warehousing

Show steps

Create SQL queries for data analysis
Build dashboards and visualizations
Design the data warehouse schema
Integrate data from multiple sources

Career center

Learners who complete Design and Build a Data Warehouse for Business Intelligence Implementation will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data analysts design and implement data-collection systems to gather data used in data warehouses, data lakes, and more. A course that helps develop strong data warehouse design and analytical query skills will be very helpful in a data analyst role. A background in data integration is also very helpful, as is experience with data visualization software, both of which are covered in this course.

See salaries and explore the career path for Data Analyst

Data Architect

Data architects create architectures that meet the data requirements of businesses. This requires a deep understanding of how data is stored, managed, and integrated across a company or organization. A course on data warehouse design and BI implementation can be very useful in this role. It can help develop a strong understanding of the principles and best practices of data warehousing and BI. It also provides hands-on experience in designing and implementing a data warehouse, which is a valuable skill for data architects.

See salaries and explore the career path for Data Architect

Data Engineer

Data engineers design, build, and maintain the infrastructure and processes that store and manage data for data warehouses and BI systems. A course on data warehouse design and BI implementation can be very helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse, which is a valuable skill for data engineers.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

Business intelligence analysts use data to help businesses make better decisions. This involves collecting, analyzing, and interpreting data to identify trends, patterns, and opportunities. A course on data warehouse design and BI implementation can be very helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also help you develop proficiency in data visualization and dashboard design, which are essential skills for business intelligence analysts.

See salaries and explore the career path for Business Intelligence Analyst

Database Administrator

Database administrators are responsible for the performance, security, and integrity of databases. This involves managing the physical and logical structure of databases, as well as implementing security measures to protect data from unauthorized access. A course on data warehouse design and BI implementation can be very helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing, as well as hands-on experience in designing and implementing a data warehouse.

See salaries and explore the career path for Database Administrator

Data Scientist

Data scientists use scientific methods to extract knowledge and insights from data. This involves developing and applying statistical and machine learning models to data to identify patterns, trends, and anomalies. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing, as well as hands-on experience in designing and implementing a data warehouse.

See salaries and explore the career path for Data Scientist

Software Engineer

Software engineers design, develop, and maintain software applications. This involves writing code, testing software, and debugging errors. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing, as well as hands-on experience in designing and implementing a data warehouse. This course will also familiarize you with data visualization and dashboard design tools.

See salaries and explore the career path for Software Engineer

Data Integration Specialist

Data integration specialists design and implement data integration solutions to integrate data from multiple sources into a single, unified view. This involves understanding the different data sources, data formats, and data structures, as well as developing and implementing data integration processes. A course on data warehouse design and BI implementation can be very helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also help you gain experience with data integration tools and technologies.

See salaries and explore the career path for Data Integration Specialist

Database Developer

Database developers design and develop databases to store and manage data for applications. This involves creating database schemas, writing SQL queries, and implementing security measures to protect data from unauthorized access. A course on data warehouse design and BI implementation can be very helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing, as well as hands-on experience in designing and implementing a data warehouse. This course will also help develop an understanding of data visualization and dashboard design tools.

See salaries and explore the career path for Database Developer

Project Manager

Project managers plan, execute, and close projects. This involves defining project scope, developing project plans, and managing project budgets and timelines. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also provide exposure to data visualization and dashboard design tools.

See salaries and explore the career path for Project Manager

Management Consultant

Management consultants advise businesses on how to improve their performance. This involves analyzing business processes, identifying problems, and developing and implementing solutions. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also provide exposure to data visualization and dashboard design tools.

See salaries and explore the career path for Management Consultant

Business Analyst

Business analysts analyze business processes and identify opportunities for improvement. This involves gathering and analyzing data, developing recommendations, and presenting findings to stakeholders. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also provide exposure to data visualization and dashboard design tools.

See salaries and explore the career path for Business Analyst

Information Architect

Information architects design and implement information systems to meet the needs of businesses. This involves understanding the business requirements, developing information system architectures, and implementing information systems. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse.

See salaries and explore the career path for Information Architect

Data Governance Analyst

Data governance analysts develop and implement policies and procedures to ensure that data is used in a consistent and ethical manner. This involves developing data governance frameworks, defining data standards, and monitoring data usage. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also provide exposure to data visualization and dashboard design tools.

See salaries and explore the career path for Data Governance Analyst

Data Quality Analyst

Data quality analysts ensure that data is accurate, complete, and consistent. This involves developing and implementing data quality standards, monitoring data quality, and resolving data quality issues. A course on data warehouse design and BI implementation may be helpful in this role. It will help develop a strong understanding of the principles and best practices of data warehousing and BI, as well as hands-on experience in designing and implementing a data warehouse. This course will also provide exposure to data visualization and dashboard design tools.

See salaries and explore the career path for Data Quality Analyst