Analytics for International Environmental Programs
About Client
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.
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.
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.
Similar Project Idea?
We have helped a number of global clientele with our analysis and reporting services to drive better performance based on data
Technologies & Tools
Our Process
Research/Analysis
Our detailed and accurate research , analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.
Design
We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.
Coding
Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.
Testing
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.
Launch
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 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.
Looking For Something Similar?
We have worked with some of the best innovative ideas and brands in the world across industries.