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
- 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..
Course Content
- Quick Introduction Microsoft Fabric ( Optional if you Already know Fabric) –> 5 lectures • 17min.
- ETL – Data Ingestion –> 14 lectures • 54min.
- ETL – Data Transformation and Loading –> 8 lectures • 45min.
- Power BI Integration, Reporting and Automation –> 5 lectures • 21min.
- Additional Lectures –> 4 lectures • 12min.
Requirements
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.