Complete Power BI Bootcamp: Go from Zero to Hero

Explore Power BI visualizations to describe data with built-in visuals and custom controls for interactive analysis, and learn which visuals best display different data elements.

Open a blank Power BI report and customize the canvas, page information, and wallpaper by adjusting aspect ratio, transparency, and background images, then prepare to add visuals.

Learn how to build Power BI reports by selecting visuals, adding data elements, switching chart types, and formatting with tooltips and lines for clear, actionable insights.

Observe how to build visuals in Power BI by selecting sales data, creating and switching between column and clustered bar charts, and refining axes, display units, data labels, and lines.

Learn line charts to track time-based trends, area and stacked area charts to show changes and totals, and ribbon charts to compare categories in Power BI, noting readability cautions.

Explore creating and formatting line, area, stacked area, and ribbon charts in Power BI; learn to set axes, legends, markers, colors, tooltips, and compare chart types for sales data.

Explore slicers in Power BI to restrict data and filter visuals across multiple pages, with options for multi or single selection, various styles, eraser, dropdown, and search controls.

Explore how to add and configure slicers in Power BI to filter visuals by year and sales territory, sync across pages, and switch between list, dropdown, button, and search formats.

Explore waterfall charts for running totals and color cues in power bi. Learn scatter charts, including bubble charts animated with a play axis to reveal time-based changes.

Explore creating waterfall, scatter, and bubble charts in Power BI, using a play axis to visualize sales trends, profits, and employee performance over time.

Explore funnel, treemap, donut, and pie charts to show parts of the whole with percentages totaling 100%, using funnel for processes and five-or-fewer values for pie or donut.

Explore funnel, tree map, pie, and donut charts in Power BI to analyze profit by category and color, adjust data labels, and clarify visual storytelling.

Map geographic data in power bi using zip codes or city names with bing maps. Use map plots, filled maps, and shape maps to compare regions and visualize data intensity.

Explore Power BI mapping visuals by creating a page and using map, field map, and shape map, linking city, state, and profit data with legends, tooltips, and color shading.

Use cards, KPIs, gauges, and scorecards in Power BI to visualize targets and progress toward goals. Explore single and multi-card visuals, KPI charts, and gauge dashboards for progress.

Explore creating and formatting cards, multi-line cards, KPIs, and gauges in Power BI, including dynamic display units, slicers by city and state, and trend analysis for profit.

Display numbers with table and matrix visuals in Power BI, applying conditional formatting and data bars. Drill down and roll up by year, quarter, and month to explore totals.

Explore analytic visuals in Power BI, including R and Python visuals, key influencers, and decomposition tree, and learn to use smart narrative and Q&A controls for data insights.

Explore Power BI analytic visuals, including the Q&A visual for natural language queries and the key influencer visual, to analyze profit drivers like lead time, color, and segments.

Add non-listed visuals, text, images, shapes, and custom visuals to enhance Power BI reports, while building navigational elements with buttons and bookmarks and controlling visual interactions.

Demonstrate visual interactions in Power BI by using edit interactions to keep the profit card constant while other visuals filter or highlight the data; set none for the profit visual.

Explore how to use custom visuals in Power BI, including blue check certified visuals and per file persistence, with options for free and paid visuals and organization restrictions.

Demonstrate adding a Power BI custom visual, importing a Power BI certified visual, and creating interactive visuals with data labels and a clustered bar chart for profit.

Discover how text boxes, images, and shapes enhance Power BI reports by using the insert menu to add, format, and group elements with logos and links.

Learn to enhance a Power BI report by adding shapes behind a visual, making backgrounds transparent, and inserting a logo and title. Then group items for synchronized movement.

Combine bookmarks with buttons to navigate pages and toggle visuals in Power BI, saving states like page, filters, and sort order for interactive reports.

Create and rename bookmarks for pages such as sales analysis and custom visuals, then design buttons that use these bookmarks for navigation, with hover and press states.

