Power BI - Business Intelligence for Beginners to Advance

Power BI enables organizations to collect and organize data from applications, IoT devices, and transactions to deliver relevant, reliable information for faster, more informed decisions.

Power BI enables accelerated decision making by consolidating data across the company into real-time dashboards and self-service access to real-time analytics information, delivering automated reports for faster, data-driven actions.

Explore how business intelligence delivers customer insights, pricing optimization, inventory and supply chain efficiency, sales and marketing analysis, and HR dashboards, with hands-on Power BI project examples.

Power BI embodies modern BI with cloud and on-prem deployment, seamless data connectivity and ETL, scalable analytics, machine learning insights, interactive visualizations, augmented information discovery, and easy collaboration and embedding.

Explore how companies use business intelligence for sales planning, customer behavior, and unified views, and weigh buying factors like functionality, price performance, ease of use, fast queries, and data connectivity.

Explore descriptive, predictive, and prescriptive analytics in Power BI, using visualizations and reports to reveal past trends, predict the future, and prescribe actions.

Explore how Power BI delivers self-service business intelligence in a cloud-hosted platform by visualizing and analyzing data, building interactive reports and dashboards, and publishing insights across web and mobile.

Power BI connects to on premise and cloud data sources, and lets you transform, clean, and shape data to create dashboards with natural language queries and a question-and-answer feature.

Explore how to build streaming dashboards in Power BI from scratch, leverage out-of-the-box content packs like Salesforce and MailChimp, integrate Cortana for interactive reports, and share dashboards with colleagues.

Discover why Power BI is a Gartner leader, delivering augmented analytics, natural language query, and data discovery, while connecting to hundreds of data sources for citizen data scientists.

Discover the Power BI family, from service to desktop, premium, mobile, embedded, and report server, to build data models, dashboards, and reports across cloud and on premise.

Explore Power BI Desktop, a Windows app for building data models and beautiful reports, publishing them to powerbi.com to share with colleagues, with guided setup and UI overview.

Explore the Power BI service overview, including workspaces, dashboards, reports, datasets, and app workspaces, and learn how to share and manage content across your organization.

Learn how to use Power BI service to access prebuilt content packs, apps, and dashboards, and to create your own content from files and databases using connectors.

Navigate day-to-day IT challenges in deploying BI solutions. See how Power BI SaaS frees you from on-prem hardware, reduces costs, and provides built-in connectors and content packs.

Power BI enables seamless Azure and on-premise data connections, live streaming, and integration of diverse sources with row level security and easy, customizable dashboards.

Learn to import csv files in Power BI, adjust delimiters, preview data, and load or edit the query in Power Query for clean data.

Import data from Excel files into Power BI by connecting to the finance sample, loading the sheet as a table, and cleaning data in the query editor.

Import data from the web into Power BI, clean and transform with the query editor, rename tables, remove columns and rows, and relate state names to abbreviations for visuals.

Build interactive Power BI visuals by ranking states, showing top five and worst five, and using tooltips to reveal weather, well-being, health care, and cost of living across visuals.

Create real-time streaming datasets in Power BI using Pubnub, then build dashboards with line charts and gauges to visualize live sensor data such as temperature and humidity.

Download and install the free SQL Server Express edition, review edition comparisons, verify hardware requirements, install SQL Server Management Studio, and reboot to connect in the next lecture.

Connect to SQL Server, download and install Microsoft sample databases such as Adventureworks and WideWorldImporters, then restore them with SQL Server Management Studio using Windows authentication.

learn how to import data from sql server in power bi, using sql server express and adventure works database, and compare import versus direct query.

Explore how an Odata feed, a rest-based protocol built on https, xml, and json, uniformly describes data and models and enables reading into Power BI.

Import data from a folder in Power BI, combine Excel files from Regions, clean by removing duplicates and a column, set the first row as header, and enable automatic refresh.

Explore how dataflows and the common data model connect Power BI to Azure Data Lake Storage generation two, creating entities for datasets used in reports, dashboards, and cross-application reuse.

Set up an on-premise data gateway from scratch to enable data flows from on-site data to Power BI, supporting data refresh and integration with Power Apps and flows.

Create a dataflow in Power BI to build an entity from a CSV file, configure gateway and headers, and connect to Power BI desktop to publish visuals.

