Really good, clean, easy to follow, with many examples. Once you finish with this course you can start with your own first Power BI report even if you have n...
Read MoreReally good, clean, easy to follow, with many examples. Once you finish with this course you can start with your own first Power BI report even if you have never done one before. Can’t wait for new and more advanced training sessions. Thanks Wyn!
Read Lesswell-structured, clearly explained, and full of practical insights. I especially appreciated the practical examples and useful “good practice” tips that help...
Read Morewell-structured, clearly explained, and full of practical insights. I especially appreciated the practical examples and useful “good practice” tips that help avoid common mistakes and improve long-term work quality. Each step is easy to follow and thoughtfully explained, which makes the learning process smooth and effective. Highly recommended for anyone who wants to build solid Power BI skills.
Read LessThis course is incredibly thorough and highly practical. I'm very thankful to Wyn Hopkins from Access Analytic for putting it together. Anyone looking to bec...
Read MoreThis course is incredibly thorough and highly practical. I'm very thankful to Wyn Hopkins from Access Analytic for putting it together. Anyone looking to become proficient in Power BI will definitely benefit from taking this course.
Read LessSome of the wonderful feedback we've had about the in-person course
This feedback is from the in-person delivery of this course
Why Access Analytic is the right choice
Do other courses have these credentials?
Subject Matter Expert Instructor ( Microsoft MVP )
A decade of classroom experience
Focussed - Highly Relevant Content
Price in USD
Welcome - What is Power BI?
FREE PREVIEWHow to get the latest version of Power BI Desktop
Download the Exercises
Offer to host your report!
FREE PREVIEWCritical Lesson - Setting things up
Familiarising ourselves with Power BI desktop
Importing Data with Power Query
Initial understanding of column Data Types and removing rows
A sneak peak of adding visuals to the page
Power Query Magic Part 1 - Column From Examples
FREE PREVIEWPower Query Magic Part 2 - Transforming Text
Power Query Magic Part 3 - Adding an Age column and choosing what to import
Final Steps - Data Quality and Data Visualisation
Adding a DAX Measure
What if your data source is moved or renamed?
Publishing and Licencing
FREE PREVIEWQuiz: Introduction to the basics
Recap on the introduction
FREE PREVIEWAn overview on the aim of this exercise
Cleaning up the Project Cost Data
Adding Dimension (Lookup) Tables
Explaining Relationships and How Dimensions Filter Facts
The Calendar Table
FREE PREVIEWFormatting your visuals for a clean look
Unpivoting and comparing against Budget
Editing Visual Interactions
Creating a Map visual and debugging errors
Quiz: Building a multi table semantic model
Adding Columns in Power Query to assist your analysis
FREE PREVIEWUsing Columns in Visuals
DAX Measures: Variance and formatting negatives
Create a MyMeasures table to organise your measures
Date Based DAX: Year To Date - Cumulative Totals
Date Based DAX: Full Year Budget - Introducing CALCULATE and explaining the Filters
Date Based DAX: Prior Period Comparisons - including chart
Closing Thought: You MUST use Measures
DAX Tips Card - Access Analytic
Quiz: Power Query and DAX
Includes access to Forum and hosting of a showcase dashboard
USD