Project Overview
A cloud-based BI analytics solution was designed for leading news agency to analyze a large amount of historical data from various data sources. With an aim to increase its subscription, pentaho community stack is used which provided data-driven insights and generates real-time data. This effectively designed solution can minimize the churn rate and help to create an effective digital marketing campaign strategy.

Industry
Media & Entertainment
Tools & Technologies


Top Features
- Caters to diverse data sources
- Amazon Redshift Cloud DB
- Weblogs to capture user behavior and browsing patterns on the web
- Google Analytics to capture online traffic information
- Business Application for master and transactions information
- 3rd party data sources for media views and user stats
- Analyze data sources and derive the KPIs and KRAs jointly with the client to meet the business requirements
- Deploys various complex ETL jobs and transformation to integrate historical data and live data to generate near real-time analytics
- Dashboard Screens to generate behavior analytics, authors’ performance, subscribers, segment, marketing analytics
- Page View/Reader Analysis
- Content Analysis
- Subscriber Analysis
- Churn model to minimize the subscriber’s churning rate using effective data analytics
- Tools and Technologies
- Pentaho CE Edition
- HP Vertica