Master Power BI’s most powerful functions on this hands-on 2 day course.
The course includes lots of time to practise creating and editing reports and data visualisations so that you can ask questions and try things out.
By the time you finish, you’ll be an expert Power BI user.
✔ A course covering all of Power BI’s most advanced functions.
✔ Plenty of one-to-one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.
What Will I Learn?
This course will allow you to master Power BI’s most powerful functions.
By the end of this course you will be able to confidently:
- Create and customise a report in Power BI.
- Use Drill Down and Drill Through.
- Use Custom Tooltips and Bookmarks
- Create suseful data visualisations including maps, guage and dynamic images.
- Use Slicers and Filter to build more complex report pages
- Optimise your Data and Relational Model
Am I Ready For This Course?
This course assumes you already understand the basic of Power BI including measures and creating dashboard.
It is recommended that you have completed our Power BI Introduction course or have equivalent experience before attending this course. It is expected that you will have a working knowledge of Power BI, including Report design techniques and using Measures
The Training Day
Our training courses run from 9.30am to approximately 4.30pm with a break for lunch and plenty of refreshments and biscuits throughout the day.
We offer comfortable, fully air-conditioned training facilities and some of the nicest instructors on the planet.
Also, you’ll receive:
✔ A full-colour manual which covers everything in the course.
✔ Your course exercises so that you can practice at home.
✔ A Certificate of Attendance.
Course Details
Download full course details
- Main Concepts
- Transformation with Power Query
- Report Design with Report Builder
- M-Code vs DAX
- Working with Power BI Backgrounds
- Introduction to DAX
- Creating Measures & Calculated Columns
- DAX Measure and Column Syntax
- SUM vs SUMX
- FORMAT & WEEKDAY functions
- Build a Monthly Sales/Profit Report
- Using Slicers and Filters
- Working with Power BI Panes
- Building Tabular Reports
- Working with Matrix Layouts
- Types of Conditional Formatting
- Adding Drill-Downs
- Creating Drill-Through Reports
- Custom ToolTips
- Bookmarks
- Creating a Comparison Page
- Editing Interactions for Slicer/Visual Interactivity
- Custom and Conditional Formatting
- Build a YTD Summary and Detailed Report
- Time Intelligence (MTD, QTD, YTD, Prior Year)
- Understanding CALCULATE to filter
- Understanding IF and SWITCH
- Understanding DIVIDE
- Using Quick Measures
- Creating % Ratio and % Change with DAX
- Working with Charts
- Optimizing the use of Maps
- Managing and using imported Power BI Visuals
- Working with Dynamic Images
- Adding In-Page Navigation
- Mobile Layout Design
- Working with Related Tables
- Model View and Relationship Management
- Introduction to Join Types
- Modelling best practice
- Merging and Disabling Load
We will briefly introduce you to ChatGPT and its possibilities when using Power BI.
- ChatGPT vs Bard vs Other AI tools
- Some of the ways you can use ChatGPT with Power BI
- A very simple example
As this section is a brief taster, it is not covered in our course materials or post-course support.
Online Training Requirements
To attend this Power BI course online, you will need:
✔ The latest version of Power BI Desktop running on a Windows PC with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom
We would strongly recommend a second screen, as it improves the experience.
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/