Power BI Training
Learn Power BI from the world-class experts
Microsoft Power BI Training: In-person and Online
Agile Analytics is a Microsoft Gold Partner offering Power BI training in Australia by industry experts and Microsoft Certified Trainers (MCT) 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 of our courses can be customised to your specific needs and delivered virtually or at your location.
On-Demand In-House Training
From $3000
Public
Training
From $400
Why training with Agile Analytics is different?
Free monthly Q&A sessions and refresher offers
- We don’t work from a manual or a script; our trainers 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.
Free monthly Q&A sessions with the world-class industry experts
Be Trained By The Experts
Iman Eftekhari (MCT, MCSE BI / Charter) has over 20 years of consulting experience in Microsoft Data Analytics and BI.
Since the release of Power BI, Iman has been running regular sessions with Microsoft to promote Power BI and help organisations become data-driven.
He has run public and in-house training courses for 100’s of organisations and trained 1000’s at different levels of Power BI.
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 (MCT: 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) 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”.
Ali Sharifi (MSCE/BI, blogger) is a principle consultant, mentor, certified trainer, and data enthusiast who successfully designed and implemented over 50 solutions across corporates and SMEs in Australia.
With over 20 years of experience in analytics, data warehousing and DevOps, he has been sharing his experiences by providing Power BI hands on training to both individuals and companies.
Dharmesh Thaker has over 12 years of consulting experience in various Microsoft technologies, including SQL Server and Power BI.
Working with many industry leading, multinational clients for more than a decade, Dharmesh has gained a high degree of proficiency in architecting and designing solutions in Data and BI space.
Over the past years, Dharmesh has been focussing on leveraging Microsoft Power Platform (including Power BI, Power Automate (Flow) and Power Apps) in delivering large scale analytics and reporting solutions to various clients in finance, education and public sector domains.
Apart from being a hands-on developer, Dharmesh enjoys running technical training on various topics (especially, SQL and Power Platform) and sharing his knowledge and experience with the community.
Arno Wakfer is a Power BI Consultant at Agile Analytics and is certified by Microsoft as a Power BI Data Analyst as well as a Business Intelligence and Data Analyst (BIDA) with the Corporate Finance Institute. During his 15 years in Finance, he led various finance transformational projects and was a former CFO at the Top Business School in Africa.
Arno transitioned from a career as a Chartered Accountant to a Data Analyst. Arno is experienced as a Power BI developer in business insights by analysing and visualising data to help businesses drive their better performance through actionable insights.
He has trained more than 100 finance professionals across 20 businesses in Australia. As a trainer he enjoys upskilling Finance professionals and teams in Power BI. You can follow him on LinkedIn for regular insights, tips and best practice on using Power BI”.
What will you 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 courses for different roles in IT and Business, and levels from basic to advanced. Please contact us to get a detailed agenda and topics.
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
- Calculated Columns and Measures
- How to use the CALCULATE() function
- Hands-on labs
Intermediate 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
Power Apps and Power Automate
- Build Business applications using Power Apps
- Power Apps licences and environments
- Building a Canvas App, and designing App screens
- Deploying canvas Apps across multiple environments
- Integrating Power Apps with Power BI
- Automating processes and workflows using Power Automate
- Building a Power Automate flow
- Deploying flow across multiple environments
- Integrating Power Automate with Power Apps and Power BI
Power BI Finance Reporting and Analytics
- Extract, load and transform raw financial data
- Understand the correct data structure for data modelling in Power BI
- Build relationship between financial transactions and dimension tables
- Learn DAX in creating finance and ratio calculations
- Design dynamic Financial reporting dashboards using customised reporting layouts
- Perform financial analysis by constructing a ratios dashboard
- Discover advanced visualisation techniques for Financial reporting
- Best practice and productivity tips and tricks
- Hands-on labs
Public Courses
Power BI Intro – Online Training – Australia – 7 Sep 2022
This end-to-end introduction to the Power BI course offers you the opportunity to get hands-on training from the experts. Book now, reschedule it up to a day before the session! Post-training […]
Power Apps & Power Automate Training – Online – Australia – 21-22 Sep 2022
This 2 day training focuses on two important components of Power Platform – Power Apps & Power Automate. Our Power Apps & Power Automate course offers you the opportunity to […]
Power BI Intro – Online Training – Australia – 5 Oct 2022
This end-to-end introduction to the Power BI course offers you the opportunity to get hands-on training from the experts. Book now, reschedule it up to a day before the session! Post-training […]
Power BI Finance Reporting and Analytics – 12-13 Oct 2022
This 2day workshop program is designed for any Finance professional who has no prior experience in working with Microsoft’s Power BI Desktop Course outline This 2-day workshop program is designed […]
Power BI Intro – Online Training – Australia – 9 Nov 2022
This end-to-end introduction to the Power BI course offers you the opportunity to get hands-on training from the experts. Book now, reschedule it up to a day before the session! Post-training […]
Power BI Data Modelling & DAX 2 day Online Training – 23-24 Nov 2022
Our Power BI Data Modelling & DAX course offers you the opportunity to get hands-on training from the experts. Book now, reschedule it up to a day before the session! […]
Do you have any questions regarding our training courses?
Contact Us
Ask us about our customised in-house training online or at your office
You will learn:
- How to extract insights from your data
- How to move from Excel to a Power BI solution
- Power BI licensing options
- How to connect to all your data sources from Power BI
- How to automate your data refresh process
- How to reshapre and model your data
- How to create actionable reports
- How to share your reports internally and externally
