|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practice-tests-pl-300-power-bi-data-analyst-associate-cert/
课程评论：没有评论
课程名称：模拟测试：PL-300 Power BI 数据分析师助理认证 概述： 本课程旨在帮助学员准备 PL-300 认证考试，通过模拟测试涵盖多个考试领域，包括数据准备、数据建模、数据可视化与分析，以及资产的部署与维护。 1. **准备数据（25-30%）** - 学习如何获取和连接数据来源，包括更改数据源设置和选择共享数据集。 - 掌握数据转换和加载的基本方法，如选择适当的列数据类型、设计星型架构和合并查询。 - 在此过程中，还会处理数据质量问题、解决数据导入错误以及评估数据指标。 2. **建模数据（25-30%）** - 设计并实现数据模型，配置表和列属性，定义关系的基数和过滤方向。 - 使用 DAX 进行模型计算，创建聚合度量和时间智能度量。 - 优化模型性能，通过识别和删除不必要的行和列，提高查询效率。 3. **可视化与分析数据（25-30%）** - 学习如何创建报告、选择合适的可视化工具并配置其格式。 - 使用条件格式、切片和过滤，提高报告的可用性和信息传达性。 - 识别数据模式和趋势，并应用 AI 可视化和异常检测功能。 4. **部署与维护资产（15-20%）** - 创建和管理工作区，配置工作区角色，并选择合适的发布和分发方法。 - 了解数据集的访问控制和安全性，以及如何管理订阅和数据警报。 本课程为希望通过 PL-300 认证的学员提供了全面的测试准备，使其能够有效掌握 Power BI 的核心功能和实践技能。
These are the exam domains covered in the PL-300 practice test:Prepare the data (25-30%)Get data from data sourcesIdentify and connect to a data sourceChange data source settings, including credentials, privacy levels, and data source locationsSelect a shared dataset, or create a local datasetChoose between DirectQuery, Import, and Dual modeChange the value in a parameterTransform and load the dataSelect appropriate column data typesCreate and transform columnsTransform a queryDesign a star schema that contains facts and dimensionsIdentify when to use reference or duplicate queries and the resulting impactMerge and append queriesIdentify and create appropriate keys for relationshipsConfigure data loading for queriesClean the dataEvaluate data, including data statistics and column propertiesResolve inconsistencies, unexpected or null values, and data quality issuesResolve data import errorsModel the data (25-30%)Design and implement a data modelConfigure table and column propertiesImplement role-playing dimensionsDefine a relationship's cardinality and cross-filter directionCreate a common date tableImplement row-level security rolesCreate model calculations by using DAXCreate single aggregation measuresUse CALCULATE to manipulate filtersImplement time intelligence measuresIdentify implicit measures and replace with explicit measuresUse basic statistical functionsCreate semi-additive measuresCreate a measure by using quick measuresCreate calculated tablesOptimize model performanceImprove performance by identifying and removing unnecessary rows and columnsIdentify poorly performing measures, relationships, and visuals by using Performance AnalyzerImprove performance by choosing optimal data typesImprove performance by summarizing dataVisualize and analyze the data (25-30%)Create reportsIdentify and implement appropriate visualizationsFormat and configure visualizationsUse a custom visualApply and customize a themeConfigure conditional formattingApply slicing and filteringConfigure the report pageUse the Analyze in Excel featureChoose when to use a paginated reportEnhance reports for usability and storytellingConfigure bookmarksCreate custom tooltipsEdit and configure interactions between visualsConfigure navigation for a reportApply sortingConfigure sync slicersGroup and layer visuals by using the Selection paneDrill down into data using interactive visualsConfigure export of report content, and perform an exportDesign reports for mobile devicesIdentify patterns and trendsUse the Analyze feature in Power BIUse grouping, binning, and clusteringIncorporate the Q & A feature in a reportUse AI visualsUse reference lines, error bars, and forecastingDetect outliers and anomaliesCreate and share scorecards and metricsDeploy and maintain assets (15-20%)Create and manage workspaces and assetsCreate and configure a workspaceAssign workspace rolesConfigure and update a workspace appPublish, import, or update assets in a workspaceCreate dashboardsChoose a distribution methodApply sensitivity labels to workspace contentConfigure subscriptions and data alertsPromote or certify Power BI contentManage global options for filesManage datasetsIdentify when a gateway is requiredConfigure a dataset scheduled refreshConfigure row-level security group membershipProvide access to datasets