Master using the Power BI selection pane, grouping, renaming visuals, and eyeball visibility to control which visuals appear or disappear, adjust layering, and bookmark specific selected states with buttons.

Utilize the selection pane and bookmarks in Power BI to toggle visuals, creating bookmarks for unit price by sales territory and matrix, controlled by arrow buttons for a dynamic report.

Explore color theory and practical color management in Power BI, including palettes, themes, accessibility, and templates for consistent, audience-aware visuals.

Change default Power BI visual colors by selecting each visual's colors, and explore color designer io, Adobe color, and Palatine for hex values to unify palettes.

Learn to create and apply Power BI themes using the theme gallery and advanced theme generator, matching corporate color guidelines with navy blue, lime, and Georgia font.

Learn how to edit and customize a Power BI theme, save current themes, and apply consistent fonts like Georgia across visuals, cards, and KPIs for accessible, cohesive reports.

Learn how templates provide a starting point for Power BI reports, including layout, logos, slicers, and data interactions, to standardize visuals and support self-service reporting.

Demonstrate creating a Power BI report template, saving it as a template file, and opening it as a pbix to reuse data connections, visuals, slicers, and drill-through and drill-down features.

Apply design guidelines for multi-page Power BI reports by using data storytelling, clean alignment, and consistent fonts; remove clutter, replace inappropriate visuals, and use tooltips and slicers for clarity.

Learn to design Power BI reports with clear visual layouts, following design guidelines, placing the most important element at the top left, and aligning and distributing items with consistent sizes.

Organize data to tell a clear business story by aligning visuals to questions, providing context with prior periods or goals, and guiding users through consistent navigation and meaningful groupings.

Explore storytelling in Power BI with an HR hiring report showing new hires, active and separated staff, and bad hires; analyze year-over-year trends by gender, region, and age.

enable cross-page consistency by syncing slicers across power bi pages with the sync slicers pane; choose which pages to sync, control visibility, and apply advanced grouping of slicers.

Explore how to use and sync slicers in Power BI, copy and paste slicer visuals across pages, and control visibility and sync behavior with the slicer settings.

Learn to create customized tooltips in Power BI, including tooltip pages and hidden pages, to reveal richer data when hovering over visuals.

Explore how to create and use hierarchies in Power BI to drill down and drill through, roll up, and filter data across multiple levels, including date hierarchies.

Explore creating and using hierarchies in Power BI, including a date roll up and sales territory hierarchy, drilling down in visuals, and switching between implicit and explicit hierarchies.

Enable drill down to navigate hierarchical levels in visuals like the tree map, matrix, and charts with single, double, and forked arrows, revealing data by year, quarter, and month.

Demonstrate drill down and drill up in Power BI visuals, showing drill mode on versus off and navigating hierarchy with the double and forked arrows.

Learn to create a drill through page in Power BI, right-click a value to open a new detail page and return to the main page.

Explore using the filter pane to adjust data across reports, pages, and visuals, including top end filtering, relative date filters, and field filters.

Learn to use the Power BI filter pane for page and visual filters, including eastern region selection, top-five sales, and a current year relative date filter.

Explore dimensional modeling and star schema to organize data for Power BI, linking fact tables of transactions with dimension tables via unique keys for scalable reporting.

Explore dimensional modeling in Power BI by distinguishing facts from dimensions, using star and snowflake schemas, and building interactive slicers for calendar year and geography.

Discover how to build a unified Power BI data model by sourcing data from Oracle, SQL Server, cloud databases, Redshift, and Azure DB, then link tables and transform data.

Explore dimensional modeling in Power BI by connecting to SQL Server data, the customer orders view, and an Excel dim employee file, building a model from orders and related dimensions.

Publish a data model to the Power BI service from a free account with a business email, then connect reports to that dataset in a shared workspace.

