Statewide Analytics Engine for Comprehensive Insights
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Government Banking Administration
Industry
Government, Banking, Financial Services, & Insurance
Business Problem
The solution framework required was a state-wide analytical engine which takes in data from various sources like government department databases, internet, sensors, machine logs, etc., transforms them, and presents them in an user friendly format. The solution must provide insights into government schemes and policies through relevant performance metrics and to improve collaboration among departments. The client needs a system of dashboards which would enable administrators to monitor and implement government programs effectively.
Challenges
- Data silos – 24 distinct state departments.
- Data discrepancies and completeness.
- No insights into performance of departments.
- Zero to low utilization of data in most departments.
Solutions
- Development of integrated BI & advanced analytics solution.
- Structured/unstructured data from databases/web/IoT – design data models, perform ETL, improve quality, aggregate, make available for down stream applications.
- Self service BI, statistical/predictive analytics solutions.
- Price forecasting for commodities.
- Sentiment analysis on government created policies.
- Recommendation engine based on statistical models for taxation.
- Recommendation engine based on statistical models for Govt. Loans & swapping.
- Market basket analysis on MNREGA policy to increase average wage.
- Cluster analysis to improve farming practices & crop yield.
- Correlation analysis for crop yield and nutrient recommendations.
Technical Environment
- SAS EMiner, SAS VA, SAS EG, SAS data quality, SAS contextual analytics, SAS forecast studio, microsoft SQL server 2017, hortonworks data platform.
Results
- Increased ROI for the electricity department.
- Forecast solution for vaccination inventory optimization and track the efficient usage.