Overview

Kickstart your Data Warehousing and Business Intelligence (BI) Analytics journey with this self-paced course. You will learn how to design, deploy, load, manage, and query data warehouses and data marts. You will also work with BI tools to analyze data in these repositories. You will begin this course by understanding different kinds of analytics repositories including data marts, data warehouses, data lakes, data lakehouses, and data reservoirs, and their functions and uses. They are designed to enable rapid business decision making through accurate and flexible reporting and data analysis. A data warehouse is one of the most fundamental business intelligence tools in use today, and one that successful Data Engineers must understand. In this course, you will learn to design, model and implement data warehouses and explore data-warehousing architectures such as Star and Snowflake schemas. You will also learn how to populate data warehouses using ETL and ELT processes, verify data, query data and how to use Cubes, Rollups, and materialized views/tables. You will become familiar with different BI tools used by experts in the industry such as IBM Cognos Analytics, Tableau, and Microsoft PowerBI. You will also use a BI tool to create data visualizations and build interactive dashboards to gain insights from data. The hands-on labs in this course will enable you to apply what you learn and gain a practical knowledge of Data Warehousing and BI Analytics. You will work with repositories like MySQL, PostgreSQL, and IBM Db2. You will also use BI tools like Cognos Analytics. At the end of this course, you will complete a project to demonstrate the skills you acquired in each module.

Syllabus

Data Warehouses, Data Marts, and Data Lakes

Welcome to your first module! This module provides a gentle but thorough introduction to data warehouse systems, data lakes, and data marts. When you complete this module, you’ll be able to identify and compare data warehouse systems, data mart, and data lake architecture, and understand how organizations can benefit from each of these three data storage entities. Optionally, you’ll explore the workings of IBM Db2 data warehouse system architecture, view use cases, and understand the key capabilities and integrations available with IBM Db2 Warehouse. Then, you’ll learn about three types of data warehouse systems and popular data warehouse system vendors. You will be ready to help your organization assess new data warehouse system offerings when you know the five essential, critical criteria, including total cost of ownership, to evaluate before changing to a new data warehouse system.

Designing, Modeling and Implementing Data Warehouses

In this knowledge-packed module, you’ll explore general and reference enterprise data warehousing architecture. You’ll discover how data cubes relate to star schemas. Then you’ll learn how to slice, dice, drill up or down, roll up, and pivot relative to data cubes. Next, you will examine the capabilities of materialized views, their benefits, and how to apply them. You’ll learn how data organization using facts and dimensions and their related tables organizes information. Then, you will explore how to use normalization to create a snowflake schema as an extension of the star schema. You will learn about populating a data warehouse, incremental data updates, verifying data, querying data, interpreting an entity-relationship diagram for a star schema, creating a materialized view, and applying the CUBE and ROLLUP options. You’ll also discover how organizations can benefit by implementing staging.

Data Warehouse Analytics

In this module, you’ll fast-track your data analytics learning and gain hands-on data analytics experience using IBM Cognos Analytics. After registering with Cognos Analytics, you’ll explore the platform’s capabilities by creating visualizations, building a simple dashboard, and trying out its advanced features.

Final Assignment and Final Quiz

In this module, you’ll complete your final course project, which brings together concepts and practices you previously learned in the first three modules. In this final project, you will design and load data into a data warehouse using facts and dimension tables. Then you’ll write aggregation queries using CUBE and ROLLUP functions and create materialized query tables, known as a materialized view. You will complete your project by using IBM Cognos to create an analytics dashboard.