This repository contains a collection of Excel dashboards that I created while learning about Excel. The dashboards include pivot tables, various visuals like graphs and charts, and interactive elements.
- Objective :- On which range of customer we should spend more so that we will get more profit .
- Age wise Gender Calculation:- In 28-38 age group female and male count more. Next 18-27,38-47,48-57,58-67,68-77(Desc)
- Outlier Calculation:- "In annual income only 1 data point present as outlier so we can ignore this outlier. From Correlation table got to know age ,income and spending score are independent to eachother."
- Annual Incomewise Spending Score:-"28-37 age grp number of male/female count ,avg income and avg spending score more. other than 28-37 age grp,avg expenditure more for 18-27 and 68-77 grp but we can see count of male/female is very less in 68-77 grp .so from 68-77 grp from less ppl we are getting more profit ."
To use these dashboards, download the Excel files and open them in Excel. The dashboards are designed to be user-friendly, with clear labels and interactive elements that allow users to explore the data in different ways.
These dashboards are meant to be templates that can be customized to suit your specific needs.
You can modify the data sources, add or remove charts and tables, and adjust the formatting to match your branding or preferences.
I welcome feedback on these dashboards, as well as contributions from other Excel users who have created their own dashboards. Feel free to open an issue or pull request if you have suggestions or improvements to share.
Thank you for checking out my Excel dashboard repository!