In this lab we are going to analyze data from an apparel retail chain with locations in Missouri and Oklahoma. We will analyze the data from Missouri in PowerBI and the data from Oklahoma in Tableau.

Here are the data files from each state:

Missouri Stores Lab #$3$ Spring $2024.$xlsx

Oklahoma Stores Lab #$3$ Data Spring $2024.$xlsx

Each of the files has the following information:

Store ID $$ An identifier for each individual store in our region

City $$ Store$$s location city

State $$ Store$$s location state

Product ID $$ Unique identifier for products $($similar to an SKU$)$

Product Category $$ Categorization used by our company to group similar products

Cost $$ How much we paid per unit for each product

Price $$ How much we charge per unit for each product

Initial Quantity $$ How much of each product was in inventory on October $1$st

Quantity Sold $$ How many of each product was removed from inventory by December $26$th

Remaining Stock $$ How much of each product we plan to liquidate $($sell$)$ to a bargain retailer