1

Prerequisites: Python

Ensure you have Python installed on your computer. This project was built using Python 3.8+, but any recent version of Python 3 should work.

Download Python

Python's installer typically includes pip, the package manager we'll use in the next steps.

2

Get The Project Files

Create a new folder on your computer (e.g., C:\Projects\Superstore). Download and place the following two files inside it.

Superstore Dataset.ipynb Superstore Dataset.csv

(Note: Use the files you downloaded from the GitHub repository).

3

Install Required Libraries

Open a command prompt (Terminal on Mac/Linux, CMD or PowerShell on Windows), navigate to your project folder, and run the following command:

pip install pandas numpy matplotlib seaborn xlsxwriter jupyter

This will download and install all the necessary libraries for the project.

4

Launch Jupyter

In the same command prompt, run this command to start the Jupyter Notebook server:

jupyter notebook

This will automatically open a new tab in your web browser. From the file list, click on Superstore Dataset.ipynb to open the notebook.

✓

Run the Code & Get Your Dashboard

Inside the Jupyter Notebook, go to the menu bar at the top and click Cell > Run All. This will execute the entire script.

You will see the code run from top to bottom. Upon completion, a new file, Superstore_Dashboard.xlsx, will be created in your project folder.

Congratulations! You have successfully generated the automated sales report.