About This Course
The course explores how to implement data analytics solutions on a single platform with Microsoft Fabric. How to integrate, transform, and store data to train AI models and create insightful reports. Among others, the course will cover data analytics, data engineering, data integration, data management, data modeling, information protection and governance, data storage and data visualization
Audience Profile
- Data Analyst, Data Engineer, Data Scientist
Course Details
Introduction to Microsoft Fabric:
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
Get started with lakehouses in Microsoft Fabric:
- Explore the Microsoft Fabric lakehouse
- Work with Microsoft Fabric lakehouses
- Explore and transform data in a lakehouse
- Exercise – Create a Microsoft Fabric lakehouse
Use Apache Spark in Microsoft Fabric:
- Preparing to use Apache Spark
- Run Spark code
- Work with data in a Spark dataframe
- Work with data using Spark SQL
- Visualize data in a Spark notebook
- Exercise – Analyze data with Apache Spark
Work with Delta Lake tables in Microsoft Fabric:
- Understand Delta Lake
- Create delta tables
- Optimize delta tables
- Work with delta tables in Spark
- Use delta tables with streaming data
- Exercise – Use delta tables in Apache Spark
Orchestrate processes and data movement with Microsoft Fabric:
- Understand pipelines
- Use the Copy Data activity
- Use pipeline templates
- Run and monitor pipelines
- Exercise – Ingest data with a pipeline
Ingest Data with Dataflows Gen2 in Microsoft Fabric:
- Understand Dataflows Gen2 in Microsoft Fabric
- Explore Dataflows Gen2 in Microsoft Fabric
- Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
- Exercise – Create and use a Dataflow Gen2 in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric:
- Understand data warehouse fundamentals
- Understand data warehouses in Fabric
- Query and transform data
- Prepare data for analysis and reporting
- Secure and monitor your data warehouse
- Exercise – Analyze data in a data warehouse
Get started with data science in Microsoft Fabric:
- Understand the data science process
- Explore and process data with Microsoft Fabric
- Train and score models with Microsoft Fabric
- Exercise – Explore data science in Microsoft Fabric
Prerequisites
- Be familiar with basic data concepts and terminology, including data engineering, modeling, and analysis
