Microsoft Power BI - beginners to advance Level Exam PL-300

Connect to data in Power BI Desktop via get data to import or live-connect sources such as an Excel workbook and SQL Server, then transform data with Power Query editor.

Learn to clean and transform data in Power BI with the Power Query editor by removing top rows and promoting the first row as header, plus automatic data type detection.

Power BI automatically detects column data types and allows manual changes, featuring whole numbers, decimals, currency, and dates. Learn to handle mixed data and prepare for data cleaning.

Add an index column and remove alternate rows in Power BI by selecting a start row, rows to remove, and rows to keep, with duplicates, blanks, and errors options.

Keep rows in Power BI using top, bottom, and range options; also keep duplicates and keep errors to filter data.

Learn to use the choose column command in Power BI to keep only selected columns, remove others, undo changes, and jump to a target column when working with many columns.

Rename columns in Power BI by double-clicking to edit and using the right-click rename, then save and apply steps to preserve changes in the data model.

Learn how to sort columns in Power BI's home tab using sort arrows for descending or ascending orders. Practice sorting by quantity and undo steps to refine data presentation.

Explore column quality, distribution, and profile in Power BI to understand data quality, how many distinct and unique values exist, and profiling top 1000 rows for column statistics.

Enable column profiling for the entire data set in Power BI, expanding from top 1000 rows to 22,398, and apply similar full-set profiling to column quality and distribution.

Append tables by stacking rows from one table below another, starting with equal headers. When headers differ, extra columns appear with null values for existing rows, creating a unified table.

Append queries in the Power Query editor to combine sales part one, sales part two, and 2012 into a single table, using append queries as new and renaming the result.

Remove the first invalid row and align column data types in the sales data. Convert IDs and quantity to whole numbers and discount to percentage.

Split the text column by the hyphen delimiter in Power BI’s split column feature to create sales representative ID and channel representative ID, then remove error rows during data cleaning.

Learn to correct a misreported discount by dividing a column by two directly in the Power BI transform tab, using standard mathematical operations to adjust values quickly.

Learn to add a conditional column in Power BI to categorize discounts as average or high using a 10% threshold, rename the column, and set its data type to text.

Learn to merge queries in Power BI, bringing the price column from the product table into the sales table with a left outer join on product ID.

Master merging two tables in Power Query with left outer, right outer, full outer, inner, and anti joins; map employee IDs and handle nulls.

Rename the price column to unit price and add column to compute sales amount using unit price, quantity sold, and discount; set the column to decimal number in sales table.

Learn to add a new column by examples in Power BI, selecting from all columns and entering sample values like copy of quantity or discount percentages to infer the rest.

Duplicate a column in Power BI by selecting the column, choosing duplicate in the add column tab, and creating a product copy identical to the original.

Learn column formatting in Power BI by applying lower case, upper case, or capitalized words; trim spaces, remove non-printable characters, and add prefixes or suffixes to a selected column.

Explore extracting from a column using add column's extract commands to derive text segments, characters, ranges, and delimiter-based values, then convert results to numbers.

Apply scientific calculations in Power BI using add column and transform tabs to compute absolute values, powers, roots, exponentials, logarithms, and factorials on the unit price column.

Apply trigonometric functions to a selected column in Power BI using the transform tab, calculating sine or cosine for each value in the same cell, with undo.

Master rounding in Power BI by using round up, round down, or rounding to a specific decimal place with the transform or add column tabs on the sales amount.

Explore Power BI's information commands in transform and add column tabs to identify even, odd, and positive or negative values on the unit price column, returning true/false or 1/-1.

Explore date and time column transformations in Power BI, including extracting year, start and end of year, combining date and time, and computing durations and earliest or latest dates.

Explore the group by transformation in Power BI to create a new category column that sums sales per unique category, mirroring a pivot table in Excel.

Explore Power BI's transform tab and learn how the transpose command flips a table, turning rows into columns and columns into rows, with practical example columns like category and product.

