Introduction to Microsoft Fabric

Who is this course for?

Designing and structuring data in a modern cloud infrastructure whilst balancing the need for security and analytics is a growing business need.

This two day training course has been designed to orientate learners with the Microsoft Fabric platform and explain how this works End to End.

This course is suitable for those new to data analytics with awareness of Azure, SQL and Power Bi who are looking to growing their skills update to the latest features from Fabric.

Benefits

Day 1 - Introduction to Fabric Analytics:

Overview of Microsoft Fabric unified analytics platform for End-to-End analytics
Key components in the platform including to Synapse data, Power Bi and Data factory

Data Modelling and Management:

Understanding key concepts in data modelling with Fabric
Designing and managing Lakehouses and data warehouses
Creating and exploring best practices for data modelling in Fabric

Data Processing with Apache Spark:

Learning how to utilise Apache Spark within Fabric
Understanding the benefits and use cases of Apache Spark in Fabric
Running Spark code and working with dataframes
Implementing a data processing task using Apache Spark

Data Transformation and Delta Lake:

Understanding the concept of Delta Lake and its role in data transformation
Learning how to implement data transformations using Delta Lake tables with Streaming Data
Exploring and implementing best practices for data transformation in Fabric

Day 2 - Data Ingestion and Pipelines:

Understanding the process of data ingestion in Fabric
Learning how to create and manage data pipelines
Exploring best practices for data ingestion and pipeline management in Fabric
Creating and managing a Dataflow (Gen2) pipeline in Fabric

Security, Governance, and Compliance:

Understanding the importance of data security, governance, and compliance Fabric Architect vs Administrator
Implementing a security measure and a governance policy in Fabric

Real Time Analytics:

Understanding Synapse Real time analytics
KQL Database and Tables
Write Queries with KQL

Data Science:

Explore Data Science
MLGlow to Track experiments

Performance Optimisation:

Understanding the techniques for optimising data analytics solutions in Fabric
Learning how to optimise queries and improve performance

Face-to-face training

Training is held in our modern, comfortable, air-conditioned suites.

Modern-spec IT, fully networked with internet access

Lunch, breaks and timing

A hot lunch is provided at local restaurants near our venues:

• Bloomsbury
• Limehouse

Courses start at 9:30am.

Please aim to be with us for 9:15am.

Browse the sample menus and view joining information (how to get to our venues).

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Online training

Regular breaks throughout the day.

Learning tools

In-course handbook

Contains unit objectives, exercises and space to write notes

Reference material

Available online. 100+ pages with step-by-step instructions

24 months access to Microsoft trainers

Your questions answered on our support forum.