{"id":36573,"date":"2023-12-13T09:36:33","date_gmt":"2023-12-13T09:36:33","guid":{"rendered":"https:\/\/ctraining.co.il\/?post_type=course&#038;p=36573"},"modified":"2025-06-26T09:11:11","modified_gmt":"2025-06-26T09:11:11","slug":"designing-and-implementing-enterprise-scale-analytics-solutions-using-microsoft-azure-and-microsoft-power-bi-course","status":"publish","type":"course","link":"https:\/\/ctraining.co.il\/en\/course\/designing-and-implementing-enterprise-scale-analytics-solutions-using-microsoft-azure-and-microsoft-power-bi-course\/","title":{"rendered":"Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Course"},"content":{"rendered":"<h2 dir=\"ltr\" style=\"text-align: left;\">About This Course<\/h2>\n<p dir=\"ltr\">DP-500 covers methods and practices for performing advanced data analytics at scale.<br \/>\nbuild on existing analytics experience and learn to implement and manage a data analytics environment, query, transform data, implement, and manage data models, explore and visualize data.<br \/>\nYou will use Microsoft Purview, Azure Synapse Analytics, and Power BI to build analytics solutions.<\/p>\n<h2 dir=\"ltr\" style=\"text-align: left;\">Audience Profile<\/h2>\n<p dir=\"ltr\" style=\"text-align: left;\">Candidates for this course should have subject matter expertise in designing, creating, and deploying enterprise-scale data analytics solutions. Specifically, candidates should have advanced Power BI skills, including managing data repositories and data processing in the cloud and on-premises, along with using Power Query and Data Analysis Expressions (DAX). They should also be proficient in consuming data from Azure Synapse Analytics and should have experience querying relational databases, analyzing data by using Transact-SQL (T-SQL), and visualizing data.<\/p>\n<h2 dir=\"ltr\">At Course Completion<\/h2>\n<p dir=\"ltr\">After completing this course, students will be able to:<\/p>\n<ul dir=\"ltr\">\n<li>Help collect enterprise-level requirements for data analytics solutions that include Azure and Power BI.<\/li>\n<li>Advise on data governance and configuration settings for Power BI administration.<\/li>\n<li>Monitor data usage.<\/li>\n<li>Optimize performance of the data analytics solutions.<\/li>\n<\/ul>\n<h2 dir=\"ltr\" style=\"text-align: left;\">Course Details<\/h2>\n<p dir=\"ltr\"><strong>Module 1: Introduction to data analytics on Azure.<\/strong><br \/>\nExplore Azure data services, concepts of data analytics, and what you need to implement modern analytics at scale.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<br \/>\n\u2022 Understand the Azure data ecosystem.<br \/>\n\u2022 Explore modern analytics solution architecture.<br \/>\n\u2022 Understand concepts of data analytics.<br \/>\n\u2022 Explore data analytics at scale.<br \/>\n\u2022 Understand data analytics types.<br \/>\n\u2022 Explore the data analytics process.<br \/>\n\u2022 Understand types of data and data storage.<br \/>\n\u2022 Explore data team roles and responsibilities.<br \/>\n\u2022 Review tasks and tools for data analysts.<br \/>\n\u2022 Scale analytics with Azure Synapse Analytics and Power BI.<br \/>\n\u2022 Strategies to scale analytics.<\/p>\n<p dir=\"ltr\"><strong>Module 2: Govern data across an enterprise.<br \/>\n<\/strong>Use Microsoft Purview to register and scan data, catalog data artifacts, find data for reporting, and manage Power BI artifacts to improve data governance in your organization.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<p dir=\"ltr\">\u00b7\u2022 Introduction to Microsoft Purview.<br \/>\n\u2022 Discover trusted data using Microsoft Purview.<br \/>\n\u2022 Catalog data artifacts by using Microsoft Purview.<br \/>\n\u2022 Manage Power BI assets by using Microsoft Purview.<br \/>\n\u2022 Integrate Microsoft Purview and Azure Synapse Analytics.<br \/>\n\u2022 Search for assets.<br \/>\n\u2022 Browse assets.<br \/>\n\u2022 Use assets with Power BI.<br \/>\n\u2022 Integrate with Azure Synapse Analytics.<br \/>\n\u2022 Register and scan data.<br \/>\n\u2022 Classify and label data.<br \/>\n\u2022 Search the data catalog.<br \/>\n\u2022 Register and scan a Power BI tenant.<br \/>\n\u2022 Search and browse Power BI assets.<br \/>\n\u2022 View Power BI metadata and lineage.<br \/>\n\u2022 Catalog Azure Synapse Analytics data assets in Microsoft Purview.<br \/>\n\u2022 Connect Microsoft Purview to an Azure Synapse Analytics workspace.<br \/>\n\u2022 Search a Purview catalog in Synapse Studio.<br \/>\n\u2022 Track data lineage in pipelines.<br \/>\n\u2022 Integrate Azure Synapse Analytics and Microsoft Purview.<\/p>\n<p dir=\"ltr\"><strong>Module 3: Model, query, and explore data in Azure Synapse.<br \/>\n<\/strong>Query and explore data in Azure Synapse Analytics. You&#8217;ll learn how to query and visualize data in a data lake and a data warehouse.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<p dir=\"ltr\">\u2022 Introduction to Azure Synapse Analytics.<br \/>\n\u2022 Use Azure Synapse serverless SQL pool to query files in a data lake.<br \/>\n\u2022 Analyze data with Apache Spark in Azure Synapse Analytics.<br \/>\n\u2022 Analyze data in a relational data warehouse.<br \/>\n\u2022 Understand Azure Synapse serverless SQL pool capabilities and use cases.<br \/>\n\u2022 Query files using a serverless SQL pool.<br \/>\n\u2022 Create external database objects.<br \/>\n\u2022 Query files using a serverless SQL pool.<br \/>\n\u2022 Get to know Apache Spark.<br \/>\n\u2022 Use Spark in Azure Synapse Analytics.<br \/>\n\u2022 Analyze data with Spark.<br \/>\n\u2022 Visualize data with Spark.<br \/>\n\u2022 Analyze data with Spark.<br \/>\n\u2022 Design a data warehouse schema.<br \/>\n\u2022 Create data warehouse tables.<br \/>\n\u2022 Load data warehouse tables.<br \/>\n\u2022 Query a data warehouse.<br \/>\n\u2022 Explore a data warehouse.<\/p>\n<p dir=\"ltr\"><strong>Module 4: Prepare data for tabular models in Power BI.<br \/>\n<\/strong>Designing reports for enterprise scale requires more than just connecting to data. Understanding Power BI model frameworks and strategies for scalability and optimization are key to a successful enterprise implementation.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<ul dir=\"ltr\">\n<li>\u2022 Choose a Power BI model framework.<br \/>\n\u2022 Understand scalability in Power BI.<br \/>\n\u2022 Create and manage scalable Power BI dataflows.<br \/>\n\u2022 Describe the significance of scalable models.<br \/>\n\u2022 Implement Power BI data modeling best practices.<br \/>\n\u2022 Configure large datasets.<br \/>\n\u2022 Create a star schema model.<br \/>\n\u2022 Define use cases for dataflows.<br \/>\n\u2022 Create reusable assets.<br \/>\n\u2022 Implement best practices.<br \/>\n\u2022 Create a dataflow.<\/li>\n<\/ul>\n<p dir=\"ltr\"><strong>Module<\/strong> <strong>5: Design and build tabular models.<\/strong><\/p>\n<p dir=\"ltr\">introducing the foundational components of designing scalable tabular models using Power BI.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<ul dir=\"ltr\">\n<li>\u2022 Create Power BI model relationships.<br \/>\n\u2022 Use DAX time intelligence functions in Power BI Desktop models.<br \/>\n\u2022 Create calculation groups.<br \/>\n\u2022 Enforce Power BI model security.<br \/>\n\u2022 Use tools to optimize Power BI performance.<br \/>\n\u2022 Use DAX time intelligence functions.<br \/>\n\u2022 Additional time intelligence calculations.<br \/>\n\u2022 Create Advanced DAX Calculations in Power BI Desktop.<br \/>\n\u2022 Understand calculation groups.<br \/>\n\u2022 Explore calculation groups features and usage.<br \/>\n\u2022 Create calculation groups in a model.<br \/>\n\u2022 Create calculation groups.<br \/>\n\u2022 Restrict access to Power BI model data.<br \/>\n\u2022 Restrict access to Power BI model objects.<br \/>\n\u2022 Apply good modeling practices.<br \/>\n\u2022 Enforce model security.<br \/>\n\u2022 Use Performance analyzer.<br \/>\n\u2022 Troubleshoot DAX performance by using DAX Studio.<br \/>\n\u2022 Optimize a data model by using Best Practice Analyzer.<br \/>\n\u2022 Use tools to optimize Power BI performance.<\/li>\n<\/ul>\n<p dir=\"ltr\"><strong>Module<\/strong> <strong>6: Implement advanced data visualization techniques by using Power BI.<\/strong><\/p>\n<p dir=\"ltr\">Visualizing data in Power BI. You&#8217;ll learn about visuals in Power BI reports, using Power BI to visualize real-time data, and visualizing data in paginated reports.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<ul dir=\"ltr\">\n<li>\u2022 Understand advanced data visualization concepts.<br \/>\n\u2022 Monitor data in real-time with Power BI.<br \/>\n\u2022 Create paginated reports.<br \/>\n\u2022 Describe Power BI real-time analytics.<br \/>\n\u2022 Set up automatic page refresh.<br \/>\n\u2022 Create real-time dashboards.<br \/>\n\u2022 Set-up auto-refresh paginated reports.<br \/>\n\u2022 Monitor data in real-time with Power BI.<br \/>\n\u2022 Introduction to paginated reports.<br \/>\n\u2022 Get data.<br \/>\n\u2022 Create a paginated report.<br \/>\n\u2022 Work with charts on the report.<br \/>\n\u2022 Publish the report.<\/li>\n<\/ul>\n<p dir=\"ltr\"><strong>Module 7: Manage the analytics development lifecycle.<\/strong><\/p>\n<p dir=\"ltr\">introducing the foundational components of implementing lifecycle management techniques for Power BI assets.<\/p>\n<p dir=\"ltr\">After completing this module, students will be able to:<\/p>\n<ul dir=\"ltr\">\n<li>\u2022 Design a Power BI application lifecycle management strategy.<br \/>\n\u2022 Create and manage a Power BI deployment pipeline.<br \/>\n\u2022 Create and manage Power BI assets.<br \/>\n\u2022 Understand the deployment process.<br \/>\n\u2022 Create a deployment pipeline.<br \/>\n\u2022 Assign a workspace.<br \/>\n\u2022 Deploy content.<br \/>\n\u2022 Work with deployment pipelines.<br \/>\n\u2022 Create reusable Power BI assets.<br \/>\n\u2022 Explore Power BI assets using lineage view.<br \/>\n\u2022 Manage a Power BI dataset using XMLA endpoint.<br \/>\n\u2022 Create reusable Power BI assets.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This course will enable the students to understand Azure SQL Database and educate the students on what is required to migrate MySQL and PostgreSQL workloads to Azure SQL Database.<\/p>\n","protected":false},"featured_media":47147,"template":"","meta":{"_acf_changed":false,"inline_featured_image":false},"tags":[4344,4727,4301,4728,4729],"coursetype":[1428],"product":[5150],"audience":[],"class_list":["post-36573","course","type-course","status-publish","has-post-thumbnail","hentry","tag-500-en","tag-designing-and-implementing-enterprise-scale-analytics-solutions-using-microsoft-azure-and-microsoft-power-bi-en","tag-dp-en","tag-dp-500-en","tag-microsoft-azure-and-microsoft-power-bi-en","coursetype-microsoft","product-data-platform-en"],"acf":[],"_links":{"self":[{"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/course\/36573","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\/36573\/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=36573"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/tags?post=36573"},{"taxonomy":"coursetype","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/coursetype?post=36573"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/product?post=36573"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/ctraining.co.il\/en\/wp-json\/wp\/v2\/audience?post=36573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}