Analytics with Power BI Desktop
Lab 1 - Transforming Data with Power Query
Get Data
Use the Power Query Editor
Renaming Tables
Merging Queries
Creating Custom Columns
Splitting Data into Multiple Columns
Column from Examples
Lab 2 - Creating Relationships
Switch to Data Modelling Pane
Arrange the Tables
Creating Relationships
Lab 3 - Creating Calculated Columns & Measures
Creating & Formatting Calculated Columns
Additive Calculated Columns
Non-additive Calculated Columns
Creating & Formatting Measures
Measure - Count of Orders
Measure - Sum of Sales Including Tax
Try Creating a Measure for Sum of Sales
Solution 1
Enabling Time Intelligence
Using Time Intelligence in DAX
Calculating Total Sales Last Month
Calculating the Variance between Months
Try Creating a Measure
Solution - Total Sales Monthly Variance
Calculating the variance percentage on last month
Lab 4 - Configuring Common Charts & Filters
Slicer Visual
Time Series
Bar Chart
Analytics with Power BI Hands-On Labs
>
Lab 3 - Creating Calculated Columns & Measures
> Creating & Formatting Calculated Columns
You will create calculated columns and set up their column properties on the following pages.
Creating & Formatting Calculated Columns
You will create calculated columns and set up their column properties on the following pages.