Microsoft Power BI Training – The Essentials

Course Times

• 9am to 4pm

Data Sources, Importing and Sharing

• Importing from Structured data sources
• Importing from Semi-Structured data sources
• SharePoint and OneDrive
• Data source sharing

Data Cleaning and Transforming

• Data Cleaning
• Common Transformations
• Unpivoting
• The M language
• More complex transformations

Data Modelling: Structuring

• Creating Relationships
• Data Storage Vs Data Model
• The star schema (Fact and Dimension tables)
• De-normalising data

Data Modelling: Calculations, Measures and DAX

• Basic DAX concepts
• Creating calculated columns
• Calculated Columns with DAX
• Adding a Date/Calendar table
• Using Measures with DAX
• Creating Measures with DAX

Advanced Visualisations

• Choosing the best visualisation to present your data
• Comparisons and Rankings
• Change over time and Trends
• Spatial Data
• Downloading and using additional visualisations

Excel in business with our premier Power BI essential training. If you would like to find out more about our Microsoft Power BI course, please contact us today or feel free to give us a call on (08) 9218 9059.

• Understand the generic Business Intelligence process
• Understand the Power BI Architecture and its components
• Be able to analyse a scenario and work out the best model for output of results
• Use the Power BI Desktop to import, clean and transform data
• Use Power Query to create the best model for output of the results
• Use a variety of visualisations to present the outcomes in an understanding manner
• Load visualisations into the Power BI Service and share data with others

Completion of a Microsoft Excel Intermediate course or the equivalent knowledge is required.

Also a basic knowledge of how databases work, and database theory would be helpful.

“Would highly recommend to upcoming Business Managers and Business Analysts” Samantha from WA Country Health Service

“Thank you for an informative course, I will be using a lot of this content to apply to my own work. It was a well planned and presented course with excellent content to work through” Jessica from Dept. of Education

“Terrific course. This is difficult subject matter to teach and the quality of instruction far exceeded my expectations” Ben from Rio Tinto

“The best feature of this course was the umbrella view of theory and how this would connect to my work” Nigel from Dept. of Education

“Excellent introduction to presenting and analysing data. The software features were well demonstrated and non-repetitive. A lot was covered in the duration” Mike from Duratec Ltd

“The best part of this course was its interactive nature and the opportunity to apply our skills in workshops at the end” Bryan from BHP

“I enjoyed reviewing the examples in detail, and the step by step approach was extremely helpful. This course was set at a good pace” Sue from Dept. of Education

“The trainer was detailed in explaining the course and very patient when answering questions. He also gave us examples to work on together so we could practice our skills” Novianty from Sage Automation

“A great overview of basic functions and more advanced possibilities. Filled with lots of practical examples and the trainers were helpful in pointing where errors might occur” Vincent from Dept. of Primary Industries and Regional Development

“A well-structured course with good use of examples. It was very helpful to work through examples with the instructor’s screen next to yours” Johan from Davey Bickford Enaex Australia