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.

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.

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.

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.

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.

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.

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 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.

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 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.

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

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.

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.

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.

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.

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.

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 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.