Power BI for Data Professionals
Lecture
Paul Burpo
Beginner
1 h 33 m
2018-05-09
Lecture Overview
This course builds on your Power BI skills and walks you through the interfaces of both the Online and Desktop offerings before embarking on a journey that will show you how to ingest data, transform data, create reports and dashboards before publishing and using your data sets, reports and dashboards in the Power BI online tenant.The course will help prepare students to take the Microsoft 70-778, Analyzing and Visualizing Data with Power BI certification exam.

Related Learning Path(s):
Business Intelligence with Power BI
Objectives
  • Introduction to Power BI
  • The Power BI Service and Desktop Application
  • Connecting to Data Sources
  • Power BI service architecture and security
  • Power BI tenants and data regions
  • Creating Desktop Reports and Dashboards
  • Advanced data modeling techniques
  • Writing DAX formulas
  • Understanding evaluation context
  • Advanced Visualization
  • Bookmarks
  • Drillthrough and Dynamic Labels
  • Power BI Visuals with R
Pre-Requisites
  • Previous experience with BI concepts and visualization tools
Lecture Modules
In this module we will introduce Power BI. We will discuss the various ways we can interact with Power BI. We will cover data source support, content packs, and on-premises integration. We will then review the Power BI service architecture including deployment, service tiers, service security and storage, Power BI tenants and data regions.
In this module, we will look at advanced data modeling and analytics in Power BI.  We will cover architecting data models including fact tables, dimensions, relationships schema design and data modeling best practices in Power BI. We will cover at creation of calculated columns and measures using DAX and discuss when to use each of them. We will do a deep dive on the DAX CALCULATE function. Next, we will discuss evaluation context and filter propagation in Power BI. Finally, we will look at DAX Time Intelligence functions to optimize complex time queries. 
In this module, we look at the advanced visualization capabilities in Power BI. We will start off covering optimal visualization selection, including good vs bad design evaluation, page layout, and configuring visual relationships. Next, we will review the different chart types and visualization options in Power BI. We will talk about custom visualizations including marketplace visualizations, organizational visualizations and certified visualization. Next, we will look at the bookmarks and the selection pane and we will show you how to create toggle switches in your reports. We will look at drillthrough and dynamic labels. Finally, we will look at R visuals. 
Try Risk Free
Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments
  • MUCH MORE!