(08) 9383 8000
Microsoft-Power BI Desktop-Level 1
Level - Advanced
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.
1 Day
Overview
The Microsoft - Power BI Desktop - Level 1 course will help you to transform raw data into useable visualisations to gain more comprehensive insight into your organisation.
Content
- Learn about the components of Power BI Desktop
- Learn how to connect to source data
- Understand the data model
- Add fields to the data model
- Perform calculations using DAX (Data Analysis Expressions)
- Create dynamic reports using the built-in visualisations.
Learning Outcomes
Participants should be able to:
- Explain the different components that comprise Power BI Desktop
- Explain the data model
- Build dynamic, striking visualisations.
Program can link to:
Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
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.