Power BI Training Sydney & Online for Corporate Employees
- 100% customised for your teams
- Why learn with strangers? Your team, your pain points, our solutions
- Trusted by Westpac, TJX, NSW Fire & Rescue, NSW Government Approved Supplier
- Choose onsite in your office or virtual, no public classes
- Use your sample business data during the course
- The only provider with 100+ verified Google Reviews
Power BI Onsite Training Sydney
Training in Power BI helps you to unlock the full potential of your data by teaching you how to create interactive reports and visualisations that provide valuable insights. With Power BI, you can easily connect to various data sources, transform raw data into meaningful information, and build dashboards that allow you to track key metrics and trends. We offer Power BI Dashboard in a Day training as well as Intermediate and Bespoke training solutions. Explore our other Microsoft Training courses
Duration
1 Day
Prerequisites
Participants will need to have basic computer skills and a general understanding of Excel and formulas. Attendees will need to have downloaded the Power BI Desktop app.
Quick Glance
Outcomes for your Business
Learning outcomes your team can expect after attending our Power BI workshops:
- Build interactive dashboards
- Create DAX measures
- Import Excel and SQL data
- Publish to Power BI Service
- Schedule refreshes
- Create KPI dashboards
Who Our Courses are are Designed For:
Our Power BI courses are designed for corporate teams, including:
- Business analysts
- Finance professionals
- Project managers
- HR
- Marketing
- Executives
Power BI Business Use Cases
Our Power BI training can be adapted to your business needs including:
- Sales reporting
- Executive dashboards
- Finance reporting
- HR analytics
- Manufacturing
- Healthcare and Government
Power BI Dashboard in a Day Training Sydney
Overview
- An Introduction to Power BI
- Working with Power BI desktop file
- Connecting to data sources with Power BI desktop
- Creating a report with visualisations
- Doing more with visualisations
Working with data
- Transforming and sanitising data
- Using the Query Editor
- Data modelling
- Managing relationships
Working with reports and visualisations
- Managing report pages
- Changing report view options
- Working with visualisations
- Adding static objects to a report
A closer look at visualisations
- Matrixes, tables, and charts
- Maps
- Cards, gauges, and KPIs
- Slicers
Introduction to the Power BI web app
- Getting started
- Connecting to data sources with the Power BI web app
- Using workspaces, dashboards, and reports
- Creating custom dashboards
- Power BI web app features
Power BI Intermediate Training Sydney
Power BI intermediate skills take your data analysis and reporting to the next level, enabling you to create more sophisticated visualisations, work with complex data models, and perform advanced data transformations. With intermediate knowledge, you’ll be able to leverage features like DAX for custom calculations, build interactive dashboards with dynamic filters, and implement data relationships to create comprehensive reports.
Overview
- Understanding cloud data source connections such as SharePoint, and how to safely and seamlessly update published reports
- Sanitising and troubleshooting data inconsistencies
- Modelling relationships for improved performance and flexibility
- Create and work with Date dimension tables and Time Intelligence DAX Improve DAX calculations with best practice functions
Working with SharePoint Document Libraries
- Connect with web links to Excel and CSV files
- Connect to a SharePoint folder and extract files with PowerQuery
- Append and Combine files in a SharePoint folder for seamless dynamic growth
Identify inconsistencies and errors and sanitise with PowerQuery
- Utilise PowerQuery column tools to identify problems
- Column Quality
- Column Distribution
- Column Profiling
- Sanitise data with a variety of PowerQuery tools and M Language techniques
- Split by delimiter
- Extract text before or after delimiter
- Trim redundant spaces
- Use M Language functions similar Excel text functions
- Columns from example
- Understand when to Pivot, Unpivot and Transpose
- Identify pivoted data and plan to sanitise
- Use PowerQuery techniques such as transpose and merge to create workable headers
- Append sanitised data
- Unpivot to create ‘columnar’ tables
Modelling relationships with PowerQuery and Schemas
- Understand Normalising and Denormalising
- Create Surrogate Keys (Indexing)
- Merge Tables
- Sanitise normalised tables to improve performance and efficiency
- Modify relationship properties such as cross-filter direction
Create and work with a Date Dimension Table
- Create a Date table with DAX
- Use the Calendar Function with Min and Max
- Use the CalendarAuto function with financial year end
- Build Calendar Year and Fiscal Year columns
- Mark the Date table to use Time Intelligence functions and validate
- Build custom date hierarchies
- Drill down through Calendar Year
- Drill down through Fiscal Year
- Control the sort order of calendar categories
Improve measures with DAX functions, including Time Intelligence functions
- Use the Calculate function to filter measures
- Use the Related function to retrieve related table fields
- Use Iterator functions such as SUMX and COUNTX to improve measure performance
- Use Time intelligence functions such as YTD, PREVIOUSMONTH, DATESINPERIOD, SAMEPERIODLASTYEAR
- Use SELECTEDVALUE, IF and ISBLANK in measures to automate visuals conditionally
Automate report navigation
- Work with drill down, drill through and drill tool-tip
- Manage synchronised slicers
- Create bookmarks
- Create buttons and link bookmarks
- Create navigation menus
Work with and modify the published dataset and published report
- Edit dataset web credentials to ensure seamless updates
- Embed the published report in a SharePoint page
- Create an Alert and get notified when a threshold has been achieved
- Create an App from multiple reports and dashboards in a Workspace
Power BI Advanced Training Sydney
Our advanced Power BI course is designed for business users and analysts looking to deepen their analytics capabilities using the latest features of Power BI. You will explore real-world data challenges and learn practical solutions to clean, model, and analyse data effectively. Contact us for a tailored 1 day advanced Power BI program.
Course Inclusions
What’s Included
Free Skills Assessment
Identify your current skill level before training begins.
Comprehensive Course Materials
Digital handouts and quick-reference guides for ongoing support.
Expert-Led Training
Delivered by experienced qualified trainers with real-world corporate expertise.
Contextualised Content
Training can be tailored to your organisation’s needs and skill levels.
Hands-On
Practical activities to reinforce learning and build confidence.
Certificate of Completion
Recognising your achievement and new skills.
Trusted by Businesses, Government and Not-for-Profit Organisations Across Australia
Our Most Popular Microsoft Training Courses
✓ Microsoft Copilot Training – AI-powered productivity with Microsoft 365
✓ SharePoint Training – end user and site owner training for SharePoint
✓ Microsoft 365 Training – maximise the value of your Microsoft investment
✓ Microsoft Project Training – project planning, scheduling and reporting
✓ Microsoft Teams Training – collaboration, meetings and file sharing
✓ Microsoft Word Training – professional document creation and formatting
✓ Microsoft PowerPoint Training – presentations that engage and influence
FAQS
Do you offer customised Power BI inhouse training for businesses?
Yes, our Power BI training courses can be delivered onsite at your offices in Sydney, Brisbane, Melbourne and across Australia.
Can I get tailored Power BI training sessions for my team onsite?
Yes, we offer tailored hands on Power BI workshops for teams who need to focus on specific areas or data sets.
Do you specialise in advanced Power BI training delivered onsite?
Yes, our onsite Power BI training sessions can be pitched at intermediate or advanced level and customised to your needs.
Can I book a Power BI trainer to come to our office in Sydney or Brisbane?
Yes, our trainers travel to all major cities in Australia to deliver training on Power BI.
Is Power BI training available virtually?
Yes, our trainers are experts at both face to face and virtual delivery of our Power BI programs.
Can your Power BI courses be customised for our data?
Yes, we can contextualise the training to include sample data making the training more relevant.
Do you offer a free Power BI contextualisation meeting?
We offer a complimentary 30-minute session to understand your team’s goals, data challenges, and training needs. This helps us tailor your onsite Power BI course for maximum relevance and impact.
Onsite Training
Roving Trainers
Virtual Training
Training Roll-outs
We're Here To Help!
Call Us
02 9454 7702
Hours
M-F: 9am - 5pm
S-S: Closed