Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions.
1 Day
This course introduces more advanced DAX (Data Analysis Expressions) concepts including variables, takes a deeper look at how functions are evaluated, analyses data over time using Time-Intelligence Functions and introduces more advanced visualisations concepts.
This course is designed for those who are ready to explore more of the advanced functions of Power BI. While there are no prerequisites the course assumes an intermediate level understanding of Power BI, gained through formal training or hands-on experience.
Participants should be able to:
Program can link to: Turn Data into Compelling Visual Presentations
Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.
Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
Level - Intermediate
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.