In this lab, you will learn to build powerful dashboards and reports in Power BI. You will learn to take advantage of advanced data analytics features of Power BI such as DAX queries, KPIs and R scripts.
Estimated time required to complete: 3 hours, 30 minutes
You will have access to this environment for 6 hours, 0 minutes
Who this lab is designed for
Visualize data with dashboards and reports with Power BI
Writing DAX queries to analyze data in Power BI
Use KPIs and parameters in Power BI
Leveraging R for analyzing and visualizing data in Power BI
Exercise 1: Visualizing Data with Power BI
In this exercise, you will create a basic Power BI visualization by selecting check boxes next to field names. Then, you'll learn how to use drag-and-drop and make full use of the Fields and Visualizations panes to create and modify visualizations.
Exercise 2: Dashboarding with Power BI
Exercise 2 is all about dashboarding, and cutting a dash with your data! In this exercise, you will learn more about dashboarding features in Power BI. We will use the example from the last exercise.
Exercise 3: Analytics in Power BI and DAX
This exercise is all about analytics and calculations in Power BI. We'll learn about how you can manage these features and what Microsoft provides as a part of business analytics functionality in Power BI
Exercise 4: Performance KPIs and Parameters in Power BI and DAX
This exercise is all about analytics and calculations in Power BI. We'll learn about how you can manage these features and what Microsoft provides as a part of business analytics functionality in Power BI. We will also look at parameters in PowerBI.
Exercise 5: R and Power BI
In this exercise, we will install R and RStudio. Then, we will learn R by example. You will be supplied with a series of scripts written in R, and you will run through them at an atomic level in order to understand how R works.
Login to Start Lab
Not Registered?Already Registered?
Real Time Labs allow you to learn technology in an isolated environment without the hassle or cost of setting up a dedicated learning environment.
2018 Skill Me Up and Opsgility, LLC. All Rights Reserved