Prepare Data in Power BI Desktop
Setup local lab environment
Category: Power BI
The estimated time to complete the lab is 45 minutes In this lab you commence the development of a Power BI Desktop solution for the Adventure Works company. It involves connecting to source data, previewing the data, and using data preview techniques to understand the characteristics and quality of the source data. In this lab you learn how to: Open Power BI Desktop Set Power BI Desktop options Connect to source data Preview source data
Category: Power BI
All setup and resource files can be downloaded from GitHub. Ideally, you should complete these labs in a hosted lab environment. If you want to complete them on your own computer, you can do so by installing the following software. You may experience unexpected dialogs and behavior when using your own environment. Due to the wide range of possible local configurations, the course team cannot support issues you may encounter in your own environment. Table
If you should ever start reading a book on DAX, you will quickly reach a chapter on the CALCULATE function. The book will tell you that the CALCULATE function is at the heart of everything that you do in DAX and is the key to understanding the language. A delegate on one of my courses adopted the policy of starting every formula with =CALCULATE, and it’s not such a bad approach! This article explains how
The estimated time to complete the lab is 45 minutes In this lab you will create measures with DAX expressions involving filter context manipulation. In this lab you learn how to: Use the CALCULATE() function to manipulate filter context Use Time Intelligence functions Table of Contents Toggle Lab storyExercise 1: Work with Filter ContextTask 1: Get startedTask 2: Create a matrix visualTask 3: Manipulate filter contextExercise 2: Work with Time IntelligenceTask 1: Create a YTD
The estimated time to complete the lab is 45 minutes In this lab you will create calculated tables, calculated columns, and simple measures using Data Analysis Expressions (DAX). In this lab you learn how to: Create calculated tables Create calculated columns Create measures Table of Contents Toggle Lab storyExercise 1: Create Calculated TablesTask 1: Get startedTask 2: Create the Salesperson tableTask 3: Create the Date tableTask 4: Create calculated columnsTask 5: Complete the Date tableTask
