Power BI Training

Do you want to learn from the experts?

Microsoft Power BI Training Sydney and Online

Agile Analytics is a Microsoft Gold Partner offering Power BI training in Australia by industry experts to transfer knowledge and develop applicable skills for your team. Our courses cover a variety of topics across business functions based on typical business pain points using materials developed by industry experts and Microsoft. All our courses can be customised to your specific needs and delivered at our training facilities, at your location or virtually.

Why training with Agile Analytics is different?

  • We don’t work from a manual or a script; our consultants use a dynamic, hands-on approach including group projects, real-life scenarios and interactive discussions.
  • We draw on our extensive experience in the IT & Business spheres to simulate problem scenarios which your organisation faces in the real world.
  • We provide industry best practises to help you overcome the problems you face, leveraging our expertise that we use to teach in the field every day.

Be Trained By The Experts

20180729_163538-600x329

Iman Eftekhari (MCT, MCSE BI / Charter) has over 19 years of consulting experience in Data Analytics and BI.

Since the release of Power BI, Iman has been an evangelist, running regular sessions at Microsoft to promote Power BI to the market. He has run public and in-house training courses for more than 100 organisations and trained over 2000 people.

Iman is the founder and co-organiser of the official Power BI User Group in Sydney and is a regular speaker at user groups and seminars in Australia and overseas.

Cyrus Mohseni (Microsoft Certified Trainer) having worked within the education and training industry for over 15 years as well as the IT industry for 10 years, Cyrus brings a wealth of experience and skill. Throughout his career he has been involved in the development and facilitation of numerous training programs for government and non-government organisations aimed at providing individuals with the skills they require to achieve formal qualification status.

Matt Allington MVP

Matt Allington (MVP) is a career expert in Power BI training and has 30+ years experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Pivot and Power Query. He brings his business and IT experience to the table to get fast and effective results and help you with general business data problem solving.

Matt is the author of the books “Supercharge Power BI: Power BI is Better When you Learn to Write DAX” and “Supercharge Excel: When You Learn To Write DAX For Power Pivot”.

Daniil Maslyuk is a Power BI consultant, author and trainer. He has been consulting and training Power BI solutions since it became available.

Daniil is the author of the official Microsoft Power BI exam reference book, and a regular presenter at technical conferences, such as SQL Saturday, PUG and Power BI World Tour.

IMG_3725-600x431

What will I learn?

These workshops are designed to help you start or accelerate your Power BI experience with a comprehensive training program in a single day.
You will learn how to query, reshape and pull in data, how to organise the results into a data model with relationships and calculations (DAX). Finally, you will learn the best way to visualise your data through a variety of charts, graphs, maps and how to share it with others and keep them up-to-date.

There are different cources for different roles in IT and Business, and levels from basics to advanced. Please contact us to get the detailed agenda and tipics. 

Power BI Intro

  • Power BI overview
  • Connect, shape and clean data
  • Overview of Data Modelling
  • Creating calculations using DAX
  • Data visualisation best practices
  • Automating data refresh
  • Publish and sharing reports
  • Group project

Data Modelling and DAX

  • Power BI new features
  • Data Modelling for Power BI
  • Import, Direct Query, Live, and Composite mode
  • Row-level Security (RLS), static and dynamic
  • Optimising your data model
  • DAX best practices​
  • Caclulated Columns and Measures
  • How to use the CALCULATE() function
  • Hands-on labs

Advanced Data Visualisation

  • Science behind the Data Visualisation
  • Dashboard design best practices
  • Chart selection and report design tips
  • Applying organisational branding and theme
  • Advanced Data Visualisation techniques
  • Bookmarks, Buttons, Actions, and Tooltips
  • How to enable R & Python for Advanced Analytics
  • Hands-on labs

Advanced Data Wrangling

  • Power Query
  • Advanced Data Transformation
  • Introducing to M
  • M vs. DAX
  • Join types and scenarios
  • Power Query best practices
  • Data Flow, Power Automate, and Power App
  • Optimising your data transformation pipelines
  • Hands-on labs

Advanced DAX and Data Modelling

  • Deep dive into the Data Modelling techniques
  • Understand the consequences of data model design decisions
  • Relationship types and use cases
  • Learn a deep understanding of DAX formulas
  • Understand advanced concepts of calculated columns and measures
  • Evaluation contexts and context transition.
  • Writing complex formulas using the VAR syntax
  • Other DAX patterns to solve business problems.

Power BI Architecture

  • Power BI for enterprises
  • Power BI Admin
  • License types and considerations
  • Security options
  • Deployment best practices
  • Governance and control
  • Typical use cases for self-service and governance
  • Data Flow, Power Automate, and Power App
  • Building scalable solution with 3-layer architecture

Some Of Our Satisfied Customers

Do you have any questions regarding our training courses?

Contact Us

Book your next training or ask us about our customised in-house training at your organisation


You will learn:

  • How to extract insights from your data
  • How to move from Excel to a Power BI solution
  • How to connect to all your data sources from Power BI
  • How to automate your data process
  • How to reshapre and model your data
  • How to create professional reports in minutes
  • How to share & publish your reports internally and externally