Power BI Mastery: Zero to Hero Data Skills

Learn how to download and install Power BI desktop for free from the Microsoft Store or direct download, and enable preview features for the Power Query editor and transform data.

master how to create six basic charts in Power BI desktop, import data from Excel or other sources, and format and export data from visuals as CSV.

Create a stacked column chart by assigning subcategory to axis, sales to values, and region to legend, then enable data labels and use focus mode for clarity.

Create a simple Power BI Desktop pie chart by placing region in the legend and sales in values, then adjust labels, hide the legend, and increase text size for clarity.

Create a donut chart in Power BI by dragging region to legend and sales to values, then customize detail labels, font sizes, and legend to display names, percentages, and values.

Create a funnel chart in Power BI using the built-in option, assign subcategory to the category and sales to values, and resize for a clear visualization.

Create and analyze a ribbon chart in Power BI by mapping year to axis and region to legend, revealing ranking of sales and regional performance across years.

Learn to create a simple map in Power BI using geographical data types, drag state to location, and show US profit by region with size and legend.

Create a field map to visualize profits by state, color states by region, and reveal state names and profits in tooltips on hover.

Create a map with a pie chart in Power BI by using state as location, category as legend, and sales as size; adjust bubble size and zoom to explore distributions.

Format a map in Power BI by applying data colors, per-state color customization, and bubble size to reflect sales. Adjust labels, borders, title, tooltips, and background to improve readability.

Learn to change a map background in Power BI by using the format options and map styles, selecting themes like aerial, dark, light, grayscale, or road to suit your visualization.

Create a simple table in Power BI by dragging fields into values, then sort by column headings and apply conditional formatting, with explorations of aggregations, matrix basics, and grand totals.

Learn practical steps to format tables in Power BI, including adjusting text size, header sizing, grid lines, styles, and adding titles for clearer visuals.

Learn to apply conditional formatting in a Power BI table using background color, font color, data bars, and icons. See how rules and advanced controls adapt as data changes.

Learn to change table aggregations in Power BI, switching between sum, count, average, min, max, and percent of total with simple field options and dropdowns.

Learn to convert a table to a matrix in Power BI, placing subcategory in rows and regions in columns with sales as values for clearer, multi-directional insights.

Apply conditional formatting in Power BI matrix visuals with data bars, color adjustments, and icon-based KPIs to distinguish positive from negative profit and sales across regions.

Drag and drop fields to create hierarchies in a Power BI matrix, then expand and drill up or down to analyze sales by category, subcategory, region, and order date.

Learn to work with subtotal and grand total in a Power BI matrix, format subtotals and totals, and set font color and background color for labels.

Master number formatting in Power BI tables and matrices by converting decimals to whole numbers, applying thousands, millions, or billions display units, and adjusting decimal places.

Learn to create number cards as indicators showing total sales, profit, and quantity, and explore four card types and filters on visuals, pages, all pages, and drill through.

Create a text card in Power BI to display subcategory data in alphabetical order and use top N to reveal the highest selling, profitable, and quantity subcategories.

Learn how to create a date card in Power BI, display the earliest and latest dates, and identify the most profitable and highest selling days using filters.

Explore how to use the multi-row card in Power BI to display multiple fields, apply the top end option, and analyze region-based subcategory profitability.

Apply a filter on visual in Power BI to affect only one chart, using the filter on visual pane and validating that other visuals stay unchanged.

Apply filters on a page in Power BI, including filtering the entire page and individual visuals. Drag fields into the filter on this page, clear filters, and see page-level changes.

Apply a category filter across all pages to synchronize visuals on P1, P2, and P3, so furniture or technology selections update every chart.

Master drill through in Power BI to navigate between pages, jump to detailed visuals by category or region, and view furniture and regional sales data.

Master text slicers in Power BI desktop to filter reports and visuals, build hierarchies for category and subcategory, support control plus click for multi-select, and clear filters.

Format a text slicer in power bi by using the format pane to adjust selection controls, orientation, colors, and borders for intuitive multi-select filtering by end users.

Master date slicers in Power BI by creating interactive filters for order date data. Use min/max, calendar, relative dates, and date hierarchy to filter by year, quarter, or month.

Learn how to format a date slicer in Power BI, including converting to a date hierarchy, switching to dropdown boxes, and styling the background, fonts, and headers.

Learn to create and use number slicers in Power BI to filter customers by quantity and sales ranges, using minimum and maximum values and list views.

Explore advanced visuals in power BI by importing ten third-party charts from AppSource, including sunburst, sankey, and animated bar charts, and learn to enable drill-down and histogram creation.

Create a drill down donut chart in Power BI using an advanced donut visual, set up category, subcategory, and product name hierarchies, and drill down to see detailed levels.

Create a word cloud in Power BI by adding the Word Cloud visual and sizing by profit, dragging state into category. Adjust text rotation and word breaking, then customize colors.

Create a Sankey chart in Power BI by dragging category to source, subcategory to destination, and sales to weight to visualize how sales flow between categories.

Create infographics in power BI by importing the infographic designer from appsource, adding shapes, icons, and images, and customizing colors and layouts for category and sales data.

Create a play axis in Power BI, a dynamic slicer that drives bar and pie charts to reveal sales by year, quarter, or month.

Learn to add and configure a scroller visual in Power BI, set category and measure, apply whole-number formatting, and use deviation arrows with adjustable scroll speed.

Create a sunburst chart in Power BI by adding the visual, assigning category and subcategory to groups and sales or profit to values, then explore layered distribution and formatting.

Learn how to create a histogram in Power BI by importing a certified visual from the app store, configuring bins, and analyzing quantity distribution from 1 to 14.

Master image insertion in Power BI by importing pictures and formatting them with borders, backgrounds, titles, alignment, and shadows, using the insert tab and format painter.

Learn to insert and format text in Power BI by adding text boxes, resizing, aligning, and applying font size, color, background, and borders to enhance reports.

Learn how to insert and customize shapes in Power BI by using the insert tab, choosing from default shapes, adding text, adjusting colors, borders, and rotation, and understanding formatting limitations.

Insert buttons in Power BI and compare them to shapes, focusing on default back actions and other available actions; learn to add left arrow and back buttons to navigate pages.

Apply the web URL action in Power BI to open websites from images or buttons. Paste full URLs, add tooltips, and test by ctrl-clicking to navigate to YouTube and Udemy.

Create a Power BI report with an index page and P1, P2, P3 buttons that navigate to respective pages using page navigation actions, plus a back button to return.

Explore the bookmark action in Power BI to toggle chart visibility with Show all and Hide all buttons, using bookmarks for all visible and all hidden states.

Create a simple Superstore report in Power BI desktop, build visuals (donut, pie, bar, line, table), use slicers and cards, format with black background, and publish to Power BI service.

Create a Power BI service account and publish reports online by signing up with a corporate or university email, verifying your code, and using workspaces to manage your reports.

Publish a Power BI report from desktop to the Power BI service, publish to a workspace, and share interactively with colleagues.

Learn how to create and pin visuals to a dashboard in Power BI service, including new versus existing dashboards, resizing, and adjusting themes to reveal labels.

Explore common Power BI dashboard interactivity issues and learn to fix them by pinning a live page to a dashboard, enabling full-page filtering across visuals.