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)
