Data Driven Business Strategies

Core Task

Use a Generative AI package (such as ChatGPT) and RapidMiner to prepare a Weekly Sales Report for a fictitious medium sized retailer that operates a chain of 5 stores selling Pet Supplies.

The name of your store is "[surname] R Us". Replace [surname] with your surname/last name. eg. Wysel R Us

As this assignment involves significant preparatory work, your submitted assignment will limited to 500 words.

Details

This assignment comprises four tasks:

1. Create the data using a GenAI package (to be submitted as .csv)
2. Mine the data using RapidMiner
3. Create copy (words) for the Sales Report using a GenAI package
4. Collate into a '1-page' Weekly Sales Report (to be submitted as .docx)

> Step 1. Create Data using GenAI

Use a GenAI package (such as ChatGPT) to create sample/dummy data that resembles the output of a transaction processing system. Ensure your data includes at least the following fields:

• Transaction ID, Store Location, Date, Time, Customer ID, Product ID, Product Name, Quantity, Cost (of Item Sold), Price

The data must cover 1 week (7 days) of operations and include: 500 transactions for each of the retailers five (5) stores. Total of 2500 transactions. This dataset must be saved as a CSV and be submitted. A brief summary of data is attached.

> Step 2. Mine the Data using RapidMiner

Using RapidMiner mine the dataset you have just created to determine:

1. Comparative Sales (Revenue) for each store
2. Top Five Products for the store with the highest Sales
3. Bottom Five Products for the store with the highest Sales
4. Comparative Gross Profit for each store
5. Biggest Trenders - that is, the single product whose volume increased by the highest amount from Day 1 to Day 7 across all stores. That is, (Day 7 volume) / (Day 1 volume). 'volume' = number of units sold (per day)

Create charts for each insight above that convey the insight you have uncovered. Append a screenshot of your final Process window showing the operators you used in RapidMiner to generate your answers.

> Step 3. Create Copy for the Weekly Sales Report

Use a GenAI package (such as ChatGPT) to create a commentary and additional insight on your findings from Step 2 suitable for a Weekly Sales Report for the senior management of your company.

> Step 4. Collate into a '1-pager' Weekly Sales Report

Prepare and submit a 1-pager Weekly Sales Report* that includes:

• Insight and Charts from your analysis in Step 2
• Brief commentary created in Step 3
• Screen Shot of your RapidMiner processes from Step 2. This can be inserted as an appendix on the second page.

* You might want to ask ChatGPT "what is a 1-pager Weekly Sales Report"

This Weekly Sales Report must be submitted as a .docx and must will be marked against the BA/BI theory covered in Workshops (W2-4) and Context and Infrastructure theory from Lectures (T1-4). I am currently stuck on step 2.5 identifying the trenders. I cannot get the expression to calculate Volume (day 7) / Volume (day 1) to work. Please help me get the process to do this step. A screenshot and explanation would really help. Thanks