Master Microsoft Power Bi - 72+ hours of Pro Level Content

Explore the Power BI Desktop interface, including data import, model view, and visualization panes. Identify the five building blocks—datasets, visualizations, reports, dashboards, and sharing—to analyze and present data.

Explore Power BI data sources, categorized into database, Power Platform, online services, and others, and connect data using import, direct query, or live connections to refresh visuals.

Connect to data sources such as Excel, CSV, and websites in Power BI, import and load data, configure text options, and save your pbix project for later use.

Combine data from multiple Excel files in a folder with the query editor to import, transform, deduplicate, and reduce the data set, keeping the top 30 countries by population.

Master Microsoft Power BI course overview: explore Power Query Editor for data transformation and data preparation with a graphical interface, gathering data from multiple sources to create reports.

Explore the M query language, a functional, case-sensitive data transformer for Power BI. View and edit formulas in the formula bar and advanced editor, and learn about variables and expressions.

Rename and edit queries in the Power Query advanced editor, mastering error handling with step-by-step fixes. Explore M language variables, case sensitivity, and resolving common query errors.

Consolidate and optimize Power BI queries with the M formula language by reducing steps, substituting variable names with actual queries, and renaming and filtering columns for efficient reports.

Master Microsoft Power BI teaches how to change data types, replace values, group data, and use transpose and unpivot to prepare data for visualization.

Learn to split columns using delimiters or character counts, format text with case and trim, merge columns, and extract details in Power BI Desktop's transform data window.

Append data from multiple sheets, including GDP and population, and create custom columns and an index column; then clean and format the data for a Power BI data model.

Construct and manage relationships between tables, merge data with queries, and apply cardinality options: one-to-many, many-to-one, one-to-one, and many-to-many, in Power BI Desktop.

Master text formulas in custom columns and conditional formulas in Power Query to get first three characters, last four characters, and to combine names for Power BI workflows.

Learn how to create and manipulate list values with the Power Query list function, including counting items, excluding nulls, filtering by conditions, and removing duplicates, with an Excel data example.

Master the group by aggregate function in Power Query to sum the total sales price by sales channel and load the updated table.

Learn to add and subtract dates in power query using date functions, including previous year and last two years checks, and apply these to excel sales data.

Learn to use Power Query rounding functions such as round, round up, and round down; create custom columns for results and arithmetic; and apply sine and even checks.

Explore Power Query basics to compute percentages with percent of, apply fill up and fill down, use modulo, and group data for conditional updates.

Learn to add prefixes and suffixes to text in power query, split data by gender, and append tables to consolidate employee records.

Master Power BI by learning to dynamically merge scattered data from multiple columns into a single column in Power Query, handling variable column counts with dynamic headers and delimiter-based merging.

Master power query group by to aggregate monthly sales by customer, grouping by customer name and month, and compute the monthly total sales with advanced options.

Learn three ways in Power Query to separate text and numbers from a mixed string, using custom columns and text functions to extract text and numeric values in Excel data.

Master Microsoft Power BI shows how to reduce rows in Power Query using keep top rows, keep bottom rows, and a range of rows, plus removing duplicates.

Learn to extract top N records in Power Query by creating a total discounted sales price list, sorting descending, applying List.Range, and merging with sales details.

Learn to handle errors in Power Query with the if error function, convert column types, create quantity updated and updated sales, and remove or recalculate rows to ensure accurate totals.

Learn to merge tables based on condition in power query by using a full outer join on date columns, and build a custom column to align ticket prices with visitors.

Learn to use let and nested let statements in Power Query by declaring variables and nesting outer and inner blocks. Apply to transform data and extract dates with hash date.

Create custom functions in Power Query and invoke them with parameters, test with numbers and text, handle errors, and use the advanced editor to modify functions and results.

Master Power Query custom functions in M language to compute chocolate cups per cake, invoke functions across orders, and build multi-condition logic for chocolate taste (strong, moderate, mild).

Create and use parameters in Power Query to drive dynamic data transformations and filtering in a data table, including any value, list of values, and query-based parameters (barometer).

Master fill up and fill down in Power Query to fill missing values based on conditions. Learn grouping, custom columns, and pivot operations to shape and apply data transformations.

Learn to index columns in Power Query to retrieve the previous row value, then compute revenue differences using group by, custom columns, and list functions.

