Power BI (Business Data Analytics)

This 3 full-day training course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data.

This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.

The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they’ve learned to their own data.

This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course.

In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn’t be able to do what they need to do.

This is an introductory course and although it does not assume any prior experience with Power BI®, participants will gain much more from the course if they have at least used Power BI® a little prior to attending.

Participants who have taught themselves Power BI® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know.

A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.

Learning Objectives:

• Confidently use the Power BI® solution, including Power BI® Desktop, PowerBI®.com and the Power BI® Gateway
• Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis
• Combine data sources together and gain an introductory understanding of the M language
• Write formulas using the DAX language for generating custom columns, measures and tables
• Design reports and dashboards using a wide range of both built-in and custom visuals
• Publish reports and dashboards to PowerBI®.com
• Share reports and dashboards with others using PowerBI®.com
• Customize reports and dashboards so that different user groups automatically see their own personalized views