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.

Learn to create and manage fabric workspaces, assign admin, contributor, and viewer roles, and configure settings. Pin favorites, manage access, and integrate with OneDrive, Azure, Git, and Power BI.

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.

Learn to prepare and load data into a lake house with Microsoft Fabric Power BI, configure data flows gen two via the Power Query Online Editor, set destinations, and publish.

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.

Create an SQL view that calculates the total sales amount by month from the date key, grouping by month number, and save it in the lake house.

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.

Attach a lake house to notebooks by using the one lake data hub to select an existing lake house or create a new lake house in the current workspace.

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.

Explore Microsoft Fabric notebooks to visualize NYC taxi data from a lakehouse. Create and interpret distributions, bins, scatter plots, box plots, heatmaps, and correlation visuals with Seaborn and pandas.

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.

Connect Power BI to a Fabric lakehouse via direct link and direct query, load NYC taxi predictions, and build an end-to-end report with slicers and visuals.

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.

Set up a reflex in data activator to monitor Redmond shipments, trigger a temperature out-of-range alert (33 to 41 degrees), and email the shipping team when violations occur.

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.

Create a data flow gen2 in Microsoft Fabric by importing data from various sources, transforming with Power Query Editor, merging customers with order counts, and publishing to a Lake House.

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.