Power BI Masterclass from Scratch in 180 Minutes - 2026

Learn to source data from Excel files and folders, clean and transform it with the Power Query Editor, and merge tables to enrich sales data with product price.

Power BI compresses large data by loading a 5 million-record CSP file into PowerBA, applying the Wartipag algorithm in Power Query Editor, shrinking 595 MB to 122 MB.

Identify tables, keys, and schemas (star or snowflake) in Power BI data modeling, then create one-to-many and other relationships to connect dimension and fact tables.

Master DAX to create new tables, columns, and measures in Power BI, build a calendar table for time intelligence, and compute sales, profit, and prior month trends.

Explore canvas settings and visual formatting in Power BI, customizing canvas size, background, and images; adjust x and y axes, labels, colors, gridlines, borders, and tooltips for bar charts.

Explore the full range of Power BI charts, from 42 default visuals to AppSource additions, and see how calendar tables and proper relationships power accurate visuals.

Identify and fix a Power BI sorting error by adjusting the month name field, removing incorrect formatting, and sorting by a new month number column in the calendar table.

Master visual, page, and report level filters in Power BI, with basic, advanced, and top end options. Learn to apply year filters and see their impact across visuals and pages.

Master how to use system defined and user defined hierarchies in Power BI, from state–region–city to year–quarter–month–day, with drill down, drill up, and freeze options.

Explore drill through in Power BI across two pages by dragging a state from page 1 to the drill through area and right-clicking to view state-specific data on page 2.

Learn how to control cross-visual interactions in Power BI by using edit interactions, turning interactions on and off, and resetting to the original state with the filter button.

Power BI bookmarks capture the current state of the report, enabling quick resets by adding a bookmark named 'clear' and using a reset button to return to the original state.

Compare system defined and user defined tooltips in Power BI, enable a tooltip page, and configure visuals showing total sales, profit, and profit percentage.

Enable sync slicers in Power BI to synchronize year and month across page 1 and page 2, so selections reflect on both pages.

Learn how field parameters let a slicer switch between measures in Power BI, creating a backend parameter table to dynamically display total sales amount or profit sales.

Master conditional formatting in Power BI by applying gradient and rules to bar, column, and table visuals, using fx, field values, and color customization.

Discover Power BI's visual interaction options, including focus mode, export data, sorting, and adding text boxes, buttons, shapes, and images, plus page and bookmark navigation for interactive visuals.

Discover how the key influencer visual in Power BI helps analyze profit against order quantity and sales amount, with category and segments to reveal root causes.

Explore the decomposition tree in Power BI to analyze sales amount across categories, states, and cities, uncovering root causes of low sales in stock and build.

Discover how to use power bi q&a to fetch state-wise orders, switch between visuals, view ct-wise profit on bar charts or maps, and create real-time visuals for reports.

Explore how smart narrative in Power BI automatically generates insights from visuals. See total sales by subcategory and top contributors like CPM Kneel.

Explore how to use the column from example feature in Power Query Editor to extract a first name from an email ID and shorten occupation names in Power BI.

Build a sample Power BI report by adding a header and cards, formatting callouts, adjusting backgrounds, and combining column, line, and pie charts to show state and category insights.

Publish a Power BI report to the Power BI service by creating a workspace, signing in, and publishing the report and its dataset to the cloud.

Create and customize a Power BI dashboard from a report in the Power BI service, pin visuals, rearrange and resize them, and apply dark or light themes.

Learn how to share Power BI reports and dashboards with end users in the Power BI service, manage access with roles, and export as PDF, PowerPoint, or Excel.

Create an app in Power BI service to share reports and dashboards, add content, configure audience, publish the app, and access the published reports.

Schedule a refresh in the Power BI service by installing the data gateway. Configure daily or weekly refresh with notifications and connections for Excel, CSV, and SQL Server.

Learn to consume Power BI reports and dashboards on the mobile app, install from Play Store, open your app, and interact with charts to filter data such as Connecticut sales.