Learn to remove unnecessary columns in Power BI desktop by selecting and removing columns via the query editor, keeping only the column name and abbreviation.

Learn to import data from the web into Power BI and prepare tables by selecting the correct table from a Wikipedia page, then use the first row as headers.

Learn to create calculated and custom columns in Power BI using data from Arizona sales, computing sales price per unit, and applying column transformations without altering source files.

learn how to remove duplicates in Power BI by importing a folder of Excel files, combining the data, and using reduce rows to remove duplicates.

Unpivot columns and split columns in Power BI to tidy data, rename to country name, year, month, and amount, and use a delimited split for year and month.

This video teaches how to change data types, replace values, and rearrange columns in Power BI, including unpivoting data, handling date formats, and ensuring correct date recognition.

append multiple csv files in power bi by adding a state name column to each file, then append queries to form all states data, loading only the merged query.

Learn to merge queries in Power BI by matching rows with a left outer join, enriching state sales data with zip codes to include store manager names.

Explore visuals in Power BI, learn about charts and importing visuals from the marketplace, and configure properties, data labels, and responsive settings to tell your data story.

Explore how to create and format bar charts in Power BI, using categories like country and date to compare sales and cost of goods sold, with drill-down hierarchies and tooltips.

Plot monthly sales trends with line charts in Power BI, filter by 2014, drill down to months, and customize axes, titles, and data colors.

Learn to create a Power BI pie chart of sales by country in 2014, with legend, data labels showing percent of total, switch to bar charts when categories exceed six.

Explore how to create and analyze stacked bar charts in Power BI, combining country and discount band to reveal multidimensional insights with tooltips, legends, and formatting options.

Learn how clustered column charts compare multiple data series in vertical bars, grouped by category, and optimize for limited categories with drilldowns and tooltips.

Explore area charts in Power BI to visualize time series data, comparing sales and cost of goods sold, using the analytics tab to add constant, minimum, maximum, and average lines.

Explore building an area chart in Power BI using a web-sourced population table, cleaning data by removing the first row, unpivot year columns, and visualizing top countries by 2020 population.

Create a Power BI combo chart that combines sales and cost of goods sold on different scales, showing months for 2013–2014 and correlating measures against a target.

Create Power BI scatter charts plotting sales on the x axis and units sold on the y axis, using countries, products, and segments for differentiation, with bubble size and animation.

Use treemap charts in Power BI to visualize hierarchical data as a part of the whole, using country groups and measures like units sold or profit, with formatting controls.

Explore how funnel charts visualize sequential stages and bottlenecks in business processes, drill down by country or segment, and reveal revenue potential and campaign progress.

Explore creating single and multi-row card visuals in Power BI to display key metrics like sales, units, and profit, using the report editor or QA preview features.

Explore the gauge chart in Power BI to track a single metric toward a goal, set min and max values, and compare to cost of goods sold.

Explore KPI visuals that compare actuals to a defined goal using base and target measures. See how sales and units sold track toward thresholds with indicators and DAX targets.

Explore the matrix visual in Power BI, a grid that organizes data by rows and columns, enables drill down through hierarchies, shows subtotals and totals, and offers extensive formatting options.

Learn how to create a Power BI table to display related data in a grid, with sales, cost of goods sold, and profit, including color scales and data bars.

Use text boxes, shapes, and images in Power BI to group visuals and tell a clearer data story through customized formatting and number cards.

Explore how to add slicers in Power BI to display filters on the report canvas. Use single or multi select, dropdowns, search, reset, and date range features to tailor visuals.

Visualize data on maps in Power BI, showing states and countries with bubbles for customers and balances, with tooltips; explore field map, shape map, and latitude and longitude maps.

Explore custom visuals in Power BI by building a word cloud: install from website or marketplace, import the visual, map data fields, adjust stop words, fonts, colors, and rotations.

Master Power BI visualization interactions by learning the difference between highlighting and filtering, using slicers, and using edit interaction to control how visuals respond.

Explore Power BI AI visuals such as decomposition tree, smart narrative, and key influencer; master quick measures, field parameters, and dynamic axes, with ChatGPT and Copilot support.

Explore the decomposition tree visual in Power BI to analyze balances across multiple dimensions, using drill down, explain by, and drill-through pages with filters.

