Power BI - Advanced
Programme Overview & Summary
This two-day course covers advanced ways to extract, transform and load data, including learning a host of Power Query transforms, learning how to link to APIs, data flows and other data sources and how to work with parameters
Style and Approach
Audience
Programme Structure
2 day classroom learning.
Preparing for the workshop
Prerequisite & Requirements
None required.
Supporting Resources
Course Duration
2 days
Course Cost
For all our course pricing please login at Course pricing. Please Note: Only employees with a Network Rail email address will be allowed access.
Learning delivery
Classroom based.
Course Objectives
Learning how to link to APIs, data flows and other data sources and how to work with parameters.
Accreditation
Power BI - Advanced accreditation.
Course Progression
Stand alone course.
Course Syllabus/Topics
The course will cover a comprehensive and applied understanding of the following topics:
- Advanced DAX formulas and techniques
- Advanced Data Modelling (including the use of M language)
- Setting up an efficient Model and Schema
- Using Power Query: Pre-aggregating data, Merging data and Pivoting data
- Workflows - Using Flow or a third-party tool
- Dynamic connections - SQL Server
- R Script
- Use of Azure and effective data connections
- How to get around time intelligence.
Course Learning Outcomes
At the end of the training the delegate will be able to:
How to apply
If you would like to attend this course or have any queries about your projects following the course, or wish to submit your project for accreditation, please goto our how to book webpage.
