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

Analytics for International Environmental Programs

SPEC INDIA/Case Study/Analytics for International Environmental Programs

About the Customer

Industry: Non-profit Organization

The client is a renowned analytical service provider for international development programs, under which they gather highly crucial data like ‘Number of direct jobs created for regions’, ‘Number of low carbon technology supported’, ‘Number of people that get clean energy’, ‘Bifurcation of male and female’, ‘Targeted vs. Actual year wise, region wise / city wise’ and much more.

About_International_Environmental_Analytics

Key Challenges

The primary key challenge that the client faced was that apart from possessing good infographics, they did not have an interactive dashboard for interactivity and analytics. They were keen to deliver an interactive dashboard to their client for enhanced decision making, assuming the design would match with their infographic.

One more area of concern was that they had a dynamic hierarchy being followed, as per specific region.

Also, the client needed to develop a Cube, for adhoc analytics, which involved a lot of complex calculations and adding extra dimensions.

Data Source:

A star schema based data warehouse, based which they needed to build the dashboards.

International_Environmental_Analytics_Challenges

Our Solution

SPEC INDIA developed a solution using the Pentaho stack – an open-source tool, since a quick customizing solution was the key requirement for the client. This comprehensive solution offered the following features:

  • Provide a complementary design compared to their existing infographics.
  • Offer an image based filter that synced with other types of manual filters and gave a very nice look and feel, meeting their basic requirement.
  • Give tree type filters, where in user can view the tree hierarchy and accordingly, select filter of any level.
  • Provide Saiku adhoc cube for analytics. The client had provided many result outputs that were to be generated through ad-hoc reporting, which we matched with the acceptance criteria.
  • For a faster access of the dashboard and reports within no time, we cached the result into memory with Hazelcast in Pentaho.

 

Functionality Details:

  • Program Analysis
    • Region wise, tree type filtration.
    • Advanced Filtration, with each database column of table (102 columns) smartly integrated as filtration.
    • Drillable TreeMap chart, gives the volume analysis for each region, city, program and event.
    • Interactive analysis of budget, provided in the lower panel of the BAR chart further drilling down to Year-Month-Quarter.
    • Interactive Legend of the TreeMap chart, wherein excluding one level will exclude the all child nodes.
  • Program Ranking
    • This report is for the ranking of different programs with 2 modes – a mode is like male-female, actual-budgeted and actual-forecast.
    • Cross Tabular information of region and event is provided in lower level, which interacts by the ranking of program with mode.
    • End user can export the all details in CSV or excel, to share with other users.
    • Interactive tree filtration.

Tools and Technologies

Environmental_Analytics_Technologies

Business Benefits

SPEC INDIA’s rollout for BI Analytics Solution assisted the company in decision making for certain crucial things. It benefitted them in the following ways:

  • Unique design and matching with infographics, making the BI system an integral part of their application.
  • Program ranking with different modes, providing an insight to the customer and creating an easy view of comparison for easy decision making.
  • Advanced type of analysis like TreeMAP chart and others for better decision making.
  • Program analysis dashboard giving a view of how the programs are distributed over multiple levels of the organization.
  • Cube to help them with ad-hoc analysis making them very comfortable with the BI system, which was earlier done through query only.
  • Bootstrap based dashboard provides the flexibility of the dashboard responsiveness to any device.


Download Now

Analytics for International Environmental Programs


https://www.spec-india.com/wp-content/uploads/2018/12/Analytics-for-International-Environmental-Programs_SPECIndia.pdf

    Please prove you are human by selecting the Plane.

    Contact Now

      Please prove you are human by selecting the Car.

      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 Top_BI_Big_Data_Consultants_2020 top_mobile_app_developers_india_2020 Top-Custom-Software To-Software-Development-Company Top-Web-Design-Company top-software-developers

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

        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