Learn to use the key influencer visual in Power BI to analyze gender, state, age, and job classification with slicers, top segments, and interpretable influence.

Power BI's smart narrative automatically generates text summaries from visuals, lets you customize language, add dynamic values and measures, and publish live reports to PowerPoint that refresh with data.

Learn to use the Q&A visual in Power BI to answer natural language questions with visuals, and add synonyms to improve results.

Explore quick measures with Copilot in Power BI to auto-generate DAX behind the scenes, build filters and visuals from Microsoft sample data.

Learn to create new columns in Power Query using column from examples, combining country and product to derive age from dates, using from all columns and from selection.

Learn to use new calculation and the modeling tab in Power BI with visual calculations, templates, DAX measures, and Copilot, and build a date table while enabling preview features.

Learn to build dynamic x and y axes in Power BI using field parameters, enabling users to switch measures and dimensions with slicers.

Explore Bravo, a Power BI buddy, to install the tool, analyze models, format Dax, manage date tables, and auto generate time intelligence measures for efficient reporting.

Explore using ChatGPT and Copilot with Power BI Desktop to generate DAX and M code, build the data model, and create dashboards from sample data.

Discover how to use ChatGPT and Copilot to generate M code for a Power BI date table. Learn to document the code with comments and compare ChatGPT and Copilot outputs.

Build your first demographic report in Power BI desktop by loading a CSV, cleaning data in the query editor, and designing a dashboard with slicers, cards, and charts.

Create a live Power BI report with map and charts, employing color themes, titles, and legends to reveal customer insights by state, job classification, gender, and marital status.

Forge your first Power BI report by building interactive cards, toggling titles and labels, applying yes/no filters for house owners and renters, and adding quarterly and monthly slicers.

Create and configure slicers for quarter, education, and contact in Power BI to build an interactive first report with dynamic filters and demographic insights.

Publish your first Power BI report to the web, share it via a private workspace and app, and land users on a dashboard with interactive visuals.

Explore data modeling basics in Power BI by transforming a single-table model into a multi-table snowflake schema, using relationships, primary and foreign keys, and slicers to analyze facts across dimensions.

Explore Power BI modeling basics by building a category, subcategory, and product hierarchy linked to a sales amount fact table, and learn how one-to-many relationships enable filtering.

Power BI modeling builds a data model from calculations, formatting rules, and related tables with columns, data types, and relationships to explore, query, and analyze data from multiple sources.

Explore modeling and relationships in Power BI by integrating branch data, daily targets, and pizza sales data, then create a calculated sales column and set data types.

Learn to model data in Power BI by creating relationships, one-to-many and cross filtering, using primary and foreign keys, and understanding dimension and lookup tables for accurate reports.

Learn to create and manage relationships in Power BI, using auto detect or manual setup to link fields across tables, and understand how one-to-many and many-to-one cardinality keeps visuals consistent.

Learn normalization to minimize redundancy by structuring data into dim and fact tables, and denormalization to speed reads by consolidating into a single table in Power BI.

Create a product hierarchy in Power BI to denormalize category, subcategory, and product data, and learn when to avoid denormalizing the fact table to balance performance and memory usage.

Compare online transaction processing and online analytical processing, and explain how data warehouses support reporting with star and snowflake schemas, operational systems, and data marts.

Explore star schema and snowflake schema for data warehouses, and differentiate dimension tables from fact tables to enable slicing and dicing of sales measures.

Power BI users explore star vs snowflake schemas, demonstrating how denormalized star schemas deliver fast performance with fewer joins on fact tables, while snowflake schemas normalize dimensions to save storage.

Import data from SQL Server, load dim date, dim product, dim sales territory, and the fact Internet sales, and establish one-to-many relationships for DAX learning.

Explore DAX learning resources, including function references, syntax guides, and practical examples; discover free training, books, and expert insights from Marco Russo, Alberto Ferrari, Sam McKee, and others.

Master DAX, the data analysis expressions language for Power BI, and learn to write measures and calculated columns using table-based, tabular models, with familiar Excel-like syntax and type rules.

Explore DAX data types, including whole numbers (64-bit), decimals, currency with four-decimal precision, date and time, boolean, text, and blob, and learn how storage and precision affect calculations.

