Tag Archives: data visualization

Find a Living Place with the Help of Data Visualization Techniques

Author: Swaminathan Ramesh Sashi

1. Introduction

When you move into a new city, do you wonder which area is the best for living? In this article, I use data visualization techniques to help a family find the best area to live in Seattle. Although other cities can also be analyzed in a similar way, Seattle is chosen as an example because of ready availability of public datasets.

2. Analysis

2.1 Software used

Tableau 9.2, Excel, and R.

2.2 Dataset

The dataset is built from multiple sources. These sources are excel sheets containing various bits of data that make up the problem set.… Read more

Data Visualization with 911 Phone Records

Author: Swaminathan Ramesh Sashi

1. Introduction

Data visualization is a useful tool to analyze exploratory data and display the results. This article attempts to explain a few data visualization exercises which aim to analyze a composite dataset consisting of 911-phone records as well as the subsequent police report filings.

2. Analysis

2.1 Software used

Tableau 9.2 and Excel.

2.2 Dataset

The dataset consists of the following variables derived from the website of UW Madison Police Department:
Incident number (a unique id), incident date, incident time, location, zip codes, significance, incident description, and incident type. The dataset includes data from the years 2012-2015.… Read more

Data Visualization and Analysis, Part 3/3 – Binge Drinking

Author: Qi Chen

1. Introduction

This is the final part of Data Visualization and Analysis with R and Tableau Series, for the previous parts, please refer to part 1/3 and part 2/3 for details.

There are roughly 2 billion people around the world consuming alcoholic drinks. Among them, a great number of people are considered as “binge drinking”, which means consuming 5 or more drinks per single occasion for male and 4 or more drinks for female. Drinking alcohol has caused many problems and there are about 88,000 people died from alcohol-related causes annually. Moreover, $223.5 billion has been spent for alcohol misuse problems and 75% of the cost are related to binge drinking.… Read more

Data Visualization and Analysis, Part 2/3 – United States Department of Agriculture

Author: Qi Chen

1. Introduction

In the previous part, we introduced some data visualization techniques and showed the relationship of GDP, healthcare investment and life expectancy grouped by countries. In this article, we will focus on poverty and obesity, and analyze the dataset from United States Department of Agriculture. Specifically, by analyzing the dataset using data visualization techniques, we want to explore the following questions:

1. How does poverty rate vary within racial and ethnic groups?
2. Does the milk/soda price ratio influence obesity rate?
3. Are the obesity and diabetes rates higher in fast paced states like New York States than in agricultural states like Wisconsin?… Read more

Data Visualization and Analysis, Part 1/3 – World Bank Indicator

Author: Qi Chen

1. Introduction

Nowadays, unprecedented volume of data is available from books, radio, television, Internet and so on. From these data, useful knowledge can be discovered. However, data can be in any format such as numbers, text, or sound, which increases the difficulty of discovering useful knowledge. Some data formats, such as numbers, are sometimes too abstract and not friendly to people. As one of the techniques to address this issue, data visualization organizes different formats of data and presents it in a more easily understandable way.

In this article, we will demonstrate some examples of data visualization with Tableau.… Read more