Star Schema Courses and Certifications

ExcelIsFun

Power Query Power BI - Transform 2 Fact Tables to Star Schema Data Model - Invoice Data

Transform two invoice fact tables into a single star-schema model in Power BI using Power Query, allocated costs, relationships, measures, and slicers.

• YouTube
• 26 minutes
• Self-Paced
• Free Video

Coursera

Design Robust Data Models for Analytics

Design star-schema fact and dimension tables with surrogate keys, spot redundant lookups in snowflake schemas, and build semantic metrics layers that standardize business definitions.

• Coursera
• 3 weeks, 1 hour a week
• Self-Paced
• Paid Course

Coursera

Design Data Models for BI Reporting

Design star schema data models for self-service BI reporting: identify business processes, structure fact and dimension tables, and implement surrogate key relationships.

• Coursera
• 2 weeks, 1 hour a week
• Self-Paced
• Paid Course

Coursera

Star Schemas & Track Changes

Apply Type-2 slowly changing dimensions to preserve full data history, then evaluate star schemas for performance bottlenecks and propose refinements balancing query speed and storage.

• Coursera
• 2 weeks, 1 hour a week
• Self-Paced
• Paid Course

ExcelIsFun

Two Fact Tables - DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table

Convert two fact tables into one reportable model using Excel formulas, DAX, and Power Query.

• YouTube
• 1 hour 5 minutes
• Self-Paced
• Free Video

Data Modeling in Power BI

7767 ratings at DataCamp

Foundations of Data Modelling Proper data modeling is the foundation of data analysis and creating reports in Power BI.

• DataCamp
• 3 hours
• Self-Paced
• Free Trial Available

Transform and Analyze Data with Microsoft Fabric

241 ratings at DataCamp

Transform and Analyze Data with Microsoft Fabric Unlock the power of Microsoft Fabric for data transformation and analysis.

• DataCamp
• 4 hours
• Self-Paced
• Free Trial Available

Data Warehouses on AWS

5 ratings at Udacity

In this course, you’ll learn to create cloud-based data warehouses. You’ll sharpen your data warehousing skills, deepen your understanding of data infrastructure, and be introduced to data engineering on the cloud using Amazon Web Services (AWS).

• Udacity
• 12 hours
• Self-Paced
• Paid Course

SQLBits

Star Schema ALL the Things! But Why? - Practical Design Decisions in Data Modeling

Explore practical star schema design, from source to model to report. Learn best practices, test methodologies, and assess performance impacts in data modeling.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

SQLBits

Gathering Requirements for Your Star Schema

Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Data Warehousing on AWS with Amazon Redshift

Build a performant Redshift Serverless warehouse from S3 data using star schemas, efficient loading, pipelines, and query tuning.

• CodeSignal
• 2 hours
• Self-Paced
• Free Certificate

Data Warehouse Fundamentals

268 ratings at Coursera

Design, load, and query data warehouses, marts, and lakes: star and snowflake schemas, ETL/ELT, cubes, rollups, and materialized views in PostgreSQL and Db2.

• Coursera
• 3 weeks, 5 hours a week
• Self-Paced
• Paid Course

Data Modeling and Architecture

23 ratings at Coursera

Build data models in Power BI: configure cardinality and relationships, design star and snowflake schemas, write DAX measures, and apply data privacy and governance practices.

• Coursera
• 4 weeks, 4 hours a week
• Self-Paced
• Paid Course

Whizlabs

Power BI: Data Modeling and Data Analysis

Model and analyze data in Power BI: build calculated columns and tables, design STAR schemas with relationships and hierarchies, write DAX measures, and secure model data.

• Coursera
• 2 weeks, 4 hours a week
• Self-Paced
• Paid Course

Corporate Finance Institute

Advanced Tableau - Data Model

Combine data in Tableau using joins, relationships, and blends, then tune model performance and handle NULLs, many-to-many relationships, and ETL-built star schemas.

• Coursera
• 2 hours 18 minutes
• Self-Paced
• Paid Course