Power BI Intermediate

Welcome to “Microsoft Power BI Intermediate: Beyond the Basics,” an engaging course designed to take your data analysis skills to the next level. Throughout this journey, you’ll discover advanced Power BI techniques, empowering you to turn raw data into dynamic dashboards and insightful visualizations.

Setting the stage for success, you’ll start by delving into importing and transforming data using Power Query. Learn to navigate complexities such as resolving import errors and organizing queries effectively.

Master the art of data modeling, troubleshooting relationship issues, and understanding relationship types. In DAX, you’ll acquire essential skills, such as creating measures, calculating columns, and utilizing the CALCULATE function proficiently.

Explore diverse visualizations in the visualization section, from column and line charts to card and map visualizations. Uncover the potential of the Power BI Service, creating shared workspaces, reports, and dashboards seamlessly.

This course isn’t just about theory; it’s about practical application. Immerse yourself in a sample project of building an Orders Dashboard, from data preparation to the final dashboard.

As you close the course, you should be able to expand your Power BI toolkit and possess the skills to create compelling visual stories with data. Join us today and transform your data analysis capabilities.

In this course, students will learn how to:

• Import and transform data from Excel, text, and CSV files.
• Enable/disable load and refresh for efficient data management.
• Resolve data import errors with confidence.
• Start data modeling, understand relationship types, and utilize measures.
• Create a date table using DAX and additional conditional columns.
• Implement ROUNDUP and SUMX functions for precise calculations.
• Efficiently use DAX CALCULATE function for dynamic data analysis.
• Choose tables or matrix tables based on visualization needs.
• Format visualizations and apply effective conditional formatting
• Build diverse charts: column, line, and map visualizations.
• Incorporate gauge and card visualizations for impactful reporting.
• Utilize slicers, filters, and design elements for interactive reporting.
• Create shared workspaces in the Power BI service seamlessly.
• Construct comprehensive reports and dynamic dashboards.
• Pin visualizations to the dashboard for quick access.
• Set up scheduled refreshes for automatic data updates.

WHAT YOU GET

Certificate of Completion

• Earn a certificate each time you complete a course.
• Showcase your commitment to continuous growth and professional development.
• Impress potential employers.
• Enhance your professional profile.
• Available in PDF format to Download or Print.

INSTRUCTOR

Deborah Ashby

Meet Deb, your go-to guide in the exciting world of Excel and beyond! With her infectious enthusiasm and razor-sharp expertise, she's on a quest to turn everyone into Excel wizards. Deb doesn't just stop at Excel, though. She'll lead you through the fascinating realms of Microsoft Word, PowerPoint, and other Microsoft 365 apps, helping businesses and individuals alike to unlock their full potential. But she's no ordinary trainer. Boasting an impressive track record of over 25 years and revered by past and current learners alike, Deb's teaching prowess is unparalleled. To top it off, she's a proud recipient of the coveted Microsoft MVP (Most Valuable Professional) award. Buckle up and join Deb on this exhilarating learning journey!