Who turned the lights off?

 I was browsing through Alteryx Community and found an interesting dataset about power outage caused by animals. Dataset contains around 400 rows recording different news articles around the globe. It also contains which animal caused the outage and in what country. For some records, specific animal name was not specified and instead it says "Animal".

This was a challenge as to get actual count on specific animal I have to extract animal name from news article. I used some text mining feature in Alteryx to achieve this.

End result is a graph depicting power outage by different animals around the world.

Note:- I would not make any inference from this data as it was probably not a good sample of all the incidents around the world and was heavily biased on incidents concerning to United States . But still a fun analysis.

Click on picture to enlarge:-


Tool Used:- Tableau & Alteryx

Comments

Post a Comment

Popular posts from this blog

Superstore Executive Dashboard

Image
Here's my take on executive type dashboard built on superstore data. The major learning from this dashboard was using layout containers inside tableau to neatly organize dashboard items. Layout containers let you group related items together so you can quickly position them. Once items are inside the containers, you can change the size and placement of items inside a container and other items automatically adjust. There are two types of containers - vertical and horizontal. As name suggests, horizontal containers places items left/right and vertical containers places items above/below. It’s always a good idea to use containers for your production dashboards as this will greatly help you organize and standardize the size and layout of your dashboard’s worksheets.   Interactive Version Tool Used:- Tableau
Read more

Cereal Production Around the World – Africa’s Hunger Crisis

Image
 This dashboard shows uneven distribution of cereal production across the globe. Despite of green revolution launched half a century ago to maximize cereal production, most of the African states are still struggling to keep a balance between their population and cereal production which ultimately results in malnutrition of the population. Follow the link below the image for interactive viz.   Interactive Version Tool Used: Tableau
Read more

Melbourne Pedestrian Counting System

Image
Created this mobile friendly dashboard to track Pedestrian Patterns for Melbourne city. The city has sensors placed at major spots to track pedestrian foot traffic. Original tracking system can be found at http://www.pedestrian.melbourne.vic.gov.au/ . This dashboard is a makeover for the original system to better track pedestrian patterns. Using this information city administration can get information on different areas and rush at period of day. This information can be used for better city planning such as diverting traffic or deciding working hours for maintenance work. Interactive Version Tool Used: Tableau
Read more