An introduction to Power BI

Install Power BI Desktop, explore both the on object interaction preview and older visualization interfaces, and learn to import data, create visuals, and publish reports to the Power BI service.

Identify and connect to diverse data sources for Power BI, including Excel, SQL Server, SSAS, CSV, XML, JSON, Azure, and online services like SharePoint Online and Dynamics 365.

Power BI guides you to create visualizations by loading the HP admins workbook, building a year-based sales volume column chart, and exploring a line chart of 12 month percent change.

Explore how aggregations in power bi summarize data, switching from sum to average for 12 months percentage change and using min, max, count, median, and standard deviation.

Create a blank Power BI report and load data from an Excel workbook. Build a stacked column chart of year with average annual change and save the practice file.

Explore Power BI visualizations, including table and matrix (pivot-table style), bar and column charts, line and area charts, and pie and donut charts, with drill through and baseline zero considerations.

Discover how ai insights in power bi surface anomalies and trends using diagnostic analytics, key influencers, and decomposition trees, through interactive visualizations like maps, scatter and bubble charts, and drill-through.

Describe three filter types in Power BI - visual filters, page filters, and all-page filters - plus slicers, highlighting, and drillthrough, including cross-report drillthrough.

Practice activity demonstrates building and refining Power BI visuals, adjusting aggregations, using date axis, applying report and page filters, incorporating slicers, and testing drill-through across pages.

Import and transform data in Power BI using Power Query Editor, loading January and February from Excel, cleaning spaces, promoting headers, and mapping categories, with automatic refresh of applied steps.

Navigate the Power Query Editor menus to manage data, transforming or adding columns, filtering rows, and previewing changes while leveraging AI insights powered by Azure.

Learn to clean and transform data in Power BI by assessing column quality, distribution, and profile, then apply trimming and basic transformations to prepare clean data.

Learn how to combine multiple data sources in Power BI using merge and append queries, including automatic folder-based combining with combined files, and add columns or rows.

learn to transform and merge data in Power BI using power query, clean spaces and nulls, and perform left and full outer joins to compare 1940–1950 and 1950–2013 populations.

Create and format bar and pie charts in Power BI Desktop, apply a date hierarchy with drill down, and understand the report, data, and model tabs and their relationships.

Explore designing data layout and mapping in Power BI using Power Query Editor to shape data with column transforms, calculated columns and measures, and build hierarchies for insightful visuals.

Import four spreadsheets, establish relationships across dim and fact tables, and build a matrix and stacked column chart to explore product categories, order date, and total product cost.

Publish your Power BI Desktop files to the online Power BI service, sign up with a work or school email, and sign in to view your visualizations online.

Sign up for a free Microsoft 365 business trial to obtain a work email and access Power Platform, Power BI, and Fabric for sharing apps and reports.

Sign in to the Power BI service, explore workspaces, reports, and semantic models, and understand dashboards and reports. Power BI Desktop offers more functionality, while the service evolves.

Master Power BI terminology by exploring data sources, semantic models, reports, and dashboards, and learn how semantic models unify data across reports in the Power BI service.

Explore how Power BI uses workspaces and apps to manage dashboards, reports, semantic models, and data sources, with sharing and collaboration rules and publishing workflows.

Compare Power BI Desktop and Power BI Service, detailing data sources, semantic models, refreshing mechanisms, dashboards and apps, and collaboration through workspaces, security, and cross‑report drill‑through.

Learn to create a Power BI report using Power BI Desktop and Power BI Service, import data from Excel, build visuals, and edit queries with measures and columns.

Learn to use the Power BI service to upload Excel data, build a semantic model, create matrix and column visuals, and save or edit reports in your workspace.

Pin visuals from reports to create a Power BI dashboard, resize and arrange them, and use Q&A to add visuals; connect to a semantic model spanning multiple data sources.

Compare dashboards, reports, and workspaces, and learn to publish reports to the Power BI service, share workspaces and apps, manage permissions, and set alerts within tenant settings.

Explore how to access and share template apps and datasets in Power BI, install third-party apps, and endorse or certify datasets to boost discoverability within your organization.

Learn to build paginated reports in Power BI with the report builder. Create multi-page, printer-ready tables and matrices from SQL Server data sources and publish to the Power BI service.

Explore how to use power bi in mobile apps across apple, android, and windows, including offline viewing, background data updates, and interactive features like q&a, comments, and annotations.

Explore how to view Power BI reports and dashboards across service, desktop, and apps; share, manage permissions, export to PowerPoint or PDF, and embed reports on the web or SharePoint.

Pin visuals to a new Power BI dashboard, resize and arrange tiles, and enable a mobile layout. Use Q&A to explore data, switch metrics, and customize visualizations.

Create visualizations in Power BI Desktop, transform data with Power Query, and publish dashboards using the Power BI service.