Analyzing your data with Power BI for BI Professionals (20778B)
Power BI is a suite of business analytics tools to analyse data and share insights. Power BI Desktop transforms your company’s data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.
SyllabusModule 1: Introduction to Power BI Power BI is a product that covers many things: Power BI in Excel, Power BI Desktop, the Power BI online service, ... . In this introduction we set the scene for the rest of the training, introducing the different aspects of the Power BI product. Module 2: Getting started with Power BI Desktop Power BI Desktop is a free software product to create reports and consult those reports. But before we can create these reports we must first load data from one or more sources, and then model your data. In this module you will explore each of these three steps in the Power BI authoring. Module 3: Enhancing a Data Model Before we can make good looking reports on data the data first needs to be modeled. This involves amongst others setting up relationships between different tables, formatting rules, derived calculations (such as Year-To-Date), sorting order etc. In this module you will learn about the most common modeling tasks and how to apply them in Power BI Desktop. Module 4: Designing Reports in Power BI Desktop After the model has been fine-tuned we can use this to create our reports. Power BI allows you to create very interactive reports, and in this module you will explore many visualizations as well as the interaction between these visualizations. The Office Marketplace provides custom visualizations as well, which you will learn to use as well. Module 5: Introduction to Power BI Service If you want to share models and reports with you co-workers, the Power BI service allows you to upload these to the cloud and manage and share them with others. In this module you will learn about the general features of this Power BI service, the next modules dive into the details. Module 6: Creating Datasets and Reports in Power BI Service For some types of reporting you do not want to go through the hassle of creating a dataset in Power BI Desktop. That's why for a limited set of data sources we can start using them directly from the Power BI service without the need to first create an offline model. In this module you'll learn how to create these models directly in the Power BI Service. Also, when accessing a model in the Power BI Service we get extra querying features not available in Power BI Desktop. These as well you will experience in this module. Module 7: Creating Dashboards and Analyzing Data with Power BI Service Dashboards allow you to combine visuals from different reports into one page. This module teaches you to build and customize these dashboards in the Power BI Service. Module 8: Sharing Content in the Power BI Service Power BI has different mechanisms to share content with other users: Sometimes you want to share in order to develop something together, or you want others to customize something, or maybe you want others to have read-only permissions on the shared object. In this module you'll learn how to accomplish this with the different sharing options in the Power BI Service. Module 9: Using Power BI with Mobile Devices Power BI reports can adjust to a different form factor. This module shows you how to design you reports for viewing on e.g. a smart phone. Module 10: Writing Queries to load data If your data sources contain data that requires extra processing, you can learn in this module to filter data, combine tables and do more advanced Extract, Transform and Load (ETL) operations using the M language in Power BI Desktop. Module 11: Enhancing the Data Model using DAX Data modeling can be challenging when advanced calculations are needed. This is why Power BI uses a dedicated language DAX (Data Analysis eXperssions) to define these advanced calculations. In this module you can get familiar with the most commonly used DAX expressions and how to use them within Power BI Desktop. Module 12: Managing Data Refresh from Power BI Service Data modeling can be challenging when advanced calculations are needed. This is why Power BI uses a dedicated language DAX (Data Analysis eXperssions) to define these advanced calculations. In this module you can get familiar with the most commonly used DAX expressions and how to use them within Power BI Desktop. Module 13: Using R in Power BI Sometimes the native Power BI does not provide the advanced data processing or visualization option you need. If you want to extend the capabilities of Power BI, this is possible by using the R language. R is a statistical language developed by the open source community. This language can be used in Power BI for data loading, data transformation and data visualization. This module mainly shows you how to use R in Power BI, it is not focussing on learning the R language itself. Module 14: Reporting with Excel and Excel Onlines
In this training, you learn how to write queries with Power BI Desktop and Power BI Excel to collect data from databases, cubes, online Excel files, Facebook.... You will learn how to enrich the data model with relationships, hierarchies, DAX calculated columns and measures... And finally, you will see how to create interactive reports using the large set of visualisation available in Power BI Desktop and share them using PowerBI.com and Power BI Mobile apps.
On day 4 & 5 we cover the more technical topics on the the Power Query language, the languages R and DAX and Power BI Gateways.
Participants and RequirementsThis course is intended for people who want to use all the capabilities of the Power BI platform to build self-serviced business intelligence solutions.
CertificateMicrosoft Certificate Exam 70-778
Course Duration5 days