High Level Design

Overview

The speed at which companies can introduce new products into the market is critical for sustaining a competitive advantage, and the reduction of product development cycle time has become a strategic objective for many technology-driven firms. The best solution would be to identify in the phases in which delays that affect the overall delivery of the project occur.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

 

Goals

Reduce time to market of software products .

Objectives

  • Improve overall time to market (especially in major releases and new product releases)
  • Improve customer satisfaction to VIP customers (customers with high ARPU value)
  • Improve time per step in different projects (by identifying reasons for delay)

KPI Architecture

Objectives KPIs Measures Data Source
Improve overall time to market (especially in major releases and new product releases) Distribution of project types count([ProjectID]) Fact_Completion_tasks, DimProjectType
% completed on schedule (count([ProjectID]),[FLAG_LATE1])/count([ProjectID]) Project_Aggs
Avg delay In days (avg([ProjectID],(sum([DayToCompletion])))-avg([TimeToMarketBenchmark (days)])) Fact_Completion_tasks, DimProjectType
Projects benchmark ([Average TimeToMarketBenchmark (days)],[ProjectTypeName1]) Project_Aggs, DimProjectType
Improve time per step in different projects (by identifying reasons for delay) % of sub projects completed on time (count([ProjectID]),[On time Boolean1])/(count([ProjectID])) Fact_Completion_tasks, DimPhases
% phases delayed (dupcount([On time Boolean]),[On time Boolean1])/dupcount([On time Boolean]) Fact_Completion_tasks, DimPhases, DimProjectsType
Breakdown of Delay reason count([ProjectID]) Fact_Completion_tasks, DimPhases, DelayReason

Data Modeling (Elasticube Design)

Suggested data model for analyzing software products time to market