Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 34 Minute(s)
Language
English
Taught by
Makram Amor
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Step-by-Step BI Project-Based Course on real use case Master Data Warehousing, Processing and Integration with Fabric
Get ready to dive into the practical aspects of data management with Fabric in this hands-on, project-based course. Designed for data professionals and engineers, this course walks you through real-world scenarios, focusing on a use case scenario frequently encountered when working with Microsoft Fabric
What you'll learn:
Creating and Managing Data Warehouses: Learn how to set up Bronze, Silver, and Gold data warehouses in Fabric.
Create a modern Lakehouse architecture: Medallion architecture
Automating Data Refresh: Master the creation and execution of stored procedures to automate data refreshes.
View and Table Management: Understand how to create, drop, and manage views and tables efficiently.
Learn about the semantic models in MS Fabric
Power BI Integration: Link your data warehouse to Power BI, and create dynamic reports and dashboards.
Troubleshooting Common Issues: Gain the skills to troubleshoot and resolve common data management challenges.
Who this course is for:
Data Analysts and Business Intelligence Professionals looking to enhance their practical skills with Fabric.
IT Professionals responsible for managing data warehouses.
Anyone interested in learning how to manage data efficiently and create dynamic reports with Power BI.
Course Features:
Step-by-Step Instructions: Follow along with detailed steps to set up and manage your data warehouse.
Real-World Example: Engage with practical examples and tasks based on real-world scenarios.
Interactive Projects: Apply what you learn through interactive projects that simulate actual data management tasks.
Resources and Support: Access supplemental resources and get support to help you succeed in your learning journey.
Course Content
- 5 section(s)
- 36 lecture(s)
- Section 1 Quick Introduction Microsoft Fabric ( Optional if you Already know Fabric)
- Section 2 ETL - Data Ingestion
- Section 3 ETL - Data Transformation and Loading
- Section 4 Power BI Integration, Reporting and Automation
- Section 5 Additional Lectures
What You’ll Learn
- Set Up Data Ingestion In Fabric using different methods Pipelines, Dataflows Gen 2 and Pyspark Notebooks
- Clean and Transform Data : Set up data flows in Data Factory to clean and transform the raw data. Apply filters and remove duplicates as necessary.
- Aggregate and Process Data: Create additional data flows or Stored Proc to aggregate and process the cleaned data. Store the processed data in the GoldenDWH.
- Prepare Data for Reporting: Prepare the final dataset for the Power BI report, optimizing it for performance. Use the Gold Layer data to create the BI reports
- Automate the Workflow: Schedule the data pipelines to run daily. Set up triggers and alerts in Data Factory to notify stakeholders via email about the pipeline
- Configure Access Control Implement role-based access control (RBAC) to manage access to each layer of the medallion architecture.
Skills covered in this course
Reviews
-
AAdam Sawicz
Stored procedure to move the data from one layer to another was a great feature
-
SSrini Ramnath
It was a good course overall. the course covered all the main parts of the Fabric but would be great it would have included to use of more solutions like Pyspark Notebooks
-
HHenry Adam Jr
Simple and covers a real use case
