Microsoft Fabric Advanced

Who is this course for?

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

Benefits

This course will further develop the learners skills and practical knowledge of working with the Fabric environment

Course Syllabus

"What do I get on the day?"

Arguably, the most experienced and highest motivated trainers.

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.

Training Formats & Services

What is the Advanced Microsoft Fabric – Best Practice course about?

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.

Who should take this course?

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).

What are the key benefits of taking this course?

• 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.

How is the course delivered?

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.

What are the prerequisites for this course?

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.

Why is Microsoft Fabric gaining popularity?

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.

What product trends are shaping Microsoft Fabric’s development?

• 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.

How does this course prepare me for Microsoft Fabric certifications?

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.

What kind of practical experience will I gain?

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.

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

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.

What if I have more questions about the course?

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.