Learn DAX operators and syntax by building a total sales measure with sum, using parentheses, arithmetic, comparison, concatenation, and logical operators for cards, dashboards, and reports.

Learn how M (Power Query) transforms data and prepares it before analysis, and how DAX builds columns and measures in the Power BI model for reports and visuals.

Create a full name column in Power BI by combining first and last names in Dim Customer using M language in the query editor, then use DAX in the model.

Learn practical DAX rules for creating measures in Power BI, including organizing measures in a single table, using descriptive names, leveraging IntelliSense, testing in a matrix, and applying currency formatting.

Compare calculated columns and calculated measures in Power BI, explain when to avoid columns, and cover memory impact, evaluation timing, and practical best practices using DAX and M examples.

Dax101 explains calculated columns vs measures in Power BI, showing measures compress better, enable on-the-fly calculations, and guide to prefer measures over columns for aggregation.

Explore the sum function in Power BI, applying the initial filter to aggregate a single column. Create measures like total cost and total quantity, and understand its row context limitation.

Learn to use the average, min, and max functions in DAX to compute average sales price, minimum sale price, and maximum sales, formatted as US dollars for per-product analysis.

Explore how the DAX SUMX function iterates over each row to aggregate expressions in Power BI, comparing it with SUM, and building measures like total sales and total freight.

Use the DAX divide function to compute margin, tax, and markup percentages. It handles division by zero with an optional alternate result and uses numerator and denominator in measures.

Explore how DAX count and countrows tally rows and values, counting numbers, dates, and strings while skipping blanks, with examples for total customers and products.

Explore how the Dax calculate function changes the filter context and applies a new filter to compute measures like total sales, including same period last year and mountain bikes.

Learn to use calculate to create distinct counts of customers by gender, marital status, and education, using the dim customer table, and visualize metrics with stacked charts.

Explore how the DAX filter function returns a subset table and, with calculate, applies filter and row context to count customers and analyze purchases above thresholds like 50k and 8k.

Learn how the all function returns all rows or values and clears filters for calculations. The lecture also introduces time intelligence.

Create a date table in Power BI with M language in the advanced editor, from 2010-01-01 to 2014-12-14, including week numbers and a weekend versus weekday flag for time intelligence.

Explore Power BI time intelligence in DAX, create and use a date table, and build calendars with calendar auto to enable year-to-date and previous year analyses.

Create a lean date table with DAX calendar, deriving start and end dates from order dates, and add year and quarter columns for time intelligence.

Master the DAX time intelligence function same period last year to compare total sales using a date table, calculate with the correct filter, and maintain proper relationships for year-over-year insights.

Learn to compute year-to-date sales in Power BI using total ytd with a date table, compare to last year, and visualize running totals with charts.

Display the last refresh date in Power BI by creating a blank query, using an advanced editor, and a date measure shown as a card in the report corner.

Master time intelligence with DAX101 by creating measures for previous month and previous year, and comparing total sales across dates using the date column.

Master the dateadd function to shift dates forward or backward by days, months, quarters, or years in Power BI, enabling last-year and other time-based analyses with dynamic measures.

Explore quick measures in Power BI with DAX to compute total sales, average, and gross margin using filters and time intelligence.

Practice hands-on, real-world Power BI projects by following step-by-step labs that cover both the latest Power BI Desktop features and older versions to build professional, interactive reports.

Create a Power BI template that saves time with predesigned layouts, visuals, and data models, plus built-in calculations, date tables, and last refresh date.

Learn how a date table enables time intelligence in Power BI by linking to the fact table and enabling year, month, day, quarter, and fiscal year slicers.

This lecture guides you to build a Power BI pizza sales report from blank to final, showing sales by branch and manager with targets and drill-through to detail pages.

create a simple Power BI pizza sales report with drag-and-drop visuals—shape map, donut chart, clustered column charts, and a total sales card—apply top five filters and a detailed transactions page.

Build a Power BI pizza sales report with a details page for transactions, date formatting, drill-through to branches, and a tooltip showing top five pizzas by sales.

Explore building a pizza sales report in Power BI, using tooltip pages, chart properties, and formatting to reveal branch manager details, color themes, and publish-ready insights.

