Face to face / Online closed & onsite training. Restaurant lunch included at STL venues.
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.
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
Arguably, the most experienced and highest motivated trainers.
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
A hot lunch is provided at local restaurants near our venues:
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).
Available throughout the day:
Regular breaks throughout the day.
Contains unit objectives, exercises and space to write notes
Available online. 100+ pages with step-by-step instructions
Your questions answered on our support forum.
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.
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.
• 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.
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.
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.
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.
• 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.
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.
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.
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.
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 content...
Excellent
Mott MacDonald
Data Engineer
The 2-day Power BI course I attended was the best software training event I have attended.
"The trainer, Jens, was obviously hugely passionate and knowledgeable about the software. ... Lunch at the local Italian restaurant in Bloomsbury was very nice too, lots of comments the portions were BIG....
The course also provided a huge reference manual for my future use and a support forum for 2 years which I anticipate will come in very useful as I already have a list of new questions to ask since completing the course."
Tutorials and discussions on MS Office
MS Office tips to save you time
MS Office shortcut keys for all versions
Handy info on industry trends
Latest news & offers
Loading content...
Call for assistance
We will call you back