Assignments

IS428 Visual Analytics for Business Intelligenceand Applications

About

Assignment Dropbox

To be a Visual Detective

The assignments require you to put the concepts, methods and techniques you had learned in class to solve real world problem using visual analytics techniques. Students should also use the assignments to gain hands-on experience on using the data visualisation toolkits I had shared with you to complate the assignment.

Overview

Air pollution is an important risk factor for health in Europe and worldwide. A recent review of the global burden of disease showed that it is one of the top ten risk factors for health globally. Worldwide an estimated 7 million people died prematurely because of pollution; in the European Union (EU) 400,000 people suffer a premature death. The Organisation for Economic Cooperation and Development (OECD) predicts that in 2050 outdoor air pollution will be the top cause of environmentally related deaths worldwide. In addition, air pollution has also been classified as the leading environmental cause of cancer.

Air quality in Bulgaria is a big concern: measurements show that citizens all over the country breathe in air that is considered harmful to health. For example, concentrations of PM2.5 and PM10 are much higher than what the EU and the World Health Organization (WHO) have set to protect health.

Bulgaria had the highest PM2.5 concentrations of all EU-28 member states in urban areas over a three-year average. For PM10, Bulgaria is also leading on the top polluted countries with 77 μg/m3on the daily mean concentration (EU limit value is 50 μg/m3).

According to the WHO, 60 percent of the urban population in Bulgaria is exposed to dangerous (unhealthy) levels of particulate matter (PM10).

The Task

In this assignment, you are required to use visual analytics approach to reveal spatio-temporal patterns of air quality in Sofia City and to identify issues of concern.

You will be asked to answer the following types of questions:

1. What are the typical patterns in the prox card data? What does a typical day look like for GAStech employees?
2. Describe up to ten of the most interesting patterns that appear in the building data. Describe what is notable about the pattern and explain its possible significance.
3. Describe up to ten notable anomalies or unusual events you see in the data. Prioritize those issues that are most likely to represent a danger or a serious issue for building operations.
4. Describe up to five observed relationships between the proximity card data and building data elements. If you find a causal relationship (for example, a building event or condition leading to personnel behavior changes or personnel activity leading to building operations changes), describe your discovered cause and effect, the evidence you found to support it, and your level of confidence in your assessment of the relationship.

Task 1: Spatio-temporal Analysis of Official Air Quality

Using appropriate data visualisation, you are required will be asked to answer the following types of questions:

1. What are the typical patterns in the official air quality data? What does a typical day look like for Sofia city?
2. Describe up to ten of the most interesting patterns that appear in the official air quality data. Describe what is notable about the pattern and explain its possible significance.

Task 2: Spatio-temporal Analysis of Citizen Science Air Quality Measurements

Using appropriate data visualisation, you are required will be asked to answer the following types of questions:

1. What are the typical patterns in the citizen science air quality measurements data? What does a typical day look like for Sofia city?
2. Describe up to ten of the most interesting patterns that appear in the citizen science air quality measurements data. Describe what is notable about the pattern and explain its possible significance.

Task 3

According to Unmask My City, a global initiative by doctors, nurses, public health practitioners, and allied health professionals dedicated to improving air quality and reducing emissions in our cities, Bulgaria’s main sources of PM10, and fine particle pollution PM2.5 (particles 2.5 microns or smaller) are household burning of fossil fuels or biomass, and transport. Production of electricity by burning of coal in thermal power plants and other industrial processes are a major contributor to unhealthy air. Coal plants are responsible for almost all of the country’s sulfur-dioxide and the majority of nitrogen-oxides emissions, causing smog and acid rain.

The Data Sets

Four major data sets in zipped file format are provided for this assignment, they are:

• Official air quality measurements (5 stations in the city)(EEA Data.zip) – as per EU guidelines on air quality monitoring see the data description HERE…
• Citizen science air quality measurements (Air Tube.zip) , incl. temperature, humidity and pressure (many stations) and topography (gridded data).
• Meteorological measurements (1 station)(METEO-data.zip): Temperature; Humidity; Wind speed; Pressure; Rainfall; Visibility
• Topography data (TOPO-DATA)

They can be download by click on this link.

Visualisation Software

To perform the visual analysis, students are encouraged to explore any one or a combination of the following software:

• Tableau
• JMP Pro
• Qlik Sense
• Microsoft Power BI

One of the goals of this assignment is for you to learn to use and evaluate the effectiveness of these visual analytics tools.

Submission details

This is an individual assignment. You are required to work on the assignment and prepare submission individually. Your completed assignment is due on 11th November 2018, by 11.59pm mid-night.

You need to edit your assignment in the appropriate wiki page of the Assignment Dropbox. The title of the wiki page should be in the form of: IS428_2018-19_T1_Assign_FullName.

The assignment wiki page should include the URL link to the web-based interactive data visualization system prepared.

Reference

• IS428 2016-17 Term1 Assign3 Gwendoline Tan Wan Xin
• IS428 2016-17 Term1 Assign3 Lim Kim Yong
• IS428 2016-17 Term1 Assign3 Tan Kee Hock

Assignment Q&A

Need more clarification, please feel free to pen down your questions.