icon icon

Microsoft Fabric in Practice: From Lakehouse to Apache Spark – A Comprehensive Data Analytics Course

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Understand Fabric architecture - You will learn how Microsoft Fabric works in terms of architecture, data team roles, and network backbone, so you can better judge how to apply the platform in your own environment.

icon

Set up the platform yourself - You will go through Microsoft Fabric configuration and activation step by step, so after the course you can start working faster and avoid common implementation mistakes.

icon

Master the Lakehouse approach - You will understand how a Lakehouse differs from a traditional data warehouse and when to use it, helping you design modern analytics solutions with better architectural decisions.

icon

Work with data in Lakehouse - You will learn to explore, transform, and analyze data in Fabric Lakehouse, then present the results, so you can move from raw data to useful insights much more efficiently.

icon

Run Apache Spark in practice - You will learn Spark requirements, environment setup, and session initialization, giving you confidence to launch processing jobs and prepare the platform for larger data workloads.

icon

Process data with Spark and SQL - You will load data into DataFrames, perform transformations, and use Spark SQL, which will help you prepare datasets for analysis and reporting in a practical, repeatable way.

icon

Use Delta Lake effectively - You will learn how to create and modify Delta Lake tables and track change history, making it easier for you to maintain data consistency, versioning, and control over updates.

icon

Automate data flows - You will work with Gen2 dataflows and Data Factory pipelines, learning how to copy data, trigger processes, and monitor execution to build more reliable ETL and integration flows.

Training programme

1. Introduction to Microsoft Fabric

  • discussion of the architecture and key functionalities,
  • benefits of implementing the platform,
  • the role of data teams and backbone network infrastructure.

2. Configuration and activation of the platform

  • practical aspects of configuration,
  • the process of enabling and the first steps,
  • best implementation practices.

3. Lakehouse Concept

  • definition of Lakehouse as a modern approach to data analytics,
  • differences between traditional data warehouses and Lakehouse,
  • examples of applications in Microsoft Fabric.

4. Working with Fabric Lakehouse

  • data exploration in the Lakehouse environment,
  • data transformation,
  • visualization of analysis results.

5. Introduction to Apache Spark

  • basics of the architecture and requirements for Spark,
  • configuration of the Spark environment,
  • initialization of the session and launching the platform.

6. Operations on data in Apache Spark

  • loading data into Spark DataFrame,
  • data transformations and preparation for analysis,
  • working with data using the SQL language and the Spark SQL API.

7. Data Visualization in Spark

  • techniques for presenting analysis results,
  • use of  visualization tools,
  • optimization of data presentation.

8. Working with Delta Lake tables

  • discussion of the concept and advantages of Delta Lake,
  • creating and modifying Delta tables,
  • data versioning and change history.

9. Acquiring data using Gen2 dataflows

  • basics of how dataflows (Gen2) work,
  • benefits and limitations of the solution,
  • examples of integrating dataflows in Microsoft Fabric.

10. Automation and monitoring of data pipelines

  • introduction to pipelines in the Data Factory service,
  • practical exercises in copying data and using templates,
  • techniques for running and monitoring data flows.

What are the prerequisites for participating in the training?

icon

Data analysis basics - You should understand core data concepts such as tables, columns, records, and simple transformations so you can work comfortably with the hands-on exercises.

icon

SQL familiarity - You should be able to write basic SQL queries, including filtering, selecting columns, and simple joins, because these operations will appear in Spark SQL tasks.

icon

Cloud environment skills - You should feel comfortable working with browser-based cloud interfaces, configuring resources, and navigating service portals used to manage platform settings.

icon

Basic data handling - You should have experience loading files, reviewing datasets, and interpreting analysis results so you can focus on Fabric tools rather than core data basics.