Power BI for Professionals: Master Data Storytelling

Set up base Power BI dashboard in week one, sketch visuals, and build four KPIs: quantity sold, net revenue, cost of goods sold, and profit, with a profit margin view.

Explore project files and tasks in Power BI, review icons, data tables, and a blank pbix to build a step-by-step business performance report using past data and a 55% target.

Learn to distinguish fact (transactional) and dimensional (lookup) tables, identify duplicates and keys, and connect them to break down sales by region in Power BI.

Import data from Excel workbooks and SQL sources, then transform and clean with Power Query. Rename as dimension tables, ensure quality, remove nulls, set date types before loading.

Learn to load and clean a transaction fact table in Power BI, handle nulls, replace values, verify data types, and build data model relationships for analysis.

Create KPI cards for quantity, net revenue, cost of goods sold, and profit with targets and year-over-year changes; configure a switchable chart with a slicer and gauge for profit margin.

Create a calendar date table from scratch, store measures in a DAX house, and tie it to transactional data using min and max date and mean date controls.

Create and customize a calendar table in Power BI by adding month, month number, weekday, week number, and quarter columns; format dates, sort by month, and define weekday versus weekend.

Create a calendar table in Power BI using the weekday and week number logic to classify weekdays and weekends, and establish one-to-many relationships in the data model.

Explore how to compute total net revenue in Power BI using sumx and the related function to join product and transactional tables, applying discounts and filtering for completed transactions.

Master calculating total revenue and total net revenue in power bi with dax, using sumx, related price, quantity, discount, and a completed transaction filter.

Learn how to apply dynamic number formatting in Power BI by formatting the selected measure with threshold logic, converting numbers into thousands, millions, and beyond.

Master dynamic number formatting in Power BI by building a measure named format number code that formats large numbers with underscores, e notation, and M, B, T suffixes.

Build your first KPI in Power BI by organizing measures into folders, creating net revenue and total revenue cards, and calculating target, variance, and year-over-year change.

Build a target variance and target percentage measure in Power BI to compute the net revenue KPI using DAX, formatting, and up or down arrows for clear storytelling.

Learn to build a year-over-year net revenue KPI in Power BI by comparing last year revenue with the selected year, computing the percentage, and applying conditional formatting and slicers.

Apply conditional formatting to KPI measures in Power BI, including total net revenue, targets, and growth metrics, using DAX rules and dynamic color formatting.

Create a measure for year over year percent, apply conditional formatting rules to color-code increases in green and decreases in red, and add up/down arrows to visualize KPIs.

Configure a quantity KPI in Power BI by setting total quantity, creating a previous-month target with date add, and building variance and percentage measures to tell the data story.

Learn to create quantity KPI measures in Power BI, reuse revenue measures, format year-over-year percentages, and rename and organize measures for target variance analysis.

Master quantity KPI conditional formatting in Power BI by building measures, setting color rules for quantity and target, and visualizing variance and percent trends for storytelling.

Learn to compute cost of goods sold and total profit in Power BI by filtering to completed transactions, using the calculate function to change context, and deriving net revenue.

Set up a profit margin gauge chart using a divide function, targeting 0.55, and apply conditional formatting to display green above target and red below.

Create a dynamic measure to compare profit margin target with achieved percentage, showing whether the target is exceeded or below and formatting the result in Power BI reports.

Build a switchable chart in Power BI that switches between month, quarter, year, and week views and between quantity, revenue, cost of goods sold, and profit.

Learn to build dynamic chart titles in Power BI with DAX, using selected value and switch measures to display quantity, cost of goods sold, revenue, or profit.

Identify and fix custom number formatting errors in Power BI by applying dynamic formatting, currency or none formats, and correcting data labels for revenue, profit, and quantity.

Define a consistent color palette from a logo or color tools, then mix blue, white, gray, and purple for reports and dashboards using Adobe Color.

create a PowerPoint background by capturing screenshots, pasting them into slides, and refining with shape merge options and color settings.

Create a reusable PowerPoint background by customizing colors, adding rounded button shapes, and aligning grouped KPI cards through duplication, then export as PNG for Power BI.

Clean and format a Power BI dashboard by removing backgrounds and borders, centering visuals, and updating title to total cost of goods sold. Harmonize colors and call-out values for consistency.

