Power BI Intermediate

Power BI is a powerful, interactive business intelligence (BI) solution from Microsoft. It imports data from multiple sources, which you can then transform and analyze with a range of visual tools. Power BI has a user-friendly interface ideal for people with a limited technical background, allowing them to create their own reports and dashboards.

This intermediate Power BI course is designed to build on the material covered in our Power BI beginner-level course, so it is ideally recommended to go through that course first, which will give you a good handle on the basics and familiarity with the interface. If you already have a preliminary understanding of Power BI’s functionality, this intermediate course is right for you.

In this course, we discuss the data files to be used and some Power BI settings to set you up for success in learning. The last part of the course is one big exercise, giving you plenty of practice building reports and dashboards.

This course also includes course files to follow along with the instructor and uses the Power BI Desktop version.

This course uses the Power BI Desktop version. It also includes course files to follow along with the instructor.

The course covers:

• Importing and transforming data in Power Query
• Importing Excel, text, and CSV files and combining files
• Enabling/disabling load and report refresh
• Resolving data import errors
• Getting started with data modeling and relationship types
• Learning measures vs. calculated columns
• Creating a date table with DAX
• Creating additional and conditional columns
• Using the ROUNDUP and SUMX functions
• Creating quick measures and key measures tables
• Using the DAX – CALCULATE function
• Using tables vs. matrix tables
• Formatting visualizations and applying conditional formatting
• Building column, line, and map charts
• Adding gauge and card visualizations
• Using slicers and filters and apply design elements
• Creating a shared workspace in the Power BI service
• Building reports and dashboards
• Pinning visualizations to the dashboard
• Setting up scheduled refreshes

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!