DP-500T00 Designing and Implementing Enterprise-Scale Analytics Using Azure and Power BI
صمّم التحليلات على مستوى المؤسسة بـ Azure وPower BI. خلال أربعة أيام تبني كتالوج البيانات وتحكمها بـ Microsoft Purview
نظرة عامة
صمّم التحليلات على مستوى المؤسسة بـ Azure وPower BI. خلال أربعة أيام تبني كتالوج البيانات وتحكمها بـ Microsoft Purview، وتستعلم عن بحيرة البيانات بـ serverless SQL في Azure Synapse، وتحلّل البيانات بـ Apache Spark، وتبني مستودع بيانات علائقياً، وتصمّم نماذج Power BI قابلة للتوسّع، استعداداً لامتحان DP-500.
المنهاج
المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.
- Understand the Azure data ecosystem
- Explore modern analytics solution architecture
- Understand data analytics types
- Explore the data analytics process
- Understand types of data and data storage
- Explore data team roles and responsibilities
- Review tasks and tools for data analysts
- Scale analytics with Azure Synapse Analytics and Power BI
- Strategies to scale analytics
- What is Microsoft Purview?
- How Microsoft Purview works
- When to use Microsoft Purview
- Search for assets
- Browse assets
- Use assets with Power BI
- Integrate with Azure Synapse Analytics
- Register and scan data
- Classify and label data
- Search the data catalog
- Register and scan a Power BI tenant
- Search and browse Power BI assets
- View Power BI metadata and lineage
- Catalog Azure Synapse Analytics data assets in Microsoft Purview
- Connect Microsoft Purview to an Azure Synapse Analytics workspace
- Search a Purview catalog in Synapse Studio
- Track data lineage in pipelines
- What is Azure Synapse Analytics
- How Azure Synapse Analytics works
- When to use Azure Synapse Analytics
- Understand Azure Synapse serverless SQL pool capabilities and use cases
- Query files using a serverless SQL pool
- Create external database objects
- Get to know Apache Spark
- Use Spark in Azure Synapse Analytics
- Analyze data with Spark
- Visualize data with Spark
- Design a data warehouse schema
- Create data warehouse tables
- Load data warehouse tables
- Query a data warehouse
- Describe Power BI model fundamentals
- Determine when to develop an import model
- Determine when to develop a DirectQuery model
- Determine when to develop a composite model
- Choose a model framework
- Describe the significance of scalable models
- Implement Power BI data modeling best practices
- Configure large datasets
- Define use cases for dataflows
- Create reusable assets
- Implement best practices
- Understand model relationships
- Set up relationships
- Use DAX relationship functions
- Understand relationship evaluation
- Use DAX time intelligence functions
- Additional time intelligence calculations
- Understand calculation groups
- Explore calculation groups features and usage
- Create calculation groups in a model
- Restrict access to Power BI model data
- Restrict access to Power BI model objects
- Apply good modeling practices
- Use Performance analyzer
- Troubleshoot DAX performance by using DAX Studio
- Optimize a data model by using Best Practice Analyzer
- Create and import a custom report theme
- Enable personalized visuals in a report
- Design and configure Power BI reports for accessibility
- Create custom visuals with R or Python
- Review report performance using Performance Analyzer
- Describe Power BI real-time analytics
- Set up automatic page refresh
- Create real-time dashboards
- Set-up auto-refresh paginated reports
- Get data
- Create a paginated report
- Work with charts on the report
- Publish the report
- Elements of data governance
- Configure tenant settings
- Deploy organizational visuals
- Manage embed codes
- Help and support settings
- Usage metrics for dashboards and reports
- Usage metrics for dashboards and reports - new version
- Audit logs
- Activity log
- REST API custom development
- Provision a Power BI embedded capacity
- Dataflow introduction
- Dataflow explained
- Create a Dataflow
- Dataflow capabilities on Power BI Premium
- Template apps - install packages
- Template apps - installed entities
- Template app governance
- Describe the Power BI and Synapse workspace integration
- Understand Power BI data sources
- Describe Power BI optimization options
- Visualize data with serverless SQL pools
- Define application lifecycle management
- Recommend a source control strategy
- Design a deployment strategy
- Understand the deployment process
- Create a deployment pipeline
- Assign a workspace
- Deploy content
- Work with deployment pipelines
- Create reusable Power BI assets
- Explore Power BI assets using lineage view
- Manage a Power BI dataset using XMLA endpoint
لمن هذه الدورة
محلّلو البيانات ومعماريو ذكاء الأعمال المتمرّسون.
قبل أن تبدأ
- A foundational knowledge of core data concepts and how they’re implemented using Azure data services. For more information see Azure Data Fundamentals. Experience designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value using Microsoft Power BI. For more information see Power BI Data Analyst.
الشهادة التي تؤهّلك لها
دورات ذات صلة
المزيد في بيانات Microsoft وPower BI ←55128 Writing Reports with Report Builder and SSRS Level 2
بيانات Microsoft وPower BI
تفاصيل الدورة ←55232 Writing Analytical Queries for Business Intelligence
بيانات Microsoft وPower BI
تفاصيل الدورة ←55315 Introduction to SQL Databases
بيانات Microsoft وPower BI
تفاصيل الدورة ←Administering a SQL Database Infrastructure (55353)
بيانات Microsoft وPower BI
تفاصيل الدورة ←Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
بيانات Microsoft وPower BI
تفاصيل الدورة ←Data Analysis using Power BI Desktop - Level 1: Report Builder
بيانات Microsoft وPower BI
تفاصيل الدورة ←لنرسم خطوتك التالية معاً.
أخبرنا بالدورة أو الشهادة التي تهمّك، ونرسل لك المنهاج والمواعيد القادمة والرسوم وخيارات التدريب الخاص لفريقك.