|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/become-a-microsoft-power-bi-data-analyst/
课程评论：没有评论
课程名称：成为Microsoft Power BI数据分析师 课程概述： 本课程旨在培养学员成为能够利用Power BI提供可行洞察的数据分析师。学员将学习如何与各垂直领域的重要利益相关者合作，识别业务需求，清理和转换数据，并使用Power BI设计和构建数据模型。通过生动易懂的数据可视化，学员将为业务创造有意义的价值，使其他人能够进行自助分析，并部署和配置解决方案以供使用。 课程内容： 1. **数据准备**：学习如何从不同的数据源获取数据，包括连接数据源、选择共享数据集或创建本地数据集、清理和转换数据，以及解决数据质量问题。 2. **数据建模**：掌握设计数据模型的基础，包括定义表格、配置属性、创建计算表、实施行级安全角色，以及使用DAX进行计算和优化模型性能。 3. **数据可视化与分析**：学员将学习如何创建报告和仪表板，包括添加可视化元素、格式化视觉效果、配置报告页面、进行数据钻取和分析，以及使用AI视觉和预测功能。 4. **资产部署与维护**：理解如何管理文件和数据集，包括配置数据集的计划刷新、管理工作区中的内容、发布和更新资产，并配置敏感性标签和数据警报。 通过完成本课程，学员将能够运用Power BI的各种功能，深入分析数据，识别趋势和模式，并将结果以生动易懂的方式展示给利益相关者。此课程适合希望提升数据分析及可视化技能的专业人士。
The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient using Power Query and writing expressions by using DAX.Prepare the data - ( Get data from different data sources)Identify and connect to a data sourceChange data source settingsSelect a shared dataset or create a local datasetSelect a storage modeUse Microsoft DataverseChange the value in a parameterConnect to a data flowClean, transform, and load the dataProfile the dataResolve inconsistencies, unexpected or null values, and data quality issues Identify and create appropriate keys for joinsEvaluate and transform column data typesShape and transform tablesCombine queriesApply user-friendly naming conventions to columns and queriesConfigure data loadingResolve data import errorsModel the data - ( Design a data model )Define the tablesConfigure table and column propertiesDesign and implement role-playing dimensionsDefine a relationship's cardinality and cross-filter directionDesign a data model that uses a star schemaCreate a common date tableDevelop a data modelCreate calculated tablesCreate hierarchiesCreate calculated columnsImplement row-level security rolesUse the Q & A featureCreate model calculations by using DAXCreate basic measures by using DAXUse CALCULATE to manipulate filtersImplement Time Intelligence using DAXReplace implicit measures with explicit measuresUse basic statistical functionsCreate semi-additive measuresUse quick measuresOptimize model performanceRemove unnecessary rows and columnsIdentify poorly performing measures, relationships, and visualsReduce cardinality levels to improve performanceVisualize and analyze the data ( Create reports & Dashboards)Add visualization items to reportsChoose an appropriate visualization typeFormat 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 reportManage tiles on a dashboardConfigure mobile viewUse the Q & A featureAdd a Quick Insights result to a dashboardApply a dashboard themePin a live report page to a dashboardEnhance 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 paneDrilldown into data using interactive visualsExport report dataDesign reports for mobile devicesIdentify patterns and trendsUse the Analyze feature in Power BIIdentify outliersChoose between continuous and categorical axesUse groupings, binnings, and clusteringUse AI visualsUse the Forecast featureCreate reference lines by using the Analytics paneDeploy and maintain assets (Manage files, datasets and Manage workspaces)Identify when a gateway is requiredConfigure a dataset scheduled refreshConfigure row-level security group membershipProvide access to datasetsManage global options for filesCreate and configure a workspaceAssign workspace rolesConfigure and update a workspace appPublish, import, or update assets in a workspaceApply sensitivity labels to workspace contentConfigure subscriptions and data alertsPromote or certify Power BI content
