[NEW] PL-300: Microsoft Power BI Data Analyst Associate 2026

Explore the power BI desktop interface, including the ribbon and core panes. Learn how data flows from connector to model and report views for dashboards and collaboration.

Learn how to perform ETL in Power BI using connectors, Power Query, and data models to create visualizations from clean, trusted data.

Learn to connect Power BI to a CSV file, preview data, choose delimiters, and use Power Query to transform and load data into the data model for visualization.

Learn to promote headers and set data types in Power BI via Power Query Editor, handling CSV inputs with M code and renaming columns.

Apply column distribution and column profile insights to identify distinct and unique values, detect duplicates such as emails, and guide data cleaning and exploratory data analysis in Power BI.

Explore splitting a column into multiple parts in Power BI using split column methods: by characters, by delimiter, and by positions, including domain extraction from emails.

Explore the Power Query Editor's transform tools to rename and split columns, auto-detect data types, and apply formatting—lowercase, capitalize each word, and trim or clean to tidy data efficiently.

Master the extract tool in Power BI to pull text ranges from strings, including length, first and last characters, and text before or after delimiters, while reordering and merging columns.

Learn to create conditional columns in Power BI using if-else logic to classify annual income as pay categories and to build a homeowner classifier with Y, N, and unknown outcomes.

Explore date transformations in Power Query to derive age, year, start and end of year, days in month, month name, day of week, and quarters for time series analysis.

Explore numerical tools in Power BI data transformation, including replace values, convert to whole numbers, add new columns, and compute sine, cosine, tangent, rounding, absolute value, square root, and division.

Learn how to fix a broken data load when the file moves by using data source settings to change the source in Power BI and refresh the preview.

Sort by first name, replace blanks with unknown, and handle infinities when dividing income by total children. Create a custom column to compute a division using a flexible editor.

Master common Power Query import errors in Power BI, covering step- and cell-level issues, and learn practical fixes for missing columns, type conversions, and error handling.

Explore pro tips in the Power Query editor. Use the gear icon or double-click a step to change the data source, tweak applied steps, and manage load to improve performance.

Configure Power BI data loading settings to control type detection, headers for unstructured sources, and parallel query loading in Power Query Editor, with file-level overrides and cache management.

After completing all transformations, push the cleaned data into the data model, then switch to report view to create visualizations from the transformed tables.

Learn how primary keys provide a unique identifier for every row, enforce uniqueness and non-null values, and distinguish records using foreign keys to normalize tables.

Explore how foreign keys create parent-child relationships between tables, enforce primary keys, and prevent invalid data while linking authors to their books through lookups.

Split a big table into a fact table of numeric measures and dimension tables of descriptive data. Link them with foreign keys to support aggregate, context-rich queries.

Explore star schema and snowflake schema by connecting multiple fact and dimension tables with primary and foreign key relationships, and visualize simple model layouts in the Power BI data model.

Configure a Power BI data model by loading CSV files, building dimension tables, creating a unified sales fact via append, and manually defining relationships.

Learn to normalize a denormalized dataset in Power Query by creating fact and dimension tables, planning schema, and building a star or snowflake data model in Power BI.

Connect to a local MySQL database in Power BI Desktop by specifying host and port, previewing tables, and choosing load or transform to create the data model.

Compare direct query and import modes in Power BI, exploring in-memory Vertipaq performance, real-time data access, data freshness, gateway needs, and offline vs online use cases.

Use import mode in Power BI for fast responses and complex data modeling with local cached data; choose direct query for real-time needs and large datasets staying at the source.

Explore composite models in Power BI by blending import and direct query modes, and learn how dual storage mode lets a table switch between them at runtime.

Configure field properties in the Power BI data model by renaming fields, adding descriptions and synonyms, organizing with display folders, and setting data types, sorting, and formatting for visuals.

Create and mark a custom date table in Power BI desktop to enable time intelligence with a unified, unique, non-null, contiguous calendar. Supports DAX time calculations like year-to-date.

Create your first KPI card in Power BI Desktop, drag the sales amount into the visual, and explore aggregations like sum, average, min, and max with formatting options.

Learn to use format painter to copy formatting across KPIs in Power BI, align visuals, set decimals, and rename labels, while understanding what formatting copies and what it doesn’t.

Create and customize a clustered column chart in Power BI to segment total sales by continent. Learn how to adjust axes, titles, tooltips, colors, borders, and grid lines.

Learn to build multi-field line charts in Power BI by adding sales, cost, and quantity over time, and customize legends by continent for clear trend visualization.

Learn to combine a line with a stacked column chart in Power BI, displaying 2011 sales by continent alongside a total cost marker and labeled totals.

Explore a stacked area chart variation that stacks sales amount and total cost, removing the return amount to reduce noise, and adjust colors, transparency, and stacking by y-axis or legend.

Learn to build a Power BI treemap that shows total cost by channel, with color, category labels, data labels, and customizable tiling and display units.