Perform a conditional join in power query by extracting seller names from the description column, creating a seller name list, and merging two tables to align sales data.

Learn to use the if function in Power Query to build conditional columns and nested if statements. Apply and/or logic, explore list contains, and multiply quantity by price for revenue.

Master Microsoft Power BI: dynamically rename columns in Power Query by creating a dynamic header list, transposing the table, and applying rename steps in the advanced editor within Excel.

Create a delimited, limited list in Power Query by building a reference to sales data and deriving unique customer–product combinations, then extract values to show product lists by customer.

Create dynamic start and end dates for data tables in Power Query by loading Excel data, adding an index and date logic, and deduplicating to name start and end dates.

Master approximate matching in power query by merging sales data with the bonus structure table and computing the bonus amount from the sales value.

Combine tables with different columns by appending three or more tables in Power BI, transforming in the query editor, and enabling load to display only the merged data.

Learn to handle nulls and blanks in Power Query by cleaning data, replacing empties with zero, and creating custom columns to identify and manage missing values.

Build a dynamic calendar table in Power Query by creating a date list, converting numbers to dates, and using a parameter table to define the date range.

Pivot data in Power Query by transforming data and using a pivot column to aggregate values, then build a matrix visualization to summarize revenue and profit by country and dates.

Learn to apply multiple-criteria filters in Power Query using lists and not contains, refining sales data by channel type, genotype, and geographic region for dynamic insights.

Learn to summarize and group data in Power Query by product category, loading an Excel sheet, applying a basic group operation, and reviewing applied steps and formula.

Learn to dynamically rank data with ties in Power Query using group by, identify top five values, and classify others below 3500. Add custom and conditional columns and apply changes.

Convert multiple columns into rows in Power BI via Power Query, fix headers, transform data, and pivot to create separate sales and quantity columns with no aggregation.

Learn to calculate running totals in Power Query by sorting dates, adding an index, and creating a running total column; apply per group by product using a custom function.

Learn to stack data from columns to rows in Power Query by unpivoting, cleaning attributes, and creating pivoted fields for sales, state, and commodity, with dynamic refresh.

Rename multiple columns in Power Query and sort data by any column, updating the formula bar and applied steps as you use the header rename, advanced editor, and home options.

Learn to find top n rows in each group using Power Query by merging category data, sorting by total quantity sold, and selecting the top subcategories per category.

Learn to create a rule number for each group by using power query's group by product category, then add an index per group and apply changes.

Retain the most recent project status and remove duplicates in Power BI by loading an Excel file, sorting by last status update date, and deduplicating by project, employee, and status.

Perform a vlookup in power query by merging two data tables with a left outer join, returning location, salary, and bonus, with automatic refresh when source data updates.

Extract min and max dates by category in Power BI using Power Query, duplicating queries, computing earliest and latest dates, building a dates list, and applying transformations.

Create unique combinations from multiple columns in Power BI using Power Query, loading three tables, adding custom columns, and merging to produce all possible rows.

Unstack uneven rows into separate columns in Power BI using Power Query, by identifying name changes, creating indices, grouping, pivoting, and renaming headers for dynamic refresh.

Create a date time column in a calendar table with Power Query, calculate days between dates, and convert durations to total days for time increments.

Explore dynamic filters in Power Query by converting region data to a list and using list.contains to filter and build a conditional column.

learn to add an index column to subgroups in a Power BI data table by grouping under transform data, creating a custom index with a function, and applying changes.

Explore using custom functions in Power Query to display status icons for employees with a conditional column and emoji icons, and implement a function via the advanced editor.

Learn to extract data from top rows in Power Query by using a custom column to access binary workbook content, then combine six yearly tables into one.

Define data types and dynamic data types in power query, including Typekit dynamic application, automatic column typing, and type detection to adapt tables and source data.

Create and use hierarchies in Power Query by generating one column per level with custom columns, then apply a slicer to navigate multi-level data.

Learn to perform sumif-like aggregation between two tables in Power Query by creating a custom column, filtering on sales channel and product type, and summing the revenue.

Learn to dynamically remove empty columns in Power Query for Power BI using M language, identify and filter columns by names, promote headers, and keep only relevant data columns.

Learn how to perform fuzzy matching and VLOOKUP-style lookups in Power Query to merge data from multiple tables, adjust similarity thresholds, and handle mismatches in Power BI.

