Microsoft Fabric for Data Analysts

In this course, you will be introduced to Microsoft Fabric as an integrated platform for modern data analytics. You will learn how to collect, clean, structure and transform data into semantic models and visualizations. Through realistic, hands-on assignments you will work with Lakehouses, Warehouses and Pipelines to build a complete workflow: from raw data all the way to dashboards in Power BI.

What you learn

• The architecture and main components of Microsoft Fabric.

• Loading and transforming data using Data Pipelines and Dataflows.

• Working with Lakehouses and Warehouses as storage and processing structures.

• Designing and optimizing semantic models for analytics.

• Visualizing and sharing insights with Power BI within Fabric.

After this course you will be able to:

• Execute an end-to-end data analytics process in Microsoft Fabric independently.

• Integrate, transform and model data from multiple sources.

• Build and visualize a semantic model using Power BI.

• Use Microsoft Fabric as a central environment for data-driven decision-making.

For whom

• Data engineers and BI specialists.

• Data analysts and data scientists working with Microsoft technologies.

• Professionals who want to simplify and modernize their data architecture using Microsoft Fabric.

Prerequisites

• Basic knowledge of SQL and Power BI.

• Understanding of data architecture or ETL processes is recommended.

• Programming experience in Python is useful but not required.

Content (global program)

Part 1

• Introduction to Microsoft Fabric.

• Overview of architecture and components (OneLake, Lakehouse, Warehouse, Power BI).

Part 2

• Loading and transforming data.

• Working with Data Pipelines and Dataflows (theory + hands-on practice).

Part 3

• Working with Lakehouses and Warehouses.

• Structuring and organizing data for analytics workloads.

Part 4

• Building and optimizing semantic models.

• Model design, relationships, measures and performance considerations.

Part 5

• Visualization with Power BI & end-to-end workflow.

• From raw data to dashboard: integrating all components and course evaluation.