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