Learn how to convert a date to fiscal periods in Power Query by building month, year, and quarter columns and defining a U.S. fiscal year October to September.

Learn to create conditional columns in Power Query to group employees by name initials a, b, and c, and by name endings e and y, then apply and save changes.

Discover how to execute a full anti join in Power Query by merging morning plus and evening class data, revealing records present in one table but not the other.

Learn to add leading zeros to month numbers in Power Query by using custom columns, text formatting, and example-based column creation to ensure correct month sorting.

Count how many times a text appears in a column using Power Query by converting to lowercase, splitting text into lists, and counting list items.

Learn to unpivot data dynamically in Power Query, turning monthly sales columns into a single value column and using a dynamic column list that updates with new columns.

Learn to change column names dynamically in a Power BI visual by using a slicer, selecting attributes to rename, and updating a report with a single-select control.

Access the power query library, search and apply functions like text and date in the editor, convert to table, create a custom column using a date function, and apply changes.

Discover how to create Power BI reports from a dataset using report view, add visuals like map and stacked column charts, apply filters, and manage pages and fields.

Explore visualizations in Power BI, including matrix, table, cards, slicers, and filters; learn drag-and-drop of fields, interactivity across visuals, focus mode, and comparing population 2018 and 2019 by region.

Use the Q&A feature in Power BI to ask data in natural language and view results as cards or visualizations such as line charts, area charts, or tables.

Explore data modeling with DAX in Power BI, load and transform data from multiple sources, define relationships, and build measures and calculated columns to analyze and forecast business trends.

Import data from Excel, transform and cleanse it, then build and manage relationships between tables, and apply DAX to create reports in Power BI desktop.

Use the DAX lookup function to add calculated columns that pull geographic region from country or territory and discount details such as discount type and percentage from a lookup field.

Learn to create a DAX calculated column that multiplies two columns to produce product, then compute total cost price, total sales price, and discounted sales price, formatted as currency.

Create a DAX calculated column to divide and find the difference between two fields, format results as currency, and apply conditional columns in Power Query for the Power BI model.

Master how to create DAX measures and use aggregate functions like SUM and SUMX to calculate total sales and total profit loss within a Power BI data model.

Explore DAX aggregate functions such as min and max, create measures to compute minimum and maximum profit over a time frame in Power BI, and format results as currency.

Learn the DAX average function, create a new measure for average profit over a timeframe in sales details, and format the result as currency.

Create and customize Power BI visualizations by dragging measures, switching chart types, and arranging charts to reveal total sales, profit by geography, and key performance metrics.

Master DAX functions count, counta, countax, countrows, countx, countblank, and distinctcount to count rows, non-blank values, blanks, and distinct values in Power BI.

Learn DAX text functions such as combine values, search, find, exact, and trim to build a full name column, locate substrings, compare names, and remove extra spaces.

Master power bi uses dax text functions such as concatenate, replace, left, right, mid, and len to build full names and extract substrings and character counts.

Explore DAX text functions like SUBSTITUTE, FIXED, and FORMAT to transform text, round numbers, and format currency and dates in Power BI data models.

discover how to extract minute, hour, day, month, quarter, and year from a date-time column using DAX functions in Power BI, and create new calculated columns to analyze website traffic.

Master dax advanced date functions such as datediff, datesbetween, and datesinperiod to calculate total sales with measures and date tables, testing results in visuals.

Learn to use the edate and eomonth functions in Power BI to add or subtract months from a start date and determine month-end dates for due and maturity calculations.

Learn to compute cumulative totals for month, quarter, and year using time intelligence functions (MTD, QTD, YTD) in Power BI, and build measures to track sales over time.

Master information functions in Power BI and dax, including isblank, isnumber, istext, isnontext, iserror, isodd, iseven, and islogical, with if tests to validate data types and handle blanks.

Master how the DAX contains function and its variants—contains row, contains string, and contains string exact—to evaluate rows, filter data, and create measures for online sales.

Learn how to use the time intelligence opening balance in Power BI, including month, quarter, and year, by building measures from total sales value with a calendar table.

Master closing balance month, closing balance quarter, and closing balance year in Power BI by creating measures that evaluate the last date in each period.

Master Dax max, maxa, and maxx functions in Power BI to find the largest values across columns and expressions, create measures, apply filters, and compare target versus actual sales.