Explore how to reverse rows in Power BI's transform tab, turning the last row into the first, with practical steps like adding an index column and reversing order.

Count rows in a Power BI table using the transformation tab's count rows command. The example shows a large table with eight rows.

Transform and fill null values in Power BI by using fill down and fill up in the transform tab, demonstrated on an imported Excel table with merged rows.

Pivot the category column in Power BI to create new columns named category one, category two, category three, and category four, using the sales values and optional aggregation.

Learn how to unpivot columns in Power BI to convert wide tables into long attribute-value pairs, reshaping date columns into a single date attribute and sales values.

Explore dax, a collection of functions and operators that enable calculations on data tables to create new information, columns, and measures for actionable insights.

Explore how time intelligence in Power BI delivers visibility of data over days, months, quarters, and years, with visuals that drill up or down to compare across periods.

Explore time intelligence in Power BI by creating a well-structured date table and linking it to sales and stock tables to analyze sales across quarters and months.

Create a date table using the calendar function in Power BI, converting to a proper date column, and formatting dates for a report with start and end dates.

Create a dynamic date table in Power BI using calendar auto that detects the model's min and max dates, then format the date column as short date.

Explore date table hierarchies: year, quarter, month, and day—for time intelligence, and learn to relate the date table to sales data with drill up and down.

Learn how to create a new DAX column in the date table to extract the year from dates using the Year function, turning dates into a four-digit year column.

Extracts month numbers and month names from a date table in Power BI. Use the month function to get 1–12 and the format function to produce January through December.

Extract week numbers from a date column in Power BI using the week number function, choose whether weeks start on Sunday or Monday, and prefix results with wk for clarity.

Extract quarter numbers from a date column in Power BI using the quarter function, create a new column, and format labels as Q1-Q4 in the date table.

Create a date table with a custom hierarchy in Power BI, adding year, quarter, month name, and week number with DAX, then delete the extra calendar table.

Create a separate measures table in the data model using enter data from the home tab, rename it to measures table, load it, and start creating measures in that table.

Learn to create a DAX measure using the sum function to compute total sales from the sales table, display it on a card, and format the result as millions.

Create and apply DAX measures to compute the maximum and minimum stock values from a stock table, then visualize them with card visuals in Power BI.

Apply dax countrows to count transactions in a sales table and compute average sales per transaction by dividing total sales by total transactions, with average on sales amount.

Apply the DAX CALCULATE function to filter expressions and compute year-specific sales in Power BI, using date year extraction and measures to verify results.

Explore the DAX totalYTD function to compute the year-to-date value of an expression using a date table, with optional filter and a default year-end date of December 31.

Explore the DAX dateadd function to shift dates and calculate last month sales in Power BI, enabling month-over-month comparisons in a table visual.

Master the DAX if function in Power BI, including syntax and logical tests. Build nested ifs to categorize sales change as low, good, or bingo using 5% and 10%.

Learn how to remove infinity in the monthly change sales measure using the DAX if function by testing last month sales for blanks and returning blank or a value.

Explore how the DAX switch function evaluates an expression against cases and returns corresponding results, illustrated by a Power BI measure that assigns commission rates based on sales change category.

Learn how DAX variables act as temporary memory to store intermediate results in Power BI, improving readability and performance when computing return rate and retention rate from the sales table.

Explore DAX FIRSTNONBLANK and LASTNONBLANK in Power BI to derive opening and closing stock per month by filtering for non-blank dates.

Adjust the stock table’s date hierarchy by removing day and quarter, placing year and month at the top to show January 2011 and January 2012, preparing for upcoming features.

Learn how to use the DAX SAMEPERIODLASTYEAR function in Power BI, connect a centralized date table, and create measures like minimum stock to visualize last year’s values.

Master the data model view in Power BI. Use the properties pane and display folders to rename tables, add descriptions and synonyms, hide tables, and group related columns.

Explore the data model view properties pane by selecting a table or column, adjust storage mode, data type, formatting, thousand separators, and display folders, then apply summary, sorting, and nullability.

