Who is this training for?
- Individuals with PL-300 certification or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing.
- Professionals who want to use Microsoft Fabric to build and deploy enterprise-wide data analytics solutions.
Training objectives
- Understand the architecture and core components of Microsoft Fabric to design end-to-end analytics solutions
- Design, implement, and manage enterprise-wide data analytics solutions
- Prepare, integrate, and transform data from multiple sources using dataflows, pipelines, and notebooks
- Create and optimize lakehouses, data warehouses, and semantic models to support analytics needs
- Develop Powerful analytical models and reporting with Power BI and DAX
- Automate and orchestrate data flows and analytical processes
- Implement data governance, security, and compliance mechanisms
- Manage the lifecycle of analytics solutions, including deployment, monitoring, and performance optimization
Summary
This course covers the methods and practices for implementing and managing enterprise-wide data analytics solutions using Microsoft Fabric. Attendees will build on their existing analytics experience and learn how to use Microsoft Fabric components, including Lakehouses, data warehouses, notebooks, data flows, data pipelines, and semantic models, to build and deploy analytics assets.
Course outline
- Introduction to end-to-end analytics using Microsoft Fabric
- Administer Microsoft Fabric • Integrate data with Dataflows Gen2 in Microsoft Fabric
- Integrate data with Spark and Microsoft Fabric notebooks
- Use Data Factory pipelines in Microsoft Fabric
- Get started with Lakehouses in Microsoft Fabric
- Organize a fabric lake house using an architectural inset design
- Use Apache Spark in Microsoft Fabric
- Work with Delta Lake tables in Microsoft Fabric
- Get started with data warehouses in Microsoft Fabric
- Load data into a Microsoft Fabric data warehouse
- Query a data warehouse in Microsoft Fabric
- Monitor a Microsoft Fabric data warehouse
- Understand scalability in Power BI
- Create Power BI model relationships
- Use tools to optimize Power BI performance
- Apply Power BI model security
Approach and methodology
Practical and structured approach combining focused theory and guided workshops. Participants gradually develop their expertise as a Microsoft Fabric Analytics engineer through concrete exercises inspired by professional scenarios, promoting immediate application of the learnings. They learn how to design analytics solutions, model data, and leverage the capabilities of Microsoft Fabric to transform and unlock the value of data at scale. Led by a Microsoft certified trainer, the training focuses on interactivity and the development of directly transferable technical skills to design modern analytical solutions in a professional context.
Prerequisites
Prior experience in building and deploying enterprise-level data analytics solutions.
Recommendations
- Solid foundation in data analytics and BI Knowledge of Power BI (modeling, visualization)
- Proficiency in SQL and Python (asset) Understanding of data modeling and warehouse/lakehouse concepts
- Familiarity with Microsoft Fabric or Azure Data environments
