Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Instructor-led training -

Introduction to Microsoft FabricIntroduction to Microsoft Fabric

Face to face / Online closed & onsite training. Restaurant lunch included at STL venues.

  • 2 days Instructor-led

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.

Introduction to Microsoft Fabric

Benefits

Learn the key features of the Fabric platform including OneLake, Synapse data and Data Factory

Understand how to leverage Microsoft Fabric to have a unified and governed single source of data

Course Syllabus

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:

Overview of 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:

Overview of Synapse Real time analytics
KQL Database and Tables
Write Queries with KQL

Data Science:

Overview of 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

"What do I get on the day?"

Arguably, the most experienced and highest motivated trainers.

Face-to-face training

lunch

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

online training (virtual)

Regular breaks throughout the day.

Learning tools

in-course handbook

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.

What to expect when training

Training Formats & Services

Training formats available

  • On-site at your company office UK wide
  • Closed group at one of our London training venues
  • Near-site at a location close to you
  • Bespoke one-to-one basis
  • Tailored training courses to your requirements
  • Executive coaching & mentoring

What is the Introduction to Microsoft Fabric course about?

This 2-day course provides a foundational understanding of Microsoft Fabric, a unified analytics platform that integrates data engineering, data science, real-time analytics, and business intelligence. You’ll learn the basics of Fabric’s components, including Data Factory and Dataflows Gen2 for data integration, OneLake and Lakehouse for storage, Synapse Data Science and MLFlow for machine learning, Synapse Real-Time Analytics with KQL for real-time insights, and Power BI for visualisation and reporting. The course also covers governance and security using Microsoft Purview, ensuring you can confidently start working with Fabric in your organisation.

Who should take this course?

This course is ideal for data professionals new to Microsoft Fabric, including data analysts, data engineers, business intelligence professionals, and IT managers. No prior experience with Fabric is required, making it perfect for beginners. However, a basic understanding of data concepts (e.g., databases, data processing) and familiarity with Microsoft 365 will be beneficial. If you’re looking to explore Fabric’s capabilities and understand how it can streamline your organisation’s data workflows, this course is a great starting point.

What are the key benefits of taking this course?

• Foundational Knowledge: Gain a comprehensive overview of Microsoft Fabric and its core components over 2 days, setting a strong foundation for further learning or implementation.

• Practical Skills: Learn to perform essential tasks like data integration with Data Factory, storage with OneLake, and reporting with Power BI, through hands-on examples.

• Understand Key Features: Explore Fabric’s capabilities in data science, real-time analytics, and governance, preparing you to leverage these tools in your organisation.

• Stay Ahead of Trends: Get introduced to a platform that 90,000 organisations, including many Fortune 500 companies, are adopting in 2025, driven by its AI integration and unified data management.

• Tailored Training: This course is offered as closed group training at customer sites or online, customised to your organisation’s needs. No public schedule course is currently available.

How is the course delivered?

The Introduction to Microsoft Fabric course is a 2-day training programme offered as closed group training, delivered either at customer sites or online. This allows for a customised learning experience tailored to your organisation’s specific requirements, whether you prefer an in-person session at your location or a virtual training environment. Please note that no public schedule course is currently offered, ensuring a focused and private training experience for your team.

What are the prerequisites for this course?

No prior experience with Microsoft Fabric is required, making this course accessible to beginners. However, a basic understanding of data concepts—such as databases, data processing, or business intelligence—will help you get the most out of the training. Familiarity with Microsoft 365 and its ecosystem (e.g., Power BI or Azure) is beneficial but not mandatory. If you’re completely new to data analytics, you might find it helpful to review introductory resources on Microsoft Learn before attending.

Why is Microsoft Fabric becoming essential for data professionals?

Microsoft Fabric is rapidly becoming a cornerstone for data professionals, with an estimated 90,000 organisations—roughly 30% of Power BI’s enterprise user base—adopting it by early 2025. The global data fabric market, valued at £2.1 billion in 2024, is growing at a 21.2% CAGR, driven by the need for unified data management and AI-driven insights, according to Fortune Business Insights.

Fabric’s ability to integrate tools like Data Factory, Synapse, and Power BI into a single platform has enabled organisations to reduce analytics deployment times by up to 75%, with some firms onboarding in just four months compared to the typical 18, as reported by PwC. Its AI capabilities, such as Copilot and Azure AI Foundry, align with the trend that over 75% of data models will integrate AI by 2025, making Fabric an essential tool for modern data workflows.

What product trends are shaping Microsoft Fabric’s role in the industry?

• AI Integration: Fabric’s AI features, like Copilot and Azure AI Foundry, enable automation and intelligent insights, reflecting the growing demand for AI-driven analytics.

• Unified Data Management: OneLake provides a centralised data lake, simplifying access and governance across diverse data sources, a key trend in data management.

• Real-Time Analytics: With Synapse Real-Time Analytics and KQL, Fabric meets the increasing need for processing streaming data and enabling faster decision-making.

• Industry-Specific Solutions: Fabric offers tailored analytics for sectors like healthcare and finance, addressing the trend of specialised data solutions for unique industry challenges.

• Security and Governance: Integration with Microsoft Purview ensures robust governance and security, a critical feature as organisations face growing compliance demands.

How does this course prepare me for further Microsoft Fabric training or certifications?

This 2-day introductory course provides the foundational knowledge needed to pursue advanced Microsoft Fabric training, such as the Advanced Microsoft Fabric – Best Practice course, or certifications like DP-600 (Microsoft Fabric Analytics Engineer). It covers essential concepts like data integration, storage, real-time analytics, and governance, which are key topics in Fabric-related exams. By completing this course, you’ll be well-prepared to dive deeper into Fabric’s advanced features or start your certification journey with confidence.

What kind of practical experience will I gain?

Over the 2 days, you’ll engage in hands-on exercises to apply what you learn. You’ll explore tasks like moving and transforming data with Data Factory and Dataflows Gen2, storing data in OneLake and Lakehouse, creating basic machine learning models with Synapse Data Science, querying real-time data with KQL, and building reports in Power BI. You’ll also learn how to monitor and govern your Fabric environment using Microsoft Purview, giving you practical skills to start using Fabric in your organisation.

How can I access Microsoft Fabric for hands-on practice?

To participate in the course exercises, you’ll need a Microsoft 365 work account with a Fabric licence or trial enabled. If you don’t have one, you can set up a free Microsoft 365 Developer Account and activate a Fabric trial for learning purposes. STL Training can provide guidance on setting up your account, or you can follow instructions in beginner tutorials on Microsoft Learn or TechCommunity.

What if I have more questions about the course?

For additional enquiries, you can contact us or explore Microsoft Learn, where you’ll find self-paced modules, learning paths, and updates on Fabric’s latest features to complement your training.

Loading...

Loading content...

TrustPilot

star star star star star Excellent

Resources

Blog

Tutorials and discussions on MS Office

Hints & Tips

MS Office tips to save you time

Cheat sheets

MS Office shortcut keys for all versions

Infographics

Handy info on industry trends

Subscribe

Latest news & offers

Promotions

Latest Feedback

  • 98.70% customer recommendation
  • 99.19% training objectives met
  • 226,755 delegates trained
  • 14,566 organisations trained

Latest X / Tweet

  • Boost productivity & profitability with STL Training! 💼 ✅ No course cancellations 🖥️ Virtual or in-person in London 🍽️ Lunch included 📚 2 years of support This week: Word Intermediate—graphics, Excel data stl-training.co.uk/order/pricing_…t.co/QSQqMqK3Go
Loading...

Loading content...

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.