|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-pl-300-exam-practice-questions/
课程评论：没有评论
课程名称：Microsoft PL-300 考试练习题 *更新于2023年10月* 课程概述：本课程涵盖 Microsoft PL-300 考试所需的主要概念，内容包括： 1. **数据准备（25-30%）** - 获取和连接数据源，调整数据源设置，包括凭证和隐私级别。 - 选择共享数据集或创建本地数据集，并选择数据连接模式（直接查询、导入和双模式）。 - 数据转换及加载，包括适当的列数据类型，设计星型架构，清理数据，并解决数据一致性和质量问题。 2. **数据建模（25-30%）** - 设计和实施数据模型，配置表和列属性，创建角色播放维度，定义关系的基数和交叉过滤方向。 - 使用 DAX 创建模型计算，优化模型性能，创建计算表和度量值。 3. **数据可视化与分析（25-30%）** - 创建报告，选择合适的可视化，格式化和配置可视化效果。 - 使用交互式视觉效果钻取数据，配置报告内容导出，并针对移动设备设计报告。 4. **资产的部署与维护（15-20%）** - 创建和管理工作区及资产，配置工作区角色，发布和更新资产。 - 管理数据集，并配置安全组成员资格以及访问权限。 通过本课程，您将系统地掌握 PL-300 考试所需的各项技能，提升在 Power BI 中的数据处理、建模和可视化能力。希望这个课程对您的学习有帮助。如需任何支持，请随时联系我，祝学习愉快！感谢您，Neil
*Updated Oct 2023*The course includes the below concepts for the exam: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 datasetsI hope you find this course useful for your studies,Please message me if I can assist in any way,Happy learning!Thanks,Neil
