Microsoft Fabric AdvancedFace to face / Online closed & onsite training. Restaurant lunch included at STL venues.
This one day follow up session has been designed to further develop skills with Fabric.
It will cover the recent developments in Microsoft Fabric and discuss the best practice use of key areas. Questions that will be considered include:
Where should things be stored SQL Server or Lakehouse,
Best method for Data flow
when to use different artifacts
Updates to Fabric
Recent changes and updates in Microsoft Fabric which could include the following
AI functions
* AI Functions (Preview): AI functions for data engineering with GenAI
* Approximate String Matching (Preview): Fuzzy string matching in SQL database
* AutoML Code-First Preview: Automates machine learning workflows
* Azure Data Factory Item: Integration with existing Azure Data Factory
* OPENROWSET (Preview): Available in Data Warehouse
Enhanced Governance: Improved governance and cost control[/list]
Storage options
Best practices for choosing the right storage solution
Use cases and scenarios for Lakehouse vs SQL Server
Data Flow and Access to Objects in the Warehouse
Designing efficient data flows
Ensuring access to warehouse objects for analytics and reporting
Using Different Artifacts in Fabric
Best practices for using OneLake, Synapse, Data Factory, and Power BI
Techniques for optimising data analytics solutions
Improving query performance and data processing efficiency
Governance
Implementing security measures and understanding enhanced governance
Real-Time Analytics and Data Science
Leveraging Synapse for real-time analytics
Exploring data science capabilities and tracking experiments with MLGlow
Data Transformation and Ingestion
Implementing data transformations using Delta Lake
Best practices for data ingestion and pipeline management
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 one-day follow-up course is designed to deepen your skills in Microsoft Fabric, a unified analytics platform. It covers recent updates to Fabric, including AI functions (preview), fuzzy string matching in SQL, and AutoML Code-First Preview for automated machine learning workflows. You’ll explore best practices for choosing storage solutions (Lakehouse vs. SQL Server), designing efficient data flows, ensuring access to warehouse objects for analytics, and implementing governance and security measures. The course also dives into real-time analytics with Synapse, data science capabilities with MLGlow, and data transformation using Delta Lake, equipping you with practical knowledge to optimise your data workflows.
This course is ideal for data professionals, including data engineers, data analysts, and data scientists, who want to advance their expertise in Microsoft Fabric. It’s particularly suited for those with some experience in data modelling, analytics, or engineering, such as professionals who have completed certifications like PL-300 (Power BI Data Analyst) or DP-203 (Azure Data Engineer). Learners should be familiar with basic data concepts and have some experience with programming languages like SQL, PySpark, or Kusto Query Language (KQL).
• Stay Updated: Learn about the latest Microsoft Fabric updates, including AI-driven features like Copilot and Azure OpenAI Service integration, which are driving Fabric’s adoption as a leading platform.
• Practical Skills: Gain hands-on experience with data ingestion, transformation, and real-time analytics, using tools like Synapse, Data Factory, and Delta Lake.
• Optimise Workflows: Master best practices for storage, data flow design, and query performance to enhance your organisation’s data processing efficiency.
• Enhanced Governance: Understand how to implement security measures and cost control strategies, leveraging Fabric’s integration with Microsoft Purview for unified governance.
• Career Growth: Position yourself as a valuable asset in a market where 90,000 organisations, including many Fortune 500 companies, are adopting Fabric in 2025.
• 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 Advanced Microsoft Fabric – Best Practice course is 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. Please note that no public schedule course is currently offered, ensuring a focused and private training environment for your team.
You should have a foundational understanding of data analytics and engineering concepts, such as data preparation, modelling, and analysis. Familiarity with Microsoft Fabric or related tools like Power BI, Azure Data Factory, or Synapse Analytics is beneficial but not required. Experience with one of the following languages is recommended: SQL, PySpark, or KQL. If you’re new to Fabric, consider our Introduction to Microsoft Fabric course.
Microsoft Fabric is seeing rapid adoption, with an estimated 90,000 organisations—roughly 30% of Power BI’s enterprise user base—using 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 demand 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 led to significant efficiency gains, with some organisations cutting analytics deployment times by up to 75%. Additionally, Fabric’s 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 it a critical tool for modern data professionals.
• AI Integration: Fabric’s focus on AI, with features like Copilot and Azure AI Foundry, reflects the growing trend of AI-driven analytics. These tools help automate tasks, provide intelligent suggestions, and enable advanced machine learning model deployment.
• Unified Data Management: The rise of OneLake as a centralised data lake simplifies governance and access, addressing the industry’s need for unified data solutions across diverse sources.
• Real-Time Analytics: Fabric’s Real-Time Intelligence capabilities cater to the increasing demand for processing streaming data and event-driven scenarios, enabling faster decision-making.
• Industry-Specific Solutions: Fabric offers tailored solutions for various industries, such as healthcare and finance, aligning with the trend of providing specialised analytics tools to meet unique sector challenges.
• Security and Governance: With data security a top priority, Fabric’s integration with Microsoft Purview ensures robust governance, a critical feature as enterprises face growing compliance demands.
This course contributes to the skills needed for certifications like DP-600 (Microsoft Fabric Analytics Engineer) and DP-700 (Microsoft Fabric Data Engineer). It covers key exam topics such as data ingestion, transformation, real-time analytics, and governance, while providing practical experience with Fabric’s advanced features. Please note the course is not designed as a stand-alone preparation for any certification but will assist in combination with approved learning resources.
You’ll work on real-world scenarios, such as designing data flows, implementing Delta Lake for data ingestion, and using Synapse for real-time analytics. The course includes hands-on exercises like exploring data science capabilities with MLGlow, optimising query performance, and setting up governance measures to secure your data environment. These practical applications ensure you can immediately apply your skills in your day-to-day job.
To follow along with 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 enable a Fabric trial for learning purposes. Instructions for setting up these accounts are often provided in beginner tutorials, such as those on Microsoft Learn or TechCommunity.
For additional enquiries, you can reach out to us. You can also explore further resources on Microsoft Learn, where you’ll find self-paced modules, learning paths, and updates on Fabric’s latest features.
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
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
