Project overview
- Organisation
- Cyient
- Role
- Data Analyst
- Period
- Sep 2018 - Feb 2020
Self-service BI & KPI Standardisation
Self-service analytics for 10+ business users using Excel, PowerPivot and Power BI, with KPI definitions standardised across sales, marketing, finance and project-management stakeholders; analytics contributed to an approximately 15% improvement in customer retention.
~15%Contributed to: improvement in customer retention
Context
Sales, marketing, finance and project-management stakeholders each measured performance their own way and depended on analysts for routine questions.
Scope
- Self-service analytics for 10+ business users
- Excel, PowerPivot and Power BI
- KPI definitions standardised across sales, marketing, finance and project management
Business Impact
Analytics contributed to an approximately 15% improvement in customer retention, with business users able to answer routine questions themselves.
Technology
- Excel
- PowerPivot
- Power BI
Related work
- Cyient
Headliners Sales Forecasting
An executive Power BI forecasting product combining regression modelling and scenario planning.
View project - Burda Luxury, Asia Pacific
Semantic-Layer Governance
A governed measurement layer separating business definitions from individual dashboards and analyses.
View project - Burda Luxury, Asia Pacific
Executive Daily Intelligence
A 13-section executive intelligence product backed by a prioritised 16-item engineering backlog.
Read case study