Microsoft Power BI - Beginner to Pro

Connect to various data sources in Power BI Desktop using Get Data, preview and transform data in Power Query Editor, and configure data source settings to load data.

Explore data transformation with Power Query Editor in Power BI, cleaning and filtering raw data to prepare accurate, complete data for modeling and analysis.

Clean and transform a two-year e-commerce dataset in Power Query Editor by removing nulls, splitting names and contact info, extracting year, rearranging columns, and filtering and sorting by product.

Transform data in power query editor by appending datasets, merging, removing duplicates, and creating an id column with a conditional rating and city name mapping for clean market sales data.

Explore data transformation in Power Query Editor by cleaning a three-year layoff dataset: fix nulls, remove duplicates, capitalize location, calculate total and remaining employees, and group by industry for insights.

Break a data set into four tables—sales, customer, movie, and date—using Power Query Editor, to create a sales fact table and related dimension tables for Power BI data modeling.

Explore how to organize data with the dimensional data model and star schema, building fact and dimension tables, defining relationships, and using Power BI to model data.

Learn to create and edit data model relationships in Power BI, understand cardinality and cross-filter direction, and manage active or inactive relationships and primary key–foreign key connections.

Explore data analysis expressions (DAX) in Power BI, learn what DAX is, its uses, and how to write DAX syntax, operators, and functions for calculated columns, measures, and tables.

Shows how to use DAX in Power BI to create a sales rating column and measures for average sales, total quantity, and total sales using IF, AVERAGE, SUM, and SUMX.

Apply DAX to change cross-filter direction between related tables and count entries in a column. Extract shipping year and delivery year using dot notation.

Learn to compute cumulative sales with dax using calculate, filter, all selected, and max, create delivery and shipping measures, and consolidate them into a key measures table for visualization.

Discover how data visualizations in Power BI transform data into insights using visuals like card, area, donut, and pie charts, and learn to build interactive reports.

Enhance your Power BI reports with interactive visuals, navigation, tooltips, and drill-through, then publish to Power BI service or on-premises report server, and configure mobile layouts.

Learn to identify trends and patterns in Power BI using data segmentation, clustering, binning, and advanced analytics such as forecasting and AI visuals for sales insights.

Learn to build and publish paginated reports with Paginated Report Builder, compare it to Power BI Desktop, and export outputs to PDF, Excel, CSV, and XML.

Create and manage dashboards in power bi using interactive visuals and real-time data. Differentiate dashboards from reports and customize layouts, themes, and collaboration.

Configure the on-premises data gateway and schedule daily data refreshes in Power BI. Manage dataset permissions and implement row-level security to tailor access for executives.

Create and manage Power BI workspaces and apps to organize dashboards, reports, and datasets for collaborative and external sharing, with licensing and audience controls.

Learn what PL 300 Power BI data analysis exam covers, including data preparation, modeling, visualization and deployment, its prerequisites and format, and how to prepare for the exam and interviews.