All Power BI classes include
Free retake
Detailed curriculum
Live instructor
Flexible rescheduling
Certificate of Completion
Small class sizes
Course recording
What you learn in this Power BI course
- Power Query advanced functionality
- Advanced data import options
- Working with multiple data sets
- Enhanced data modeling in Power BI
- Expanded report design concepts
- Advanced dashboard design
- Creating sophisticated data visualizations
Power BI course - intermediate - Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
Intermediate Power BI Course Topics
Power Query advanced functionality
Understanding differences between Power Query and DAX
Importing data from PDF using Power Query PDF
Import data from web pages
Importing data from tables
Bulk importing data
Methods for combining multiple data sets
Using custom columns
Using math operations
Enhanced data modeling in Power BI
Using parameters to visualize variables
Organizing data with grouping and binning
Using time intelligence functions
Using quick measures for common calculations
Expanded report design concepts
Creating and using report themes
Using conditional formatting
Using drillthrough in Power BI reports
Advanced dashboard design
Working with dashboard themes
Using KPI and Multi KPI visuals
Using a trend analysis dashboard
Embedding images in reports
Advanced data visualizations
Using data profiling tools
Adding moving averages to a chart
Using forecasting
Power BI course instructors
AGI instructors are Power BI professionals and skilled teachers. You'll learn from a live Power BI professional that brings years of experience that will help you learn Power BI quickly and easily.
Grace
MS, Information Design
BA, Digital Communications
Adjunct Professor, St. Olaf
Shirley
MLA, Harvard
MS, Bentley
BS, Bentley
Elizabeth
BS, Finance
Teaching Assistant, Virginia Tech
Accounting & Finance Roles
Fred
MIT, Data Science
SCRUM Master
Certified Technical Trainer
Custom and private Power BI classes
This Power BI course is available as a private class. Curriculum can be customized for your specific needs. Power BI classes can be delivered at your location, online, or in our classrooms. For more information, call 781-376-6044 to speak with a training consultant or contact us.
Power BI course versions
There are three versions of Power BI. This Power BI course is beneficial for users of any of these three versions. You can use the free Power BI in Fabric, previously known as Power BI Desktop, or Power BI Pro, or Power BI Premium. You will need Power BI Pro or Premium to publish reports, and the Premium version is necessary for accessing AI capabilities.
If attending a Power BI course in our classrooms, the app is provided. If attending an online Power BI course, please download the app before starting the course.
Who benefits from this Power BI course
This two-day course is useful for anyone who uses Excel and needs to visualize their data, going beyond Excel’s default charts and graphs. Whether you are a business analyst, data professional, or an Excel user, this course enhances your data manipulation and visualization skills. By seamlessly combining Power BI and Excel, you will be equipped with a holistic set of skills to efficiently manage, analyze, and create data representations and visualizations.
You can attend this PowerBI class with a live instructor online or in-person. You can also schedule this as corporate Excel training for your group or organization.
Suggested follow-up course: Advanced Power BI course for transforming data