Amrit Subramaniam

An Analysis on the severity of CoVID-19 in Tamil Nadu GUIDED BY Revathi Santhanam BaneraSoft (I) Pvt. Ltd. REPORTED BY Amrit Subramaniam BaneraSoft (I) Pvt. Ltd. 3rd April 2020 - METHOD OF ANALYSIS Visualization of Information Data Acquisition – Ministry of Health & Family Welfare, Government of India • An overview of the figures across the state, with a timeline of the positive cases’ history, with district wise views • Graph chart visuals showing the figures overall, and per district Data Selection – District-wise data for the state of Tamil Nadu Data Preprocessing Geographical Analysis Analysis Visualization of Information • A map indicating the affected districts with buttons sized proportional to the number of cases • Specific district data viewable from the map, when the button corresponding is clicked Geographical Analysis Most & Least Affected Areas 2 VISUAL ANALYSIS - 3 Slicer with districts listed, to select and further analyze a particular region Gauge indicating the active cases (colored) and the discharged cases VISUAL ANALYSIS - 4 “Chennai” has been selected from the list of districts, with all other visual elements reflecting Out of 44 cases, 35 are yet to recover Case history, across the time period indicated in the legend GEOGRAPHICAL ANALYSIS - 5 Supported by a visual map, the circles that are larger in size symbolize more cases in that region. Clicking on a district’s circle focuses the other elements to display that district’s data A “hover-over” tool tip displaying essential details, while navigating across the map GEOGRAPHICAL ANALYSIS - 6 “Namakkal” district has been selected on the map, thereby making the other elements focus on its data The pie chart indicates this district’s significance to the overall number MOST AFFECTED DISTRICTS - 7 Chennai, Namakkal, Tirunelveli, Coimbatore, Salem districts have been worst hit by the spread of CoVID-19 LEAST AFFECTED DISTRICTS - 8 Ariyalur, Karur, Thanjavur, Tiruppur, Tiruvarur districts are least affected by the spread of CoVID-19 CONCLUSION Analysis Result - The spread of CoVID-19 in Tamil Nadu is over a scattered geographical area, and appears to have equal magnitude (number of persons infected) regardless of how far the districts are. The contagion at scattered areas can prove dangerous as the disease is believed to have a fast incubation rate within a healthy person Action Plan Initiate district wise home testing for those who might have come in contact with those infected, as the contagion is severe only in few districts Suspend the gathering of people for insignificant reasons, similar to a curfew, and ensure availability of medical facilities in all districts, with special focus on those districts affected the most. 9 THANK YOU! DATA SOURCED FROM • Ministry of Health & Family Welfare, Government of India INFORMATION PROCESSED ON • Microsoft Power BI SCOPE FOR IMPROVEMENT • Realtime sync for the numbers to be updated from time to time, and reflect across the different analysis reports - 10