DATASET$1-3$ POINTS

$$ Cleaning the data

$$ Remove empty rows.

$$ Remove incomplete Event records. Every process step must have a date.

$$ Remove duplicate Event records. Each Event ID is unique.

$$ If Excel does not recognize the process step data as dates, convert the cell contents into dates.

$$ Event IDs and Event types are numbers by format.

Analysing the data

$$Calculate the duration $($in days$)$ between each process step and the total duration for all Events.

$$ Calculate the average duration between each process step and the average total process duration for all

Event types.

Example for a single Event:

Submit three Excel$-$files.

Name the files:

firstname$-$lastname$-$assignment$2-$DATASET

firstname$-$lastname$-$assignment$2$POWERQUERY

firstname$-$lastname$-$assignment$2-$FINDANDMERGE

Points for the assignment $($total $15)$:

DATASETS $6$

POWER QUERY $6$

FIND AND MERGE $3$

See instructions in separate PDF$.$DATASETS

$$ "DATASETS"$-$file has three sheets. First sheet "DATASET$1"$ is its own task and sheets two and three, "DATASET$2\_1"$ and "DATASET$2\_2"$ are another one.

$$ The datasets needs to be cleaned before they can be analysed. You can turn the data into table or keep as a range, whichever you find easier to work with.

$$ DATASET$1$ basic info

$$ The data is process data where Events go through a process from A to G$.$

$$ Process step colums A to G have dates as data. The date depicts when the process step began. Process step G means completion of the whole process.

$$ DATASET$2$ basic info

$$ The data is sales data for product range. SKU $($stock keeping unit$)$ is assigned to each unique product.

Agency depicts a retailer. Volume is the amount sold during the time and average max temp describes the temperature at the retailer for the sales