Format a Power BI dashboard to sharpen data storytelling: remove extra decimals, set target profit and cost of goods sold to zero, apply dollar formatting with comma, size 16.

Master dashboard formatting by applying color changes, gradients, and a switchable measure for dynamic coloring in Power BI. Turn off the legend and adjust week-number sorting for consistent data storytelling.

Master dashboard formatting in Power BI by styling slicers, hover effects, and color schemes, enforcing single selection, and aligning selected and unselected states for clear data storytelling.

Update chart titles in Power BI by making them dynamic, reflecting the selected measure from the slicer (quantity, revenue, profit) and formatting with or without a dollar sign.

Learn to create and hide and show slicers in Power BI, configure year, month, continent, and product as dropdowns, and group items to toggle detail filters on a dashboard.

Learn to create hide and show slicers in Power BI with bookmarks and actions, group elements, edit interactions, and build an e-commerce dashboard with a plan for a custom tooltip.

Create tooltips in Power BI that adapt titles and metrics to hovered charts. Show a card with target, variance, and percentage, plus top and bottom items by measure.

Learn to create a custom tooltip in Power BI, extending the default tooltip with measures, dynamic titles, and icons to reveal top insights on hover.

Learn to build a custom tooltip in Power BI by creating reusable measures for variance, target, and percent variance, and apply conditional formatting to visualize target vs actual values.

Create dynamic tooltips in power bi by building a measure that formats the title with the selected month, quarter, year, and week name, updating based on user selections.

Create a dynamic custom tooltip in Power BI by adding charts, showing top five products with a switchable measure, and highlighting bottom five underperforming products and top five categories.

Learn how to create a custom tooltip in Power BI by adding charts, using top and bottom five by country and product, and applying conditional formatting for clearer insights.

Create a customer analysis dashboard in Power BI, tracking registered customers, purchase history, and a dynamic top-n view, with age groups calculated by age at purchase and a hidden slicer.

Build a simple, navigable Power BI dashboard analyzing customer performance with a switchable measure (profit, quantity, net revenue), dynamic top-N customers for current and previous year, and age-group profit contributions.

Learn to calculate the total customers with purchase history in Power BI by using a distinct count on the transaction table, ensuring registered non-purchasers aren't counted.

Learn to build dynamic top customers in Power BI by creating switchable measures, rankx with all, and a field parameter to control top n, improving insight.

Master dynamic top customers with switchable measures by configuring a top selector (start, end, increment), and presenting a clustered bar chart with data labels, sorted by top customers.

Explore building dynamic titles and subtitles in power bi using a measure and selected value to reflect the top customers by quantity, revenue, or profit.

Learn to build dynamic top customers visuals in Power BI by using switchable measures and last year calculations to tell a concise data story.

Calculate customer age at the transaction day in Power BI for data storytelling, using date of birth and last transaction date, and compute year difference.

Define an age bucket with DAX using a switch true and a variable to classify customer age into age group values, then visualize in a chart and tidy the dashboard.

Learn dashboard formatting in Power BI by cleaning up cards, renaming labels, adjusting colors and icons, adding images and titles, and configuring conditional formatting with slicers.

Master dashboard formatting for data storytelling by learning to align, duplicate, and color shapes, build clean backgrounds, and export polished PNGs for Power BI visuals.

Refine Power BI dashboards by aligning titles, dividers, colors, and spacing; duplicate and adjust elements, export updated visuals to PNG, and prepare slicers for interactive storytelling.

Polish your Power BI dashboard and report visuals by ensuring consistent font sizes (16 for titles, subtitles, labels) and aligned across visuals, to enhance professional data storytelling.

Add slicers for month, year, and brand to filter the Power BI report. Format, align, group visuals, and use bookmarks to open and close the slicer panels.

Explore locational analysis in week 03 of the dashboard course, using maps and tables to show customers, countries, and revenue by continent, age, and gender with tooltips and top-country contributions.

Create a demographic insights report from the prior data set focusing on customer demographics, sales by continent, and age-group insights, with a clear, easy-to-navigate dashboard.

Create Power BI dashboards showing total customers, countries, and average revenue per customer, plus revenue by gender, with a map switchable to a table and continent slicers for top markets.

Master creating a custom map in Power BI by using a shape map, importing a JSON map, and configuring projection and zoom on selection for country net revenue.

