Regular Price: £480 Batch Price: From £480 📅 View Dates & Prices Group Booking Discount: From £300 per person 🧮 Calculate & Book 1-to-1 Training: £600 📋 Booking Request Form Course Overview Microsoft Fabric for Data Analytics & Engineering is a practical 12-hour instructor-led course designed to introduce learners to Microsoft's unified platform for data integration, engineering, warehousing, analytics and business intelligence. Participants will learn how to work with OneLake, create Lakehouses and Warehouses, ingest and transform data using Data Factory, build data pipelines, query data with SQL, and prepare analytical data for reporting. Learners will also explore how Microsoft Fabric integrates directly with Power BI to create semantic models, reports and end-to-end analytics solutions. Through hands-on exercises and a practical project, learners will follow the complete data journey from source data through ingestion, transformation and storage to analysis and reporting. The course is suitable for Data Analysts, BI professionals, SQL users and aspiring Data Engineers who want practical experience with the Microsoft Fabric ecosystem. Requirements Previous experience with Microsoft Fabric is not required. Participants should have a basic understanding of working with data and should ideally have experience with SQL, Microsoft Power BI, Microsoft Excel or another data analysis tool. Basic SQL knowledge, including concepts such as SELECT, filtering, grouping and joins, is recommended but not mandatory for all parts of the course. Previous Python, PySpark or data engineering experience is not required for the core 12-hour course. Learners will need access to an appropriate Microsoft Fabric environment. Some practical features require a Fabric trial or paid capacity and appropriate workspace permissions. We highly recommend you complete the following course(s) before attending the Microsoft Fabric for Data Analytics & Engineering course: SQL for Beginners You may also complete the following course(s) before attending the Microsoft Fabric for Data Analytics & Engineering course but they are not mandatory: Microsoft Power BI for Beginners SQL Intermediate to Advanced Data Analysis with Python Data Engineering with Python & SQL Course Content Introduction to Microsoft Fabric Understanding Microsoft Fabric Why organisations use unified data and analytics platforms Overview of Data Engineering, Data Factory, Data Warehouse and Power BI Understanding Microsoft Fabric workspaces Understanding Fabric capacities Introduction to OneLake Understanding Fabric items and workloads Overview of an end-to-end Fabric analytics architecture OneLake & Microsoft Fabric Storage Understanding OneLake OneLake as the shared storage layer in Fabric Understanding files and tables Introduction to Delta tables Structured and unstructured data Understanding Lakehouse, Warehouse and other storage options Introduction to OneLake shortcuts Choosing an appropriate storage approach Working with Fabric Lakehouses Understanding the Lakehouse architecture Creating a Lakehouse Exploring files and tables Loading data into a Lakehouse Working with Delta tables Understanding the SQL analytics endpoint Querying Lakehouse tables with SQL Understanding how Lakehouses support both engineering and analytics workloads Data Ingestion with Data Factory Introduction to Data Factory in Microsoft Fabric Understanding data ingestion Creating data connections Copying data into Fabric Understanding source and destination data Creating simple data pipelines Using pipeline activities Running and monitoring pipeline executions Understanding scheduled data loads Data Transformation with Dataflows Gen2 Introduction to Dataflows Gen2 Using Power Query Online Selecting and filtering data Changing data types Handling missing and inconsistent values Creating calculated columns Combining and transforming datasets Loading transformed data into Fabric Using Dataflows within analytical workflows Data Warehousing with Microsoft Fabric Understanding the role of a Data Warehouse Lakehouse vs Warehouse Creating a Fabric Warehouse Understanding tables and schemas Loading data into a Warehouse Querying data using T-SQL Creating views for analytical use Understanding fact and dimension tables Introduction to dimensional modelling SQL Analytics in Microsoft Fabric Using SQL within Fabric Running SELECT queries Filtering and sorting analytical data Grouping and aggregating data Joining related tables Querying Lakehouse data through the SQL analytics endpoint Querying Fabric Warehouse data Preparing analysis-ready datasets Power BI & Semantic Models in Fabric Understanding the relationship between Fabric and Power BI Introduction to semantic models Connecting analytical data to Power BI Understanding tables and relationships Creating basic measures Building report visuals Creating interactive reports Understanding Direct Lake at a conceptual level Moving from engineered data to business insights Monitoring, Security & Managing Fabric Solutions Understanding workspace roles and permissions Managing access to Fabric items Monitoring pipeline runs Identifying failed pipeline activities Understanding refresh and scheduling Introduction to data governance concepts Understanding development and production considerations Managing and organising Fabric items Practical Microsoft Fabric Project Create a Fabric workspace Create a Lakehouse Ingest source data Clean and transform the data Create reusable pipeline steps Store prepared data in Lakehouse or Warehouse tables Query the data with SQL Create or use a semantic model Build a Power BI report Run the complete workflow from source data to business insight Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Australian Central Time (Adelaide) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Training venue: Unit 15, Boardman House, 64 Broadway, Stratford, London E15 1NT, United Kingdom Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information