Go Green One tree
One life


The rapidly growing news agency was facing a challenge of analyzing large amount of historical data from various data sources and then generating meaningful analytics out of that.

Data Sources: Amazon Redshift Cloud DB

Weblogs: Capture user behavior and browsing patterns on the web.

Google Analytics: Capture online traffics information.

Business Application: Capture the master and transactions information.

3rd party data sources: Capture the information about media views and user stats.

Consolidate the data from various semi-structured and structured database and populate into a data warehouse.

Mapping of data from various data sources.

Generating behavior analytics, authors’ performance, subscribers, segment, marketing analytics.

Define the Subscriber Churn Model to minimize the customer attrition.

Our Solution

SPEC INDIA implemented a Cloud based BI Analytics Solution using Pentaho community stack, below are the solution features:

Analyze data sources and derive the KPIs and KRAs jointly with client to meet the business requirements.

Consolidate various data sources like Amazon Redshift Cloud DB, Weblogs (Semi-structured data), Polopoly (Oracle 11g), Google Analytics (Google APIs), Video Brightcove (Rest APIs).

Deployed various complex ETL jobs and transformation to integrate historical data and live data to generate near real time analytics.

Interface development to monitor the ETL jobs status as well as perform data cleansing.

Customize the Pentaho open source code to achieve specific business requirements.

Page View/Reader Analysis To visualize the number of readers for each of the category like sports/newspaper/politics etc.

Segment different type of readers i.e. occasional/frequent/Engaged readers

Linear Regression for future page views

Separate analysis for the Mobile readers and Website readers

Customization to add the comments/descriptions for any of the data points.

Content Analysis Visualize different types of author articles and viewers of the articles.

Top 10 authors with option to check the granularity of article and headline.

Analyze the history of the different articles published by authors and popularity of those articles.

Hourly traffic analysis of the article viewers

Top performing articles and sources which attracted viewers to go to the articles

Subscriber Analysis Visualize the topline summary and percentage engagement by entitlement

Subscriber content preferences and breakdown for subscription type

Subscriber trends analysis

Analysis on added Versus Cancelled Versus Pending subscribers

Effective campaign recommendation to retain the subscribers


Similar Project Idea?

We have helped a number of global clientele with our analysis and reporting services to drive better performance based on data

Submit Request

Technologies & Tools


Our Process


Our detailed and accurate research , analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.


We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.


Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.


Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.


We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.

Business Benefits

SPEC India’s successful implementation of Cloud based BI Analytics Solution helped news agency in meeting its subscription and digital marketing goals.

Centralized authors, subscriber, articles and viewers for generating analytics.

Minimize the subscriber churning using the effective data analytics.

Get meaningful insights from historical and real time data.

Effectively design the new digital media marketing campaign strategy.

Identify performing and non-performing authors, articles and content.

Saiku Analytics and Self-service Dashboard Plug-in helped end users to generate the adhoc analytics and own dashboards.


Looking For Something Similar?

We have worked with some of the best innovative ideas and brands in the world across industries.

Connect With Us