Microsoft Fabric Training
What you'll learn
- Introduction
- OneLake & Lakehouses
- Data Activator
- Copilot in Fabric
- Data Science
- Data Factory
- Data entities
- Power BI & Semantic Models
Course content
8 modules • 40Hrs Duration
Introduction
- Get started with Microsoft Fabric
- Setting up the environment
OneLake & Lakehouses
- OneLake
- Workspaces
- Lakehouses
- Exploring workspaces
- Create a lakehouse
- Load data into lakehouse
- Load data into tables
- Exploring Delta Tables
- Using Dataflow Gen 2
- OneLake file explorer
- Using SQL analytics endpoint
- Build a visual query
- Creating shortcuts
- Managing access & sharing
Data Activator
- Data Activator Overview
- Add data from Eventstream
- Create Reflex from Power BI data
- Setting up Triggers
- Create Triggers from Objects
Copilot in Fabric
- Data integration
- Real-time intelligence
- Business intelligence
- Data Engineering
- Spark in Fabric
- Creating a data frame
- Exploring the notebooks
- Uploading & reading files
- Connect a lakehouse
- Defining the schema
- Filtering Data
- Modify Schema
- Adding columns
- Aggregating & Grouping
- Using functions
- Joining Data Frames
- Writing files to lakehouse
- Writing to Delta Tables
- Spark SQL queries
- Temporary views
- Using Python & SQL
- Scheduling notebooks
- Integrating notebooks in pipelines
- Spark settings
- Spark job definition
- Schedule Spark job definition
Data Science
- Data Science Introduction
- Setup of Notebook & Load Data
- Creating Pandas Data frame
- Data Cleansing using Data Wrangler
- Exploratory Analysis – Distributions
- Feature Impact Analysis
- Feature Engineering
- Connecting the results to Power BI
- Setting up experiments & understanding models
- Split and Sample Training Data
- Train Model
- Exploring Experiment & Metrics
- Understanding ROC & Precision Recall Curve
- Comparing different models
- Save run as ML model
- Applying the ML model
Data Factory
- Azure Data Factory & Data Pipelines
- Copy Data Activity
- Adding Data Flow Gen 2 to Pipeline
- Disable Staging for better performance
- Schedule Data Pipeline
- Troubleshoot & Monitor Data Pipeline
Data Warehouses
- What is a warehouse
- Creating a data warehouse
- Create Table
- INSERT & UPDATE data
- Alter Table Schema
- Calculating columns & Schema Updates
- COPY INTO command
- Copy Data using Pipeline
- Referencing SQL endpoints from Lakehouses
- Cloning tables
- Modify Semantic Model and Create Reports
Power BI & Semantic Models
- Understanding semantic models
- Using semantic models in Power BI
- Create new semantic model
- Creating measures
- Connect to Fabric from Power BI Desktop
- Using SQL endpoint
- Auto Create Reports
- Creating Apps
- Updating & Deleting Apps
Trainers recent project activities
- Successful data migration and code migration from AX 2012 to Dynamics 365 for Operations 10.0.12 version.
- PowerApps Timesheet management application, in integration with Dynamics 365 for Operations.
- Complete module design and architecture development for Estimation process in Dynamics AX 2012.
- Custom Embedded Power BI report creation for Dynamics 365 Asset Management.
Prerequisites
Basic understanding of data management Familiarity with cloud computing concepts
Who this course is for
- Dynamics 365 Finance and Operations consultants
- Microsoft Fabric beginners
- IT Professionals and Data Analysts
- Business Intelligence Experts
- Decision-Makers and Strategic Planners
- Anyone interested in enhancing their data capabilities
This course includes
Certificate of completion
Case Studies: 2 Mini Projects
