01483 688488 01483 688488 Request a callback Email us
Microsoft
Office 365Office 365
AccessAccess
ExcelExcel
OutlookOutlook
Power AutomatePower Automate
Power BIPower BI
PowerPointPowerPoint
ProjectProject
SharePointSharePoint
VisioVisio
WordWord
Adobe
After EffectsAfter Effects
CaptivateCaptivate
Creative CloudCreative Cloud
IllustratorIllustrator
InDesignInDesign
PhotoshopPhotoshop
Premiere ProPremiere Pro
CAD
AutoCADAutoCAD
RevitRevit
SketchUpSketchUp
SolidWorksSolidWorks
Technical
Crystal ReportsCrystal Reports
HTML & CSSHTML & CSS
MapInfoMapInfo
RR
SPSSSPSS
SQLSQL
WordPressWordPress
Finance
Finance CoursesFinance Courses
XeroXero
Soft Skills
AssertivenessAssertiveness
Chairing MeetingsChairing Meetings
Minute TakingMinute Taking
Team LeaderTeam Leader
Time ManagementTime Management
Executive Coaching
Deliver Confident & Impactful Presentations Training
Power BI Training: 2 Day Advanced Course

Power BI Training: 2 Day Advanced Course

4.87 / 15 reviews

Introduction

Master Power BI’s most powerful functions on this 2 day Advanced Power BI training course. 

This is a hands-on course. You get lots of time to practise creating and editing reports and data visualisations. This ensures that you really get to grips with what you are being taught.

By the time you finish, you’ll be an expert Power BI user.

✔ A complete advanced Power BI course that covers 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 Power BI course you will be able to confidently:

  • Create and customise a report in Power BI.
  • Drilldown into the data in a model.
  • Build drill-through reports and relative date reports.
  • Create stunning data visualisations including maps, bullet and scatter charts.
  • Refresh your data manually and also at pre-set intervals.
  • Set security and data permissions.

 

The Trainer

Oakley is our usual trainer for this course. He has been a Microsoft certified trainer for 8 years.

He has been training Microsoft applications for 19 years, and focuses on Power BI and Project.

 

Am I Ready For This Course?

This course assumes you are already a comfortable Power BI user. 

It is recommended that you have completed at least our introduction to Power BI course, and ideally our Excel BI training course. or that you have equivalent experience, before attending this course.

The course assumes that you already have a good understanding of the basics of Power BI including using DAX and measures and creating dashboards.

If you are new to Power BI but keen to become an advanced user we would recommend that you look at our combined power bi course which offers you both introduction and advanced training with a £100 reduction.

The Training Day

We provide everything that you’ll need for a really fun, productive day of Power BI training. You don’t need to bring anything with you.

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 A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take your course exercises home with you.
✔ A Certificate of Attendance.

Course Details

  • What is Power BI?
  • The main concepts the course will cover
  • Power Query
  • Power BI Desktop
  • Introduction to DAX
  • Implicit vs Explicit Measures
  • Creating Measures & Calculated Columns
  • Commonly Used DAX Functions
  • SUM, AVERAGE, COUNT, DISTINCTCOUNT
  • Time Intelligence (MTD, QTD, YTD, Prior Year)
  • Understanding ‘CALCULATE’ and the filter context
  • Using Quick Measures
  • Build a Monthly Trend Report
  • Types of Slicers and Filters
  • Using Field, Format, Analytics Pane
  • Building Tabular Reports
  • Replicating Excel Pivot Tables
  • Types of Conditional Formatting
  • Optimizing the Matrix Layouts
  • Adding Drill-Downs
  • Creating Drill-Through Reports
  • Filtering Reports by Relative Dates
  • Viewing the Underlying Data Driving a Visualization
  • Customizing Report Visual Interactivity
  • Exporting Data from Power BI
  • Build a Qty Shipped Vs Qty Sold Report
  • Building Reports using Q&A
  • Optimizing Report Slicers
  • Choosing Visuals Based on Context
  • Using Custom Visuals
  • Optimizing the use of Maps
  • Getting Value from Scatter, Ribbon & Bullet Charts
  • Adding & Optimizing Tool Tips
  • Visual Alignment Tips
  • Custom Page Sizing
  • Using Logos & Custom Icons
  • Formatting Tips & Tricks
  • Understanding Row Level Security
  • Creating and Testing Security Roles
  • Publishing Models to the Cloud Service
  • Basic Sharing of Dashboards & Reports
  • Creating App Workspaces
  • Adding Users & Editing Workspaces
  • Connecting to Apps / MS Teams
  • Overview of the Data Gateway
  • Scheduling Data Refreshes
  • Refreshing On-Demand

Online Training Requirements

To attend this Power BI course online, you will need:

✔ MS Power BI 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 to attend the course

If you have access to a second screen, we would encourage you to use it as it improves the experience.