Build a Power BI dashboard for delicious pizza sales, consolidating branch data, daily sales and targets, computing sales amounts, and visualizing state and pizza-type performance for managers.

Build a Power BI sales report for a delicious pizza shop by adding a background image, logo, currency-formatted total sales, and a state map with a donor chart.

Create a Power BI dashboard for delicious pizza sales, using cluster bar and stacked column charts, formatting axes and colors, and analyzing by pizza type and state.

build a fictitious America Bank deposit report in Power BI from a blank template, with dynamic slicers, matrices, charts, and a narrative summary, plus drill-through details.

Create a deposits report in Power BI using Power Query to extract year and show metrics like number of customers and balance with visuals by state, gender, and job classification.

Learn to build dynamic Power BI narratives with a narrative visual, create measures using calculate, and configure slicers for education, state, and marital status to drive interactive bank dashboards.

Create a dynamic tooltip page in Power BI that displays balance by job classification, education, gender, and marital status across states using bar, pie, donut, and treemap visuals.

Duplicate the main dashboard, delete visuals to create a detailed page, then add fields, format dates, and enable drill-through to show transaction details for America Bank.

Enhance an American bank report in Power BI by creating DAX measures for total balance, gender, and ownership filters, and add images to visualize balance by demographics.

Design a Power BI bank report by arranging a background, placing logos, and creating evenly sized cards for total balance, house owners, renters, and white-collar balances with images.

Learn to build and customize a Power BI bank report by switching visuals to pie, doughnut, and bar charts, adjusting legends, labels, and backgrounds for clear mobile phone layouts.

Learn to create a phone layout in Power BI by switching to phone view, arranging balance and numbers by education, resizing visuals, and publishing the report.

Build dynamic Power BI sales reports for a car company, visualizing total sales, units, profit, and average order across countries, segments, and discounts with slicers and drill-through.

Create an interactive Power BI financial and sales report using charts (pie, donuts, bars), data labels, slicers for date and country, and a tooltip page for deeper analysis.

Learn to build a sales report in Power BI, creating visuals by country, product, discount band, and segment, with tooltips, data labels, and a drill-through detailed page.

Discover how to create a single dynamic Power BI report with a matrix that switches metrics—total sales, units, profit, and more—via parameter and button slicers.

Transform an Excel sales dataset into a Power BI financial report with filters and visuals, including a date table, to analyze profit and loss by segment and discount band.

Learn to create and format measures in Power BI, including total sales, cost of goods sold, margin, and profit percentage, and build a report with cards, matrix, and slicers.

Design a Power BI report by adjusting padding, borders, headers, and category labels, and configure slicers for country and segment with charts and data labels.

Explore building a financial report in Power BI by configuring clustered bar and donut charts, applying consistent formatting with format painter, and adding slicers for country, products, and discount band.

Master Power BI financial reporting by using slicers and segment filters to drive consistent totals, costs of goods sold, margins, and net profit across all charts.

Explore how to use Power BI analytics tab to analyze monthly sales by segment, apply forecast and trend lines, and set up date filters, with practical steps to publish reports.

Develop a Power BI report to analyze a 20-country personality survey, ranking traits like personality, looks, intelligence, humor, and wealth, with slicers and gender-based charts.

Build Power BI dashboard that ranks what matters in partner choice across 20 countries, using you gov data, and map looks, intelligence, wealth, sense of humor, and personality to attributes.

Learn how to manipulate Power BI data by splitting columns, transforming text case, and building interactive reports with slicers, themes, and customized headers.

Build a Power BI dashboard with a horizontal slicer and styled header to compare how women and men rank traits like personality, looks, sense of humor, intelligence, and similar interests.

Explore how a productivity survey informs a Power BI dashboard, using age filters, tooltips, and measures to quantify distractions, interruptions, and productivity from a 2017 Microsoft Office team study.

Create and optimize Power BI visuals for a productivity survey by building cluster charts, showing data labels and percentages, filtering blanks, and configuring slicers and layouts.

Create a dynamic Power BI productivity dashboard by building pie and donut charts, configuring tooltip and detailed pages, and enabling drill-through for age, country, and productivity questions.

Create a one-page Power BI dashboard from Microsoft’s productivity survey, using an age slicer and data relationships to visualize how productivity relates to happiness and key distractions.

