Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Module 1 – Overview of Microsoft Fabric
- Introduction to the platform architecture and its constituent elements.
- Exploring integration points with Microsoft 365 and other Microsoft services.
- Distinguishing the functional differences between Data Factory, Synapse, and Fabric.
Module 2 – Workspace Creation and Management
- Explaining the purpose and structure of Fabric Workspaces.
- Steps for creating and effectively organizing Workspaces.
- Implementing permission frameworks and access control strategies.
Module 3 – The Fabric Lakehouse
- Defining the Lakehouse paradigm: the fusion of Data Lakes and Data Warehouses.
- Setting up a Lakehouse instance within Microsoft Fabric.
- Techniques for importing, managing, and maintaining data assets.
Module 4 – Utilizing Notebooks in Fabric
- Introduction to notebook environments supporting Python and SQL.
- Creating and executing notebooks directly within the Fabric interface.
- Applying notebooks for exploratory analysis and complex data transformations.
Module 5 – Pipelines and Visual ETL
- Understanding ETL principles as they apply to Microsoft Fabric.
- Developing visual pipelines for streamlined data ingestion and transformation processes.
- Configuring schedules and monitoring data flow performance.
Module 6 – The Data Warehouse
- Building and configuring Data Warehouses within Fabric.
- Designing table models and establishing data relationships.
- Connecting the warehouse to various external data sources and architectural layers.
Module 7 – The Semantic Model
- Defining the semantic model and explaining its critical role in analytics.
- Procedures for creating and refining analytical models.
- Implementing measures, hierarchies, and Key Performance Indicators (KPIs).
Module 8 – Developing Reports with Power BI
- Establishing connections between Power BI and the underlying semantic model.
- Applying best practices for effective dashboard design and user experience.
- Strategies for sharing insights and publishing reports within the Fabric ecosystem.
Course Recap and Future Directions
Requirements
- A solid grasp of fundamental data concepts and cloud computing services.
- Practical experience with analytics tools such as Power BI or SQL.
- Basic familiarity with Microsoft 365 environments.
Target Audience
- Data analysts and data engineers.
- Business intelligence developers.
- IT specialists working within Microsoft data platform landscapes.
