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

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 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.

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.

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 approximate matching in power query by merging sales data with the bonus structure table and computing the bonus amount from the sales value.

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.

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.

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 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.

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 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.

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.

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.

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.

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 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.

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.

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 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.

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 create dynamic URLs and fetch dynamic weekly stock data in Power BI using ticker symbols, a data table, and custom functions.

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.

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.

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.

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.

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.

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 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 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 identify consistently high-demand products across three weeks using DAX in Power BI, including a calendar table and three-week product intersection.

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.

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.

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 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.

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 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.