Explore data modeling in Power BI by defining data structure, properties, and relationships to create a coherent data model that enables cross-table filtering and insightful visuals.

Learn how data modeling in Power BI enables time-aware analysis with date hierarchies, filters across related tables, and drill-down capabilities, while boosting performance and report accuracy.

Learn how star and snowflake data models organize a centralized fact table with linked dimension tables, enabling filtering and analysis in Power BI through relationships.

Explore cardinality in Power BI data modeling, covering one-to-one, one-to-many, and many-to-one relationships. Understand how direction shapes filtering between dimension and fact tables with channel and sales examples.

Explore one-to-one cardinality in Power BI by linking a date table to a stock table, showing bidirectional filters, relationship creation, and the impact of removing and reestablishing the connection.

Explore many-to-many cardinality in Power BI, why it's not directly supported, and how to model it using simple relationships, with a preview of converting to a star schema.

Hide part one, part two, and sales 12 in model view to keep them from the data pane. Switch to report view to confirm the sales table is visible.

Explore the Power BI data model view, delete and re-establish relationships between the fact table and dimension tables, and see how removed links break date filtering in report visuals.

Explore building a Power BI data model with a star schema, linking fact and dimension tables (sales, stock, date, product, channel, region) via active one-to-many relationships and appropriate cross-filter directions.

learn to add a heading to a power bi dashboard using shapes and text, adjust font size and color, and position items on the canvas for a clear sales header.

Add a card visual in Power BI's visualization pane, drag the total sales measure into the visual, and format the title, callout value, and border for a polished dashboard.

Set the card visual to currency format to display a dollar sign for total sales, and use the currency options to switch among currencies.

Create a chord visual from a sales table column, set sum aggregation, turn off category label, enable title 'total quantity sold', and apply border and rounded corners to maintain theme.

Create a new measure, increase_sales, to compute the percent change in sales from 2011 to 2012, then build and format a Power BI card visual across three KPI cards.

Create a line chart of week‑on‑week sales with sales amount on the y axis and a date hierarchy on the x axis, using 2011 and 2012 measures for two lines.

Demonstrates formatting a Power BI line chart, using focus mode and date hierarchy to drill up and down, and adjusting x/y axes, legends, colors, and fonts in the visualization pane.

Format the line chart visuals in Power BI by adjusting legends, grid lines, zoom slider, data labels, markers, line style, and series/background options for clear, customizable visuals.

Explore visuals formatting in the visualization pane by adjusting height, width, position, and title; tune padding, borders, and shadows, then configure tooltips and alt text for accessibility.

Create and explore a clustered column chart in Power BI by building a product-category hierarchy, enabling drill down and focus mode to compare sales by category and product.

Discover how filter context works in a Power BI data model by linking product and sales tables via product ID, enabling category filtering in visuals.

Create and format a Power BI donut chart to show sales amount by channel, adjust title, colors, and labels, and understand the channel ID relationship guiding the visualization.

Learn how to fix map visuals in Power BI by swapping Egyptian regions for US states and linking region IDs in the star schema for flexible dataset changes.

Learn to add constant lines and dynamic targets to Power BI line charts, adjust data labels, and manage drill up and drill down to keep targets aligned with the data.

Enable map visuals in Power BI by turning on security options, including map and fill map visuals ArcGIS for Power BI, then click okay and proceed with visual creation.

Learn to deploy a filled map visual in Power BI, mapping US states from a star schema, configuring data categories, and using tooltips for state sales and zone data.

Explore the second form of the map visual in Power BI by plotting states with latitude and longitude, sizing bubbles by the sum of sales, and using tooltips for zones.

Build and deploy an area chart in Power BI to compare 2011 and 2012 sales by zone and state, with drill up/down through a zone-state hierarchy and formatting adjustments.

Deploy an area chart visual for year-to-date values by applying a border and copied formatting, then use a date hierarchy on the x axis to show 2011 and 2012 ytd.

