Microsoft Fabric – basic course

Why take this course

If you are involved in data analysis or report creation but are constantly lacking a single, consistent tool to unify all your tasks, this training will introduce you to Microsoft Fabric to streamline your workflow and gain comprehensive data insights. You will be able to assess the potential of this tool and leverage its capabilities in your daily work.

What you'll learn

• You will understand the capabilities of Microsoft Fabric and its key components, such as Power BI, Data Warehouses, and Semantic Models.
• You will learn how to integrate and schedule ETL (Extract, Transform, Load) processes.
• You will learn to work with Spark notebooks and create and manage Data Warehouses.
• You will be able to create and manage semantic models and learn the best practices for data modeling.
• You will discover how to create reports and visualizations in Power BI, using various chart types, filters, and slicers.

Who is this course for

This training is designed for data analysts, report creators, and non-technical individuals who want to understand the principles of Microsoft Fabric. It is also ideal for decision-makers who need to evaluate the tool’s potential for their organization.

Topics covered

Introduction

• What is Fabric?
• Key components: OneLake, Lakehouse, Spark, Data Warehouse, Semantic Model, Power Query, Power BI
• Demonstration of Fabric environment and user interface

Data Factory

• Data ingestion and transformation (e.g. Power Query)
• Integration and scheduling of ETL processes

Lakehouse

• Lakehouse structure overview
• Working with Spark notebooks
• File management and data connection

Warehouse

• Creating and configuring
• Loading and transforming data
• Creating views

Semantic Models / Power BI

• Creating and managing semantic models
• Relationships, star schema, best modeling practices
• Introduction to DAX expressions
• Security and access management

Power BI Reporting & Visualization

• Slicers, filters, bookmarks
• Power BI Services & Dashboards
• Visualization types – practical use cases