Power BI & Power Pivot: Introduction

Import data into Power Pivot's data model from an Access database, selecting tables, previewing filters, and loading millions of rows to populate dimension and fact tables.

In Power BI and Power Pivot, build a data model by linking the fact table to product and date tables, creating one-to-many relationships and filters that propagate.

Create a pivot table connected to your workbook's data model, drag sales amount and category fields, verify relationships, and access fields from all related tables for accurate totals.

Discover how to build your first data model in Power BI, switch between report, data, and modelling views, and visualize sales with KPI, area charts, and maps.

Import data from Excel and CSV sources into a Power BI data model, creating tables, establishing relationships, and configuring regional settings for accurate data import.

Explore designing relationships in Power BI and Power Pivot by linking customers and suppliers to geographic dim tables and using one-to-many connections for accurate visualizations.

Create a date table in Power BI with a DAX table in data view to generate all dates from 2018-01-01 to 2020-12-31 in one column, then link to transaction dates.

Create a table visualization from the data model, add year and quarter from the date table, rename fields such as sales including taxes and sales excluding taxes, and adjust formatting.

Create stacked area charts in Power BI to show sales excluding taxes and tax amount over time, using a year–quarter hierarchy and drill down, with y axis starting at zero.

Create and configure slicers at the top of a Power BI report, using a state/province dropdown and a timeline slicer to filter visuals. Adjust multi-select, formatting, and type options.

Create a stack bar chart showing sales excluding taxes and tax amount by city, using the density table for city names, and filter by state such as Arizona.

Learn to create a map visualization in Power BI by using city names or latitude and longitude, and improve plotting accuracy by adding city, province, and country details.

Design visualizations in Power BI with three kpi cards for sales including taxes, sales excluding taxes, and the tax amount, and arrange a map zoomed to Arizona and a table.

Explore finalising a Power BI report page by aligning visuals, managing cross-filter interactions, and refining formatting, page size, background, and titles for a polished sales report.