The Complete Power BI Practical Course 2026

Compare Power BI Desktop for building dashboards and reports with Power BI Service for sharing and collaboration, and explain Power BI Pro and Premium licensing for teams and scalable deployment.

Explore why Power BI for Mac isn’t available and learn free and paid workarounds, including Parallels, Turbo Net, and a 12-month remote desktop solution via AWS.

Sign in to aws, launch a Windows virtual machine on the free tier with a key pair, and connect from Mac via Remote Desktop to install Power BI.

Explore importing data in Power BI by connecting to Excel files, using Power Query to transform data, promote headers, view applied steps, and load multiple tables via the navigator.

Discover how to use Power Query's extract function to capture the username from an email by text before the @ delimiter. Replace or create a username column for cleaner dashboards.

Remove duplicates in the currency table to ensure unique currencies and enable accurate filtering in Power BI reports, using the Power Query interface to remove duplicates.

Filter a currency table in Power BI by keeping six currencies using text filters with equals and advanced options, then apply the same approach to currency keys with numeric filters.

Calculate a person’s age from birth date using date functions and duration to total years, then round down for whole years. Preserve updated ages by removing the birth date.

Unpivot currency columns in Power Query to turn six currency fields into two: currency key and sales amount, after promoting the first row as headers.

Learn how parameters in Power BI enable scalable, data-source driven reports by centralizing file locations and updating a single value to refresh multiple tables.

From the complete Power BI practical course, learn to convert all sales to euros by merging exchange rates and dividing amounts in Power Query.

Define role level security in Power BI to restrict data by country, create roles for United States, Canada, and France, and test visible data with geo data from Excel.

Explore DAX, a Microsoft formula language for Power BI, Power Pivot, and SSAS tabular models that enables calculated measures, calculated columns, related tables, time intelligence, and row-level security.

Create calculated columns in Power BI to extend a table and store results in the in-memory data model. Use DAX to flag late shipments and label premium purchases.

Build a calendar table in power bi with calendar auto, adding year and month attributes for time intelligence; connect to internet sales on order date and mark as date table.

Build measures in Power BI using the fact Internet sales table, defining total sales amount with sum and counting sales. Comment code in ducks and organize measures by table.

Organize measures in a measures table to keep the model tidy, move calendar table measures into it, and pin the table to the top; remember measures render only in visuals.

Power BI's calculate function changes the filter context to update results. The lecture shows creating a measure with calculate and using color filters, with a note on filter inside calculate.

Discover how sumx, a Power BI iterator, processes every row of a table by applying an expression and aggregating the results, shown with sales amount in euros.

Apply the divide function to compute the percentage of total sales per age bucket, using all to remove filters and avoid dividing by the same total.

Learn how variables simplify complex expressions and improve readability and performance of measures in Power BI, using a year-over-year growth calculation with current year sales, latest year, and parallel periods.

Explore using the treatas function to perform currency conversion between unconnected tables in Power BI, leveraging isfiltered, calculate, max, and dynamic exchange rates to convert totals to euros.

Explore the switch function in Power BI to toggle a measure between number and percentage using a data type slicer, compare switch with if statements, and address formatting and defaults.

Learn to use text functions in duck language to display selected filters (customer, country, product) as a single line, and build a dynamic year-over-year growth indicator with arrows.

Learn to use concatenatex in Power BI to join multiple values into a text string, as both a measure and a calculated column, with related table, delimiter, and order by.

Explore time intelligence in Power BI using a calendar table to compute year-to-date, last year, and last month sales, and to create cumulative comparisons.

Learn to build expression based titles in Power BI that dynamically display the selected year and the previous year comparison using DAX measures, slicers, and dynamic titles.

Learn to create calculation groups in Power BI using tabular editor, including YTD, MTD, same period last year, and year over year for dynamic measures.