Visualize the top ten products by sales in Power BI using a clustered column chart, applying top N filtering on sales amount and formatting data labels for clear insight.

Deploy a waterfall chart in Power BI by configuring date hierarchy and sales amount, break down by state, drill through year to quarter to month, and format with data labels.

learn to visualize key sales KPIs with card visuals in Power BI, duplicating visuals, applying retention rate and return rate measures, and formatting titles for clear insights.

Add a daily sales target to the date table using a DAX if statement (1800 for 2011, 2200 for 2012) to power KPI card visuals and drill-down.

Create a KPI card showing sales against a target with a trend axis from a date table, and pair it with a year slicer for year-by-year analysis in Power BI.

Learn how the slicer filters visuals by year, switching between 2011 and 2012 to update charts, top ten products, year to date values, and a waterfall chart in Power BI.

Explore how interactions among Power BI visuals, including area charts, filter region sales, focus top east products, and undo selections; learn why targets may not update without proper table relationships.

Learn to control and edit interactions among visuals in Power BI by using edit interactions to filter or highlight visuals, stop unwanted filtering, and manage slicer effects for precise dashboards.

Create a Power BI table visual on a new page using the date table's year and month name to display 2012 sales, current and last month, and related measures.

Deploy the matrix visual in Power BI, drill down from year to quarter to month using focus mode, and compare it with a table while building and formatting stock table.

Learn how to apply conditional formatting to a single column in a Power BI table, using background color, font color, data bars, and threshold-based icons for monthly change sales.

Apply conditional formatting to a column chart of sales by category using a gradient, highlighting minimum values in red and maximum values in green, and customizing zeros.

Explore how the key influencer visual in Power BI analyzes data to identify factors that drive low ratings for cloud services, such as consumer role, premier subscription, and region.

Learn how to use the key influencers visual in Power BI to analyze sales amount by category and product, explain influencers, and interpret segment insights to drive revenue.

Learn how bookmarks capture a report page's state, including filters, slicers, and visuals, and how to save, rename, and use them via the bookmark pane for quick navigation.

Add realistic target lines to a Power BI line graph by creating year-specific measures, configuring dashed and dotted targets, and enabling drill up and drill down for insightful sales trends.

Discover how simple tooltips show basic chart info and how advanced tooltips reveal deeper, dynamic data, and hover over donut segments to see segment contributions and category breakdowns.

Create a dedicated advanced tooltip page and enable it as a tooltip to reveal category contributions. Show sales as a percentage of grand total and apply the tooltip to visuals.

Learn how to use Power BI switch parameters to let end users toggle visuals between channels and regions, using a slicer to switch a donut chart and other visuals.

Create and configure drill through report pages in Power BI to filter visuals by channel, category, and product, and navigate with a back button.

Learn to group data in Power BI report view by creating zones (east, west, south, central) from the states table, without adding a column, and apply grouping to other tables.

Learn to create and configure numeric bins in Power BI, choosing bin size or count, and visualize sales amount by quantity bins with a clustered column chart.

Learn to apply and customize Power BI report themes from the view tab, save your own themes, and load json files or browse the theme gallery.

Explore how to design Power BI reports for mobile devices using the mobile layout tool, resize and position visuals, and tailor each page for mobile viewing without altering desktop layouts.

Implement a pro custom filter pane in Power BI to house slicers and filters in a collapsible panel, updating charts as you apply key accounts and clothing.

Design a pro custom filter pane in Power BI by grouping filter visuals, configuring slicers for year, category, products, and channel, and using bookmarks and a button to toggle visibility.

Copy the custom filter pane with its slicers from one dashboard page and paste it onto another, then use bookmarks and action buttons to control its visibility on each page.

Fix a Power BI custom filter pane by updating bookmarks: uncheck data and select visual elements to bookmark only visibility, keeping slicers and filters intact across dashboards.

Format a slicer to match the theme by setting dark blue backgrounds, white text, and a dark golden border with rounded corners for the donut chart and header.

