الرئيسية/الدورات/بيانات Microsoft وPower BI/PL-300T00 Design and Manage Analytics Solutions Using Power …
بيانات Microsoft وPower BIPL-300T00 Design and Manage Analytics Solutions Using Power BI (PL-300 Exam Prep)
استعدّ لدور محلّل البيانات في Power BI. خلال ثلاثة أيام تجلب البيانات وتنظّفها
3 أياممتوسط22 وحدةPL-300Microsoft Certified: Power BI Data Analyst Associate
نظرة عامة
استعدّ لدور محلّل البيانات في Power BI. خلال ثلاثة أيام تجلب البيانات وتنظّفها، وتهيّئ النماذج الدلالية، وتكتب صيغ DAX بما فيها دوال time intelligence، وتحسّن أداء النموذج، وتعمل مع Copilot، وتحدّد متطلبات تصميم التقارير، استعداداً لامتحان PL-300.
المنهاج
المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.
22 وحدة
- Overview of data analysis
- Roles in data
- Tasks of a data analyst
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
- Explore end-to-end analytics with Microsoft Fabric
- Explore data teams and Microsoft Fabric
- Enable and use Microsoft Fabric
- Module assessment
- Use Copilot in Power BI to prepare and model data
- Create reports with Copilot in Power BI
- Get your data ready for AI usage in Power BI
- Module assessment
- Get data from files
- Get data from relational data sources
- Create dynamic reports with parameters
- Get data from a NoSQL database
- Get data from online services
- Select a storage mode
- Get data from Azure Analysis Services
- Fix performance issues
- Resolve data import errors
- Shape the initial data
- Simplify the data structure
- Evaluate and change column data types
- Combine multiple tables into a single table
- Profile data in Power BI
- Use Advanced Editor to modify M code
- 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
- Module assessment
- Configure relationships
- Configure tables
- Configure columns
- Configure hierarchies
- Configure measures
- Configure parameters
- Understand DAX calculation types
- Write DAX formulas
- DAX data types
- Work with DAX functions
- Use DAX operators
- Use DAX variables
- Create calculated tables
- Create calculated columns
- Understand implicit measures
- Create explicit measures
- Use iterator functions
- Use DAX time intelligence functions
- Additional time intelligence calculations
- Understand visual calculations
- Create visual calculations
- Use parameters in visual calculations
- Module assessment
- Describe semantic model optimization techniques
- Review performance of measures, relationships, and visuals
- Use variables to improve performance and troubleshooting
- Reduce cardinality
- Optimize DirectQuery models with table level storage
- Create and manage aggregations
- Identify the audience
- Determine report types
- Define user interface requirements
- Define user experience requirements
- Explore designs in a Power BI report
- Design the analytical report layout
- Design visually appealing reports
- Use report objects
- Select report visuals
- Apply filters and slicers to reports
- Understand filtering techniques and considerations
- Case study - Configure report filters based on feedback
- Design reports to show details
- Design reports to highlight values
- Design reports that behave like apps
- Work with bookmarks
- Design reports for navigation
- Work with visual headers
- Design reports with built-in assistance
- Tune report performance
- Optimize reports for mobile use
- Explore statistical summary
- Identify outliers with Power BI visuals
- Group and bin data for analysis
- Apply clustering techniques
- Conduct time series analysis
- Use the Analyze feature
- Create what-if parameters
- Use specialized visuals
- Understand Power BI service
- Understand workspaces
- Publish to Power BI service
- Use a Power BI gateway to connect to on-premises data sources
- Configure a semantic model scheduled refresh
- Configure incremental refresh settings
- Manage and promote semantic models
- Boost performance with query caching (Fabric or Premium capacity)
- Use lineage and impact analysis
- Understand sharing models
- Create a Power BI app
- Apply data governance principles
- Track report or dashboard usage
- Configure data alerts
- Explore data by asking questions
- Review Quick insights
- Add a dashboard theme
- Pin a live report page to a dashboard
- Set mobile view
- Configure row-level security with the static method
- Configure row-level security with the dynamic method
- Use single sign-on (SSO) for DirectQuery sources
- Restrict access to Power BI model objects
لمن هذه الدورة
المحلّلون الساعون إلى شهادة Power BI Data Analyst Associate.
قبل أن تبدأ
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
- DP-900T00 Microsoft Azure Data Fundamentals is recommended
الشهادة التي تؤهّلك لها
جزءٌ من هذه الدبلومات
دورات ذات صلة
المزيد في بيانات Microsoft وPower BI ←متوسطPL-200
Microsoft Power Platform Functional Consultant (PL-200 Exam Prep)
Microsoft Power Platform
تفاصيل الدورة ←تأسيسيPL-900T00
Microsoft Power Platform Fundamentals (PL-900T00)
Microsoft Power Platform
تفاصيل الدورة ←متوسط
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
تفاصيل الدورة ←متوسط55353
Administering a SQL Database Infrastructure (55353)
بيانات Microsoft وPower BI
تفاصيل الدورة ←لنرسم خطوتك التالية معاً.
أخبرنا بالدورة أو الشهادة التي تهمّك، ونرسل لك المنهاج والمواعيد القادمة والرسوم وخيارات التدريب الخاص لفريقك.