Power BI Course Details
Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.
The comparison table will help you find the course specific to your learning needs:
Power BI Dashboard in a Day 1 day - $500
This course covers the end-to-end steps of developing, publishing, and sharing Power BI reports and dashboards. It best suits people with no or basic Power BI skills to learn about Power BI elements and the best practices in creating the reports. The attendees will learn about:
- Transform data from a variety of data sources
- Define business rules and KPIs
- Explore data with powerful interactive visuals
- Build stunning reports
- Publish the reports to Power BI Service on the web
- Share their dashboards with their team members
Course Topics
- Overview of Power BI elements
- Accessing different data sources
- Overview of Power Query
- Data cleansing, shaping, and transformation
- Using M language in Power Query
- Basic of Data Modelling
- Creating Relationships
- Developing reports by standard and custom visuals
- Visualisation best practices
- Advanced visualisation: Bookmark, Tooltip, Drill Through
- Introduction to DAX
- Create measure and calculated column by DAX
- Publishing and sharing report in Power BI Service
- Creating dashboard
Mastering in DAX and Data Modeling 1 day - $600
This course best suits people with basic to intermediate Power BI skills and seeking to enhance their knowledge in data modelling, Power Query advanced functions and writing DAX formulas. The attendees will learn about:
- Create and optimize a data model
- Understand the consequences of data model design decisions
- Create queries using M
- Understand the use of Power Query functions
- Understand concepts of calculated columns and measures
- Create advanced calculations with DAX
Course Topics
- Getting and shaping data
- Understand data storage in Power BI
- Basic of data modeling
- Creating Dimensions, Fact and Shaping the data
- Creating Relationships
- Use parameters and functions
- Use techniques to reduce size of data
- Introduction to DAX
- DAX Evaluation, Filter and Row contexts
- DAX functions - Aggregator/Iterator
- Deep dive to Calculate function
- DAX Time Intelligence
- DAX table functions
- Querying data by DAX
Power BI Comprehensive Training 2 days - $1000
We have designed this two days training workshop to help you promote your Power BI skills to a higher level quickly. It is a combination of Dashboard in a Day and Mastering in DAX and Data Modeling courses. The attendees can learn how to develop Power BI reports with modelling best practices and using DAX formulas.
- Day 1: Power BI Dashboard in a Day
- Day 2: Mastering in DAX and Data Modeling
| Power BI Dashboard in a Day | Mastering in DAX and Data Modelling | Power BI Comprehensive Training |
|---|---|---|
| 1 day | 1 day | 2 days |
| Course details | ||
| Overview of Power BI (Desktop & Service) | Getting and shaping data | Day 1: Power BI Dashboard in a Day |
| Accessing different data sources | Understand data storage in Power BI | Day 2: Mastering in DAX and Data Modelling |
| Overview of Power Query | Basic of data modeling | |
| Data cleansing, shaping, and transformation | Creating Dimension, Fact and Shaping the data | |
| Using M language in Power Query | Creating Relationships | |
| Basic of Data Modelling | Use parameters and functions | |
| Creating Relationships | Use techniques to reduce size of data | |
| Developing reports by standard and custom visuals | Introduction to DAX | |
| Visualisation best practices | DAX Evaluation, Filter and Row contexts | |
| Introduction to DAX | DAX functions – Aggregator/Iterator | |
| Create measure and calculated column by DAX | Deep dive to CALCULATE function | |
| Publishing and sharing report in Power BI Service | DAX Time Intelligence | |
| Creating dashboard | DAX table functions | |
| Refreshing data by Power BI Gateway | Querying data by DAX | |
Due to the COVID-19 restriction, we have cancelled our face to face classroom training sessions but instead, we are introducing remote workshops to support the hundreds of remote workers willing to upskill their Power BI capabilities. The courses will be run on Zoom with a maximum of 5 attendees. Below is the list of our courses for the coming months.
| Course Name | Course Date | Time | Price | Enrolment |
|---|---|---|---|---|
| Power BI Dashboard in a Day | 16 Sep 2021 | 9am – 5pm | 500 AUD | Open |
| Power BI Comprehensive 2 days | 23- 24 Sep 2021 | 9am – 5pm | 1000 AUD | Open |
| Mastering in DAX and Data Modelling | 30 Sep 2021 | 9am – 5pm | 600 AUD | Open |
| Power BI Dashboard in a Day | 14 Oct 2021 | 9am – 5pm | 500 AUD | Open |
| Power BI Comprehensive 2 days | 21- 22 Oct 2021 | 9am – 5pm | 1000 AUD | Open |
| Mastering in DAX and Data Modelling | 28 Oct 2021 | 9am – 5pm | 600 AUD | Open |
Register for a session today by filling in your details below and we will get in contact with you for payment and booking confirmation within 24 hours.