Learn to add a continent slicer and create dax measures for top location revenue and top country percentage contributions to provide context for maps and tables in Power BI dashboards.

Create DAX measures in Power BI to display top location revenue and top country revenue with a continent slicer, formatting as currency and percentage, and plan for multi-select handling.

Master a dynamic multi-select continent filter in Power BI by using distinct and concatenate with a comma delimiter, enabling all-selected handling and no-selection messages for your dashboard.

Create and use DAX measures to count distinct countries with purchases, filter by customer history, and compute average revenue per customer, then visualize net revenue by gender in Power BI.

Build a matrix table in Power BI with continents and age groups. Add measures for customers, transactions, net revenue, profit, and profit margin, then apply formatting and conditional styles.

Implement Power BI report background and formatting: capture screenshots, insert shapes, align visuals, adjust colors, add icons, and create custom data labels with text boxes.

learn how to combine a table and a map in Power BI using bookmarks, group them, and toggle visibility with a bookmark navigator, while styling text and adding slicers.

Master bookmark-based slicer control and page navigation in Power BI by creating show/hide slicers, grouping them, and wiring actions to navigate between customer and location views.

Add a dynamic tooltip to the chart. Reveal hover details and display in the sidebar totals for customers, transactions, revenue, profit, margin, plus top product and category, revenue trend.

Construct a Power BI tooltip page for customer locations, adding a card and a clustered bar chart, with net revenue, profit, top products, and a gender donut chart using DAX.

Master Power BI for professionals by learning to design and fine-tune tooltips for customer location visuals, format charts, harmonize colors, axes, and data labels for clear data storytelling.

Create dynamic tooltip titles in Power BI by building an active dimension measure that uses selected values for age group, country, and continent to display contextual performance metrics.

Build a Power BI dashboard. Track total revenue, net revenue after discounts, discount percentage, and status-based revenue (completed, pending, canceled) with a running total for previous and current year KPI.

Create an insightful revenue dashboard that highlights total revenue, total net revenue, discounts, and completed, pending, and canceled revenue, using DAX to compare cumulative revenue to last year.

Identify and display key revenue kpis on the dashboard, including net revenue, discount amount, discount percentage, and total revenue, plus monthly cumulative revenue with year-over-year comparison and variance.

Learn to compute total revenue and net revenue, isolate the discount with DAX, and create a discount percentage using calculate, related, and filter context for completed transactions.

Create dynamic progress bars in Power BI by building measures for completed, pending, and cancelled revenue, and visualize percentage progress with clear status breakdowns.

Create a 100% stacked bar chart in Power BI to visualize revenue by status—completed, pending, and canceled—tuning colors, axis, and legend for clear data storytelling.

Learn to calculate cumulative revenue in Power BI using running totals and DAX, compare with last year, and visualize with an area chart to reveal revenue variance.

Master formatting a cumulative dashboard in Power BI by shaping a clean background, aligning cards, applying consistent fonts, colors, decimals, and icons to clearly convey the story.

Learn to build a cumulative analysis dashboard in Power BI by linking detail pages, setting actions and filters, and handling missing values with zero using DAX.

Create KPI cards showing the top product, category, and brand in Power BI. Use bookmarks and tooltips to reveal top five and underperforming items, aligning with the PDF and DAX.

Analyze product performance and profitability across categories and brands to identify the most profitable category and brand, with metrics like average sales per product and total net revenue.

Explore profitability dashboards in Power BI by category, brand, and overall profit, featuring KPI cards for net revenue, total quantity sold, average price, and top products, categories, and brands.

Master profitability analysis in Power BI by filtering visuals at visual, page, and all pages levels to reveal products, build measures for total profit, average sales per product, and price.

Format a Power BI dashboard by selecting visuals, adjusting sizes and fonts, applying consistent colors and backgrounds, configuring headers, data labels, and legends, and fine-tuning layout for clear data storytelling.

Learn to craft a custom PowerPoint background by creating and aligning multiple shapes, applying gradients and colors, and exporting the design as a PNG for use in presentations.

Explore building and labeling top and underperforming charts in Power BI, using bookmarks to switch between top and bottom views, color-coding by net profit, and grouping visuals for clean storytelling.

Improve data storytelling by styling selections with matching colors and fonts, organizing groups, and implementing a product slicer with bookmarklet actions and tooltips to drive interactive filtering.

