Microsoft Power BI – The Practical Guide 2026
-
Getting StartedWelcome to This Course0sWhat is Power BI0sInstalling Power BI Desktop0sConnecting Power BI Desktop to Source Files0sCreating Our First Visuals0sJoin Our Online Learning CommunityComparing Excel & Power BI0sCourse Outline0sThe Two Ways (Paths) Of Taking This Course0sHow to Get the Most Out of This Course0sImportant: How to Access Course Resources, Project Files & Slides0s
-
Understanding the Power BI Desktop Basics & Preparing the Course Project
-
Data Preparation in the Power Query EditorModule Introduction0sUnderstanding Data Preparation / Cleaning / Cleansing0sConnecting Power BI Desktop to Source Files0sHow Power BI Queries Data0sUnderstanding Basic Row Operations0sFiltering Data0sAnalyzing Columns & Removing Blank Fields0sUnderstanding & Using the Append Feature0sChoosing & Removing Columns0sAppend Behind the Scenes0sUnderstanding the Transpose Feature0sReplacing Values7m 36sWorking with Dates – The Basics6m 50sUnderstanding Data Formats5m 50sHandling Data Format Errors0sUnderstanding Pivoting & Unpivoting0sApplying Pivoting & Unpivoting0sFixing a Sorting Problem0sExtracting Data, Splitting Columns & Sorting Multiple Columns0sIntroducing the “Group By” Feature0sImproving the Project Structure0sWrap Up0s
-
Data Transformation in the Power Query EditorModule Introduction0sData Warehouse, Data Model & Data Schema0sThe Star Schema – Theory0sApplying the Star Schema to our Project0sUnderstanding References0sImporting Country & Region Codes0sUsing “Enter Data” to Create a Table0sUnderstanding the Merge Feature0sHow to Join Tables0sUnderstanding Outer, Inner & Anti Joins0sJoin Kind in Practice0sHandling Merge Errors0sUnderstanding the DIM-age Table0sBringing Back the “age-group” Column0sGetting the Maximum Values From Each Age Group0sCreating Conditional Columns0sCreating an Index Column0sCreating a DIM-gender Table0sUnderstanding the FACT Table0sFinishing the FACT Table0sApplying Basic Mathematical Operations0sUsing the Enable Load Feature0sWrap Up0s
-
The Data Model: Working with Relationships & DAX (Data Analysis Expressions)Module Introduction0sQuery Editor vs Data Model0sUnderstanding Relationships0sCreating our First Relationship0sUnderstanding Cardinality & Difference Relationship Types0sOne to Many & Many to One0sOne to One0sMany to Many0sFixing the Column Order Bug0sUnderstanding the Cross Filter Direction0sUnderstanding Active Properties0sAdding Relationships to the Project0sM-Language vs DAX (Data Analysis Expressions)0sCreating a Custom Column with the M-Language0sCreating a Calculated Column with DAX0sM vs DAX – What Should I Choose?0sThe DAX Basics0sThe Core DAX Syntax0sDAX Data Types0sDAX Operators0sDAX Core Functions0sCreating a Table with the CALENDAR Function0sExtracting Data with the DOT Notation0sAdding & Dividing Columns0sWorking with IF Functions0sUnderstanding Relationship Functions0sCalculated Column vs Measure0sUnderstanding & Creating Measures0sWorking with FILTER & CALCULATE Functions – Theory0sCombining CALCULATED & FILTER Functions0sAdding the Filter Condition to CALCULATE0sUsing Measures in Measures0sChanging the Measure’s Home Table0sUnderstanding the Data Category0sWrap Up0s
-
Creating Visuals in the Report ViewModule Introduction0sThe Power BI Workflow & Understanding Basics Visual Elements0sCreating & Duplicating Pages0sOrganizing Visuals0sCreating a New Visual0sCreating Line & Column Charts0sHow FILTER Affects the Visual0sUnderstanding Interactions0sHierarchies & Drill Down0sFormatting Chart Colors0sThe Canvas0sFormatting the Page Background / Wallpaper0sFormatting the Filter Pane & Filter Cards0sFormatting Visuals: General Settings0sDiving Deeper Into Formatting Visuals0sWorking with Report Themes0sFinishing the Report Theme0sUnderstanding the Slicer0sDefault Summarization & Sorting Order0sCreating Treemaps & Working with Multiple Slicers0sCreating Tables0sSyncing Slicers0sFilter on Visual, Page & Report Level0sCreating Single & Multi Row Cards0sAdding a Secondary Y-Axis0sCombining Column & Line Charts0sThe Waterfall Chart0sImporting Visuals0sFinishing Touches0sWrap Up0s
-
Power BI Pro & Mobile: Sharing & Collaborating with Workspaces & AppsModule Introduction0sThe Next Steps0sPower BI Pro Pricing0sPower BI Pro Interface Tour0sPublishing & My Workspace – Theory0sPublishing / Importing Power BI Desktop Projects to Pro0sDatesets Walkthrough0sList View vs Lineage View0sExploring Reports In Pro0sUnderstanding Dashboards0sCreating Reports & Dashboards0sDiving Deeper Into “My Workspace”, Understanding Refresh and a Refresh Error0sGateways – Theory0sGateways: Configuring Manual & Scheduled Refreshs0sSharing Data From “My Workspace” via Direct Access0sSharing Links0sUnderstanding Collaboration Workspaces – Theory0sCreating Colaboration Workspaces0sSharing Data via Apps0sPublishing & Unpublishing Apps0sDeleting Collaboration Workspaces0sWorkspaces vs Apps0sWorking with Power BI Mobile0sWrap Up0s
-
Other Data Sources
-
How to Stay Up-to-Date in the Power BI World?
-
Course Round Up
-
Optional: Power BI Desktop Crash Course / Introduction & SummaryModule Introduction0sProject Setup0sConnecting Power BI Desktop to the Source Files0sQuery Editor Walkthrough0sRemoving Blank Rows & Fixing Format Errors0sSaving the Project0sDuplicates vs References0sAppending Queries0sSplitting Columns & Extracting Data0sBasic Column Interactions0sData Modelling Theory0sCreating the “Orders” Table0sWorking with Indexes0sThe Formula Bar0sMerging Queries0sLoading Data Into the Data Model0sCreating Line Charts0sUnderstanding Relationships0sFormatting Numbers in Charts0sUnderstanding Interactions0sHierarchies & Drill-Down0sSorting Axis Values0sFormatting Visuals & Applying Report Themes0sReports, Map Visual & Default Summarization0sThe Data Category0sApplying Filters to Visuals0sUnderstanding Slicers0sCreating Tables0sWorking with DAX (“Data Analytics Expressions”)0sSorting Weekdays with Calculated Columns0sFixing the Revenue Calculation0sIntroducing Measures0sWorking with Quick Measures0s
-
Bonus: Selected Features by Example & Refresher Project
-
This Course Was Completely Updated
-
Course Roundup
This course turned more than 250.000 students into Power BI professionals and was specifically created for business users who need to learn fast, comprehensive and efficient to get the job done!
–
In the course you can take two paths:
– The Complete Path (full >15h course also teaching more advanced concepts & features)
– The Summary Path (2h crash course to master Power BI as quick as possible)
Both approaches will teach you Power BI in great detail and turn you into a Power BI professional. You decide what learning type you are – it’s your choice!
–
You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?
Then the Power BI tools are the tools to choose for you!
In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks – and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes.
This is what you will learn:
Get to know the different tools of the Power BI universe and learn how to use them
Understand Power BI Desktop and its components
Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps
Learn how to filter and format data, how pivoting and unpivoting works
How to work in the different views of the Data Model
How to create calculated columns and measures
How to build relationships between different tables
How to create a report with different interactive visualization types
Learn how to use Power BI Pro to create dashboards and to share and publish your results
How to access your results from multiple devices using Power BI Mobile
And more!
Don’t miss this opportunity to become a Power BI expert today! Enrol now, unlock your potential & transform your career today!
What's included
- 17.5 hours on-demand video
- Assignments
- 6 articles
- 19 downloadable resources
- Access on mobile and TV
- Certificate of completion