Foresight BI

Introduction & Prerequisites

Understanding Data Normalization (part 1)

Understanding Data Normalization (part 2)

Understanding Data Normalization (Part 3)

Understanding Fact and Dimension Fields

Eliminating Redundancy in data with Normalization

Understanding the requirements for Normalizing Data

Planning for Data Normalization

Mapping Data for Normalization

Mapping out the Fact Fields

Creating an Entity Relationship Diagram from Mapped Model

Assignment - Data Normalization Assignment

Download class files

12. Normalizing data with Power Query (part 1)

Normalizing data with Power Query (part 2)

Normalizing data with Power Query (part 3)

Organizing Queries into Folders

Assignment - Normalizing Data with Power Query

Confirming model relationships (part 1)

Confirming model relationships (part 2)

Understanding Model Cardinality and Cross-filter direction

Understanding Model Cardinality and Cross-filter direction (part 2)

Explaining Cross-filter direction (part 1)

Explaining Cross-filter direction (part 2)

Explaining Cross-filter direction (part 3)

Understanding Star Schema and Snowflake Schema

Converting from Snowflake to Star Schema

Assignment - Creating Power BI Data Model

Introduction to Date Dimension Tables

Introduction to creating Date Tables in Power BI

Creating Date Tables with CALENDARAUTO function

Validating Date Tables and Connecting to fact table

Creating Yar Column with YEAR function

Creating Quarter and Month Number columns with QUARTER and MONTH functions

Creating Month Name column with FORMAT function

Fixing Month Sorting Order

Creating Day of Week column with FORMAT function

Fixing Day of Week Sorting Order

Creating Week of Year Column with WEEKNUM function

Introduction to creating Date Tables with Power Query

Step 1 of creating Date Table with Power Query

Step 2 of creating Date Table with Power Query

Step 3 of creating Date Table with Power Query

Step 4 of creating Date Table with Power Query

Final steps of creating Date Table with Power Query

Assignment - Building a Power BI Date Table

Intro to working with multiple fact tables

Preparing our Target Data

Creating the relationships for our Target data

Understanding and Managing Many to Many Relationships

Managing Many to Many relationships with Bridge Tables

Introduction to Troubleshooting Power BI models

Troubleshoot when all visual categories show the same values

Troubleshoot when all visual categories are not displaying

Troubleshoot when Date Categories are not displaying on Visuals

Troubleshoot when unable to link two tables (part 1)

Troubleshoot when unable to link two tables (part 2)

Showing categories with no data and troubleshoot when visual categories show some blanks