Explore DAX techniques to extract the first non-blank value and the last non-blank value using firstnonblankvalue and lastnonblankvalue, build measures in Power BI, and analyze sales price by product name.

Master dax functions firstnonblank and lastnonblank to build measures such as total sales and first/last nonblank values in Power BI, using an Excel dataset with blanks to verify results.

Master the DAX GENERATESERIES function, which returns a single column table named value, generating a numeric series from start to end with a specific increment, shown through multiple examples.

Create and compare DAX measures using the except, all, and all except functions in Power BI, including building new tables, using calculate, and visualizing regional and product sales.

Explore DAX functions ALLSELECTED and SELECTEDVALUE by building measures that compute total sales across all regions and years while preserving explicit filters, and display the selected region in a card.

Explore the DAX value function converting text to numbers, the error function for invalid data, and the in operator for filtering; build measures with calculate and slicers to compare channels.

Learn how the DAX upper and lower functions convert text to uppercase and lowercase, with a practical example of adding new columns in a data table.

Master Microsoft Power BI: learn the DAX TREATAS function, create relationships across three tables, and build measures like total sales, marketing cost, and marketing percentage to analyze cross-table data.

Explore the DAX has one value function, which returns true when a column's context is filtered to one distinct value and false otherwise, with examples at month and year levels.

Discover how DAX union and cross join create a single table via union of tables and the cartesian product, with aligned columns and retained duplicates.

Learn to use the DAX parallelperiod function to compute previous year sales, building a total sales measure, establishing a calendar table relationship, and comparing it with standard date functions.

Learn to use the DAX TOPN function to rank and return top rows, create measures like total sales and total property loss, and generate top five values in Power BI.

Learn the DAX group by function to create summary tables by grouping data across multiple tables in Power BI, and build reports like total sales by product and geography.

Explore DAX data forecast by using historical records to project sales, create total sales and total sales forecast measures, link a calendar table, and visualize October–December projections.

Compare the difference between hasonefilter and hasonevalue in Power BI and learn how each responds to direct, indirect, and cross filters with slicers.

Learn how the DAX functions isfiltered and iscrossfiltered work with direct, indirect, and cross filters, using the product name column in the detail table to create measures and test results.

Understand the order of evaluation in DAX and how context shapes calculations. See how the calculate function and sum mix use context and filters across calendar, region, and sales tables.

Learn to look up values across tables by matching product name and date with the look up value function, add related columns from a lookup table, and use model relationships.

Learn to use the filter function to apply custom filters in calculations, returning a subset of a table based on a condition and a nested filter function.

Learn to perform multi text search in Power BI using DAX to extract fruit names with search and switch, and identify exact positions with find.

Learn to display last six months of sales data in Power BI by selecting a date in a slicer, using an end-of-month column and calendar table to filter two-table model.

Discover how to create and manage relationships in Power BI, linking the main sales data table to product, salesperson, store location, and country lookup tables, with cardinality and cross-filter direction.

Learn to compute percentage of total in Power BI with DAX, using measures for total sales and profit, and filter logic with all, values, and divide in matrix visuals.

Learn to compute year-over-year growth in Power BI using date functions like same period last year, build a calendar table, and create dynamic visuals.

Discover how to find weekly sales and total profit in Power BI with DAX by building a calendar table and setting week starts on Sunday or Monday.

Learn to use DAX variables in Power BI to break complex calculations into steps, improving performance and readability while creating measures like regional profit and total profit from sales data.

Master time intelligence in Power BI to find events in progress, such as open orders, by using a calendar table and DAX measures.

Learn to perform allocation calculations in Power BI by grouping data by month, creating date ranges between sales and delivery dates, and using group by, current group, and generate.

Compare measures and calculated columns in Power BI: calculated columns are evaluated per row in the data model, while measures evaluate at visuals and react to filters.

Master role playing dimensions in Power BI with DAX, linking the calendar table and other dimensions to a fact table using active relationships and userelationship in star and snowflake schemas.

Learn to apply multiple filter conditions in DAX with the calculate function, referencing multiple columns, to compute profit Asia online using a calendar table and premium product data.

Learn to apply conditional formatting in Power BI to tables and charts using color scales, icons, and data bars, with rules for diverging values and field-based colors.

Learn to calculate the average of top values in a column in Power BI using add columns and calculate with max to compare shop and product performance.

