Data Warehousing

Explore the intricacies of data warehousing as you delve into fundamental concepts such as data warehouse architecture, dimensional modeling, and the hands-on implementation of Extract, Transform, Load (ETL) processes. Gain practical insights by working with tools like PostgreSQL for robust database management, Pentaho for seamless ETL execution, and Power BI for dynamic business intelligence. Uncover advanced topics including the management of slowly changing dimensions, the exploration of Extract, Load, Transform (ELT) strategies, and techniques for optimizing data warehouses. This comprehensive exploration equips you with the expertise to design, implement, and refine data warehouses, enabling effective data management and insightful analysis.

Softwares Utilized
Pentaho, PostgreSQL, PGAdmin, and PowerBI

Year
Fall 2023

  • Facts and Dimensions

    Identify dimensions and facts, define what dimensions tables and fact tables to create.

  • Four Fact Tables

    • Transaction-grained fact table

    • Periodic snapshot fact table

    • Factless fact table

    • Accumulating snapshot fact table

  • Slowly Changing Dimensions

    Type 1: The new data overwrites the existing data.

    Type 2: Enables you to track the history of updates to your dimension records.

Fact and Dimension

Fact and Dimension

Fact and Dimension

Fact and Dimension

Transaction-Grained Fact Table

Transaction-Grained Fact Table

Periodic Snapshot Fact Table

Periodic Snapshot Fact Table

Factless Fact Table

Factless Fact Table

Accumulating Snapshot Fact Table

Accumulating Snapshot Fact Table

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension

Slowly Changing Dimension