Implementing a Lakehouse with Microsoft Fabric -koulutuksessa perehdytään mitä tarkoittaa Microsoft Fabric ja Lakehouse.
Tavoite
Tavoitteena on saada yleiskäsitys Microsoft Fabricista keskittyen Lakehouse-konseptiin.
Kenelle
Koulutus on suunnattu Data-ammattilaisille, jotka mm. mallintavat ja analysoivat dataa, kuten Data Analyst, Data Engineer, Data Scientist.
Koulutuksen sisältö
Create a lakehouse
- Create a workspace and assign the workspace to a Fabric capacity
- Create and manage shortcuts to other lakehouse data in the same workspace
- Create tables, including managed and external
Ingest data
- Upload files using the lakehouse explorer
- Ingest data by using a data pipeline, dataflow, or notebook
- Schedule data pipelines, dataflows, and notebooks
Transform data
- Implement a star schema, including Type 1 and Type 2 slowly-changing dimensions
- Transform columns
- Shape tables
- Implement data cleansing
- Implement file partitioning
- Load transformed data into a Delta table
Perform exploratory analytics
- Query data by using the SQL analytics endpoint
- Create relationships between tables
- Analyze data by using the default semantic model
Avainsanat
Microsoft Fabric, Lakehouse, Apache Spark, Delta Lake