Format page by selecting an empty canvas, apply light blue wallpaper at 50% transparency, turn off backgrounds in effects, and hide contribution tooltip and drillthrough page for Power BI report.

Learn to edit slicer interactions in Power BI to control which visuals update, by setting none for certain visuals and linking others to year selections, ensuring accurate KPI targets.

Create a clear all slicers button to reset category and channel filters in Power BI, styling it with a dark blue background, white text, and gold border on multiple pages.

Power BI service licenses: free, pro, premium per user, and premium capacity, with insights on sharing reports, dataset size, refresh rate, and pricing considerations.

Sign into the Power BI service in the cloud using a work or student email, explore the home page, and understand pro licenses and premium workspaces.

Create and customize a new workspace in Power BI by naming the workspace, adding a description, uploading an image, and publishing content to the learning workspace.

Publish a Power BI report to a service workspace by signing in, saving changes after hiding pages, and selecting the learning workspace, then view the report and dataset.

Share Power BI reports with colleagues via email view-only links or copy shareable links in Power BI service. Grant workspace access so teammates can view all reports in the workspace.

Explore workspaces and apps in Power BI, learn how to share reports, assign roles (viewer, contributor, member, admin), and build apps that bundle related reports for end users.

Add users to the learning workspace, assign roles (admin, member, contributor, viewer), and remove users to manage access in Power BI service.

Create and manage dashboards in Power BI service to present high-level visuals from reports, pin visuals to dashboards, and explore data with detailed reports and filters.

Publish reports to a workspace, then create a Power BI app that bundles related dashboards and reports for end users. Add content, set audience access, and share the app link.

Update app contents by deleting unwanted dashboard reports and publishing the updated Power BI app; re-add content later with add content and update.

Learn how to manage access to a Power BI app by adding audience via email, handling direct access, and approving or declining access requests through the manage permissions workflow.

Explore exporting Power BI reports to PDF or PowerPoint, managing hidden tabs, and creating subscriptions and alerts with email or Teams delivery in the Power BI service.

Explore how the on premises data gateway bridges data to cloud services such as Power BI, Power Apps, and Power Automate, with standard mode, personal mode, and virtual network gateway.

In the learning workspace, remove the personal computer gateway via gateway settings in the semantic model, then reinstall to complete the setup.

Deploy and configure the on premises data gateway for Power BI, connect local data sources, and schedule automatic refresh to pull new Excel data daily.

Implement row level security in Power BI by creating roles to filter data by channel or zone, preview as roles, and publish to Power BI service.

Configure row level security in Power BI service by mapping email IDs to roles like zonal manager west and key accounts, noting admins bypass rls and viewers are restricted.

Explore dynamic row level security in Power BI by mapping emails to channels, creating a role, and filtering data via user principal name to secure reports in Power BI service.

Learn how the Power BI service uses incremental refresh to partition data, refreshing only the most recent two months while keeping older data fixed, reducing refresh load on large datasets.

Implement incremental refresh in Power BI by defining range start and end parameters in Power Query editor and converting date columns to date time.

Power BI service analyzes your dataset to generate quick insights and visuals you can pin or implement in Power BI Desktop before republishing; row level security disables this feature.

Explore endorsements in Power BI, including promotion and certification of semantic models such as datasets, data flows, reports, and apps, in Power BI service.

Power BI performance analyzer is a built-in tool that records per-visual timings and DAX query times, helping you identify bottlenecks and improve rendering speed when applying slicers.

Improve Power BI report performance with best practices in data modeling, optimizing relationships, and removing unused columns. Use DAX variables and certified visuals, and split large reports across pages.

Learn how deployment pipelines in Power BI enable development and testing in the service before end users see changes, using sample data and parameters to switch data sources.

Navigate licensing for deployment pipelines in Power BI, including premium per user or capacity, pro licenses, and free trials, then create three-stage pipelines across development, test, and production workspaces.