Master data filtering in Power BI by measure categories using a slicer, building measures to compare 2018 and 2019 sales, and drive a status-driven table.

Master Microsoft Power BI by learning to compare one category value against all others, create measures and charts, build relationships, and use a disconnected others table for insight.

Explore the earlier and earliest functions in DAX to compute the current row values within nested evaluation contexts, then apply them to cumulative totals and region-based expense allocation.

Learn to compare budget versus actual data across project categories in Power BI by building two linked tables and slicers, with measures that enforce distinct selections and dynamic currency visualizations.

Learn to create dynamic URLs and fetch dynamic weekly stock data in Power BI using ticker symbols, a data table, and custom functions.

Explore how to search text in a Power BI column using DAX containsstring and containsstringexact, including case sensitivity, wildcard support, and building measures with selected value.

Master Microsoft Power BI teaches DAX IN and DAX CONTAINSROW to filter data, build total sales measures, and compare 2019 and 2020 across stores and online channels.

Explore the four types of Dax operators: arithmetic, comparison, concatenation, and logical; learn how they perform math, compare values, join strings with the ampersand, and combine expressions.

Explore DAX table functions and the filter context in Power BI, using examples of filter, all selected, related, summarize, and sumx to build measures and temporary tables.

Learn how row context and greater context interact in Power BI's DAX to enable dynamic analysis and filtered measures.

Learn cross filtering and bi directional filtering in Power BI, connect fact sales data with product dimensions, and use crossfilter in measures for distinct count.

Explore how row context and filter context propagate through direct and indirect relationships in Power BI, using related and related table to create calculated columns and measures.

Learn how DAX CALCULATE and CALCULATETABLE modify filter context to evaluate expressions in Power BI, producing scalar or table results, with practical examples like Europe region revenue.

Master DAX calculate and all functions in Power BI to compute totals and percentages while ignoring filters. Apply allexcept patterns to reveal category and class insights.

count working days between two dates in Power BI using DAX and a calendar table, excluding weekends and public holidays by country, with practical examples.

Learn to use the DAX look up value function in Power BI to pull multiple product fields into the sales data, even without relationships, using calculated columns.

Learn to build a DAX measure using or logic in Power BI slicers, selecting geographic region or product category to filter sales data with CALCULATE, FILTER, and RELATED.

Extract dates from text strings and numeric sequences using Power Query in Power BI. Learn to use examples to create a date column and fix formats for US dates.

Explore DAX related and relatedtable functions in Power BI to fetch data across tables using relationships, including calculated columns and measures with product and sales examples.

Learn to use the DAX CONCATENATEX function to summarize multiple row data into a single cell in a table or matrix, enabling readable cross-table summaries across related tables.

Learn how to use the DAX format function in Power BI to format numbers as currency, fixed two decimals, and general numbers, and apply conditional formatting to reports.

Compare time periods in Power BI using DAX DATEADD and CALCULATE with a calendar. Create measures for previous month, quarter, and year profits; connect to the calendar to analyze trends.

Learn to find cumulative averages in Power BI using DAX functions AVERAGEX, SUMMARIZE, and DATESINPERIOD; create virtual tables and use CALCULATE with DATESINPERIOD to compute three- and six-month average sales.

Learn how to compare time periods in Power BI using DAX previous month, parallel period, and dateadd, build measures for month-over-month sales, and visualize period differences.

Master how to calculate exact time spent on a task in Power BI with DAX time functions, extracting hours, minutes, and seconds, and compute the total time and associated cost.

Master Power BI with DAX to calculate previous year data up to a specific date using same period last year and calendar tables for accurate sales comparison.

Create a KPI visual in Power BI using a DAX-based measure to compare actual sales to targets, with date-aware trends and current value against the goal.

Learn to compute percentages based on column totals in Power BI using DAX with variables and divide, and compare results with show value as percentage of grand total and CALCULATE.

Learn to create multilingual reports in Power BI using parameters and translation tables, with dynamic titles and measures for total sales and total quantity in English, German, Spanish, and French.

learn to perform weighted average calculations in Power BI with DAX by creating calendar and dimension tables, defining monthly and country weights, and building measures for accurate insights.

Learn to group by in Power Query to create summarized tables by country and product class, apply sums to numeric columns, and handle text-value limitations.

