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.

 

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

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Échantillons de données et exemples de dashboards (téléchargement direct)

Documentation