Configure a date dimension in Power BI with a unique, gap-free date table and mark it as date for calculations, then sort month by number to improve reporting.

Sort the date dimension by calendar month number and day of week number to fix sort order in Power BI; publish and refresh the report while disabling calendar month summation.

Learn to model Power BI data by building relationships between fact and dimension tables in a star schema, using keys such as employee key and salesperson key.

Explore role playing dimensions in Power BI, focusing on active and inactive relationships between the sales and calendar tables, and the DAX-based solution while avoiding extra date tables.

Explore a role-playing dimension in Power BI by linking orders and ship dates to a calendar through date keys, managing active and inactive relationships, and validating date-driven filters.

Master column formatting in Power BI by adjusting model view, data types, default aggregations, and date and number formats, while adding descriptions and hiding unused fields.

Format Power BI fields and models by converting date time to short dates, switching currency to decimal with thousands separators, and hiding unused keys while adding hover descriptions.

Explore modeling data from multiple sources in Power BI, merging OLTP and Excel data into a star schema with facts, dimensions, and a date table.

Shows how to load an Excel table into Power BI, create a date table, establish relationships for a star schema with segment and country, and build slicers and a matrix.

Power Query enables you to clean, shape, and transform data for Power BI reports - create new columns, merge tables, replace values, split and merge columns, and filter duplicates without coding.

Learn to extract data from the web and transform it with Power Query. Build Power BI visuals from a Wikipedia table of metropolitan statistical areas.

Explore how to transform data in Power BI using fill, pivot, append, and merge to shape tables, reconcile Excel data, and join datasets with left, right, or inner joins.

Learn to use fill, pivot, and inner join during merge in Power BI with Power Query to clean and transform Excel and Gap Minder data.

Learn how to modify columns in Power Query by splitting a column by position, removing the product label, merging columns with a dash, and creating a color class from examples.

Use Power Query parameters to drive changes in Power BI without editing code, enabling parameterized connections, filters, and server/database values that can be updated in the service after deployment.

Learn to create and apply parameters in Power Query to centralize server and database names, switch environments, and filter data with a date parameter.

Learn how to configure incremental refresh in Power BI with range start and end parameters in Power Query, applying a date filter to refresh only new data.

Power BI incremental refresh for the orders table by creating range start and end parameters, applying filters, and setting archive and refresh rules to automatically fetch new data.

Explore DAX, the summarization language used in Power BI, and learn to create measures for aggregations, implicit summarization, running totals, and year-over-year analyses.

Learn to create DAX measures in report and data views, using distinct count, total sales amount, and context to drive accurate Power BI insights.

Create and manage columns and tables in Power BI using Power Query and Dak's, learn when to duplicate tables, use a blank Dak's container, and build tables with add columns.

Create new columns and calculated table in Power BI, combine city name and state to form city state, and compute profit as price minus cost with two decimals.

Use quick measures in Power BI to create measures without writing DAX in no-code environment. Auto-name measures reveal the DAX while time intelligence and aggregations operate with a date table.

Create quick measures in Power BI to calculate sales from new customers using a marked date table and date key, then explore iterative max calculations across territory and country.

Delve into creating dax measures in Power BI, covering naming conventions, data type formatting, use of variables with return, and best practices for readable, reusable measures.

Explore creating and renaming measures in Power BI, using variables and filtering by profit to classify large profits and format results for visuals.

Explore common DAX functions for creating measures in Power BI, including calculate and filter context, aggregation and time functions, and how to handle row context with iterative functions.

Explore common DAX techniques to create measures in Power BI, including calculating max country percent, iterating with sumx, and using calculate with filters and keepfilters for North America.

Reuse measures and variables to build modular dax in Power BI, improving readability, performance, and maintenance, by embedding calculations and using switch instead of if statements.

Learn modular DAX techniques in Power BI by consolidating measures with a total order amount and implementing a switch-based discount using SUMX over orders to apply quantity-based pricing.