Excel Dashboard & Data Collector - Production Factory

STR ROCKS - The Rock Production factory

Requires the rock production factory's performance data to be recorded and simply analysed to include KPIs and custom reports all in one place. Must be easy to use and for security reasons Macro Free

Time for some Excel 🚀

The Data

Data was collected by planning & short intervals. [Data displayed is randomised specially for demo use]

The Visuals

The button Interface was designed for ease of use, due to the large amount of sheets used, links to sheets were created. Bars, Columns, Line Charts, Gauges, Heat, Tables and more.

The Outcome

STR ROCKS has an all in one super user friendly system, with built in performance logs, data records, dashboards and KPI trackers. 👍STR ROCKS!

Bonus : As the data is updated instantly so is everything else, KPIs, logs & dashboards. Saving on the financial costs for additional aftermarket software & training as it was all created within Excel. 😎

Notes

[STR ROCKS, performance, targets & details are all fictitious and been made specially for demo use only]