The ItemsSold table was converted into a CSV file and is available along$-$

side this assignment. $($This file is provided to you in XL format. You can

save it as CSV if you want, but XL is easier to read$).$

Spot at least $4$ data cleaning opportunities in the file. Comment on what

type of error it is$.$ Which of these problems can be fixed $?$

$($Q$2)$: The store management wants to run weekly reports such as:

$($a$)$ how much revenue is generated by each cashier?

$($b$)$ what quantity of each item is sold during each shift?

$($c$)$ what is the number of items sold per lane?

Prepare a star schema for a data warehouse. Clearly indicate the fact

measures in the Fact table $($call it SALESFACT$).$ Show the Fact table in

the center with the dimension tables around it$,$ in a star formation. The

Dimension tables should have the same name as in the original schema,

with the suffix $$ DIM$$

Note: In practical warehouse design, new keys $($called surrogate keys$)$ are

generated for the dimension tables. However, we will not concern ourselves

with that here. The dimension tables can have the same keys as the original

tables