Power BI
Power BI Desktop - Dashboard Reports in 3-Hours
Build a real Power BI dashboard in a single three-hour session. Connect and transform Excel data, add a calculated column and a DAX measure, create polished visuals, and publish your report online.
CPE Eligible - visit /cpe for details.CPE page →
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
Lesson 1: Introduction to Power BI Desktop
- Introduce Power BI Desktop Reports
- Explore Query Editor, Data Tables and Data Model
- Demonstrate use of Power BI Online and App
Lesson 2: Data Transformation using Query Editor
- 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
Lesson 3: View Data Tables and Data Model
- 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
Lesson 4: Power BI Reports and Visuals
- 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
Lesson 5: Publish a Power BI File
- Demonstrate Publishing to Power BI Online
- View Power BI Reports in the Cloud