Data Warehousing and BI Certification Training

Module 1: Introduction to Data Warehousing & BI

⏳ 3 hours

• Topics: DW vs. OLTP systems, BI lifecycle, key terminology

• Hands-on: Explore real-world DW use cases and outline a BI roadmap

Module 2: Data Warehouse Architecture

⏳ 3 hours

• Topics: Inmon vs. Kimball approaches, hub-and-spoke, bus architectures

• Hands-on: Design a high-level architecture diagram for a sample enterprise

Module 3: Dimension & Fact Tables

⏳ 3 hours

• Topics: Star and snowflake schemas, slowly changing dimensions

• Hands-on: Create dimension and fact tables in ERwin and populate with sample data

Module 4: Data Modeling Techniques

⏳ 3 hours

• Topics: Conceptual, logical, and physical modeling; normalization vs. denormalization

• Hands-on: Translate a logical model into a physical schema in a relational database

Module 5: ETL Fundamentals

⏳ 3 hours

• Topics: ETL process design, data cleansing, transformation patterns

• Hands-on: Build an ETL workflow to load CSV data into staging tables

Module 6: ETL Tools & Informatica

⏳ 3 hours

• Topics: PowerCenter components, mappings, workflows, sessions

• Hands-on: Develop an Informatica mapping to transform and load data

Module 7: Business Reporting  ⏳3 hours

• Topics: Report types, parameters, drill-down capabilities

• Hands-on: Create paginated reports and parameterized dashboards

Module 8: Data Visualization 

⏳3 hours

• Topics: Visualization principles, dashboard design, DAX basics

• Hands-on: Build an interactive dashboard in Tableau or Power BI

Module 9: OLAP & Data Cubes

⏳ 3 hours

• Topics: Cube design, measures and dimensions, MDX queries

• Hands-on: Deploy an OLAP cube and query it for key metrics

Module 10: Capstone Project

⏳ 3 hours

• Topics: End-to-end implementation, performance considerations

• Hands-on: Execute a mini-project covering architecture, ETL, reporting, and OLAP

Get certificate