|
|
| Line 27: |
Line 27: |
| | <br/> | | <br/> |
| | <div align="left"> | | <div align="left"> |
| − | <div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">DATA</font></div> | + | <div style="background: #ffebba; padding: 12px;font-family:Helvetica; font-size: 15px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #ffcc16 solid 10px; border-right: #ffcc16 solid 10px; text-align:center "><font color="#3f3d3d">DATA CLEANING</font></div> |
| | <br/> | | <br/> |
| − | ::'''Company X provided us excel files containing the following data:'''
| |
| − |
| |
| − | ::*Distribution of stores Company X supplies to across Singapore from 2014 to 2017, according to the type of store, the product brand supplied and the region the store is located. There are four types of stores, namely:
| |
| − | ::**THC: supermarkets, convenience stores and petrol marts.
| |
| − | ::**TOP: Chinese restaurants and seafood restaurants.
| |
| − | ::**MOB: modern cafés, bars and pubs.
| |
| − | ::**New channels and events: stores which are not permanent such as carnivals and sponsorships.
| |
| − |
| |
| − | ::*Key performance indicators of each brand from 2014 to 2017 for different age groups of males. The KPI scores are derived from surveys conducted by Company X.
| |
| − | ::*Price index of each brand from 2015 to 2017. This shows the average retail prices.
| |
| − | ::*Details of the promotions which retailers advertised on newspapers such as The Strait Times and Lian He Zao Bao, from 2017 to 2018, for the brands Company X owns as well as competing brands.
| |
| − | ::*Duration and date of the campaigns Company X held for each brand in 2017.
| |
| − | ::*Monthly sales volume for each brand from 2014 to 2017.
| |