Explore building and testing DAX measures in Power BI to analyze a productivity survey, including interruptions, distractions, time management, and technology factors.

Learn to build a Power BI productivity survey dashboard by creating measures for total respondents and interruption percentages. Visualize results with cards and time-of-day filters to explore responses.

Build a Power BI survey report by designing visuals, adding slicers and themes, and formatting headers to compare responses with bar and pie charts.

Create a Power BI productivity survey dashboard featuring a donut chart, adjustable titles, lines to separate visuals, and slicers to analyze age-based responses.

Create a Power BI report on the toughest sport by skill using ESPN data, unpivot 60 sports and ten skills, and transform data with Power Query Editor.

Create an interactive Power BI report by building a button slicer for sports ranked by skill, then visualize each sport's skill values with a stacked bar chart and descriptive text.

Power BI workflow to compare sixty sports by ten skills, unpivot data, merge rank with sport for a slicer, and build a three-section report with a themed interface.

Learn to build a power bi sports skills dashboard by adding a chiclet slicer, sorting by rank, and creating stacked bar visuals with sport descriptions for interactive insight.

Create a Power BI dashboard that analyzes sports skills with a top 15 sports matrix, using unpivoted data, slicers, filters, and styled text and numbers.

Build a US natural disasters Power BI report and dashboard from scratch, using a text-delimited data source, date modeling, dynamic narration, and an image-based chicklet slicer for interactive filtering.

Create metrics for losses and deaths, build a shape map by state with tooltips, add a dynamic narrative, and publish the report in Power BI.

Learn to load and explore US natural disaster data from 2017 in power bi, including disaster type, date, deaths, losses, and visuals with headers, themes, and KPIs.

Create an interactive Power BI dashboard on natural disasters with chicklet slicer from marketplace, category-based filters by disaster type, and KPI cards showing deaths and losses by event cost.

Build a Power BI dashboard that visualizes deaths and average losses per event by state with a shape map, tooltips, and an accompanying summary report.

Learn to build an interactive Power BI report showing top five states by deaths, alongside a losses in billions pie chart, with per state summaries and formatted visuals.

Build a comprehensive Power BI report on terrorism in the world, designing three pages with tooltip and detailed views, focusing on clarity, performance, and actionable insights.

Begin with the advanced projects and keep progressing through new Power BI challenges. Complete all lessons to become a Power BI rock star and start the learning journey.

Analyze procurement spend and supplier performance using a star schema with a fact purchase table and supplier and stock item dimensions, tracking total purchases, total quantity, and finalized POS.

Create and customize matrices for total quantity, total purchases, and pos, add a date slicer from the fact table date key, and build donut and column charts for procurement spend.

Power BI spend analysis basics: label charts in millions, switch stacked column to line visuals, and use a multi-measure parameter with button slicers to cycle total purchases, quantity, and pos.

Create an advanced procurement spend analysis in Power BI with tooltip and drillthrough pages to show top ten items by total purchases and access detailed transactions.

Explore procurement spend analysis using power bi, transforming and analyzing expenditure data from wideworldimporters 2017, building measures and dashboards to monitor costs, efficiency, governance, and inventory.

Build Power BI measures for total purchases, finalized and non-finalized purchase orders, and order quantities, using dim stock unit price, and visualize insights in a themed procurement dashboard.

Learn to build procurement spend analyses in Power BI by creating cards, donuts, and bar charts, formatting totals, labels, legends, and colors to reveal packaging and color trends.

Leverage Power BI for procurement spend analysis, focusing on purchases and POS by month with bar and line charts, plus top ten suppliers and products matrices.

Create a procurement spend analysis dashboard in Power BI, using year, month, quarter, and week filters, metrics, and themed visuals to compare top suppliers and items.

Build a Power BI product analysis counting quantities across reseller and internet sales using Adventureworks data, with snowflake schema, category relations, and country-flag slicers.

Learn to build Power BI charts by plotting monthly total units sold with a 100% stacked chart, category legends, year slicers, and ten subcategories, products, and resellers, with data labels.

Learn to analyze products in Power BI: configure top n total units by product, use category and subcategory, add narration and tooltips, and design a tooltip page with multiple charts.

Leverage Power BI to build interactive tooltips, drillthrough detail pages, and connected tables that reveal customer and reseller data, with slice-and-dice filtering by country and category.

