Skip to content
SPEC INDIA

SPEC INDIA

Request a Quote
Menu
  • Services
      • Custom Software Development
      • Enterprise Mobility
      • Technology Consulting
      • Business Intelligence & Analytics
      • On-Demand Team
      • Product Engineering
      • Legacy Application Modernization
      • Software Testing & QA
      • SLA Driven 24/7 Support
  • Technology
      • .NET core
      • ASP.NET
      • Java
      • Power BI
      • Tableau
      • Pentaho
      • DevOps
      • IoT
      • Beacons
      • Fullstack
      • MEAN Stack
      • React
      • AngularJS
      • NodeJS
      • VueJS
      • Kotlin
      • Swift
      • React Native
      • Flutter
      • Python
      • ML
      • Big Data
      • Salesforce
      • R
      • AI
      • Azure
      • AWS
    • Our Innovation

      Hire highly-skilled on-demand teams to build sustainable, secure, and strategic digital solutions.

      Let's Connect
  • Industries
      • Retail & FMCG
      • Healthcare
      • Supply Chain & Logistics
      • Education
      • Manufacturing
      • Advertising
      • Travel & Hospitality
      • Media & Entertainment
      • Energy & Utilities
      • BFSI
  • Business Solutions
      • Custom Mobile ERP
      • Mobile Sales Force Automation (SFA)
      • Enterprise CRM
      • Warehouse Management System
      • Enterprise Service & Maintenance Solution
      • Vehicle Tracking System
      • Help Desk Management System
      • Laundry Management System
      • Spot Billing System
  • Our Work
    • Case Study
      Live BI Visualization
      Portfolio
  • Company
      • Overview
      • Quality Policy
      • GDPR
      • Testimonials
      • Life @ SPEC
      • CSR
      • Events & News
      • Engagement Models
      • Project Execution Models
      • Contact Us
      • Career
      • Blog
CLOSE

Cloud based Data Analytics for News Agency

SPEC INDIA/Case Study/Cloud based Data Analytics for News Agency

About the Customer

Industry: News Agency

Client is based in Ireland and is a leading quality newspaper – delivers news, opinion and analysis to around 793,000 readers each week. With media technologies evolving, different means of storytelling and delivery have come up. The company continues the transition from print to multiplatform publication, while upholding the journalistic principles that earned it the reputation as the paper of reference. Company began its online editions last year to reach its global readers.

 

About_News_Agency_Cloud_Data_Analytics

Key Challenges

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:

  1. Amazon Redshift Cloud DB
  2. Weblogs: Capture user behavior and browsing patterns on the web.
  3. Google Analytics: Capture online traffics information.
  4. Business Application: Capture the master and transactions information.
  5. 3rd party data sources: Capture the information about media views and user stats.

Some of the key challenges were:

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

 

News_Agency_Cloud_Data_Analytics_Challenges

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

Tools and Technologies

News_Agency_Cloud_Data_Analytics_Tools

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.


Download Now

Cloud based Data Analytics for News Agency


https://www.spec-india.com/wp-content/uploads/2018/12/data-Analytics-for-NewsAgency_SPECIndia.pdf

    Please prove you are human by selecting the Flag.

    Contact Now

      Please prove you are human by selecting the House.

      Safe & Confidential

      INDIA

      “SPEC House”, Parth Complex, Near Swastik Cross Roads, Navarangpura, Ahmedabad 380009, INDIA.

      +91-79-26404031, 32, 33, 34

      [email protected]

      USA

      “SPEC Partner", 350 Grove Street, Bridgewater, NJ 08807, United States.

      +1 908-450-9862

      [email protected]
      Goodfirms_Logo ISO_27001_Certified ISO_Icon top_mobile_app_developers_india_2020 Top_BI_Big_Data_Consultants_2020 Software_Developers_India_2020

      Services

      • Custom Software Development
      • Enterprise Mobility
      • Business Intelligence And Analytics
      • Web Application Development
      • Mobile App Development
      • UI / UX Design
      • Technology Consulting
      • Cloud Deployment
      • DevOps

      Quick Links

      • Blog
      • Career
      • News
      • Life @ SPEC
      • Case Study
      • Newsletter
      • Contact Us
      • Sitemap
      • Privacy Policy
      • Terms of Use
      • Tech in 200 Words

      © 2022 SPEC INDIA. All Rights Reserved.

      DMCA.com Protection Status

      Request a Quote

        .doc, .docx, .pdf, .xls, .xlsx, .jpg and .png files with 5MB size allowed.

        Please prove you are human by selecting the Heart.

        Safe & Confidential
        We use cookies to enhance your user experience. By continuing to browse, you hereby agree to the use of cookies.
        To know more; visit our Privacy Policy & Cookies PolicyAccept and Close
        Privacy & Cookies Policy

        Privacy Overview

        This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
        Necessary
        Always Enabled
        Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
        Non-necessary
        Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
        SAVE & ACCEPT