Learn to calculate daily rolling averages in Power BI using DAX, applying moving average concepts with seven- and fourteen-day windows and a barometer slicer to adjust days and visualize results.

Learn to switch between total sales, total cost, and total profit using a slicer and a dynamic measure table in Power BI, enabling interactive charts and cards.

Fix dates stored as text in Power Query by converting to date using split column, add custom column, and column from examples across five practical methods.

learn to calculate the sum of distinct monthly marketing expenses in power BI using DAX by applying distinct values, max per channel type, and the values function.

Create a total sales measure in Power BI and apply dynamic conditional formatting to values and totals. A dynamic slicer updates the formatting based on average revenue and other conditions.

Explore how to perform month- and quarter-over-time comparisons with DAX dateadd and sameperiodlastyear, employing time intelligence functions on a calendar table.

Create and connect data tables in Power BI, then build three measures: total sales, total cost, and total profit, and use a slicer to hide or unhide them dynamically.

Calculate cumulative discounts in Power BI using DAX by evaluating sales over defined periods, applying customer-specific discount percentages and deriving total sales, cumulative sales, discount amount, and net sales.

Use DAX switch to create an importance column and custom sort status in Power BI visuals, applying the order to tables and charts for a priority view.

Model data with targets across hierarchy levels in Power BI using a matrix and DAX to compare total sales, profit percentage target, and profit plus net actual.

Learn to limit a Power BI visual to the user's date by building a disconnected date table and a DAX measure using calculate and filter.

Learn to calculate same period last month in Power BI using DAX by creating measures for total sales, building a calendar table, and filtering dates to compare periods.

Learn to create an index based on multiple columns in Power BI using DAX, by building a calculated column with the EARLIER function and applying calculate and filter to assign numbers by country and product.

Explore how to calculate the max and min of a measure in Power BI using DAX, with techniques like MAXX and ALL to ignore filters and compare country-level sales data.

Create a dynamic pricing model in Power BI using DAX, linking calendar, price, and usage data to compute total expense with fill down and last non-blank price across dates.

learn to use virtual tables in Power BI, including physical, calculator, and watch tables, which stay dynamic without increasing file size.

Identify uptrends and downtrends in sales over a chosen time period with Power BI. Build dynamic measures, moving line charts, and slicers to compare best and worst periods.

Calculate quartiles in Power BI using DAX percentile functions, compare inclusive and exclusive variants, and build measures to compute q1, q2, and q3 from a data table.

Explore the DAX product and DAX PRODUCTX functions in Power BI to multiply values and compute future investment returns from historical data, creating measures and currency formatting.

Learn to build dynamic rankings in Power BI by creating measures for total sales, total cost, total profit, and profit percentage, then rank these measures using DAX and slicers.

Learn to fetch results from disconnected tables in Power BI using treatas, create measures with calculate and values, and filter by product id to align data without relationships.

Learn to use isinscope and hasonevalue in DAX to detect hierarchy levels, create percentage measures across country, product, class, and gender, and manage total row behavior in Power BI.

Learn to find bottom n values in a category with DAX in Power BI, using total sales, ranking, and get next, illustrated through two practical examples.

Create a top N sales report in Power BI using a disconnected slicer to pick 3, 5, or 10, with measures for total sales, total cost, and total profit.

Learn to implement dynamic currency conversion in Power BI using DAX, with primary and secondary currencies, exchange rates, and a slicer to report in one currency.

Explore how DAX keepfilters and DAX removefilters modify filter context in Power BI, using calculate and measures to show or hide total sales by country, including Germany.

learn how to calculate age from birth date in Power BI, bucket ages into groups, and analyze sales by age, gender, and product class to reveal customer preferences.

Explore the DAX rounding functions in Power BI, including round, roundup, and rounddown, with practical examples using numbers, prices, and time data.

Explore DAX rand and randbetween functions in Power BI, generating random numbers from 0 to 1, or between two bounds, with practical examples and refresh behavior.

Learn to use the DAX RANKX function to build static and dynamic rankings in Power BI with total sales, using ALL or ALLSELECTED to adjust ranks by slicer selections.

Explore working with multiple fact tables in a Power BI data model using DAX, connect shared dimension tables, and create cross-table totals with measures.

Master smart narratives in Power BI to summarize visuals with natural language, and build measures like total sales, total cost, and total profit with currency formatting.

