IS428 2016-17 Term1 Assign2 Timothy Tan Swee Guang

From Visual Analytics for Business Intelligence
Revision as of 05:26, 25 September 2016 by Timothytan.2013 (talk | contribs)
Jump to navigation Jump to search

Perception and Data: How the media influences perceptions of consumption patterns around the world

Abstract

Problem and Motivation

With the ubiquitous presence of the media in everyday life, it is easy for us to form conscious or unconscious perceptions of different societies based on what the media portrays it to be. For example, the media always depicts European meals as fresh and healthy (I.e. Italian Pastas, Paella from Spain, Greek Salads or fresh fish from the Netherlands). Whilst, associating fast-food or unhealthy foods to countries like the US or Canada. But is this really true? Or is the media truly biasing our perceptions?

This study aims to explore how media can influence our perceptions on how we perceive differing countries consumption patterns. Through the use of food facts, the study attempts to proxy how media bias our views on how healthy or unhealthy a country truly is through its advertisements on what they eat.This study will proxy products availability in a country as an indicator of what people eat in that country.

Health Indicators


Healthy Measures (per 100g)
- Fiber
- Fruits, Vegetables and Nuts
- Monounsaturated Fat
- Omega 3 Fat
- Polyunsaturated Fat
- Proteins

Unhealthy Measures (per 100g)
- Alcohol
- Fat
- Salt
- Saturated Fat
- Sugars
- Trans Fat

Approaches

Data Preprocessing


1. Removed "Null" Product Names
2. Treated "Countries_en" column
- Delimited multivalued cells
- Stacked Columns
3. Treated "main_category_en" column
- Removed names with ":" by formula


Policy Recommendations

Tools Utilized

  1. Excel 2013 for data preparation
  2. SAS Enterprise Guide for data preparation
  3. JMP-PRO for data preparation
  4. Tableau for visualization