|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-pl-300/
课程评论：没有评论
课程名称：PL-300：Microsoft Power BI 数据分析师 - 2025年5月 课程概述：本课程旨在帮助学员掌握Microsoft Power BI的数据分析技能，重点内容包括数据准备、数据建模、数据可视化分析和Power BI的管理与安全。 技能概览： 1. **数据准备（25-30%）**： - 学习如何获取和连接数据，识别数据源并修改数据源设置。 - 数据清洗与评估，包括调整数据列的数据类型、解决数据不一致性及数据质量问题。 - 进行数据转换与加载，创建事实表和维度表，并确定查询的合并与追加方法。 2. **数据建模（25-30%）**： - 设计与实现数据模型，配置表和列的属性。 - 创建并使用角色扮演维度，建立关系的基数和交叉过滤方向。 - 使用DAX创建模型计算和聚合度量，提高模型性能。 3. **数据可视化与分析（25-30%）**： - 创建报告，选择合适的视觉效果并进行配置信息。 - 应用条件格式化与主题定制，增强报告的可用性和叙事性。 - 使用AI视觉和分析功能识别数据模式与趋势，检测异常值。 4. **Power BI 管理与安全（15-20%）**： - 创建和管理工作区及资产，配置工作区应用。 - 发布、导入或更新工作区中的项目，并管理仪表板与订阅。 - 实施行级安全角色与敏感信息标签，确保数据的安全性。 通过本课程的学习，学员将具备利用Power BI进行数据分析与可视化的全面能力，为未来的数据分析职业打下坚实基础。
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
