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

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.

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

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.

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.

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 to remove unnecessary columns in Power BI desktop by selecting and removing columns via the query editor, keeping only the column name and abbreviation.

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.

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

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.

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.

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.

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.

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.

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 Q&A visual in Power BI to answer natural language questions with visuals, and add synonyms to improve results.

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.

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

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.

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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

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.

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.

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.

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.

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.

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.

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 an advanced sales report in Power BI with two dynamic measures for reseller and internet sales, plus graphs and margins using the AdventureWorks dataset.

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.