Let’s make it work for you
Overview
Microsoft Fabric is a unified software-as-a-service platform that brings together data engineering, data integration, analytics, and business intelligence. It enables organisations to design, build, and manage end-to-end analytics solutions within a single environment.
This course equips learners with the skills to implement enterprise-grade analytics solutions using Microsoft Fabric. It focuses on the full analytics lifecycle, including data ingestion, transformation, storage, modelling, and visualisation. Learners will work with core Fabric components such as Lakehouse, data pipelines, notebooks, semantic models, and integrated Power BI capabilities.
Through practical scenarios and guided exercises, learners will explore how to design scalable, secure, and maintainable analytics architectures. The course also covers governance, access control, and best practices to support reliable decision-making across the organisation.
Prerequisites
Before attending this course, learners should have:
- Experience working with data and analytics solutions
- Familiarity with Power BI or similar reporting tools
- A general understanding of data modelling concepts
- Basic knowledge of data transformation and querying
Target audience
This course is designed for professionals involved in designing, building, or managing analytics solutions, including:
- Data analysts responsible for reporting and insights
- Analytics engineers building data pipelines and models
- Business intelligence professionals delivering dashboards and reports
- Technical professionals implementing analytics platforms
It is ideal for individuals looking to adopt Microsoft Fabric as a modern, unified analytics platform.
Delegates will learn how to
By the end of this course, learners will be able to:
- Describe the core components and architecture of Microsoft Fabric
- Design and implement Lakehouse-based analytics solutions
- Ingest and transform data using pipelines and notebooks
- Build and manage semantic models for reporting and analysis
- Implement security, governance, and access control mechanisms
- Deliver insights through integrated Power BI reporting
Outline
Introduction to Microsoft Fabric
This module introduces the Microsoft Fabric platform and its role in modern analytics.
- Overview of Microsoft Fabric architecture
- Key workloads and capabilities
- Understanding unified analytics in a SaaS environment
- Comparing Fabric with traditional analytics platforms
- Exploring real-world use cases
Working with data ingestion in Fabric
This module focuses on bringing data into Fabric from multiple sources.
- Overview of data ingestion patterns
- Creating and managing data pipelines
- Connecting to cloud and on-premises data sources
- Scheduling and monitoring data ingestion workflows
- Handling data quality and reliability
Data transformation and processing
This module explores how to clean, transform, and prepare data for analysis.
- Using notebooks for data transformation
- Introduction to Spark-based processing in Fabric
- Data wrangling and preparation techniques
- Managing transformation workflows
- Optimising performance for large datasets
Lakehouse architecture and data storage
This module covers how to design and manage data storage using the Lakehouse approach.
- Understanding the Lakehouse concept
- Creating and managing Lakehouse environments
- Working with files, tables, and structured data
- Organising data for analytics workloads
- Implementing best practices for storage design
Building semantic models
This module focuses on creating structured data models for analytics and reporting.
- Introduction to semantic modelling
- Designing data models for performance and usability
- Creating relationships and measures
- Managing datasets within Fabric
- Optimising models for reporting scenarios
Reporting and analytics with Power BI
This module explores how to deliver insights using integrated reporting tools.
- Connecting Power BI to Fabric data sources
- Designing interactive reports and dashboards
- Implementing visualisation best practices
- Sharing and collaborating on reports
- Enabling self-service analytics
Security and governance in Fabric
This module covers essential practices for securing and governing analytics solutions.
- Understanding security concepts in Fabric
- Managing user roles and permissions
- Implementing data access controls
- Monitoring usage and activity
- Supporting compliance and governance requirements
Managing and maintaining analytics solutions
This module focuses on operational aspects of Fabric solutions.
- Monitoring performance and workloads
- Managing workspaces and resources
- Troubleshooting common issues
- Implementing lifecycle management practices
- Ensuring scalability and reliability
Best practices for enterprise analytics
This module brings together key principles for building robust analytics solutions.
- Designing for scalability and performance
- Ensuring data consistency and accuracy
- Applying governance frameworks
- Supporting collaboration across teams
- Aligning analytics with business objectives
Exams and assessments
There are no formal exams included in this course. Learners will complete knowledge checks and practical review activities throughout the course to confirm understanding of Microsoft Fabric concepts and implementation tasks.
Hands-on learning
This course includes practical, guided learning designed to help learners apply Microsoft Fabric skills in realistic analytics scenarios.
Learners will take part in hands-on activities such as:
- Creating and managing Microsoft Fabric workspaces and Lakehouse environments
- Building data pipelines to ingest data from different sources
- Using notebooks to transform and prepare data for analysis
- Creating tables, relationships, measures, and semantic models
- Connecting Fabric data sources to Power BI reports and dashboards
- Applying access controls, governance settings, and monitoring practices
Frequently asked questions
How can I create an account on myQA.com?
There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.
If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".
If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.
Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.
How do QA’s virtual classroom courses work?
Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.
We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.
How do QA’s online courses work?
QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course.
Once you have purchased the Online course and have completed your registration, you will receive the necessary details to enable you to immediately access it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.
All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.
When will I receive my joining instructions?
Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.
When will I receive my certificate?
Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.