Build a Power BI product analysis report with AdventureWorks data, tracking units sold, top resellers, top products, and top subcategories across countries.

Create top ten resellers, products, and subcategories in Power BI using reseller sales and total sales metrics, apply top ten filters, and format visuals with a clean white theme.

Learn Power BI product analysis using country and date slicers, create pie charts and matrices by category, promotion category, and reseller, and format visuals for clear insights.

Learn to build a product analysis report in Power BI, analyzing month-by-month sales, category performance, and seasonality with white visuals and filters for year and country.

Explore regional analysis in Power BI by building a live map and matrix to compare total sales, costs, and margins across countries, states, and categories, and review previous year data.

Explore regional analysis in Power BI by building a country map with total sales, total cost, and gross margin, and drill down to state levels using all level down hierarchy.

Create a regional Power BI report with a category-subcategory-product matrix showing total sales by countries and states, plus category, subcategory, and date slicers and a cluster column chart.

Create a regional Power BI report by country and state using a matrix and slicers to show total sales, cost, gross margin, and quantity, with a tooltip for subcategory sales.

Create a regional analysis in Power BI using AdventureWorks data. Build measures for internet and reseller sales, map regions, and compare current versus previous year.

Build a regional analysis in Power BI by creating measures: total sales, total cost, gross profit, and percentage profit, displaying them with white cards, a date slicer, and regional flags.

Create a regional Power BI dashboard by visualizing internet and reseller sales, total cost, and margin with map bubbles and a multi-level matrix of categories, subcategories, and product names.

Learn regional analysis in Power BI by creating charts that compare this year's to last year's sales and gross profit across categories, subcategories, and products with white headers.

Explore a real-time IT tickets analysis dashboard that improves visibility of ticket statuses and volume trends. It enables quick issue detection, bottleneck identification, and data-driven insights for resource optimization.

Learn to analyze IT tickets in Power BI by creating measures for user count, tickets, days open, and average days, then build a dynamic matrix and severity visuals with slicers.

Switch severity to priority charts in Power BI IT-tickets analysis, add legends and labels, and build a tooltip with dynamic matrices for tickets and users.

Design an IT-tickets analysis dashboard in Power BI by building a detailed page with drill-through, duplicating pages, and configuring slicers for severity, priority, ticket type, and department.

Analyze and visualize a 100,000-ticket IT helpdesk dataset, clean and structure fields, and build an advanced dynamic-measure dashboard with filters, insights on severity, priority, and resolution days.

Learn Power BI IT ticket analysis by adding a last refresh date, building a date and measures table, and calculating distinct users, total tickets, and average days open.

Build a Power BI report by creating a matrix, configuring slicers for severity and department, and adding measures like total tickets and distinct departments, with a last refresh date display.

Develop dynamic measures in Power BI by building a major selection table and a switch-based logic to toggle visuals by average days, total days, or total users.

Master Power BI analytics for IT tickets by building dynamic visuals—donut and cluster charts with slicers for severity, priority, and ticket type to reveal total tickets and average resolution days.

Build an advanced human resources dashboard in Power BI that visualizes key metrics like salary, total employees, active employees, left employees, and sick days, with dynamic slicers and narration.

Build a Power BI human resources data model with a date table and fields such as hire date, department, job type, and satisfaction to support three reports.

Explore how to build Power BI measures for payroll analytics—total salary, total and active employees, sick days, and average age—plus multi-row cards, a pie chart for job types, and slicers.

Build an HR Power BI dashboard with donut chart and cluster charts, slicers for gender, marital status, education, current role, last promotion, salary by gender, plus narration and templates.

Build a Power BI human resources dashboard using templates and tooltips, configure slicers for salary and employees, and link to detailed drill-through pages with salary, active employees, and sick days.

Build HR reports in Power BI using dynamic measures for salary and number of employees, with interactive filters and graphs across departments, then create a date table and measures.

Design a Power BI HR dashboard by creating and testing measures for salary, total employees, and sick days, then build a themed report with dynamic measures.

Learn to switch between salary and total employees using a dynamic measure, with a salary default, and build interactive donut charts for job type, gender, and education.

Build an interactive Power BI dashboard for HR data with gender, marital status, education, current role, last promotion, sick days by department and date.

