(08) 9383 8000
Microsoft-Power BI Desktop-Level 2
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
Overview
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.
Skill level
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.
Content
- Learn how to build complex DAX formulas using variable and advanced functions
- Gain an understanding of how functions are evaluated
- Create formulas to analyse data over period of time using Time-Intelligence Functions
- Learn how to create dynamic visualisations using report themes, conditional formatting and KPI's.
Learning Outcomes
Participants should be able to:
- Build complex DAX formulas using variable and advanced functions
- Explain how functions are evaluated
- Create formulas to analyse data over a period of time using Time-Intelligence functions
- Build dynamic, striking visualisations.
Program can link to: Turn Data into Compelling Visual Presentations
Level - Fundamental
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.
Level - Intermediate
If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.