Power BI: Hands-On Reports and Dashboards Training

Experience Power BI Desktop and Power BI Service in action. Watch and perform exercises to connect to 7 million records from various sources, refine the data in Power Query and import the tables into Power BI. Organise and model your data to “slice and dice” summary information. Implement insightful, dynamic data visualizations. Publish your report to Power BI Service. Add a workspace and an app to distribute your report and share with others.

No pre-requisite. Helpful if the participant has used pivot tables, databases, or PowerPoint.

The audience for this course is for data and business professionals who need to learn how to build Power BI reports to present data using a tabular model and insightful visualisations telling a dynamic data story to share with others in your organisation and online.

Learning Tree end-of-course exam included

Power BI: Hands-On Reports and Dashboards Training Delivery Methods

• Extensive hands-on labs for enhancing practical skills
• Learning Tree end-of-course exam included
• After-course instructor coaching benefit
• After-course computing sandbox included

Power BI: Hands-On Reports and Dashboards Training Course Benefits

• Connect to various data sources in Power BI Desktop and in Power Query, refine and clean up data; restructure tables and import data to the Power BI document.
• Implement a tabular data model for reporting, examine and relate tables with a calculated column to handle a many to many relationship.
• Take a tour of visuals: move and resize the visual container; populate the visual with the design well; format the visual with the format pane and analytic panes. Examine the Ellipse for additional features: show as a table, and sorting.
• Filter the visual with the top 5 items. Investigate custom grouping to add a column to a table. Use the new field in a visual. Filter the page using the custom group as criterion. Add a slicer to add additional filters to the page.
• Place several visuals on the page and examine cross filtering. Control cross filtering by editing interactions.
• Leverage automatic date and custom hierarchies to drill down from summary to detail information. Explore cross filtering and interactions to gain insights on granular information.
• Enhance the data model with DAX formulas to add a date table and measures summing sales for this year. Explore implicit measures vs. explicit measures.
• Program a formula with CALCULATE and SAMEPERIODLASTYEAR functions to produce the previous year’s total. Find the % Growth reusing custom measures and the DIVIDE Function.
• Tell the data story - format visuals, add in finishing touches - investigate themes, backgrounds, conditional formatting; refresh data and publish your results to the Power BI Service.
• Explore the Power Bi Service, activate a special workspace to collaborate with others online – publish and add reports to the new workspace.
• Consider various dashboard designs to launch multiple reports with tiles that preview the report. Pin several tiles to a custom dashboard. Add a visual with the Q&A feature.
• Examine the files used in the workspace. Transform the special workspace to an app to distribute your reports and share with others.
• Bonus: Share your app with others in the class. Open your app on the phone.

Power BI Reports and Dashboards Training Outline