This course is designed for those interested to learn the advanced features of Power BI such as merging and duplicating queries, various Data Analysis Expressions or DAX, and different kinds of formatting and design.
Read more.Instructor
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 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.
What you’ll learn:Â
- 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
Continuing from our foundational “Learn The Basics Of Power BI” course, we’re excited to elevate your expertise. Delve into advanced facets of Power BI, transcending into the realm of a proficient Business Intelligence analyst.
Through comprehensive exploration of intricate Power BI concepts, your data preparation, analytical finesse, and visualization prowess will experience remarkable enhancement. The acquired skills will empower you to contribute substantial value to your organization.
It’s essential to underline that our team comprises seasoned senior developers and analysts, distinguishing us from mere trainers. Our instruction is deeply rooted in real-world applications, ensuring utmost practicality and seamless implementation of the knowledge you gain. Elevate your proficiency with us and champion the world of Business Intelligence.
Our Promise to You
By the end of this course, you will have learned Advanced Power BI skills.
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?