Context
The client has several reporting solutions (SSRS, Alpana) but fails to bring fluidity to analyses and must multiply static reports often exported to Excel to satisfy end users.
Challenge
Find a viable, simple and efficient solution that would provide effective factory dashboards.
Technologies used
DBMS: MS SQL Server 2008R2, 2012 and 2016 • Dataviz: Tableau Server 2019
Methodology and implementation
Implementation of a modern dataviz solution to replace static reports:
**Objectives** - Enable interactive data exploration - Reduce report creation time - Improve operational decision-making - Train teams in visualization best practices
**Achievements** - Installation and configuration of Tableau Server 2019 - Internal team training (2 days) - Creation of 4 major operational dashboards: * Factory electrical consumption * Maintenance management (CMMS) * Regulatory compliance and maintenance * Energy performance
Each dashboard offers a synthetic view with drill-down capability to analyze details.
Results
Tableau Server is installed in version 2019. The team is trained in Tableau. A series of factory dashboards brings new insights to the data. Dashboards are useful and used.
Visualizations
Factory electrical consumption dashboard
Computerized maintenance management dashboard
Regulatory compliance and maintenance dashboard
Energy performance dashboard