This project creates a Sales Dashboard using Streamlit, Plotly and DuckDB, featuring performance visuals and financial data to analyze the economic dynamics of a company.
- Upload and visualize sales data from an Excel file.
- Overview of yearly and monthly sales performance.
- Detailed analysis of budget vs. forecast.
- Visual representation of sales by business unit and scenario.
Install using requirements.txt
- Python 3.11 or more
- Streamlit
- Plotly
- Pandas
- DuckDB
-
Clone the repository:
git clone https://github.com/kunal9960/workflow_dashboard.git cd workflow_dashboard
-
Install required packages:
pip install -r requirements.txt
-
Run the Streamlit application:
streamlit run main.py
-
Upload your own data file or use the default dataset provided.
-
Data Preview: Explore a preview of the uploaded sales data, including yearly and monthly summaries.
-
Configuration: Upload your own sales data file or use the default dataset to customize the dashboard.
-
Dashboard Preview: View visualizations such as bar charts for yearly sales, line charts for monthly budget vs. forecast, and bar charts for yearly sales per account.
Contributions are welcome! If you have any ideas for improvements or new features, feel free to fork the repository and submit a pull request. You can also open an issue to report bugs or suggest enhancements.
Feel free to contact me if you need help with any of the projects :)