Syvennä osaamistasi yritystason data-analytiikkaratkaisuissa Microsoft Fabric -alustan avulla.
Tavoite
Tämä koulutus tarjoaa sukelluksen Microsoft Fabric:n maailmaan, joka on yritystason data-analytiikkaratkaisujen toteuttamisen työkalu. Käymme läpi Microsoft Fabric:n komponentit, kuten Lakehouse, Data Warehouse, Notebooks, DataFlows, Data Pipelines ja Semantic Models, ja opetamme, kuinka niitä voidaan käyttää tehokkaasti analytiikkaratkaisujen toteuttamiseen.
Kenelle
Koulutus on suunnattu data-analytiikan asiantuntijoille ja datainsinööreille, arkkitehdeille sekä kaikille, jotka haluavat hallita Microsoft Fabric -tekniikat. Se on erinomainen tilaisuus laajentaa osaamista ja syventää ymmärrystä data-analytiikan alalla.
Lisätiedot
Koulutus valmentaa Microsoftin viralliseen DP-600 Implementing Analytics Solutions Using Microsoft Fabric -sertifiontitestiin.
Suosittelemme, että osallistujilla on jo Power BI -osaaminen (esim. PL-300 Microsoft Power BI Data Analyst tai vastaava) sekä perustiedot SQL:stä ja Pythonista. Tämä koulutus on loistava tapa viedä urasi seuraavalle tasolle data-analytiikan alalla.
Koulutuksen sisältö
Module 1: Administer Microsoft Fabric
Lessons
- Describe Fabric admin tasks.
- Navigate the admin center.
- Manage user access.
Module 2: Ingest Data with Dataflows Gen2 in Microsoft Fabric
Lessons
- Describe Dataflow (Gen2) capabilities in Microsoft Fabric
- Create Dataflow (Gen2) solutions to ingest and transform data
- Include a Dataflow (Gen2) in a pipeline
Module 3: Ingest data with Spark and Microsoft Fabric notebooks
Lessons
- Ingest external data to Fabric lakehouses using Spark
- Configure external source authentication and optimization
- Load data into lakehouse as files or as Delta tables
Module 4: Use Data Factory pipelines in Microsoft Fabric
Lessons
- Describe pipeline capabilities in Microsoft Fabric
- Use the Copy Data activity in a pipeline
- Create pipelines based on predefined templates
- Run and monitor pipelines
Module 5: Get started with lakehouses in Microsoft Fabric
Lessons
- Describe core features and capabilities of lakehouses in Microsoft Fabric
- Create a lakehouse
- Ingest data into files and tables in a lakehouse
- Query lakehouse tables with SQL
Module 6: Organize a Fabric lakehouse using medallion architecture design
Lessons
- Describe the principles of using the medallion architecture in data management.
- Apply the medallion architecture framework within the Microsoft Fabric environment.
- Analyze data stored in the lakehouse using DirectLake in Power BI.
- Describe best practices for ensuring the security and governance of data stored in the medallion architecture.
Module 7: Use Apache Spark in Microsoft Fabric
Lessons
- Configure Spark in a Microsoft Fabric workspace
- Identify suitable scenarios for Spark notebooks and Spark jobs
- Use Spark dataframes to analyze and transform data
- Use Spark SQL to query data in tables and views
- Visualize data in a Spark notebook
Module 8: Work with Delta Lake tables in Microsoft Fabric
Lessons
- Understand Delta Lake and delta tables in Microsoft Fabric
- Create and manage delta tables using Spark
- Use Spark to query and transform data in delta tables
- Use delta tables with Spark structured streaming
Module 9: Get started with data warehouses in Microsoft Fabric
Lessons
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage datasets within a data warehouse
Module 10: Load data into a Microsoft Fabric data warehouse
Lessons
- Learn different strategies to load data into a data warehouse in Microsoft Fabric.
- Learn how to build a data pipeline to load a warehouse in Microsoft Fabric.
- Learn how to load data in a warehouse using T-SQL.
- Learn how to load and transform data with dataflow (Gen 2).
Module 11: Query a data warehouse in Microsoft Fabric
Lessons
- Use SQL query editor to query a data warehouse.
- Explore how visual query editor works.
- Learn how to connect and query a data warehouse using SQL Server Management Studio.
Module 12: Get started with data warehouses in Microsoft Fabric
Lessons
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage datasets within a data warehouse
Module 13: Monitor a Microsoft Fabric data warehouse
Lessons
- Monitor capacity unit usage with the Microsoft Fabric Capacity Metrics app.
- Monitor current activity in the data warehouse with dynamic management views.
- Monitor querying trends with query insights views.
Module 14: Understand scalability in Power BI
Lessons
- Describe the importance of building scalable data models
- Implement Power BI data modeling best practices
- Use the Power BI large dataset storage format
Module 15: Get started with data warehouses in Microsoft Fabric
Lessons
- Describe data warehouses in Fabric
- Understand a data warehouse vs a data Lakehouse
- Work with data warehouses in Fabric
- Create and manage datasets within a data warehouse
Module 16: Create Power BI model relationships
Lessons
- Understand how model relationship work.
- Set up relationships.
- Use DAX relationship functions.
- Understand relationship evaluation
Module 17: Use tools to optimize Power BI performance
Lessons
- Optimize queries using performance analyzer.
- Troubleshoot DAX performance using DAX Studio.
- Optimize a data model using Tabular Editor.
Module 18: Enforce Power BI model security
Lessons
- Restrict access to Power BI model data with RLS.
- Restrict access to Power BI model objects with OLS.
- Apply good development practices to enforce Power BI model security.
Avainsanat
Microsoft Fabric, Data Analytics, Power BI, Lakehouse, Dataflow, Data Factory, Data Warehouse