Data Trends by Month Dashboard Excel

Description
The report provides a range of data with a high amount of detail. Some of the metrics covered include revenue v plan, expenses v plan on a region by region basis. Project spend, customer satisfaction, website visitors by department, 24 month trend analysis for revenue by employee, volume by employee, cultural diversity, attendance, risk, market growth, leads and product lines.

There are a number of charts including some high level gauge charts, a waterfall chart, customer satisfaction, employee satisfaction, change in FTE and an interesting look at projects by size comparing current year to the same period (n ) years ago. The report contains a range of interesting infographics which tie in well with the underlying dataset.

The report uses a slicer to spin the dashboard by region and the details by country will change accordingly. There is a combo box which allows the monthly aspects of the report to change showing YTD data seamlessly.

Users will gain the maximum benefit from this file if they are already competent spreadsheets users. The file is designed for people who use Excel on a regular basis, and are comfortable with using its tools and functions. Incorporation of new data should be plug and play considering the calculations you wish incorporated.

If you have any questions regarding this tool, don’t hesitate to reach out by starting a discussion below or private messaging directly through my Eloquens author channel.

If you’ve found this tool useful, show your appreciation by leaving a rating and a review!

-> If you want to acquire a full range of my Best Dashboards, have a look here: https://www.eloquens.com/tool/BN8rC7ld/startups/kpi-dashboards/premium-dashboard-models-the-very-best

-> If you want to learn with me how I actually build these Dashboards with dozens of best practices, check out my advanced video course here: https://www.eloquens.com/tool/dXVXtKZK/startups/kpi-dashboards/advanced-dashboard-design-course

- Marcus Small