Power BI Beginner to Pro with Data Analysis Mastery

Explore other visuals available in Power BI, starting with tables, to elevate data analysis, visualization, and exploration to a whole new level.

Learn to build and customize a Power BI table visual, populate data, apply sums and other aggregations, multi-level sorting, conditional formatting, and date hierarchy basics.

Master slicers in Power BI to filter dashboards by product, channel, and date, customize slicer visuals, control edit interactions, and apply cross-visual filtering and highlighting.

Master drill through in Power BI by linking dashboard filters to the transactions page, enabling cross-report navigation from day name to date, week, quarter, month, and year.

Learn to filter Power BI dashboards with slicers and the filter pane, applying basic or advanced filters across visuals, a page, or all pages for year 2019 and 2020.

Explore the matrix visual to organize data in rows and columns. Expand year, quarter, and month hierarchies and apply subtotals and conditional formatting for clearer reports.

Explore Power BI bar and column charts, including simple, stacked, clustered, and 100% stacked variants, using sales by region and country for clear comparison.

Master line, area, stacked area, and 100% stacked area charts in Power BI, using dual y-axes, legends, shading, and zoom to analyze regional and product trends.

Build a line and stacked column chart in Power BI with dual y-axes, plotting sales (columns) and average discount (line) across quarters, and explore legends and clustered column charts.

Explore ribbon charts in Power BI to visualize sales over time, compare products, regions, and channels, and analyze quarterly and regional trends using small multiples.

Explore how the waterfall chart identifies drivers of change across years and channels, showing how each product contributes to total sales.

Master funnel charts to measure conversion across product journeys, highlighting serum as the hero product, revenue by product, and regional comparisons across Europe, North America, and Oceania using data labels.

Use scatter charts to reveal patterns and correlations between discount, units sold, and revenue in Power BI, including cross checks across channels, regions, and products with DAX.

Explore pie, donut, and tree map visuals to show sales composition by product and channel, adjust legends and labels, and use tree maps as interactive slicers.

Create precise dashboard metrics using card and multi-row card visuals in Power BI, displaying exact sales values and average discounts with flexible formatting, titles, borders, and callout styling.

Create and customize Power BI maps and filled maps to display sales by region and country, size bubbles, and switch between world map and filled map styles with zoom controls.

Explore Power BI visuals from bar and pie charts to advanced visuals like ribbon, waterfall, funnel, and scatter, plus tables and matrix, and prepare for decks calculations.

Learn DAX in Power BI for calculations using calculated columns and measures, inflating sales by 20% with a 1.2 multiplier and comparing column versus measure in a matrix.

Learn to build calculated columns in Power BI with DAX, converting dates in the calendar table into day, month, and year, and adding these columns directly in Power BI.

Add calendar columns in Power BI using DAX, including quarter, month name, day name, day number of week, and week number, with Monday start and calendar versus financial year considerations.

Add columns to the calendar table with DAX, including quarter number, month name, day name, and week number; adjust week start to Monday and note calendar year vs fiscal year.

Learn to build conditional calculations in Power BI DAX using if, if or, and in to classify days as weekend or weekday and extend with and/or logic.

Use advanced DAX to create an expected sales column with an if and and condition for weekend days in the first ten days of each month.

Learn to build a calculated column named expected sales in Power BI using DAX with IF, OR, and AND, including parentheses for correct logical grouping and validating results.

Learn to merge multiple Power BI columns with DAX by using the concatenate approach, creating new columns like year end quarter and quarter number, with spaces between values.

Master the DAX RELATED function to pull fields from connected tables, like day type from the calendar and standard price from product, streamlining data modeling in Power BI.

Learn to build basic calculated columns in Power BI to compute actual price from standard price and discount, then derive sales revenue from actual price and sales units.

Create a calendar table in Power BI using DAX, with the calendar auto function to generate dates from inception to end of data, and automate column updates.

Learn to fetch data from unconnected tables in Power BI using the lookupvalue function, with related as fallback, demonstrated on calendar tables to extract year values.

Explore how ChatGPT aids Power BI and DAX formulas through precise prompts and detailed project context, balancing 80/20 work between us and ChatGPT in cosmetics retail data analysis.

Show how to write basic DAX formulas in Power BI for a calendar table with ChatGPT, generating day, month, year, quarter, and weekday columns, then discuss basics versus complex formulas.

Learn to craft DAX formulas with ChatGPT, using the if function to label weekends versus weekdays, and handle exact column names and multi-condition logic for sales in Power BI.

Explore creating a DAX conditional column in Power BI with ChatGPT phase 3 to classify days as weekday, normal weekend, or super weekend by day name and day of month.

