Learn Microsoft Power BI in Microsoft Fabric - 2 in 1 Course

Explore Microsoft Fabric, an AI-powered all-in-one analytics platform that unifies data across data lake, data engineering, data integration, real-time analytics, Power BI, Synapse, and Data Factory.

Explore Microsoft Fabric as an end-to-end, unified analytics platform that combines data factory, Synapse, Data Explorer, and Power BI to enable real-time, governed insights across the organization.

Explore Microsoft Fabric’s integrated analytics experiences—Power BI, Data Factory, Synapse Data Engineering, Synapse Data Science, Synapse Data Warehouse, and Synapse Real-Time Analytics—designed for end-to-end data workflows.

Discover how to create and manage Microsoft Fabric workspaces, control access with granular workspace rules (admin, member, contributor, viewer), and configure OneDrive, Azure connections, and Git integration for fast navigation.

Compare Power BI Desktop and Power BI Service, noting how Desktop handles data modeling and report creation locally while Service enables cloud-based dashboards and collaboration.

Learn to integrate Microsoft Fabric with Power BI, ingest data using Dataflows Gen2 and pipelines into a lake house, build a dimensional model, and generate a sales report.

Configure lake house data destinations with the power query template, mapping dim date, dim employee, dim store, dim customer, and fact online sales. Publish and rename the data flow.

Orchestrate a data pipeline by configuring a data flow in the lake house, adding an Office 365 outlook mail on failure notification, and scheduling daily runs.

Create semantic model in lakehouse by defining relationships in star schema, using sql endpoint to link a fact online sales with dimension tables through many-to-one active relationships.

Create a simple DAX measure to calculate total sales amount by summing the sales amount in the fact online sales table, using the formula editor and commit.

Create a SQL view that calculates total sales amount by month from the fact online sales table, saving the view in the lake house for easy future access.

Review the end-to-end workflow from Microsoft Fabric to Power BI, create a lake house, load data, build a semantic model and relationships, and craft a customizable report to gain insights.

Explore how to upload pbix and rdl files to Power BI service within Microsoft Fabric, manage workspaces, and publish dashboards from Power BI Desktop and Report Builder.

Explore creating a Power BI report from a published data set in Microsoft Fabric, auto-create visuals, customize fields, and export or embed live data for insights.

Create a KPI scorecard in Power BI within Microsoft Fabric to track key metrics. Connect to data, set current values and targets, and configure rules, notifications, and subscriptions.

Import datasets from excel or csv, or paste data, preview the table, and create a report or paginated report in Power BI Fabric workspace, with options to share and refresh.

Publish and manage Power BI apps from workspaces, create audience-specific content, and distribute via app marketplace or direct links. Control permissions and interactivity for app consumers.

Learn to use the matrix in Power BI to manage KPIs with scorecards, track trends, filter for on track, completed, or risk, and view KPI history and targets.

Explore monitoring hub in fabric to view and manage Power BI items in one place, filter by status and item type, refresh data, and review run histories.

Explore real-time data in Power BI through three streaming options—push data set (api with an underlying database), Azure Stream (temporary cache, no report visuals), and PubNub streaming (direct tile visuals).

Explore settings across Microsoft Fabric and Power BI, including preferences, resources, extensions, governance and insights, and manage dashboards, datasets, and data sources.

Find answers in Power BI via search, the official documentation, blogs, and learning paths; rely on the Power BI community, webinars, and context-sensitive help.

Wrap up the course by reviewing Power BI in Microsoft Fabric, covering basics, data loading and visualization, AI features, and responsible use with hands-on resources.