Learn PowerBI from scratch - With Portfolio Projects

Install Power BI Desktop on Windows via the Microsoft Store or the official website, with Mac users using virtualization or the online Power BI service.

Explore Power BI connectors to link desktop to Excel, CSV, databases, cloud services, and more, using Get Data, to import data from multiple sources into a single unified data model.

Connect Power BI to Excel via the Excel connector, import a named table or range, and learn when to load or transform data for initial insights; refresh updates data.

Learn how to import CSV files into Power BI using the CSV file connector, understand CSV basics, encoding, delimiter, and automatic data type detection, then load data into Power BI.

Connect Power BI to a SQL database using the PostgreSQL connector and import mode. Create and import a view named view sales summary to streamline data and reduce load.

Master data transformation in Power Query Editor and use data profiling tools—column quality, distribution, and profile—to clean and standardize data for analysis in Power BI.

Learn practical data transformation in Power Query Editor by loading multiple CSV datasets into Power BI, cleaning data, removing rows and columns, promoting headers, and tracking changes with applied steps.

Learn to enhance datasets in the Power Query editor by renaming fields, adding an index column, and creating columns with conditional logic or column from examples for date and time.

Explore data transformation in Power BI and Power Query, including grouping by product key to total quantity, pivoting and unpivoting to long formats, and merging and appending queries for analysis.

Master Power Query transformations in Power BI with M code, using the Advanced Editor to understand applied steps, reuse transformations across similar datasets, and tailor data types, headers, and columns.

Learn Power BI data modeling essentials, including fact and dimension tables, primary and foreign keys, and one-to-many relationships, then build star or snowflake schemas.

Explore data analysis expressions DAX in Power BI to create dynamic measures and calculated columns, enabling advanced calculations and interactive insights.

Explore calculated columns and measures in Power BI, compare their row-by-row versus on-the-fly calculations, and learn when to use each for revenue calculations and dynamic aggregations.

Explore aggregate functions in DAX within Power BI, including sum, average, count, and distinct count, and learn how to create measures in a dedicated measure table to summarize data.

Learn to create date tables in Power BI with DAX, using the calendar and calendar auto functions to build dynamic date ranges for filtering and time-based visuals.

Explore date and time functions in DAX to create and convert dates, extract year, month, and day, and use today, now, weekday, and week number for Power BI projects.

Explore time intelligence functions in DAX that perform date-range calculations with calendar awareness in Power BI. Create year-to-date, quarter-to-date, and month-to-date revenue measures using order date.

Learn DAX logical functions in Power BI, including the IF, SWITCH, AND, OR, IFERROR, and IN, with practical examples classifying revenue and quantity.

Explore DAX calculate and filter functions in Power BI to compute total revenue by year, define high value sales, and fix totals using the ALL function.

Explore data visualization with Power BI to turn raw data into compelling visuals and interactive dashboards that tell stories, reveal insights, and support informed decisions.

Explore the Power BI report view to design and arrange visuals on the canvas. Use the ribbon, panes, visuals, and filters to create interactive, insightful reports.

Explore Power BI basics by creating bar, column, line, and donut charts; add data fields and use cross-filtering to tell your data story.

Explore the visualization pane to customize visuals, switch visual types, and format colors, labels, and titles using the format and analytics tabs for clear, engaging Power BI reports.

Master filtering and slicing in Power BI to create interactive reports with visual, page, and report level filters, plus slicers that drive dynamic data exploration.

Explore advanced visualization types in Power BI, including maps, bubble-sized measures, and tables, then import custom visuals for richer, interactive analytics.

Master Power BI visuals by using small multiples and enhanced tooltips to add insights, including how legends, age group and continent influence charts, and how to create tooltip pages.

Learn Power BI from scratch by building a healthcare dashboard end-to-end, covering requirements gathering, data collection, transformation, and modeling, then create visualizations with interactivity and stakeholder feedback.

Learn to blueprint a healthcare Power BI dashboard with wireframes and stakeholder approval, then build visuals and dynamic measures like latest month wait list, previous year, and switchable averages.

Polish a healthcare dashboard in Power BI by arranging visuals, adding a side filter pane, slicers, and a logo; create a detailed matrix view and publish to Power BI service.

Celebrate completing Power BI mastery by applying data import, transformation, modeling, and visualization skills to real-world projects, build a portfolio, and pursue certification.