Use a power bi tooltip to display KPIs: quantity sold, cost of goods sold, revenue, and profit. Explore net revenue line chart monthly by category and brand, plus age groups.

Create a dynamic Power BI tooltip by designing a tooltip page, formatting visuals for net revenue and cost of goods sold, and displaying selected product, category, or brand details.

Create a dax reporting date measure using the calendar date table, format the start and end dates, and apply it across the report to show ranges from 2022 to 2024.

Master linking and syncing Power BI report pages, configuring navigation between detail and customer detail pages, with active page highlighting via color and underline. Save frequently to protect your work.

Build a dashboard home page with navigation buttons, icons, and hover effects in Power BI, linking to details and customers pages for seamless data storytelling.

Learn in week six how to scrape data from a YouTube channel, clean and transform it in Power Query, and build a Power BI dashboard powered by my channel data.

Learn to extract YouTube channel data using analytics in advanced mode, choose metrics like views, watch time, subscribers, revenue, and download as CSV or Google Sheet for Power BI analysis.

Set up a Power BI dashboard with key performance indicators for videos posted, impressions, views, subscribers, and weekly/monthly trends, using tooltips, slicers, and page navigation to explore video statistics.

Customize a date table in Power BI with calendar auto, add year, month, week, and weekday columns, clean invalid dates, and establish a many-to-one relationship for DAX dashboards.

Continue building on week six by using the YouTube data you've downloaded and transformed, leveraging the custom calendar table to analyze your data.

Create a new Power BI table and write basic DAX measures for total views, impressions, and subscribers, then compute a click-through rate KPI from video posted data with proper formatting.

Learn to turn viewer metrics into insight by building dynamic KPI cards with CTR and impressions, using a year slicer to compare 2022 to 2021 in DAX.

Learn to add insights to numbers in Power BI by organizing measures into folders, creating previous year totals with date add, and building dynamic KPI titles for data storytelling.

Learn to turn numbers into insights in Power BI by creating year-over-year change measures, formatting percentages with positive and negative indicators, and applying conditional color cues for clear data storytelling.

Create a polished PowerPoint background for data storytelling slides by shaping a card, applying a hex color, adding shadow, aligning duplicates, inserting a logo, and exporting as PNG.

Learn to build dynamic Power BI visuals using a variable and an if function to switch between all videos posted and selected metrics, then align and group KPI cards.

Learn how to replicate previous measures in Power BI by copying a previous year measure, creating new measures for impressions, renaming, and applying conditional formatting while organizing in folders.

Explore how percentage change in impressions indicates growth, with 2021 reporting about 25 million impressions and formatting numbers with comma separators to read the kpi accurately.

Explore creating views and subscribers KPIs using an animated icon in Power BI, customizing titles, adding icons, and arranging cards to show year-over-year changes.

Calculate and visualize click-through rate in Power BI using a gauge chart with conditional formatting to compare actual CTR against a 10% target, applying red-to-yellow-to-green color rules.

Master weekly performance in Power BI by building a table and chart driven by week names, using a dynamic measure and conditional formatting to highlight weekends.

Understand how start of month is calculated in Power BI and how it differs from month visuals, including year slicers and focus mode effects.

Master visual calculations to generate running totals and cumulative views for month-over-month insights in Power BI, and compare with DAX measures using calculate and max date.

Format a Power BI dashboard background by resizing visuals, creating a title and legend, color-coding weekend versus weekday views, and exporting a PNG with video-type cards powered by Power Query.

Create a DAX measure using calculate to compute the percentage of total views by video type (excel post, power BI post, others) and visualize with slicers.

Develop robust DAX by using measures in the date table to classify weekdays and weekends with switch and if, and implement error handling returning zero on blanks.

Verify measures for previous year subscribers, then build date and video type slicers in Power BI using bookmarks, with a single-column dropdown and hover styling, plus PowerPoint export.

Create a Power BI slicer by importing a PowerPoint-crafted graphic, styling colors and borders, and using a bookmark to toggle open and close filter states.

This lesson teaches configuring a slicer with bookmark-driven open/close actions, editing interactions, unfiltering, and managing bookmark groups to control dashboard filters.

Correct conditional formatting in a Power BI chart by fixing the threshold rules: red for below 5%, orange for below 10%, and green for above 10%, with proper number formatting.