Learn to create measures in Power BI with DAX, performing aggregations like sum. Build a total sales measure, format as a whole number, and enable period-to-period growth with analytics expressions.

Learn how to create an average discount measure in Power BI using DAX, apply it to a regions-by-products matrix, format as a percentage, and compare regional product discounts.

Master sumx for row by row calculation in Power BI, multiplying sales units by actual price to get total sales on the dashboard, without a dedicated sales column.

Use related in measures to pull the standard price from the product table and compute revenue with sumx.

Apply sumx and related to compute total sales by multiplying unit sales with net price drawn from the product table, derived as standard price times (1 minus discount).

Learn how the DAX calculate function filters data to compute sales as a percentage of grand total or row total, including calculating percentages relative to a hero product like serum.

Learn to use the DAX CALCULATE function to create a filtered total sales measure for serums, filtering across product and sales tables, with dynamic slicer-driven results.

Create measures with the calculate function to compute total sales by product names, format as whole numbers, and display dynamic results in a sales matrix.

Create measures to compare product sales using the divide function, calculating toner as a percentage of serums, formatted to two decimals. Explore error-safe division and matrix rollout across five products.

Master Power BI DAX: use divide in a matrix to compute product-level ratios, fix serum as the hero product, and produce a dynamic percent of serum with row-level filters.

Calculate min date and max date in Power BI using DAX measures. Create min date and max date from the calendar date column, and explore per year and quarter visuals.

Bypass filters in Power BI with calculate and all to compute min date across data and max date across data for full data analysis.

Explore time intelligence in Power BI with DAX by calculating running totals, year-to-date, quarter-to-date, and rolling 12-month values, then convert to averages and growth.

Learn to create a total sales year-to-date measure in Power BI with DAX YTD, remove quarter breakdown, and visualize month and year totals across yearly data.

Build QTD and MTD measures using DAX, connect to a dates table, and visualize quarterly and monthly total sales movement in this Power BI masterclass.

Learn to build a total to date measure in Power BI by using calculate with dates between, min date across data, max date across data, and the all function.

Compute a three-month rolling sum to smooth seasonal sales fluctuations, using dates in period and dynamic end dates, then convert to a monthly average for comparability.

Learn to build a three month rolling sum in Power BI with DAX, excluding initial days using an if statement and date logic. Include seven day rolling and daily averages.

Build a seven day rolling sum and its average in Power BI by creating total sales seven day rolling and average measures with dates in period and max date.

Master the previous period value in Power BI with advanced DAX, building a dynamic measure using date add to shift dates and display prior month, quarter, or day values.

Learn to create a dynamic previous period in Power BI by using distinct count of month names from the calendar table to adapt to year, quarter, and month levels.

Compute period-on-period growth in Power BI by subtracting prior period sales from current, presenting results as a whole number and as a percentage, while handling blanks.

Learn to implement previous corresponding period analysis in Power BI using DAX, comparing the same period last year across month, quarter, and day, with a PCP measure.

Calculate growth by subtracting total sales PCP from total sales to create the growth measure, then compute growth percentage by dividing by the prior value and format to two decimals.

Visualize period growth with a line and clustered column chart in Power BI, using PCP values, growth markers, and 0% line filters to highlight trends in total sales.

Apply dax switch as an alternative to if and build a calendar table in power bi. Hard code start and end dates, and extract day, month, year, and weekday name.

Learn how to use the DAX SWITCH to classify day names into weekend or weekday, compare methods using column references versus true expressions, and observe sequential evaluation effects.

Create a day type column with switch for Monday through Friday to label weekdays and weekends, using or to simplify checks and save time with copy-paste.

Discover how to use DAX variables to simplify complex formulas by defining a var and return a calculation, using switch to map day names to weekdays or weekends.

Define a dynamic holiday column in Power BI using DAX variables for New Year, Independence Day, Veterans Day, and Christmas; apply switch true with prioritized conditions to return holiday names.

Learn to implement dynamic holidays in Power BI with advanced DAX, handling dates like the third Monday in January, and import holiday data from Excel or Google Sheets.

Use the switch function to create a day type column that returns holidays when present and day type when blank, including not blank and is blank handling.

Learn to handle holidays with non-fixed dates in Power BI by building a dynamic calendar table and using DAX with variables to count nth weekdays, such as Thanksgiving.

Learn to compute Memorial Day, the last Monday of May, in Power BI using a dynamic DAX measure that counts Mondays with filter and CALCULATE over tbl calendar.

Create a dynamic 2021 sales forecast in Power BI by using a 2020 sales measure, a case-type slicer (best, base, worst), and a selected value driven forecast measure.