Problem Statement
Coronavirus disease (COVID-19) is an infectious disease caused by a newly discovered SARS-CoV-2 virus. The governments of all countries/ states are taking steps to slow the spread of the virus by testing and treating patients, tracing contacts, limiting travel, quarantining, and providing proper hospital facilities. hospital facility etc.
Value Proposition
By leveraging advanced analytics and visualization tools on data captured across ICT applications deployed At the frontlines, the State Dashboard Solution provides valuable insights and evidence to help make bold decisions to effectively fight the pandemic.
Various Statistical Models are constructed to –
- Understand the 360 view of the situation
- Situational Forecasting & Predictive Modelling
- Hospital Infrastructure & Medical Resource Optimization
Solution Strategy
Problem Statement
The Hon’ble Chief Minister Dashboard (CM Dashboard) has been envisioned to ensure a sustained and consistent performance across various sectors, an Information Reporting Framework are highly significant to ensure the right information reaches the CM office at the right time and in the right format.
Value Proposition
The framework would provide indicators and dashboards, this will allow officials to get information about various departments’ progress which will help the CM office to strategize the citizen engagement of a state.
Various Analytical Dashboards are built to –
- Showcase, the progress of various schemes.
- Implement the web-based application for the Chief Minister’s Office (CMO) enabling a comprehensive analytics-based interactive solution.
- Provide Chief Ministers and departments with quick and detailed information about various government schemes and departments that will help them take policy decisions.
Solution Strategy
Problem Statement
Requirement of a framework containing capabilities to manage and store data, intelligence, and analytics engine to monitor suspicious entities/transactions, and an investigation interface to evaluate alerts, along with a visualization and reporting solution that provides an overview of overall operations.
Value Proposition
Structured data Should be provide in either Streaming Format or HDFS Format. Data is received from The Ingestion layer which is further To create ETL, Analytical Data/Reporting Marts, which will be further used in the Investigation.
- Horizontal table partitioning approach
- Calculating Columns for Analytical approach/Processes
- Use extended/additional table approach – another way to implement vertical partitioning
- Logical file grouping will be used for better performance