This two-day instructor led course will take you through the process of using Power Query and Power BI Desktop to analyse data.  This course will help you develop the skills to take raw data and transform it before incorporating it into a data model.  Date models are then used to build interactive visualisations that allow data to be explored.

Each section of the course will provide an opportunity to explore the new subject area, followed by an exercise to reinforce learning.   

Who will benefit from this course

This course assumes no prior knowledge of Power Query or Power BI but attendees should be familiar with Excel and the concepts of datasets and basic reporting.

Key elements of the course 

• Introduction to Power BI and working with Power BI Desktop
• Import data from a variety of sources
• Use tools to remove, replace, split, merge and filter data
• Learn how to group and aggregate data to reduce dataset 
• Add new columns using calculated fields
• Understand data models and create relationships between tables
• Create calculations with DAX
• Learn the difference between calculated fields and measures
• Create measures with DAX
• Create a Date Table and use DAX for time period-based evaluations
• Work with reports and visualisations in Power BI Desktop
• Publish reports and create dashboards

Course Details

This is a two-day, tutor led, on-line course the dates for which are set out on the Course Schedule. It can also be run as a tailored, company specific course either on-line or at an organisation’s premises.