Data analysis

Data analysis is the systematic examination and transformation of project data to generate insights that guide decisions. It helps identify trends, explain variances, and forecast outcomes across scope, schedule, cost, quality, and benefits.

Key Points

  • Turns raw project data into actionable insights that inform decisions.
  • Uses qualitative and quantitative techniques such as trend, variance, and root cause analysis.
  • Works best when the analysis question, assumptions, and data lineage are clearly defined.
  • Iterative and time-boxed; revisit as new data and feedback become available.
  • Effective communication uses simple visuals and a clear narrative tailored to stakeholders.
  • Data quality, context, and bias management are critical for trustworthy results.

Purpose of Analysis

Enable evidence-based decisions by revealing what is happening, why it is happening, and what is likely to happen next. It supports forecasting, risk response selection, benefits realization tracking, and performance improvement.

  • Detect patterns, trends, and anomalies in performance data.
  • Explain schedule, cost, and quality variances and their drivers.
  • Predict future outcomes and test alternative scenarios.
  • Provide clear recommendations for action and governance decisions.

Method Steps

  • Frame the question: define the decision to support and success criteria.
  • Identify and source data: select authoritative, traceable data aligned to baselines.
  • Prepare data: clean, standardize, and document assumptions and transformations.
  • Analyze: apply descriptive, diagnostic, predictive, or prescriptive techniques as needed.
  • Validate: check for accuracy, bias, outliers, and sensitivity to assumptions.
  • Visualize and communicate: use concise charts and a clear narrative of findings and implications.
  • Recommend and act: present options, impacts, and next steps for decision-makers.
  • Monitor and iterate: track results, learn, and refine the analysis with new data.

Inputs Needed

  • Approved baselines and current performance data (scope, schedule, cost, quality, benefits).
  • Risk register, issue log, change log, and assumptions log.
  • Historical data, lessons learned, and organizational process assets.
  • Stakeholder information and decision criteria or thresholds.
  • Environmental factors such as policies, tools, and data governance rules.

Outputs Produced

  • Findings and insights explaining performance and drivers.
  • Forecasts and scenarios with stated confidence or ranges.
  • Variance analyses and trend reports with visuals and commentary.
  • Recommendations, decision support materials, and action items.
  • Updates to plans, baselines, and registers as decisions are implemented.

Interpretation Tips

  • Always compare against approved baselines and defined thresholds.
  • Triangulate using multiple measures to avoid relying on a single metric.
  • Differentiate correlation from causation; confirm root causes before acting.
  • Assess sensitivity to key assumptions and data quality.
  • Explain limitations, confidence levels, and potential biases.
  • Translate technical findings into stakeholder-relevant impacts and options.

Example

A project team sees rising schedule slippage over four sprints. The manager standardizes sprint data from two tools, then performs trend and root cause analysis. The trend shows velocity dropping 10% per sprint; interviews and defect logs reveal rework is consuming capacity.

Findings are visualized in a simple chart with a short narrative. The team recommends adding a quality gate and addressing a recurring defect source. After implementing the actions, the next two sprints show stabilized velocity and reduced cycle time.

Pitfalls

  • Starting analysis without a clear question or decision in mind.
  • Using inconsistent or low-quality data sources without reconciliation.
  • Cherry-picking results or ignoring outliers without justification.
  • Overfitting models or overstating precision and certainty.
  • Misleading visuals that hide scale, context, or assumptions.
  • Failing to document methods, assumptions, and data lineage.

PMP Example Question

A project manager plans to use trend analysis to forecast the completion date, but schedule data from multiple tools shows different baseline dates. What should the manager do first?

  1. Build the trend chart using the most recent data.
  2. Standardize data definitions and align all data to the approved baseline.
  3. Run a Monte Carlo simulation to estimate schedule risk.
  4. Escalate the issue to the sponsor for a decision.

Correct Answer: B — Standardize data definitions and align all data to the approved baseline.

Explanation: Reliable analysis requires consistent, traceable data. Confirm data quality and baseline alignment before performing the analysis.

Project Management Bootcamp

Embark on a transformative journey with our Project Management Bootcamp at HK School of Management. Elevate from beginner to pro using the latest PMBOK and Process Groups Practice Guide. Our unique, engaging approach makes learning interactive and fun, replacing dull slides with dynamic doodles and real-life scenarios.

This hands-on program includes working on two full project plans. The first evolves as you learn, while the second culminates in a comprehensive plan, solidifying your expertise. You'll navigate real-world challenges, backed by quizzes and in-depth analysis, avoiding common pitfalls and setting you on a path to success.

Enhance your learning with downloadable materials and templates, invaluable for your future projects. The course covers essential topics like PMI, PMO, PMBOK, and project management ethics, delving into critical process groups and key areas such as scope, schedule, cost, and stakeholder management.

Learn from seasoned professionals and join a community of enthusiastic lifelong learners. Ready to master project management and lead with confidence? Enroll now and start your transformation!



Advance your Lean Six Sigma expertise!

HK School of Management helps you take Lean Six Sigma to the next level—without the overwhelm. Master advanced statistical tools, Excel-based analysis, and real-world improvement techniques to solve complex problems with confidence. For the price of lunch, you get practical templates, guided examples, and hands-on project experience you can use immediately at work. Backed by our 30-day money-back guarantee—zero risk, real impact.

Learn More