Power BI Desktop & DAX - Zero To Hero - Intermediate Level

In this video we will learn how to import the data we are going to use to build our model

In this video I we will learn how to format the data we have imported into our model

In this video we will see if Power BI has automatically defined the relationships between the tables, and we will learn how to disable this feature.

In this video we will learn how to create a date dimension in Power BI. I have attached the script you will need in the resource section of this lecture

In this video we will create the relationships between the dimension tables and the data fact table.

In this lecture we will create the report template, add the pages we will need. We will also learn how to delete and rename pages.

In this lecture we will add all the slicers we need to filter the data our visuals will be built off.

In this lecture we will learn how to build the navigation for our report so the end user can navigate seamlessly through the pages of the report

In this lecture we will learn how to build a separate table to keep our measures in

In this lecture we will build our first DAX measure, one that will return our total sales. I have attached a file in the resource section that has all the DAX measures we will use in the course as a reference to assist you.

In this video we will create the total cost measure

In this video we will create the total quantity measure

In this video we will create the total budget measure

In this video we will create a measure to count total transactions

In this video we will create a measure that will work out our profit margin

In this video we will create a measure that works out the availability percentage

In this lecture we will create a measure that calculates percent variance between budget and total sales

In this lecture we will create a measure that calculates percent variance between budget and last years total sales

In this lecture we will create the lifetime KPI measure table to house all our lifetime KPI measures

In this lecture we will create a lifetime sales measure that will sum the total sales from the day the business started

In this lecture we will create a lifetime cost measure that will sum the total costs from the day the business started

Create the rest of the lifetime measures for transactions, profit, availability and variance of budget

Here we will create a table to house our filtered DAX measures

In this lecture we will create DAX measures that filter the total sales for each of the first 2 product categories

In this lecture we will create a measure for total sales that filters the kitchen product category only

In this lecture we will create a table to house our KPI by period measures

In this lecture we will create a measure for total sales for the same period last year

In this lecture we will create a measure for total costs for the same period last year

In this lecture we will create a measure for total quantity for last year

Create the rest of the measures for LY for the remaining KPI's - profit, transactions, cost, total sales

Create total sales measures for year to date (YTD) and year to date for last year (YTD LY)

In this lecture we will learn how to create measures to rank our data

In this video we will look at how to create quick measures. We will also have a look at what DAX resources are on the internet to assist you after the course

In this lecture we will add all the visuals needed for the home page

In this lecture we will create all the visuals to measure this years sales against the same period last year

In this lecture we will create the visuals that measure total sales, cost and budget for the regions and reps

In this lecture we will create the visuals that measure total sales, cost and budget for the product categories and products

In this lecture we will create the visuals that measure total sales, cost and budget for the stores

In this lecture we will create visuals to rank sales by product, region and store

In this video we will create a matrix to measure all the KPI's for the business across the years

In this lecture we will create a BI self service page where users can drill into the total cost and sales by the different dimensions using the decomposition tree visuals

In this video we will do a walk through of the Power BI service, and then wrap up the course