ANLY482 AY2017-18T2 Group10 Project Overview: Data

From Analytics Practicum
Revision as of 13:13, 21 February 2018 by Minghao.ong.2014 (talk | contribs)
Jump to navigation Jump to search

Tennet logo.png


HOME

ABOUT US

PROJECT OVERVIEW

ANALYSIS & FINDINGS

PROJECT MANAGEMENT

BACK TO MAIN ANLY482

Overview

Data

Methodology

Data Overview

The data provided by the sponsor is in Microsoft Excel format for each outlet by month. For now, they have provided the data for a total of 12 months from Dec 2016 to Nov 2017. The data that was given to us are Inventory Data, Monthly PLU (Programmable Logic Unit) and Sales Data. One limitation is that the company has recently changed the format of the inventory data, and thus we would be working with 2 different formats of inventory data. Below is a short description of the each dataset:

Dataset NameDataset Description
InventoryDescribes the inventory order for each outlet the data is updated daily.
SalesDescribes the sales for each outlet for each month daily.
MonthPLUDescribes the number of patrons for each outlet according to the type of meal daily.

PLU Data Cleaning Process

Inventory Data Cleaning Process

Sales Data Cleaning Process