Power BI Desktop - Dashboard Reports in 3-Hours
Turn raw data into clear, interactive dashboards and reports with hands-on Power BI training.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
Course objective
In this webinar, you will learn to connect to an Excel file, perform transformations to the data, and load the results to Power BI Desktop. Students will then view the Data Model, create a calculated column in data tables, and summarize data using a DAX measure. Finally, use the drag and drop/point and click interface to quickly build a dashboard with tables and charts.
Prerequisites
To ensure your success, each student should have a general knowledge of Microsoft Office concepts and basic Excel formula creation.
Course outline
- Introduce Power BI Desktop Reports
- Explore Query Editor, Data Tables and Data Model
- Demonstrate use of Power BI Online and App
- Select Excel as a Source, and Connect using Navigator Pane
- Explanation of Query Editor Features
- Perform Basic Text and Numeric Transformations in Query Editor
- Load Results to Power BI Desktop
- Examine Excel Data Results in Tables
- Review Data Table Relationships versus VLOOKUP
- Summarize Table Data using a Calculated Column
- Summarize Data using a DAX Measure
- Field Pane in Power BI
- Visual Tile Pane in Power BI
- Create a Table and Matrix Table
- Create a Column, Line and Pie Visual
- Quickly Format the Report using a Theme
- Demonstrate Publishing to Power BI Online
- View Power BI Reports in the Cloud