Difference between revisions of "ANLY482 AY2017-18T2 Group10 Project Overview: Data"
Jump to navigation
Jump to search
| Line 52: | Line 52: | ||
</div> | </div> | ||
| − | < | + | ==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em; text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic'; border-left:8px solid #1b96fe; margin-bottom:5px"><font color= #000000><strong>PLU Data Cleaning Process</strong></font></div>== |
| + | <div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px"> | ||
| + | |||
| + | </div> | ||
| + | |||
| + | ==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em; text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic'; border-left:8px solid #1b96fe; margin-bottom:5px"><font color= #000000><strong>Inventory Data Cleaning Process</strong></font></div>== | ||
| + | |||
| + | |||
| + | <div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px"> | ||
| + | |||
| + | </div> | ||
| + | |||
| + | ==<div style="background: #ffffff; padding: 17px;padding:0.3em; letter-spacing:0.1em; line-height: 0.1em; text-indent: 10px; font-size:17px; text-transform:uppercase; font-weight: light; font-family: 'Century Gothic'; border-left:8px solid #1b96fe; margin-bottom:5px"><font color= #000000><strong>Sales Data Cleaning Process</strong></font></div>== | ||
| + | |||
| + | <div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Century Gothic, Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left; font-size: 15px"> | ||
| + | |||
| + | </div> | ||
<!-- End Body ---> | <!-- End Body ---> | ||
Revision as of 13:13, 21 February 2018
Contents
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 Name | Dataset Description |
|---|---|
| Inventory | Describes the inventory order for each outlet the data is updated daily. |
| Sales | Describes the sales for each outlet for each month daily. |
| MonthPLU | Describes the number of patrons for each outlet according to the type of meal daily. |
