From Bricks to Business Intelligence: Optimizing Project Finances

Summary:

As a dedicated Business Analyst for a finance company, this project centers on crafting an interactive report detailing financial stages and project lifecycle management. The report provides insights into key metrics and trends, aiding the leadership team in monitoring performance effectively.

Key Performance Indicators (KPIs):

• Projects and Invoices: 99
• LOI Issued & Target Projects: 97M issued LOIs (Letters of Intent) against a target of 9,826 projects
• Savings & Avg. Project Value: $657.92M in savings achieved, with an average project value of $7.82M

Departmental Breakdown:

• E2E Department: Holds the highest budget ($20.5M) but also the lowest SSBD (Shortfall Savings Budget Delta) of $2.6M, indicating strong budget utilization.
• Status by Department:
  • Savings: First 6 months saw 68% savings, declining to 32% in the last 6 months.
  • Project Status: 70 current projects, 23 ongoing, and 6 cancelled projects.
  • Monthly Target: Targets varied, with June having the lowest and December the highest.

Divisional Analysis:

• Project Status: E2E Centralized has the most projects (25), while Direct Boards & Services has the least (3).
• Gap Analysis:
  • ICCD achieved the highest savings percentage (26.9%).
  • B2C achieved the second-highest savings percentage (31.42%).

Project Lifecycle Analysis:

• Biannual Analysis: Long-term projects contribute significantly to the overall project portfolio.
  • First 6 months: 72% of project value comes from long-term projects.
  • Second 6 months: 68% of project value comes from long-term projects.
• Project Variance: Quarter 3 experienced the highest variance rate, indicating potential deviations from project plans.

Project Goals:

• Identify areas for improvement in departmental budget utilization and project management efficiency.
• Develop strategies to increase savings percentage across all departments.
• Analyze the impact of project lifecycles on overall project success.
• Investigate the causes of project variance in Quarter 3 and implement corrective measures.

Expected Outcomes:

• Enhance project management practices through data-driven insights.
• Optimize resource allocation and budget planning across departments.
• Increase overall project success rate and achieve consistent savings targets.