Add slicers, create country-wise visuals, and implement page navigation to build a navigable Power BI dashboard.

Explore building a Power BI dashboard sketch that tracks monthly views, detailed video posts, key metrics (views, subscribers, likes, shares, comments, revenue), and geo and traffic sources from YouTube.

Create a video post analytics dashboard in Power BI, including a monthly clustered bar chart, measures for views, revenue, subscribers, and a detailed video table with publish dates and metrics.

Learn to add and configure slicers in Power BI, including selecting, opening, and closing slicers, and linking them to filters for dynamic data storytelling.

Explore Power BI to map viewer countries and traffic sources, building a shape map, a top ten country table, and key sources like YouTube search, browse features, and playlists.

Add page navigation in Power BI by inserting a page navigator, bookmarks, and consistent colors to create easy, interactive navigation across three pages for data storytelling.

Build a dynamic Power BI revenue dashboard with month and year slicers, KPI views, and view switches (quarter, season, week type, monthly trend), plus drill-through to product details.

Identify and clarify dashboard requirements by reviewing client messages and PDFs, then coordinate a meeting with the data owner to discuss how to achieve the dashboard in Power BI.

Sketch and prototype a Power BI dashboard, detailing a logo, title, reporting date, revenue KPI with last year and last month changes, and navigable charts with a month slicer.

Load data from Excel and Access into Power BI, transform and trim columns, rename to dim_categories and fact cells, and assess column quality to count rows.

Clean and prep data in Power BI by removing unused keys, renaming date key to date, setting the date data type, and selecting essential columns for relationships.

Create and fix Power BI relationships using Power Query, build a date table, and map the correct keys to establish one-to-many and many-to-one relationships for accurate data storytelling.

Create a total revenue measure using sumx and related to join transaction and product data, then build a kpi card showing last month and last year revenue.

Learn to build a dynamic KPI card title in Power BI with DAX, using variables and selected value to show month and year for total revenue, and manage dash visibility.

Create KPI cards in Power BI using DAX for year-over-year and month-over-month change, compute percentages from revenue, and display up or down arrows.

Create a custom Power BI background in PowerPoint by shaping a rounded rectangle with a blue gray gradient, centering it, and inserting the logo to finalize the KPI slide.

Create and customize a Power BI background by resizing, coloring, and aligning elements, then duplicate, group, and fine-tune layout before saving as an editor template and exporting as png.

Learn to format a dynamic KPI card in Power BI, adjusting canvas background, size, and borders. Align colors for the title, values, and icon to support clear data storytelling.

Create dynamic KPI cards in Power BI by producing measures for month-over-month and year-over-year changes. Apply conditional formatting with color-coded arrows and background colors to convey performance clearly.

Learn to create and format revenue charts in Power BI using bookmarking, a total revenue card, and a line chart with month and week granularity.

Create and customize charts for a KPI card in Power BI, including season axis, week types, and quarter views, with color tweaks and data labels to tell the story.

Learn how to apply dynamic number formatting in Power BI to display actual values on charts by creating a new measure and adjusting data labels and formatting across revenue visuals.

Master bookmarking KPI charts and button formatting in Power BI to toggle quarter, week, and month views by grouping visuals.

Visualize top five and underperforming brands by revenue with drill-down to product-level details, tracking transaction revenue, profit, profit margin, and return rate using interactive bookmarks and charts.

Reuse or create a chart to visualize revenue by category with consistent formatting, then set up a drill-through page to analyze Contoso product revenue and quantity.

Learn to build a detailed product analysis table in Power BI by creating and organizing measures for revenue, transactions, refunds, and profitability using dax, formatting, and folders.

Learn to create and configure sorting buttons for table data using bookmarks, sorting by transaction, quantity, revenue, and other metrics, with styling, hover effects, and layout adjustments.

Learn to create a sorting button for a table by inserting and styling a blank button, and use bookmarks to toggle open and close states on a dashboard.

Learn to configure drillthrough in Power BI, pass brand and category filters (for Contoso) to a product detail page, and navigate from dashboard to report pages with styled buttons.

Build a dynamic DAX measure, active drill-through, to capture the selected brand or category during drill-through and display it in a text box as product brand or product category.

Format slicers in Power BI by adding, arranging, and styling to show 12-month columns, customize background, borders, hover and selected colors, and adjust font size and layout for a dashboard.