Microsoft Fabric Masterclass: A Unified Data &Analytics Tool

Navigate the Microsoft Fabric home to access items across workspaces, switch product experiences, and use the navigation pane, search, filters, and favorites to manage lake houses, warehouses, notebooks, and reports.

Navigate the fabric settings pane to manage preferences, resources and extensions, governance and insights, and power BI items, datasets, storage management, and gateways.

Explore how to use the Fabric help pane, a feature-aware, context-sensitive search and guidance hub that surfaces docs, forums, and recommended topics for your current Fabric screen.

Explore lakehouse concepts with Microsoft fabric in end-to-end introduction. Build a lakehouse using the bronze, silver, and gold medallion layers and understand data unification that eliminates silos and reduces costs.

Create a lake house in a workspace, import a CSV via a data flow, publish and refresh, then query the SQL endpoint to aggregate row counts by buying group.

Build a report from the WWE Lake House dataset by auto creating visuals, adjust measures, and save to a workspace, with sharing and export options.

Integrate Microsoft Fabric with Power BI, load data into a lake house using Dataflows Gen2 and pipelines, build a dimensional model, and generate a report of latest sales figures.

Orchestrate a data pipeline in Microsoft Fabric using data flows, data sources, and a lake house with a named pipeline and Office 365 Outlook failure alerts.

Explore building a semantic model in the lakehouse by creating a star schema with a fact online sales and related dimension tables, defining relationships, cardinality, and cross-filter directions for analytics.

Learn to create DAX measures in Microsoft Fabric, building a basic total sales amount from the fact online sales using the formula editor and commit, with potential for more measures.

Auto create a report from your modeled data to visualize and explore quickly, with dynamic updates and personalized visuals saved to a workspace.

Review the end-to-end workflow from Microsoft Fabric to Power BI, building a lake house, loading data, creating a semantic model, DAX, a view, relationships, and a customizable report.

Microsoft Fabric's data science workflow—from ingesting and cleaning data to training models and generating insights—with Power BI visuals. Use Spark, Python tools, Delta Lake, and Mlflow for end-to-end analytics.

Ingest the NYC taxi yellow dataset into a fabric lakehouse using Spark and Delta Lake format. Create NYC taxi_raw in the lakehouse with optimized Delta writes for scalable analytics.

Cleanse and prepare the NYC taxi dataset with Apache Spark notebooks, derive date features, apply filters to remove outliers, and save to a prep delta table for ML training.

Train and register a Lightgbm regression model in Microsoft Fabric using mlflow to log hyperparameters and metrics for the NYC Taxi Trip Duration experiment.

Perform batch scoring on a cleaned dataset, load the trained Lightgbm regressor, and save predictions to a delta table in Fabric lakehouse, with SQL previews and Power BI visualization plans.

Explore data activator, a no-code Microsoft Fabric experience that automatically triggers actions when data patterns or thresholds are met, monitoring Power BI data and alerting users or starting workflows.

Explore the core concepts of data activator: events as streams from data sources, objects and object instances, triggers that fire on conditions, and properties to reuse logic across triggers.

Learn to pull data from Power BI into data activator, set alerts when thresholds are met, and configure triggers with reflex items in your workspace.

Explore Microsoft Fabric Data Factory, a data integration tool to ingest, transform, and move data from sources to a lakehouse and data warehouse with fast copy, data flows, and pipelines.

Explore Microsoft Fabric's data factory experience, blending low-code AI-enabled data preparation with Azure Data Factory scale to build automated data pipelines for ingesting, transforming, end-to-end integration across hybrid multi-cloud connectivity.

Explore essential Microsoft Fabric resources, including the home page, blogs, community, GitHub readiness, webinars, documentation, guided tours, status dashboard, and the support portal to accelerate learning.

Celebrate completing this Microsoft Fabric course and solidify your mastery of distributed systems; share your certificate on LinkedIn to attract employers or collaborators and continue learning through real world projects.