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.
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.
Module 2: Data Modeling and Analytics in Power BI
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.
Module 3: Advanced Visualization in Power BI
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
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.
Access to Real Time Lab environments and lab guides
Course Completion Certificates when you pass assessments
2018 Skill Me Up and Opsgility, LLC. All Rights Reserved