Learn to pull data from Excel, CSV sources into Power BI Desktop, clean and transform it in Power Query Editor, and merge queries to add product cost and price.

Learn how Power BI compresses data with the Vertipaq columnar engine, shrinking a 5 million-record CSV from 595 MB to 122 MB after loading into PowerPivot via Power Query Editor.

Create a clean data model in Power BI by defining relationships between dimension and fact tables, establishing primary and foreign keys, and differentiating star and snowflake schemas.

Explore DAX in Power BI by building data models, creating calendar tables, and using measures and calculated columns to compute sales, profit, and time intelligence insights.

Explore all 42 default visuals in Power BI Desktop, including bar, column, line, area, ribbon, waterfall, funnel, scatter, pie, donut, treemap, card, slicer, matrix, and KPI.

Explore the newly introduced slicer and card visuals in Power BI, including sorting month names by month number, and tooltips on slicers showing total orders, sales, and profit.

Create Power BI hierarchies, using system defined and user defined types, drill from year to day, and build custom state region city hierarchies to drill up and freeze.

Master Power BI filters across visuals, page and report scopes using visual, page, and report filters, including advanced and basic filtering, top n by value, and 2024 selections.

Learn to use drillthrough in Power BI to right-click a data point on page one and jump to a detailed page two with state or subcategory insights.

Learn to use edit interactions in Power BI to control how visuals—bar, column, pie, and donut charts—interact, choosing filter, highlight, or none.

Explore conditional formatting in Power BI by using gradient rules and field-based conditions to color table and bar visuals by total profit, including background, font colors, and icons.

Learn to implement system defined and user defined tooltips in Power BI by creating a tooltip canvas, linking a report page, and displaying orders, products, sales amount, and profit percentage.

Learn how to use sync slicers to synchronize visuals across multiple report pages in Power BI, and enable this by using the view menu to sync slicers.

learn how to use and apply all slicers at once in Power BI to filter visuals, then clear all slicers, improving performance by reducing data source queries.

Learn to use bookmarks in Power BI to capture and toggle visuals. Create and assign bookmarks to buttons to switch charts and clear filters.

Use Power BI's Performance Analyzer to analyze load times, render durations, and Dax queries, and optimize reports for faster performance.

Use field parameters to drive a slicer for measures such as total sales, profit, and profit percentage, then create a parameter and apply its measure to switch visuals.

Explains useful options in Power BI, including copying and pasting visuals, undoing with ctrl z, using format painter, and aligning, distributing, and layering visuals after publishing.

Explore visual interaction options in Power BI, including filters and slicers, focus mode, CSV export, show as table, remove and undo, spotlight, and basic visual calculations with sorting.

Import and add custom visuals from AppSource into Power BI desktop, then customize and format them, checking certification, mixing free and paid options, and using visuals like scroller.

Explore smart narrative and q&a in Power BI to auto generate insights, and use the decomposition tree and column from example to analyze data and extract names and domains.

Compare a Power BI bar chart before and after formatting, applying formatting options such as axes, data labels, top-N filters, colors, borders, and conditional formatting to enhance subcategory orders.

Master Power BI report creation by building KPI cards, line and funnel charts, and interactive visuals with slicers, bookmarks, and drill-throughs across a home page and details page.

Learn to publish Power BI reports to the Power BI service by creating workspaces, publishing from desktop, sharing with your organization, and using dashboards, schedule refresh, gateways, and apps.

Explore Power BI mobile to access reports and dashboards, install the app, navigate home, favorites, workspaces, and interact with reports and slicers on mobile.