Client
Telco sector
Techniques used
- Data Automation
- Forecasting & Planning
- Business Analysis
- Machine Learning
Technology and tools
- Power BI
- Teradata
- Business Objects
- R
Requirement
Profitability study of the acquisition actions and initiatives implemented in the different channels of the company, to optimize cost, pricing and investment decisions.
Solution
Activations ROI calculation, monitoring and analysis. Application of statistical clustering techniques to estimate revenue, lifetime and costs at customer level, calculating the profitability of actions, channels and products. Automated tracking monthly dashboard.
Benefits
- Commercial offer monthly profitability monitoring, allowing its redesign in an agile way. Identification of unprofitable products and offers (corrective actions) and groups with high profitability (to enhance).
- Estimation of profitability results in new products, tariffs or discounts design and launch processes.