Microsoft Power BI Bootcamp: Beginner (Zero) to Hero Analyst

Explore the Power BI Desktop interface in detail, including the ribbon, panes, and all three views, and learn when to use Report View, Data View, and Model View during report development.

Learn how to navigate the Power BI Desktop interface, switch between Report, Data, and Model views, and confidently locate essential tools like ribbons, panes, and visual controls.

Learn the major Power BI data source categories and understand Import, DirectQuery, and Live Connection modes so you can choose the best option for each business scenario.

Discover how to connect Power BI to common data sources including Excel, SQL databases, SharePoint, cloud platforms, and web APIs, with practical guidance for real-world use.

This lecture demonstrates how to connect Power BI Desktop to multiple data sources including Excel, CSV files, SQL Server databases, and web data, with a focus on previewing and loading data efficiently.

Learn the ETL process and explore the Power Query Editor interface, applied steps, data profiling, query folding, and how Power BI prepares data for analysis.

Understand how Applied Steps work in Power Query and learn M language fundamentals to control, customize, and optimize data transformation workflows.

Perform essential Power Query transformations including column operations, data type corrections, filtering, text cleaning, and handling nulls and errors.

Explore the Power Query Editor and learn essential data transformation techniques such as removing columns, changing data types, filtering rows, and handling errors to prepare clean datasets for analysis.

Learn advanced Power Query techniques to restructure data using splitting, merging, pivoting, unpivoting, and grouping for optimal Power BI modeling.

Master advanced Power Query techniques including splitting and merging columns, pivoting and unpivoting data, grouping records, and creating custom columns for more powerful data modeling.

Learn how to append and merge queries in Power Query and apply query folding techniques to optimize performance with large and complex datasets.

Learn how to append and merge queries using different join types, understand query folding, and build unified datasets from multiple tables and data sources for optimized performance.

Learn how to design Power BI data models using the star schema, understand the roles of fact and dimension tables, and see why this structure is essential for performance and usability.

Master Power BI relationships by understanding cardinality, active and inactive relationships, and how cross-filtering controls data behavior and calculation results.

In this lecture, you’ll build a complete Power BI data model by creating table relationships, configuring cardinality and cross-filter direction, managing active and inactive relationships, and organizing hierarchies to support accurate, high-performance analysis using a star schema approach.

Learn DAX syntax fundamentals and understand the critical differences between calculated columns and measures, including when and why to use each.

Master essential DAX functions used in everyday Power BI analysis, including aggregation, logical conditions, text manipulation, and date calculations.

In this lecture, you’ll learn the fundamentals of DAX by creating calculated columns and measures using common aggregation, logical, text, and date functions, while clearly understanding the difference between columns and measures and how each impacts your Power BI reports.

Understand how filter context and row context work in DAX and learn how context transition enables measures to behave correctly inside complex calculations.

Learn how to use CALCULATE and related functions to modify filter context, ignore or replace filters, and build advanced, flexible Power BI measures.

In this lecture, you’ll gain a clear, practical understanding of how DAX evaluation contexts work, with a step-by-step walkthrough of the CALCULATE function, advanced filtering techniques, and context transition for building powerful, context-aware measures.

Learn how to use DAX iterator functions like SUMX, RANKX, and TOPN to perform row-level calculations, rankings, and top-N analysis efficiently.

Master Power BI time intelligence by building proper date tables and creating year-to-date, period-over-period, and rolling window calculations with DAX.

In this lecture, you’ll get a complete, step-by-step walkthrough of Power BI time intelligence using DAX, including how to build and mark a proper date table, apply Year-to-Date, Month-to-Date, and Quarter-to-Date calculations, and create powerful previous-period and custom time comparisons using functions like SAMEPERIODLASTYEAR, DATEADD, and DATESBETWEEN for real-world business analysis.

Learn professional DAX patterns for customer and product segmentation, running totals, and performance optimization using variables.

This lecture provides a deep dive into advanced DAX patterns in Power BI, covering iterator functions such as SUMX, AVERAGEX, RANKX, and TOPN, along with dynamic segmentation, ABC classification, and running total calculations. You’ll also learn how to use the VAR keyword to simplify complex logic and optimize DAX expressions for better performance, helping you build efficient, scalable measures for real-world business scenarios.

Learn essential data visualization principles and how to choose the right Power BI visual types to communicate insights accurately, clearly, and effectively.

Explore Power BI’s standard and advanced visuals, including configuration options, interactivity, and custom visuals, to build professional, user-friendly reports.

In this hands-on walkthrough, you’ll learn how to build, configure, and format all major Power BI visuals—including charts, tables, maps, KPIs, and custom visuals—to effectively communicate insights across different data scenarios.

Learn proven dashboard design principles to create clear, focused, and actionable Power BI dashboards tailored to different audiences and business goals.

Explore core Power BI interactivity features that allow users to filter, drill, and explore data dynamically for deeper insight and self-service analytics.

This practical walkthrough teaches you how to add interactivity to Power BI reports using slicers, filters, cross-highlighting, drill-down features, and tooltips to create intuitive, user-friendly analytical experiences.

Learn how to use bookmarks, buttons, navigation, and parameters to create highly dynamic, scenario-driven, and user-controlled Power BI reports.

In this advanced walkthrough, you’ll learn how to use bookmarks, buttons, navigation, field parameters, and what-if analysis to build dynamic, guided, and highly interactive Power BI reports with a strong user experience focus.

Learn how Power BI Service is structured, how workspaces organize content and permissions, and how dashboards provide high-level monitoring and collaboration.

Master Power BI content distribution using apps, direct sharing, and subscriptions to deliver insights securely and effectively at scale.

This complete walkthrough shows you how to publish reports to Power BI Service, work with workspaces and dashboards, share content securely, and configure subscriptions and data alerts for effective collaboration.

Learn how to configure scheduled refresh, manage credentials, and use gateways to keep Power BI datasets up to date and reliable in production.

In this walkthrough, you’ll learn how to install and configure the Power BI On-premises Data Gateway, set up scheduled dataset refreshes, manage refresh timing, and troubleshoot common connectivity issues to keep your data up to date automatically.

Learn how to implement and manage static and dynamic Row-Level Security in Power BI to control data access based on user identity and business rules.

This walkthrough teaches you how to implement and test static and dynamic Row-Level Security in Power BI using DAX, validate role behavior in Desktop, and assign users to roles in the Power BI Service to securely control data access.

Learn how to manage Power BI environments using tenant settings, licensing models, monitoring tools, and security best practices to ensure compliance and scalability.

This walkthrough provides a practical overview of the Power BI Admin Portal, showing you how to manage tenant settings, licenses and capacity, monitor usage metrics, and configure security and compliance options for effective governance.