Difference between revisions of "ISSS608 2017-18 T1 Assign AISHWARYA MOHAN"
(Created page with "Smartpolis is a major metropolitan area with a population of approximately two million residents. During the last few days, health professionals at local hospitals have notice...") |
|||
| (16 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | == Overview == | ||
Smartpolis is a major metropolitan area with a population of approximately two million residents. During the last few days, health professionals at local hospitals have noticed a dramatic increase in reported illnesses. | Smartpolis is a major metropolitan area with a population of approximately two million residents. During the last few days, health professionals at local hospitals have noticed a dramatic increase in reported illnesses. | ||
Observed symptoms are largely flulike and include fever, chills,sweats, aches and pains, fatigue, coughing, breathing difficulty, nausea and vomiting, diarrhea, and enlarged lymph nodes. More recently, there have been several deaths believed to be associated with the current outbreak. City officials fear a possible epidemic and are mobilizing emergency management resources to mitigate the impact. | Observed symptoms are largely flulike and include fever, chills,sweats, aches and pains, fatigue, coughing, breathing difficulty, nausea and vomiting, diarrhea, and enlarged lymph nodes. More recently, there have been several deaths believed to be associated with the current outbreak. City officials fear a possible epidemic and are mobilizing emergency management resources to mitigate the impact. | ||
| + | == Epidemic Cause == | ||
| + | The epidemic is originated by a oil spill in the middle west area along the bridge. There has been various blogs on this spill which has been caused by a truck accident. This to be precise has been reported from the location 42.22655N, 93.42752W. | ||
| + | === '''Hypothesis''' === | ||
| + | The text explorer was used to find out the most common phrases. One of them was a oil spill which seemed very odd from the rest. Filtering these phrases, and breaking down the blogs we can find that there has been a truck accident in the locality. This is on about 400 above blogs and around the particular area. Filtering the causes further seemed to have originated around the area after the particular incident.From the analysis we can get down to the date on which the incident started. This helped me to filter out the dates in tableau work books and analyse the impact which is later on explained. | ||
| + | The data has been further cleaned and made to analyse in an easy way at tableau. The method to clean data has been done by perfoming text analytics in excel, thereby filtering out the unwanetd and unrelated blogs. | ||
| + | |||
| + | |||
| + | |||
| + | [[File:JMP IMG.png|Location of accident]] | ||
| + | |||
| + | Tableau workbook :https://public.tableau.com/profile/aishwarya2347#!/vizhome/AishwaryaMohan_AssignmentWorkbook/Dashboardanalysis?publish=yes | ||
| + | === Causes === | ||
| + | The causes has been both airbone and waterborne through the river. Initially there has been more symptoms of airborne such as breathing and other lung related issues. Further the cause has been based out of waterborne infections. | ||
| + | The text explorer has been used to get the most common phrases which has given an idea of symptoms,this was later used in excel to model the data to be used in jmp and tableau for further analysis. | ||
| + | [[File:example.jpg|frame|Text explorer]] | ||
Latest revision as of 13:37, 4 December 2017
Overview
Smartpolis is a major metropolitan area with a population of approximately two million residents. During the last few days, health professionals at local hospitals have noticed a dramatic increase in reported illnesses.
Observed symptoms are largely flulike and include fever, chills,sweats, aches and pains, fatigue, coughing, breathing difficulty, nausea and vomiting, diarrhea, and enlarged lymph nodes. More recently, there have been several deaths believed to be associated with the current outbreak. City officials fear a possible epidemic and are mobilizing emergency management resources to mitigate the impact.
Epidemic Cause
The epidemic is originated by a oil spill in the middle west area along the bridge. There has been various blogs on this spill which has been caused by a truck accident. This to be precise has been reported from the location 42.22655N, 93.42752W.
Hypothesis
The text explorer was used to find out the most common phrases. One of them was a oil spill which seemed very odd from the rest. Filtering these phrases, and breaking down the blogs we can find that there has been a truck accident in the locality. This is on about 400 above blogs and around the particular area. Filtering the causes further seemed to have originated around the area after the particular incident.From the analysis we can get down to the date on which the incident started. This helped me to filter out the dates in tableau work books and analyse the impact which is later on explained. The data has been further cleaned and made to analyse in an easy way at tableau. The method to clean data has been done by perfoming text analytics in excel, thereby filtering out the unwanetd and unrelated blogs.
Tableau workbook :https://public.tableau.com/profile/aishwarya2347#!/vizhome/AishwaryaMohan_AssignmentWorkbook/Dashboardanalysis?publish=yes
Causes
The causes has been both airbone and waterborne through the river. Initially there has been more symptoms of airborne such as breathing and other lung related issues. Further the cause has been based out of waterborne infections. The text explorer has been used to get the most common phrases which has given an idea of symptoms,this was later used in excel to model the data to be used in jmp and tableau for further analysis.
