This course covers methods and practices for implementing and managing enterprise-scale data analytics solutions using Microsoft Fabric. Students will build on existing analytics experience and will learn how to use Microsoft Fabric components, including lake houses, data warehouses, notebooks, dataflows, data pipelines, and semantic models, to create and deploy analytics assets.
\nThis course is best suited for those who have the PL-300 certification or similar expertise in using Power BI for data transformation, modeling, visualization, and sharing. Also, learners should have prior experience in building and deploying data analytics solutions at the enterprise level.<\/p>\n
The primary audience for this course is data professionals with experience in data modeling, extraction, and analytics. DP-600 is designed for professionals who want to use Microsoft Fabric to create and deploy enterprise-scale data analytics solutions.<\/p>\n
Module 1: Ingest Data with Dataflows Gen2 in Microsoft Fabric.<\/strong> This course will teach the basics of Microsoft’s dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases<\/p>\n","protected":false},"featured_media":47147,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false},"tags":[4757,4753,4756,4758,4754,4529],"coursetype":[1428],"product":[5150],"audience":[],"class_list":["post-38169","course","type-course","status-publish","has-post-thumbnail","hentry","tag-605-en","tag-develop-dynamic-reports-with-microsoft-power-bi-en","tag-dp-605-en","tag-dp-605too","tag-microsoft-power-bi-en","tag-power-bi-en","coursetype-microsoft","product-data-platform-en"],"acf":[],"_links":{"self":[{"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/course\/38169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/types\/course"}],"version-history":[{"count":0,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/course\/38169\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/media\/47147"}],"wp:attachment":[{"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/media?parent=38169"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/tags?post=38169"},{"taxonomy":"coursetype","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/coursetype?post=38169"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/product?post=38169"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/audience?post=38169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n\u2022 Understand Dataflows Gen2 in Microsoft Fabric.
\n\u2022 Explore Dataflows Gen2 in Microsoft Fabric.
\n\u2022 Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric.
\n\u2022 Exercise – Create and use a Dataflow Gen2 in Microsoft Fabric.
\nModule 2: Ingest data with Spark and Microsoft Fabric notebooks.<\/strong>
\n\u2022 Connect to data with Spark.
\n\u2022 Write data into a lakehouse.
\n\u2022 Consider uses for ingested data.
\n\u2022 Exercise – Ingest data with Spark and Microsoft Fabric notebooks.
\nModule 3: Use Data Factory pipelines in Microsoft Fabric.<\/strong>
\n\u2022 Understand pipelines.
\n\u2022 Use the Copy Data activity.
\n\u2022 Use pipeline templates.
\n\u2022 Run and monitor pipelines.
\n\u2022 Exercise – Ingest data with a pipeline.
\nModule 4: Get started with lakehouses in Microsoft Fabric.<\/strong>
\n\u2022 Explore the Microsoft Fabric Lakehouse.
\n\u2022 Work with Microsoft Fabric Lakehouses.
\n\u2022 Explore and transform data in a lakehouse.
\n\u2022 Exercise – Create and ingest data with a Microsoft Fabric Lakehouse.
\nModule 5: Organize a Fabric lakehouse using medallion architecture design.<\/strong>
\n\u2022 Describe medallion architecture.
\n\u2022 Implement a medallion architecture in Fabric.
\n\u2022 Query and report on data in your Fabric lakehouse.
\n\u2022 Considerations for managing your lakehouse.
\n\u2022 Exercise – Organize your Fabric lakehouse using a medallion architecture.
\nModule 6: Use Apache Spark in Microsoft Fabric.<\/strong>
\n\u2022 Prepare to use Apache Spark.
\n\u2022 Run Spark code.
\n\u2022 Work with data in a Spark dataframe.
\n\u2022 Work with data using Spark SQL.
\n\u2022 Visualize data in a Spark notebook.
\n\u2022 Exercise – Analyze data with Apache Spark.
\nModule 7: Work with Delta Lake tables in Microsoft Fabric.<\/strong>
\n\u2022 Understand Delta Lake.
\n\u2022 Create delta tables.
\n\u2022 Work with delta tables in Spark.
\n\u2022 Use delta tables with streaming data.
\n\u2022 Exercise – Use delta tables in Apache Spark.
\nModule 8: Get started with data warehouses in Microsoft Fabric.<\/strong>
\n\u2022 Understand data warehouse fundamentals.
\n\u2022 Understand data warehouses in Fabric.
\n\u2022 Query and transform data.
\n\u2022 Prepare data for analysis and reporting.
\n\u2022 Secure and monitor your data warehouse.
\n\u2022 Exercise – Analyze data in a data warehouse.
\nModule 9: Load data into a Microsoft Fabric data warehouse.<\/strong>
\n\u2022 Explore data load strategies.
\n\u2022 Use data pipelines to load a warehouse.
\n\u2022 Load data using T-SQL.
\n\u2022 Load and transform data with Dataflow Gen2.
\n\u2022 Exercise: Load data into a warehouse in Microsoft Fbric.
\nModule 10: Query a data warehouse in Microsoft Fabric.<\/strong>
\n\u2022 Use the SQL query editor.
\n\u2022 Explore the visual query editor.
\n\u2022 Use client tools to query a warehouse.
\n\u2022 Exercise: Query a data warehouse in Microsoft Fabric.
\nModule 11: Monitor a Microsoft Fabric data warehouse.<\/strong>
\n\u2022 Monitor capacity metrics.
\n\u2022 Monitor current activity.
\n\u2022 Monitor queries.
\n\u2022 Exercise – Monitor a data warehouse in Microsoft Fabric.
\nModule 12: Understand scalability in Power BI.<\/strong>
\n\u2022 Describe the significance of scalable models.
\n\u2022 Implement Power BI data modeling best practices.
\n\u2022 Configure large datasets.
\n\u2022 Exercise: Create a star schema model.
\nModule 13: Create Power BI model relationships.<\/strong>
\n\u2022 Understand model relationships.
\n\u2022 Set up relationships.
\n\u2022 Use DAX relationship functions.
\n\u2022 Understand relationship evaluation.
\n\u2022 Exercise: Work with model relationships.
\nModule 14: Use tools to optimize Power BI performance.<\/strong>
\n\u2022 Use Performance analyzer.
\n\u2022 Troubleshoot DAX performance by using DAX Studio.
\n\u2022 Optimize a data model by using Best Practice Analyzer.
\n\u2022 Exercise: Use tools to optimize Power BI performance.
\nModule 15: Enforce Power BI model security.<\/strong>
\n\u2022 Restrict access to Power BI model data.
\n\u2022 Restrict access to Power BI model objects.
\n\u2022 Apply good modeling practices.
\n\u2022 Exercise: Enforce model security.<\/p>\n","protected":false},"excerpt":{"rendered":"