Learn to build a fiscal year calendar table in Power BI, using DAX to add fiscal months, quarters, and year columns for October to September years.

Create and use what-if parameters in Power BI to visualize how changes in sales affect total sales across categories, using slicers and DAX measures to show percentage impact.

Create dynamic greetings in Power BI using DAX by building static then dynamic messages with variables, time-based conditions, and concatenation. Make greetings user-specific via a lookup table.

Analyze variance and standard deviation as measures of data variability, using DAX VAR.S and STDEV.S in Power BI and Excel with practical examples.

Learn to calculate mean, median, and mode with DAX in Power BI; replicate Excel results and build a custom mode using add columns and calculate to identify most frequent value.

Discover how to use the DAX price function in Power BI to price bonds using settlement date, maturity date, rate, yield, redemption value, frequency, and basis, via an Excel workflow.

Explore DAX present value and future value functions in Power BI to compute loan and investment values with a constant rate, using rate, nper, pmt, fv, and type.

Learn to create custom KPIs in Power BI using colored up and down arrows, building measures for total sales and the difference from last year, with conditional formatting and icons.

Learn to add images to tables and slicers in Power BI by using image links, setting image category, and displaying country flags from Excel data in data and sales tables.

Learn to identify consistently high-demand products across three weeks using DAX in Power BI, including a calendar table and three-week product intersection.

Learn to calculate the average days between two events in Power BI by building a calendar table, establishing relationships, and creating DAX measures to analyze customer purchases.

Learn to calculate revenue and profit in Power BI with fluctuating cost and sales price, using dynamic cost price and dynamic sales price measures to compute sales and cost.

Learn how to count products with specific sales values using DAX in Power BI, including creating a virtual table, measures for zero sales, and filtering by customer name and country.

Learn to set up a drill-through page visual in Power BI using DAX, creating geographic region insights with measures like total sales, total cost, and total profit.

Create subgroups by product name in Power Query and reference the previous row value using an index to restart the count for each product.

Compare current month sales with the best selling month using DAX, total sales, and cumulative sales, and establish the calendar table relationship.

Build a Power BI data model with multiple what-if scenarios using DAX, exploring sales price, cost price, and demand changes with measures, slicers, and scenario-based profit.

identify the products that contribute to maximum profit in auto sales between two years using DAX, and create dynamic year comparisons with measures for cost, sales, and profit.

Learn to pull stock prices from Yahoo Finance into Power BI using Power Query, with dynamic tickers, multiple timeframes, and a calendar table for interactive analysis.

Learn to compare actual sales against targets in Power BI with DAX using cumulative totals and prior year comparisons, building calendar and target measures for country performance.

Create a multi-criteria what-if analysis in Power BI with DAX to model discounts. Assess effects on selected and non-selected product sales using measures and visuals.

Learn to implement role-based data masking in Power BI using DAX, hiding confidential fields and showing only the logged-in user's data with code names and dynamic measures.

Learn to mask direct reports' salaries in Power BI using DAX by building a multi-level reporting hierarchy and a measure that reveals indirect salaries while hiding direct ones.

Learn how to forecast sales in Power BI using historical data, create a calendar table, build relationships, and apply a five-year forecast with 95 percent confidence while analyzing seasonality.

Forecast five years of sales in Power BI by calculating CAGR and applying a CAGR-based forecast via measures, linking calendar and sales data for dynamic visuals.

Build a cumulative sales forecast in Power BI by creating a calendar table, linking it to sales data, and using DAX measures to compare actual sales with 2020 forecasts.

Explore Power BI visuals and when to use each type, from table and matrix to metrics and built-in charts. Learn loading, relationships, and formatting to create clear visuals.

Explore Power BI map visuals and cards, learning bubble and choropleth maps with latitude/longitude and country data, plus slicers to filter across related tables.

Explore stacked bar and column charts in Power BI, including 100% stacked, clustered, and small multiples, with legends, data labels, tooltips, and formatting to compare categories across a single measure.

Explore line, area, stacked area, and line and cluster column visuals in Power BI, using measures like total sales, total profit, and total cost with slicers and formatting.

Explore Power BI visuals like ribbon chart, remap chart, pie chart, and map chart to analyze total sales by geographic region and country, reveal trends, and compare category performance.

