About This Course

Building on from our Learn The Basics Of Power BI course, we will go much deeper as we teach you fully fledged Business Intelligence analyst skills by covering more advanced topics in Power BI.

Your ability to prepare data, carry out analysis, and visualize it will significantly improve, and you will be able to add a great deal more value to your company.

Please note that we are a team of senior level developers and analysts, not just trainers. We have developed our skills in the real world so what we teach is very practical and can be easily implemented. 

We will cover the following topics:

  • Data preparation: cleaning data sources, data types, date correction
  • Merge and duplicating queries
  • Deeper into DAX: time intelligence, year on year, last 30 days, running totals
  • Visualization: presentation, formatting, custom themes, conditional formatting, sync filters, drill through views
  • And much more

Requirements:

  • Ideally, you have already taken our first course Learn The Basics Of Power BI 
  • You will need access to Power BI, which can be obtained for free online or a pro version from your company

Who this course is for:

The scope of Power BI users is growing. Once the domain of analysts (Business Intelligent Data/ Reporting/MI Analysts), now many Accountants, Project Managers, Executive Assistants, and those working more and more with Analytics are using the tool.

Our Promise to You

By the end of this course, you will have learned how to use the advanced features of Power BI.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about Power BI.

Course Curriculum

Section 1 - Data Preparation
Course Resources 00:00:00
Clean Data In Query Editor 00:00:00
Power BI Data Types And Formatting 00:00:00
Transform Your Data With Custom Columns 00:00:00
Duplicate And Merge Queries 00:00:00
Date Correction 00:00:00
Erroneous Data 00:00:00
Section 2 - DAX
Introduction To Time Intelligence 00:00:00
Year Over Year Analysis And Day Analysis 00:00:00
Last 30 Days Analysis 00:00:00
Running Sum 00:00:00
Variables And Measures Within Variables 00:00:00
DAX Development Best Practices 00:00:00
Pareto Chart 00:00:00
Moving Average 00:00:00
Switch Function 00:00:00
Section 3 - Formatting And Design
Basic Report Formatting Tips 00:00:00
Custom Themes 00:00:00
Conditional Formatting 00:00:00
Drillthrough (Same Report) 00:00:00
Drillthrough (Cross Report) 00:00:00
Sync Slicers 00:00:00
Edit Interactions 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel