About this course
This an intermediate course that builds on the skills you gained in Microsoft Power BI Level 1.
You will learn how to create more advanced visualisations and work with Measures, DAX, Row Level Security, and Power Query to work with data in Power BI.
Review the course outline below to see what is covered.
Why Study Online?
- ZERO travel and flexible course delivery; complete this course online from home or at work.
- Study according to your schedule with 24/7 access to online course content.
- Fully equipped virtual classrooms. Attend real-time virtual classes with a certified trainer.
- Participate in interactive learning experiences.
- Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.
Rather study Face-to-Face?
Check out our Microsoft Power BI – Level 2 face to face Newcastle course for classroom delivery.
Prerequisites
The following pre-requisites apply to this course:
Is Power BI the same as Excel?
Power BI does not edit, add or change data like Excel does. It allows the creation of powerful dashboards and visually appealing graphical visualisations of existing data provided by Excel and other programs. It also leverages powerful tools to tidy up and fully normalise data from Excel into “Fact” and “Dimension” tables to allow much more efficient manipulation of the data.
Course structure and content
The following topics are covered in Level 2:
- The Business Intelligence process
- Data model and transformation
- Get data
- Power query editor
- Data transformation
- Check the data: Profiling
- Date transformations
- Load data
- Data Modelling
- Data Analysis Expressions
- The X functions
- Quick measures
- Time intelligence quick measures
- Secure and share data
View the attached document below for further information.
Latest Courses
Course Structure Download
PDF(152.19kB)