Learn to build a funnel chart in power bi that visualizes sequential sales stages—from identify to close—using a calendar table, relationships, and stage ordering for conversion analysis.

Create a Power BI bubble chart from a scatter chart to visualize three dimensions by mapping sales to the x-axis, profit to the y-axis, and bubble size from Excel dataset.

Create and interpret waterfall charts in Power BI to visualize cumulative changes from a starting point to an ending point. Demonstrate time-based and category-driven changes in income, expenses, and headcount.

Explore how to create visuals in Power BI using the Q&A feature to ask natural-language questions and generate visuals from a dataset with sales, calendar, and product tables.

Create a Pareto chart in Power BI using a line and clustered column chart to show contributing countries in descending bars and illustrate the 80 percent versus 20 percent principle.

Create a dynamic gauge chart in Power BI to track KPI progress against a target using a dial chart with color-coded segments and data-driven min, max, and average values.

Learn to build a dynamic status bar in Power BI that compares actual sales to targets using measures, conditional formatting, and color-coded icons.

Learn to create a Power BI progress bar chart by building measures for total target and actual sales, calculating target achievement and pending percentages, with slicers for dynamic updates.

Create a decomposition tree in Power BI to drill down sales by geography and time for root cause analysis, using a calendar table, relationships, and a total sales measure.

this lecture demonstrates how to use the key influencer visual in Power BI to analyze data, rank the factors that matter, and display them as key influences.

Learn to create dynamic small multiple visuals in Power BI with a slicer that toggles categories like geographic region, country, and product.

Learn to build a heat map chart in Power BI to visualize monthly sales by category using four tables. Create a total sales measure, apply currency formatting, and enable conditional formatting.

Learn to create a radial bar chart in Power BI to visualize revenue share by product class and compute the remaining market share.

Master Microsoft Power BI matrix visualization by building a multi-table model, creating measures for total sales and year-over-year differences, and applying conditional formatting and styles.

Learn to add emojis and icons to Power BI visuals by creating status measures (completed, in-progress, cancelled), mapping icons, and linking an emoji table for dynamic slicer-driven insights.

Create slope charts in Power BI to visualize changes in total sales by country across years, using a two-point, rank-based visualization with data loaded from Excel.

Learn to build a Power BI target chart with same or different targets, comparing actual sales to monthly targets across years using calendar and target tables, measures, and conditional formatting.

Learn to build KPI indicators in Power BI to analyze year-over-year sales, create measures for total sales and last year, apply conditional formatting and color coding, and design visuals.

Learn to highlight monthly sales above or below yearly average in Power BI by building total sales and average measures, and applying conditional formatting with an average line.

Create a Power BI visual with dynamic ranking and color by value, highlighting the top six products and top six countries by total sales with distinct colors.

Create dynamic visual titles in Power BI by building measures that reflect slicer selections (month or product), then apply them to title cards for real-time updates.

Learn to create three measures: total sales, total cost, and total profit, and toggle them dynamically with a slicer in Power BI, updating visuals and dynamic titles in real time.

Create dynamic clickable cards in Power BI to filter sales by channel type (website, blocks, paid ads) using Excel data, Power Query, slicers, bookmarks, and a monthly sales line chart.

Discover how to highlight a slicer selected value in a Power BI visual by creating a disconnected slicer and a measure that updates the chart dynamically.

Learn to group categories by criteria with DAX in Power BI, creating top end and others buckets, a dynamic top-N slicer, and measures for total sales and dynamic visuals.

Collapse and expand measures in Power BI—sales, sales last year, cumulative sales, cost, profit, and profit percentage—using a slicer, bookmarks, and buttons, with switch and selected value to update visuals.

Apply built-in and custom report themes in Power BI to standardize colors and formatting across a report, and create or customize themes for consistent visuals.

Create an interactive Power BI quality analysis dashboard with three pages: overview, details, and overall analysis, tracking department quality scores, auditors, managers, and tasks with dynamic updates and conditional visuals.

Create an interactive quality analysis dashboard in Power BI from Excel dataset, build a calendar table, and define measures for all tasks total, sample total, defects total, and errors total.

Explore data modeling with DAX to create interactive dashboards that compare defect and error percentages by months, using stacked and clustered charts, slicers, and conditional formatting.

Apply your learnings to workplace data to create impressive and dynamic data models, stand out with your new skill set, and get noticed by top management with our support.