Become proficient in advanced Power BI. Learn expert data prep, DAX, and visualizations for improved analytics and decision-making. Read more.
We are a collective of highly experienced professionals from the UK and North America who have packed decades of practical skills into top courses!
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- The use of Power BI is rapidly expanding beyond data analysts (Business Intelligence, Reporting, and MI Analysts) to a broader audience. Accountants, Project Managers, Executive Assistants, and professionals increasingly working with analytics are now leveraging this powerful tool.
What you’ll learn:Â
- Data Preparation: Cleaning data sources, managing data types, correcting dates
- Merging and Duplicating Queries
- Advanced DAX Functions: Time intelligence, year-over-year comparisons, last 30 days analysis, running totals
- Visualization Techniques: Custom themes, conditional formatting, sync filters, drill-through views, presentation, and formatting
- And much more!
Requirements:Â
- Ideally, you have already completed our foundational course, Learn the Basics of Power BI.
- You will need access to Power BI, which can be obtained for free online or through a company-provided Pro version.
Building on the foundational knowledge from our Learn the Basics of Power BI course, we’re thrilled to offer advanced Power BI training to further elevate your skills. This course dives deep into more advanced aspects of Power BI, transforming you into a proficient Business Intelligence analyst.
You’ll master complex advanced Power BI concepts, refine your data preparation techniques, and enhance your ability to create compelling visualizations. These skills will enable you to add significant value to your organization.
Our team consists of seasoned senior developers and analysts with hands-on industry experience. This practical expertise sets us apart from other trainers and ensures that the knowledge you gain is immediately applicable in real-world scenarios. Let us help you excel through advanced Power BI skills, whether you’re self-learning or taking Power BI online courses to boost your career.
Our Promise to You
By the end of this course, you will have mastered advanced Power BI skills that will empower your career.
10 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.
I recommend checking our other courses on Microsoft, Programming, and Marketing on our Instructor Profile page.
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 | ||
About This Course
Who this course is for:
- The use of Power BI is rapidly expanding beyond data analysts (Business Intelligence, Reporting, and MI Analysts) to a broader audience. Accountants, Project Managers, Executive Assistants, and professionals increasingly working with analytics are now leveraging this powerful tool.
What you’ll learn:Â
- Data Preparation: Cleaning data sources, managing data types, correcting dates
- Merging and Duplicating Queries
- Advanced DAX Functions: Time intelligence, year-over-year comparisons, last 30 days analysis, running totals
- Visualization Techniques: Custom themes, conditional formatting, sync filters, drill-through views, presentation, and formatting
- And much more!
Requirements:Â
- Ideally, you have already completed our foundational course, Learn the Basics of Power BI.
- You will need access to Power BI, which can be obtained for free online or through a company-provided Pro version.
Building on the foundational knowledge from our Learn the Basics of Power BI course, we’re thrilled to offer advanced Power BI training to further elevate your skills. This course dives deep into more advanced aspects of Power BI, transforming you into a proficient Business Intelligence analyst.
You’ll master complex advanced Power BI concepts, refine your data preparation techniques, and enhance your ability to create compelling visualizations. These skills will enable you to add significant value to your organization.
Our team consists of seasoned senior developers and analysts with hands-on industry experience. This practical expertise sets us apart from other trainers and ensures that the knowledge you gain is immediately applicable in real-world scenarios. Let us help you excel through advanced Power BI skills, whether you’re self-learning or taking Power BI online courses to boost your career.
Our Promise to You
By the end of this course, you will have mastered advanced Power BI skills that will empower your career.
10 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.
I recommend checking our other courses on Microsoft, Programming, and Marketing on our Instructor Profile page.
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 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved