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.
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
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.
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.