{"id":16951,"date":"2019-10-07T02:55:31","date_gmt":"2019-10-07T06:55:31","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=16951"},"modified":"2019-10-07T02:55:38","modified_gmt":"2019-10-07T06:55:38","slug":"zomato-dataset-visualization-india","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/zomato-dataset-visualization-india\/","title":{"rendered":"Zomato Dataset Visualization – India"},"content":{"rendered":"\n

Zomato, founded in 2008, is an Indian company that provides information, menus, and user-reviews of a wide range of restaurants, and also has food delivery options from partner restaurants in select cities.  <\/p>\n\n\n\n

DATASET AND TOOLS<\/h4>\n\n\n\n

https:\/\/www.kaggle.com\/shrutimehta\/zomato-restaurants-data\/download<\/a><\/p>\n\n\n\n

The dataset used for this project was found on an online public data platform called Kaggle. It was relatively clean and did not require any major changes. Open refine<\/a> was used to make a few alterations. For instance, country codes were switched to country names to avoid any confusion and for better understandability. <\/p>\n\n\n\n

Once the dataset was refined, Tableau public<\/a> was used to create interactive charts and graphs.<\/p>\n\n\n\n

METHODOLOGY<\/h4>\n\n\n\n

As Zomato is an Indian company, I decided to focus on restaurants in India and its cities. The first sheet I created focused on the number of restaurants that have partnered with Zomato in different cities. A horizontal bar chart was used for the representation. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The next sheet uses a treemap to represent different cuisines based on people’s preferences. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Further, I created 2 pie charts to show online delivery and table booking options in restaurants and an overall rating highlight table. As there were only 2 sections (yes\/no), the pie chart was a good tool to depict the results. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To create a cohesive visual language, all the charts and graphs shared the same color palette. The sheets were then complied into a single dashboard. I wanted the visualization to be interactive and hence added a city-specific filter. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

https:\/\/public.tableau.com\/profile\/devanshi.gami#!\/vizhome\/ZomatoDatasetVisualization\/Dashboard1?publish=yes<\/a><\/p>\n\n\n\n

FINDINGS<\/h4>\n\n\n\n
  • New Delhi has the maximum number of restaurants that have partnered with Zomato. <\/li>
  • North Indian cuisine is the most preferred and searched for.<\/li><\/ul>\n\n\n\n

    REFLECTION<\/h4>\n\n\n\n

    This project helped me understand and study data better. Tableau public is fun and easy to learn. There were a few changes that I could directly make in the dataset using Tableau. By simply dragging and dropping data, I created 17 charts and graphs in a couple of hours and eventually picked 5 of them for the final dashboard.<\/p>\n\n\n\n

    The selected dataset didn\u2019t require a lot of cleaning up but I would have liked to manipulate it more to try and produce different stories. The visualization focuses on very broad categories right now. I would like to add to this project by adding individual restaurants for each city with their ratings and add filters like cuisines and cost. Although ratings are important, I thought to put cumulative ratings for all the restaurants was slightly vague. I would also have liked to experiment with the maps as Zomato is present in a lot of different countries and regions. <\/p>\n\n\n\n

    <\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Zomato, founded in 2008, is an Indian company that provides information, menus, and user-reviews of a wide range of restaurants, and also has food delivery options from partner restaurants in select cities.  DATASET AND TOOLS https:\/\/www.kaggle.com\/shrutimehta\/zomato-restaurants-data\/download The dataset used for this project was found on an online public data platform called Kaggle. It was relatively…<\/p>\n","protected":false},"author":634,"featured_media":16964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[458],"class_list":["post-16951","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Zomato.jpg?fit=1320%2C660&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-4pp","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/634"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=16951"}],"version-history":[{"count":5,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16951\/revisions"}],"predecessor-version":[{"id":16966,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16951\/revisions\/16966"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/16964"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=16951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=16951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=16951"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=16951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}