Monthly Subscription Starting at AED 99 + VAT

Getting Started with Data Warehousing and BI Analytics
  • Level Foundation
  • Duration 17 hours
  • Offered by

About

Data is one of an organization’s most valuable commodities. But how can organizations best use their data? And how does the organization determine which data is the most recent, accurate, and useful for business decision making at the highest level? After taking this course, you will be able to describe different kinds of repositories including data marts, data lakes, and data reservoirs, and explain their functions and uses. A data warehouse is a large repository of data that has been cleaned to a consistent quality. Not all data repositories are used in the same way or require the same rigor when choosing what data to store. Data warehouses 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. You will also be able to describe how data warehouses serve a single source of data truth for organization’s current and historical data. Organizations create data value using analytics and business intelligence applications. Now that you have experienced the ELT process, gain hands-on analytics and business intelligence experience using IBM Cognos and its reporting, dashboard features including visualization capabilities. Finally, you will complete a shareable final project that enables you to demonstrate the skills you acquired in each module.

Modules

Welcome

    • 1 Videos
    • 1 Readings
    • 1 Plugin
Show info about module content

1 Videos

  • Course Introduction

1 Readings

  • Course Overview

An Introduction to Data Warehouses, Data Marts, and Data Lakes

    • 7 Videos
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes

7 Videos

  • Data Warehouse Overview
  • Popular Data Warehouse Systems
  • Selecting a Data Warehouse System
  • Data Marts Overview
  • IBM Db2 Warehouse
  • Data Lakes Overview
  • Data Lakehouses Explained

Summary and Graded Quiz

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 Graded Quiz: An Introduction to Data Warehouses, Data Marts, and Data Lakes

1 Readings

  • Module 1 Summary: An Introduction to Data Warehouses, Data Marts, and Data Lakes

Designing, Modeling and Implementing Data Warehouses

    • 8 Videos
    • 3 Readings
    • 5 ExternalTool
    • 1 Assignment
Show info about module content

1 Assignment

  • Practice Quiz: Designing, Modeling and Implementing Data Warehouses

5 External Tool

  • Hands-on Lab: Working with Facts and Dimension Tables
  • Hands-on Lab: Setting up a Staging Area
  • Hands-on Lab: Verifying Data Quality for a Data Warehouse
  • Hands-on Lab: Populating a Data Warehouse using PostgreSQL
  • Hands-On Lab: Querying the Data Warehouse using PostgreSQL (Cubes, Rollups, Grouping Sets and Materialized Views)

8 Videos

  • Overview of Data Warehouse Architectures
  • Cubes, Rollups, and Materialized Views and Tables
  • Facts and Dimensional Modeling
  • Data Modeling using Star and Snowflake Schemas
  • Staging Areas for Data Warehouses
  • Verify Data Quality
  • Populating a Data Warehouse
  • Querying the Data

3 Readings

  • Grouping Sets in SQL
  • Understanding Slowly Changing Dimensions (SCD)
  • Data Warehousing with Star and Snowflake schemas

Summary and Graded Quiz

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Module 2 Graded Quiz: Designing, Modeling and Implementing Data Warehouses

1 Readings

  • Module 2 Summary: Designing, Modeling and Implementing Data Warehouses

Final Assignment

    • 2 Readings
    • 1 PeerReview
    • 2 ExternalTool
    • 1 Plugin
Show info about module content

2 External Tool

  • Practice Project: Introduction to Data Warehousing
  • Final Assignment: Data Warehouse Fundamentals

1 Peer Review

  • Peer Review: Project Submission

2 Readings

  • Practice Project Overview
  • Final Project Overview

Final Quiz

    • 1 Assignment
Show info about module content

1 Assignment

  • Final Quiz

Course Wrap-up

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Course Wrap-Up

2 Readings

  • Congrats & Next Steps
  • Team & Acknowledgements

[Optional] Hands-on Labs using IBM Db2

    • 1 Readings
    • 3 ExternalTool
    • 4 Plugin
Show info about module content

3 External Tool

  • Obtain IBM Cloud Feature Code and Activate Trial Account
  • Hands-on Lab: Populating a Data Warehouse using IBM Db2
  • Hands-on Lab: Final Assignment using IBM Db2

1 Readings

  • About this optional lesson

Auto Summary

Embark on an exciting journey into the world of Data Warehousing and Business Intelligence (BI) Analytics with this comprehensive self-paced course. Ideal for IT and Computer Science enthusiasts, this foundational course is designed to equip you with essential skills to design, deploy, manage, and analyze data warehouses and marts. Led by expert instructors from Coursera, the course delves into various analytics repositories, including data marts, data warehouses, data lakes, and data lakehouses, highlighting their importance in facilitating rapid business decision-making through precise and adaptable reporting and data analysis. You will gain a thorough understanding of data-warehousing architectures like Star and Snowflake schemas and learn to populate these warehouses using ETL and ELT processes. The curriculum includes hands-on labs where you will work with repositories such as MySQL, PostgreSQL, and IBM Db2, and utilize industry-standard BI tools like IBM Cognos Analytics, Tableau, and Microsoft PowerBI. By creating data visualizations and interactive dashboards, you will transform raw data into actionable insights. This 1020-minute course culminates in a project that showcases the skills acquired throughout the modules, ensuring you have practical knowledge of Data Warehousing and BI Analytics. Flexible subscription options, including Starter and Professional plans, make this course accessible to a wide range of learners, from beginners to those looking to enhance their existing skill set. Join us and take the first step towards mastering a key component of modern business intelligence.