Power BI Training Course
Turn raw data into interactive reports and dashboards with Power BI Desktop, Power Query, DAX and the Power BI service.
Skills you can use on real projects
Every module is hands-on, built from the problems Bijay solves for clients.
- Understand Power BI Desktop, the service, workspaces and licensing
- Clean and shape data with Power Query and M
- Design star-schema data models with the right relationships
- Write DAX measures, including time intelligence
- Build interactive reports and dashboards, including SharePoint data
- Secure and share with row-level security, and embed in SharePoint and Teams
Power BI course curriculum
4 modules and 60 topics. Open a module to see every topic.
Module1Introduction to Power BI, Desktop & Service
15 topics
Introduction to Power BI, Desktop & Service
15 topics- What Is Power BI and Why Use It?
- Key Features, Benefits & Real-World Use Cases of Power BI
- Power BI Licensing Overview (Free, Pro, Premium, PPU)
- Introduction to Power BI Service & Cloud Capabilities
- Navigating the Power BI Service Interface
- Installing & Exploring Power BI Desktop
- Understanding Power BI Desktop Interface & Components
- Connecting to Data Sources (Excel, SharePoint, SQL, Web, etc.)
- Working with Excel & SharePoint Online Data in Power BI
- Creating and Managing Custom Tables
- Building Your First Power BI Report
- Understanding Workspaces in Power BI Service
- Creating, Publishing & Managing Reports in Workspaces
- Report Sharing, Permissions & Collaboration Features
- Import Mode, DirectQuery, Live Connections & Dataflows
Module2Power Query Editor & Data Modeling in Power BI
15 topics
Power Query Editor & Data Modeling in Power BI
15 topics- Introduction to Power Query Editor & Data Preparation
- Exploring the Power Query Interface & Transformation Tools
- Importing and Cleaning Data Using Power Query
- Basic Data Transformations (Rename, Remove Rows, Change Data Types)
- Advanced Transformations (Split, Merge, Replace Values, Conditional Columns)
- Pivoting & Unpivoting Data for Reshaping Tables
- Sorting, Formatting & Creating Custom Columns
- Combining Data Using Merge Queries & Append Queries
- Grouping, Transpose & Other Data-Shaping Techniques
- Introduction to M Query Language & Custom M Code
- Understanding the Power BI Data Model
- Star Schema & Dimensional Modeling Concepts
- Creating Relationships Between Tables & Understanding Cardinality
- Cross-Filter Direction, Active vs Inactive Relationships
- Best Practices for Data Modeling & Optimized Performance
Module3Power BI Visualizations, DAX & Reporting Essentials
15 topics
Power BI Visualizations, DAX & Reporting Essentials
15 topics- Introduction to Power BI Visualizations & Report Design
- Working with Charts (Bar, Column, Line, Area, Pie & Doughnut)
- Using Cards, KPI, Gauge & Funnel Visuals
- Advanced Visuals (Waterfall, Ribbon, Scatter, Tree Map, Key Influencer)
- Table, Matrix & Multi-Metric Reporting Visuals
- Working with Maps & Geographic Visualizations
- Adding and Using Custom Visuals from AppSource
- Using Slicers, Filters & Drill-Through Features
- Formatting Reports with Themes, Colors, Labels & Analytics Pane
- Introduction to DAX (Data Analysis Expressions)
- Aggregation, Logical & Text Functions in DAX
- Date, Time & Time Intelligence Functions in DAX
- Creating Measures, Calculated Columns & Calculated Tables
- Understanding Row Context, Filter Context & Quick Measures
- Best Practices for Writing Efficient DAX & Building Interactive Reports
Module4Power BI Dashboards, SharePoint Integration & Security
15 topics
Power BI Dashboards, SharePoint Integration & Security
15 topics- Creating Reports Using SharePoint Online as a Data Source
- Building Interactive Power BI Dashboards
- Publishing Reports & Dashboards to Power BI Service
- Embedding Power BI Reports in SharePoint Online
- Embedding Power BI Reports in Microsoft Teams
- Configuring Scheduled & On-Demand Data Refresh
- Using Filter Pane & Report-Level Interactions
- Implementing Drill-Through & Cross-Report Navigation
- Understanding Power BI Security Concepts
- Configuring Row-Level Security (RLS) & Page-Level Security (PLS)
- Managing Dataset Permissions & Workspace Access
- Exporting Reports to PDF, PowerPoint & Excel
- Sharing Dashboards Securely Across Organizations
- Monitoring Usage Metrics & Dashboard Performance
- Best Practices for Enterprise Reporting & SharePoint Integration
Every course and every solution, for one full year
This course is part of the All-Access membership. One membership unlocks all of these for 12 months, so you can move from one skill to the next without paying again.
- SharePoint Online6 modules · 15+ hours
- SharePoint Framework (SPFx)8 modules · 25+ hours
- Power Apps6 modules · 25+ hours
- Power Automate5 modules · 25+ hours
- Power BI4 modules · 20+ hoursThis course
- Copilot Studio2 modules · 9+ hours
- Power Pages2 modules · 9+ hours
- PowerShell2 modules · 5+ hours
- Real-world solutions50+ ready-to-use downloads
Everything included in All-Access
- All 8 video courses: SharePoint Online, SPFx, PowerShell, Power Apps, Power Automate, Power BI, Copilot Studio and Power Pages
- 50+ ready-to-use Power Platform and SPFx solutions to download and reuse
- Every new lesson and solution added during your year
- Full learning resources: PDFs, source files and code
- WhatsApp group and private community access
- Dedicated mentor support
- Monthly live sessions and webinars
- Interview preparation, placement support and real projects
- One payment for 12 months, with no automatic renewal
What learners say about training with Bijay
The training covers concepts from the basics to the advanced, and it was a great help in my current SharePoint Online development project. Bijay is always ready to help with any queries, whether about the course or your project. He is a great tutor.
Bijay not only clearly knows his subject, he makes the content interesting and delivers it with great real-world examples of where it works and where it doesn’t. I will highly recommend this training to everyone.
You can see the dedication and detail put into each module. I don’t think there is a more complete SharePoint training course in the market.
A very helpful course for SharePoint developers. I learned new things within the first 3–4 lectures, and even the small details of lists and libraries are covered.
Bijay Kumar
13-times Microsoft MVP · Founder, TSinfo Technologies
Bijay has more than 18 years of hands-on experience with Microsoft technologies, specializing in SharePoint, the Power Platform, SPFx and Microsoft 365. He has trained thousands of developers and IT professionals through SPGuides, wrote “SharePoint Online Modern Experience Practical Guide”, co-wrote “Microsoft Power Platform: A Deep Dive”, and runs the SPGuides YouTube channel. Every lesson comes from real client projects.
Frequently asked questions
Who is this Power BI training course for?
This course is ideal for analysts, IT professionals, business users, and consultants who want to turn raw data into interactive reports and dashboards using Power BI.
Do I need a strong data or coding background to learn Power BI?
No. Basic Excel or data familiarity helps, but you don’t need to be a developer. The course starts from fundamentals and then introduces data modeling and DAX step by step.
What will I be able to build after completing this course?
You’ll be able to connect to multiple data sources, clean and model data, create interactive reports and dashboards, and publish them for secure sharing across your organization.
Does the course cover DAX and data modeling best practices?
Yes. You learn essential DAX formulas, star schema modeling, relationships, measures, and patterns that help you design fast, reliable, and maintainable Power BI solutions.
How can this Power BI training help my career?
Power BI skills are in high demand across roles. This course helps you analyze and present data professionally, making you more valuable in reporting, consulting, and decision-support roles.
Can I buy the Power BI course on its own?
Courses are part of the All-Access membership. One payment gives you all 8 courses, 50+ ready-to-use solutions, the community and mentor support for a full year, so you can add related skills later without paying again.
How long do I have access?
You get 12 months of access from the day you join, with no automatic renewal. Lessons and solutions added during your year are included, and the monthly live sessions and webinars run all year.
Learn Power BI the practical way
Join All-Access and start this course today, then carry on with every other course and solution for a full year.
Want to try the teaching style first?
Read the free Power BI tutorials on SPGuides, or join the next free webinar.