Extend the first HR Power BI report by creating an average report that shows average salary, balance days, and sick days, using a new all metrics table with slicers.

Master Power BI dashboards for human resources by building cards with total salary, total employee, and average balance day, and arranging slicers, matrices, and charts for clear insights.

Create and customize a Power BI HR dashboard by using slicers for job classification, involvement, satisfaction, and type, and by building average and detailed pages with drill-through and tooltips.

Create a human resources report by averages in Power BI, displaying average salary, balance days, and sick days with dynamic measures and filters.

Create a Power BI matrix with average salary and average balance days, using a switch-based major selection to default to average salary, and tailor visuals by job, gender, and education.

Create Power BI reports for human resources by modeling department versus business unit visuals and a gender by job classification matrix with tab-driven metrics.

Build a location-based regional Power BI report (dashboard three) with a top location slicer, a dynamic dim matrix, and three visuals plus a table for balance days and sick days.

Build HR dashboards in Power BI using pie, donut, or tree maps with data labels to analyze salary, employee count, sick days, and balance days by city and unit.

Learn how dynamic dimensions convert measures into interactive dimensions in Power BI, build tabbed dashboards, connect data sources, and create unique IDs for related tables.

Create a dimensions table in Power BI by duplicating and cleaning a source table, unpivoting to capture id, dimension, and value, and building a filtered matrix.

Create a comprehensive Power BI report from a provided template, featuring three pages (main page, tooltip page, and detailed page), and emphasize planning, simplicity, and delivering meaningful insights.

Use bookmarks in Power BI to toggle between slicers and a matrix on the financial report, saving screen real estate while updating dynamic measures such as total sales and profit.

Create a dynamic Power BI financial report by implementing a major selector with switch logic to display total sales, cost of goods sold, or profit, and visualize with a map.

Build Power BI dashboards with donut charts, monthly sales, costs of goods sold, and margin, then deploy a bookmark feature and toggle button to switch numbers and filters.

Create Power BI visuals with cards for sales, cost of goods sold, profit, and variance. Use bookmarks and slicers to switch views and reveal matrix and slicer dynamics.

Learn to create report page tooltips and bookmarking in Power BI to display cost of goods sold, total margin, and profit percent on graphs.

Build and explore a dynamic Power BI sales analysis report with internet and reseller sales, showing total sales, cost, gross profit, and gross margin percentage, with country and category slicers.

Learn to build a Power BI sales dashboard with geography, date, and category slicers, display key metrics like sales, cost, and profit, and compare reseller and internet sales.

Build Power BI sales analysis dashboards by creating internet and reseller sales visuals, categorizing by category, promotions, and territory, and adding slicers and tooltips for interactive insights.

Create sales analysis dashboards in Power BI by mapping customers and employees to sales data, adding regions, sales territory, and margin, and building matrix and table visuals.

Create a single dynamic Power BI report that replaces three reports by switching between sales, cost, and margin with a parameter, tiles slicer, and linked visuals.

Build an advanced sales report in Power BI with two dynamic measures for reseller and internet sales, plus graphs and margins using the AdventureWorks dataset.

Test Power BI sales reports by dragging fields, converting measures to cards, and using slicers and buttons to verify sales, cost, and profit across category, territory, and promotions.

Master dynamic measures and interactive visuals in power bi by formatting sales reports, sorting by columns, and publishing polished dashboards for clear cost, profit, and sales insights.

Extend the bank report in Power BI with metrics for total balance, average balance, number of customers, and average age, using slicers for education, gender, and state.

Build a bank report in Power BI by grouping fields, using a matrix with slicers, and adding a balance by month line chart with reference lines, tooltips, and drill-down pages.

Create dynamic measures in Power BI using switch logic to display total balance, average balance, or total customers from slicer. Build cards and a gender pie chart to visualize results.

Design a bank report in Power BI with charts for balance and customers by date, and a white matrix with dynamic education dimensions, totals, and averages.

Duplicate a table, select dims such as gender, state, job classification, and education, unpivot a column, create a dims table, and establish a two-way relationship for state and education filtering.

Adapt an older pbix in Power BI to a newer desktop, build a dashboard with quarter slicers, a matrix and charts, and sort by balance after refreshing data.