Microsoft Power BI for Data Analysts from zero to Advanced

Import data from Excel into Power BI and explore the data view to transform, model, and visualize your data within a single desktop app.

Explore the data view in Power BI Desktop to view, edit, and analyze loaded data with fields, filters, sorting, DAX measures, and data relationships.

Import a file into Power BI from file tab, selecting templates or visuals from AppSource, Power Query, Power Pivot, or Power View, then start the import to view Excel contents.

Connect to data sources in Power BI using Get Data, import from files, databases, the Power Platform, or Azure Online Services, and transform with Power Query Editor or load.

Import and explore a Power BI Desktop sample dataset to practice analyzing, modifying, and visualizing data.

Clean and transform data in Power BI using Power Query and Power Query Editor to import, shape, and ensure accurate models and reports, tracking steps with Applied Steps List.

Open the Power Query editor to transform, edit, and select data before loading it into Power BI from the Home tab via the Transform Data option in the queries pane.

Explore the applied steps list in Power Query Editor to view data transformations without altering source data, and extract previous to split steps into separate queries.

Execute basic math operations on a column in Power BI by adding, subtracting, multiplying, or dividing all values with a specified number through the transform tab.

Replace errors in a Power BI column to control display values, using the queries pane and transform tab to apply replace errors and enter a new value.

Explore how data modeling turns data into decisions in Power BI, using Power Pivot and Power View to create models, reports, and visualizations that reveal relationships and trends.

Explore the Power BI model view to visualize tables, columns, and relationships, hover to highlight related columns, and interpret cross-filter direction and cardinality.

Manage and edit relationships in Power BI by viewing connections, setting cardinality and cross filter direction, and applying security filters to optimize data queries.

Learn to create and manage Power BI relationships between tables and columns, propagate filters across tables, set cardinality and cross-filter direction, and enable security filters with referential integrity for DirectQuery.

Explore the report view with Power View to visualize imported, transformed, and modeled data using visuals. See how area charts display multiple values with axes and labels to reveal insights.

Explore the Power BI report view to build dynamic visuals, apply filters, configure analytics, and publish engaging reports that tell a data-driven story.

Create visualizations in Power BI by selecting data fields or a visualization type, then drag the chart to the canvas, and discover insights with charts, maps, and gauges.

Master format features for Power BI visuals, editing colors, axes, legends, and styles via the Visualizations pane. Search, expand sections, and reset defaults to create beautiful, data-driven stories.

Master switching visualization types in Power BI Desktop to fit your data. In report view, click the current visual and select a new type from the visualizations pane, then apply.

Learn how to use text visualizations in Power BI, including card, table, KPI, and key influencer visuals, to highlight data points and communicate what the audience should know.

Create a visualization card to highlight a single value, using the card icon in visualizations, then select a table field in fields pane.

Create a table visualization in Power BI by selecting the table icon, dragging and resizing the visual, and selecting data fields to display detailed values in a tabular format.

Create a KPI chart by selecting the KPI visual, adding base measure and target measure, and configuring a trend axis using a date field to track progress toward a goal.

Create and interpret a key influencers chart in Power BI to identify factors that influence a metric, analyze data fields, and explore segments and decreases for actionable insights.

Explore the evolution of chart visualizations and learn to create and format Power BI visuals, including bar, pie, scatter, waterfall, funnel, and ribbon charts.

Create a scatter chart to reveal the relationship between two numerical values, identify correlational patterns, and tell a dynamic story using the x-axis, y-axis, size field, and legend field.

Create a waterfall chart to visualize a running total of positive and negative changes, using the visualizations pane, drag fields to x-axis and y-axis, then sort to highlight contributors.

Create a funnel chart in Power BI to visualize sequential data changes. Drag category to group and value to values, resize visuals to reveal where values drop.

Create a ribbon chart to identify the highest values and rank changes across time periods by placing time on the x-axis, category on the legend, and value on the y-axis.

Master filters, slicers, and data drilling to reveal insights in Power BI reports, applying visual, page, and report filters and using slicers to filter visuals and drill up or down.

Create a slicer to filter a Power BI report by a field, updating all visualizations on the report canvas.

Explore how to use Power BI's analyze feature to identify where distributions differ across visualizations. Learn to compare relative and absolute values, apply filters, and add insights to pages.

Master drill down and drill up in visualizations with hierarchies, moving from general sales views to detailed breakdowns by state or month, and expanding to the next data level.

Publish your dataset or report to the Power BI service, sign in if prompted, select a workspace, and open your item online to share with others.

View my workspace in the Power BI service to access reports, datasets, and dashboards published from desktop and online in one place, with filters, lineage, and list views to organize.

View and manage workspaces in the Power BI service, including private My Workspace, public workspaces, and sharing content with others.

Create a new dashboard in Power BI, name it, and start customizing visualizations from My Workspace using the dashboard option in the left pane.

Learn how to add a tile to a Power BI dashboard by selecting media, creating an image tile with a title, subtitle, and URL, and applying it to the dashboard.

Pin a tile from a report to a dashboard. Select the tile in My Workspace and pin it to an existing or new dashboard.

Learn to subscribe to a Power BI dashboard from My workspace to receive regular status updates by configuring recipients, frequency, and timing, then save.

Share a report via email to collaborate with colleagues by sharing from your My Workspace, set link permissions, and allow recipients to view, share, and build content from the data.

Export Power BI reports to PowerPoint as embedded images, choosing export options and excluding hidden tabs to generate a presentation.