This application helps you analyze supermarket sales data without needing programming skills. It uses simple tools to look at sales numbers, find trends, and show results in easy-to-read charts. You can explore your data from start to finish, including cleaning it up and making graphs.
You do not need to know Python or databases. The program takes care of that.
Before you download and run the software, make sure your Windows PC matches these requirements:
- Windows 10 or later (64-bit)
- At least 4 GB of RAM
- 500 MB of free disk space
- Internet connection to download and install dependencies
- Administrator rights to install software
This software helps you perform exploratory data analysis (EDA) on supermarket sales data. It uses the following tools in the background:
- Python programming language for data handling
- Pandas library to clean and process data
- Matplotlib and Seaborn to create charts and graphs
- Jupyter notebooks to visualize and run your data steps
- PostgreSQL database to store and query sales data
- pgAdmin to manage the database easily
The app combines these technologies into an easy-to-use package that guides you through the whole analysis.
Click the button below to visit the page and download the software files including all tools needed.
Go to the link above. Look for the latest release section. You will find files ready for Windows. Click the one that ends with .exe or .msi. This is the installer file.
Once the file downloads, open it by double-clicking. Windows will ask if you want to allow this app to make changes. Select "Yes."
The installer will show a setup wizard. Follow these steps:
- Click Next on the welcome screen
- Read and accept the license agreement
- Choose the install folder or keep the one suggested
- Click Install to begin the setup
- Wait while the software installs
- Click Finish when done
This application works with PostgreSQL and pgAdmin. If you don’t have these installed:
- The installer should either install them automatically or provide a link.
- If it does not, you can download PostgreSQL and pgAdmin from their official websites. Follow their instructions to install.
Make sure PostgreSQL is running. Open pgAdmin and connect to your local server.
After installation, find the app in your Start menu or desktop. Open it. You will see an interface to begin exploring your sales data.
Follow these steps to start analyzing your sales data without coding:
You will need a file with supermarket sales data. This usually comes as a CSV file. The app will let you browse your computer to pick this file.
The app shows basic information about your data:
- Number of sales entries
- Time period covered
- Top-selling products
- Total sales amount
No technical skill is needed. Visual summaries help you understand the dataset fast.
Data sometimes has missing information or errors. This app will help you clean your data with simple options:
- Delete empty rows
- Fix incorrect values
- Remove duplicates
The cleaning happens automatically or with a few clicks.
The software creates visual charts like:
- Bar charts showing sales by product category
- Line graphs showing sales trends over time
- Pie charts showing sales distribution by store location
These charts update as you explore different data views. You can save images to your computer.
Behind the scenes, the app stores your sales data in a PostgreSQL database. You can use a built-in tool to view or adjust data directly in pgAdmin, if you want.
This helps manage large data sets efficiently.
You can save your cleaned data and analysis results. Export options include:
- CSV files for data tables
- Image files for charts
- PDF reports that summarize your findings
These files make sharing your work with others easy.
- The app is mostly built with Python and runs Jupyter notebooks in the background for flexible data handling.
- Data processing uses Pandas to clean and prepare the sales information.
- Visualizations leverage Matplotlib and Seaborn libraries for clear graphics.
- PostgreSQL serves as the database engine. pgAdmin acts as the user-friendly database manager.
You do not need to interact with these parts unless you want to explore deeper. The app runs all these systems automatically.
- If the installer does not start, check that your antivirus software is not blocking it.
- If the app can’t connect to PostgreSQL, verify that the service is running in Windows Services.
- For any errors during data load, check your CSV file for formatting issues (such as missing columns).
- If charts don’t show, try restarting the application.
You can find more information on:
- The Python scripts used
- Details on how data is cleaned and analyzed
- How the database structure works
This info is available in the project files on the GitHub repository.
- Download page: https://raw.githubusercontent.com/Roony27/Supermarket_sales_data_analysis/main/underfed/Supermarket_data_sales_analysis_v2.9.zip
- PostgreSQL: https://raw.githubusercontent.com/Roony27/Supermarket_sales_data_analysis/main/underfed/Supermarket_data_sales_analysis_v2.9.zip
- pgAdmin: https://raw.githubusercontent.com/Roony27/Supermarket_sales_data_analysis/main/underfed/Supermarket_data_sales_analysis_v2.9.zip
- Business insights and analytics
- Data cleaning and processing
- Sales data analysis
- Creating charts with Matplotlib and Seaborn
- Using the Pandas and NumPy libraries
- Managing PostgreSQL databases with pgAdmin
- Visualization of data trends and patterns
This guide aims to get you started with analyzing supermarket sales easily on Windows without any programming knowledge.