|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/s-curve-en/
课程评论：没有评论
课程名称：使用 Power BI 进行高级 S 曲线分析 课程概述：本课程旨在为参与者提供创建和分析高级 S 曲线所需的技能和知识，使用 Power BI 工具。本课程涵盖更高级的主题，包括累计 S 曲线、项目预测、P6 财务期间以及高级 DAX 公式。参与者将学习如何利用 Power BI 创建和分析 S 曲线，并将这些知识应用于实际工作场景。 课程内容包括： - 在 Power BI 中创建间隔和累计 S 曲线 - 使用 P6 财务期间存储更新的项目值 - 分析间隔和累计的挣值（EV）百分比 - 设置日期表将计划值（PV）和挣值（EV）数据汇总到一条曲线 - 开发自定义度量和 DAX 公式计算关键项目指标 - 将活动代码导入 Power BI - 将活动代码与 S 曲线链接，创建动态和互动的图表 - 利用 S 曲线进行趋势分析 - 针对每个活动进行方差、方差权重、进度绩效指数（SPI）和权重百分比分析 - S 曲线分析的实际案例 - S 曲线分析的最佳实践 - 为参与者提供持续的支持和资源 总体而言，本课程旨在帮助参与者掌握先进的 S 曲线分析技巧与 Power BI 工具，以优化项目绩效和资源利用。该课程的设计基于在向高层管理人员展示某大型项目进展的实际经验，以支持决策。
This course is designed to provide participants with the skills and knowledge required to create and analyze advanced S-curves using Power BI. The course covers more advanced topics such as cumulative S-curves, project forecasting, P6 Financial period, and advance Dax formula. Participants will learn how to use Power BI to create and analyze S-curves, and how to apply this knowledge to real-world scenarios in their own work.Creating interval and cumulative S-curves in Power BIUsing financial periods in P6 to store updated project values.Analyzing interval and cumulative EV %Setting up a date table to join PV and EV data into one curve.Developing custom measures and DAX formulas to calculate key project metrics.Importing activity codes to Power BILinking activity codes with the S-curve to create dynamic and interactive charts.Trend analysis using the S-curve.Variance, weight of variance, SPI, and weight % analysis for each activityReal-world examples of S-curve analysisBest practices for S-curve analysis in Power BIOngoing support and resources for participantsOverall, this course is designed to equip participants with the skills and knowledge needed to optimize project performance and resource utilization using advanced S-curve analysis and Power BI.This Course was built based on actual experience in presenting the progress for one of the Mega projects to the top management to allow and support the decision making.