Explore how to create and format a gauge in Power BI to compare year-to-date sales against targets, using auto or dynamic min, max, and target values.

Learn to build a matrix in Power BI that replicates pivot tables from Excel, using rows, columns, and drill-down hierarchies for continent, channel, category, and subcategory with sales and costs.

Explore applying conditional formatting in Power BI tables and matrices, including background color, font color, data bars, and icons, using gradients and rules with precedence and practical setup.

Explore Power BI conditional formatting for percentage fields, learn to divide by 100 to use numbers, and see how formatting rules override existing colors.

Format - properties tab in Power BI lets you set data formats, default summarisation, and per-visual formatting for fields like sales amount, including currency and decimal places.

Learn to filter data in Power BI desktop using page, all pages, and visual filters with basic, advanced, and top-n techniques, including calendar year filtering.

Explore the new slicers in Power BI, including the button slicer, list slicer, and text slicer, and learn to customize state, layout, and call out values for dynamic filtering.

Sync slicers across pages, filter slicer values, and group slicers with a common name to share filters. Copy and paste to propagate selections and manage visibility with advanced options.

Apply and customize a Power BI report theme to enforce organizational fonts, colors, and visuals across all pages; import JSON themes, export them, and tailor defaults for consistent branding.

Learn how to sort visuals in Power BI, including creating a custom sort with a Power Query column and applying sort by column to order regions, e.g., Canada first.

Customize Power BI tooltips, create custom tooltip pages, and pass filter context to display rich insights on hover.

Explore DAX, the Power BI formula language for creating dynamic calculations, measures, and calculated columns and tables, with context-aware analytics like year-to-date and year-over-year insights.

Explore DAX functions in Power BI, using official Microsoft documentation and the DAX dot guide to learn aggregation, statistical, and text functions, plus iterator functions, with syntax, examples, and practice.

Discover creating calculated columns in Power BI desktop with DAX inside the data model from report, table, or model views, and compare with Power Query Editor.

Explore text functions in Power BI, focusing on the format function to format numbers, dates, and text, and learn left, right, mid, lower, upper, trim, value, substitute in DAX.

Explore implicit measures in Power BI and compare them with explicit measures, learning how visuals auto-aggregate fields like sales amount, with default summarization and filter context shaping on-the-fly calculations.

Explore explicit measures in Power BI by writing DAX to create reusable, named calculations that enhance visuals and reports, with best practices for centralizing measures.

Create single aggregation measures using max and min functions, and learn how measures interact with the data model, row and filter context, and bidirectional filtering.

Learn how iterator functions in Power BI enable on-the-fly calculations with the sumx and averagex functions, avoiding stored columns and data model bloat while creating dynamic measures.

Learn how the calculate function in Power BI modifies the filter context to evaluate expressions, control filters like Asia and year, and override slicers for precise calculations.

Master the keepfilters function in DAX to intersect forced filters with the visual filter context, producing Asia 2011 sales without duplicating values across continents.

Learn how allselected preserves outside filters while ignoring inside query filters to sum sales by continent name, using Asia, Europe, and North America with year 2011 and slicers.

Explains the use relationship function in DAX to activate a disabled relationship at runtime for a specific calculation, enabling shipping date vs order date analysis within a Power BI model.

Explore creating calculated tables in Power BI with DAX, using filter and values to build virtual and physical tables, and summarize or group by to derive insights.

Learn to build calculated tables in dax by using summarize columns with filters to produce filtered group results, then extend with add columns, generate series, and top n.

Master time intelligence in Power BI by using DAX to compare performance across day, month, quarter, and year. Build and apply a calendar table and essential time intelligence functions.

Use the date add function to shift dates by intervals, enabling month-over-month analysis and running totals with time intelligence measures and a date table.

Explore semi additive measures in DAX, learn how they differ from fully additive measures, and apply snapshot techniques like first date to show the closing balance.

Explore drill down and drill up in Power BI visuals, shifting between year, month name, and quarter levels to reveal deeper sales insights.

Group visuals using the selection pane to control the layer order and visibility, arranging KPIs, slicers, and charts, then align, distribute, and group for consistent layout and accessible tab navigation.

Configure navigation for a report demonstrates how to manage page visibility and user flow in Power BI with buttons, shapes, images, and the page navigator for cohesive data storytelling.

Configure drill through navigation in Power BI to move from a KPI page to a detailed continent page, passing filter context and enabling focused analysis.

Group data in Power Query Editor to reduce granularity, use pre-aggregated tables, and balance direct query storage mode with import mode for performance, while optimizing column data types.

Explore how to use the analyze feature in Power BI to uncover why sales decline, explain trends, and compare distributions across continents, channels, and promotions.

Discover how to group and bin data in Power BI Desktop by creating category groups, using include or exclude filters, and persisting a new grouping column for visuals.

Explore four AI visuals in power BI, including smart narrative, Q&A, key influencers, and decomposition tree, and use anomaly detection to identify anomalies with date time values.