|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms_pl_300/
课程评论：没有评论
课程名称：Microsoft Power BI (PL-300) 考试问题（2025年5月） 课程概述： 本课程旨在帮助学习者掌握Power BI工具的关键技能，内容涵盖以下几个主要模块： 1. 数据准备（25-30%）： - 获取并连接到数据源，设置数据源的凭据和隐私等级。 - 数据预处理，评估数据质量，解决不一致和空值问题。 - 数据转化，包括选择适当的数据类型、创建和变换列、合并和追加查询等操作。 2. 数据建模（25-30%）： - 设计与实现数据模型，配置表和列属性。 - 定义关系的基数和跨过滤方向，使用DAX创建计算列和度量值。 - 优化模型性能，通过识别和删除不必要的行列来提升性能。 3. 数据可视化与分析（25-30%）： - 创建报告，选择合适的可视化格式与风格，并进行定制。 - 使用DAX进行视觉计算，增强报告的可用性和叙述性。 - 应用分析工具识别模式与趋势，使用AI可视化和异常检测功能。 4. Power BI的管理与安全（15-20%）： - 创建和管理工作区及资产，配置工作区应用。 - 设置数据警报与订阅，确保Power BI内容的安全性与治理。 - 实施行级安全角色管理，应用敏感性标签以保护数据。 本课程不仅提供了实用的知识和技能，还有助于考生为PL-300认证考试做好准备。
Skills at a glancePrepare the data (25-30%)Model the data (25-30%)Visualize and analyze the data (25-30%)Manage and secure Power BI (15-20%)Prepare the data (25-30%)Get or connect to dataIdentify and connect to data sources or a shared semantic modelChange data source settings, including credentials and privacy levelsChoose between DirectQuery and ImportCreate and modify parametersProfile and clean the dataEvaluate data, including data statistics and column propertiesResolve inconsistencies, unexpected or null values, and data quality issuesResolve data import errorsTransform and load the dataSelect appropriate column data typesCreate and transform columnsGroup and aggregate rowsPivot, unpivot, and transpose dataConvert semi-structured data to a tableCreate fact tables and dimension tablesIdentify when to use reference or duplicate queries and the resulting impactMerge and append queriesIdentify and create appropriate keys for relationshipsConfigure data loading for queriesModel 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 tableIdentify use cases for calculated columns and calculated tablesCreate model calculations by using DAXCreate single aggregation measuresUse the CALCULATE functionImplement time intelligence measuresUse basic statistical functionsCreate semi-additive measuresCreate a measure by using quick measuresCreate calculated tables or columnsCreate calculation groupsOptimize model performanceImprove performance by identifying and removing unnecessary rows and columnsIdentify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query viewImprove performance by reducing granularityVisualize and analyze the data (25-30%)Create reportsSelect an appropriate visualFormat and configure visualsApply and customize a themeApply conditional formattingApply slicing and filteringConfigure the report pageChoose when to use a paginated reportCreate visual calculations by using DAXEnhance reports for usability and storytellingConfigure bookmarksCreate custom tooltipsEdit and configure interactions between visualsConfigure navigation for a reportApply sorting to visualsConfigure sync slicersGroup and layer visuals by using the Selection paneConfigure drill through navigationConfigure export settingsDesign reports for mobile devicesEnable personalized visuals in a reportDesign and configure Power BI reports for accessibilityConfigure automatic page refreshIdentify patterns and trendsUse the Analyze feature in Power BIUse grouping, binning, and clusteringUse AI visualsUse reference lines, error bars, and forecastingDetect outliers and anomaliesManage and secure Power BI (15-20%)Create and manage workspaces and assetsCreate and configure a workspaceConfigure and update a workspace appPublish, import, or update items in a workspaceCreate dashboardsChoose a distribution methodConfigure subscriptions and data alertsPromote or certify Power BI contentIdentify when a gateway is requiredConfigure a semantic model scheduled refreshSecure and govern Power BI itemsAssign workspace rolesConfigure item-level accessConfigure access to semantic modelsImplement row-level security rolesConfigure row-level security group membershipApply sensitivity labels
