Executive Analytics Dashboard Development for a Global Manufacturer
A multinational holdings company that is a manufacturer of high tech test equipment for the automotive industry needed a more robust self-service analytics and data discovery solution to accommodate accelerated growth and evolving market demand. The company relied heavily on inconsistent and dated manual processes to analyze data, including numerous spreadsheets and fragmented enterprise resource planning (ERP) data. They desired a data visualization tool that provided access to data with a capability for self-service analytics, and chose Tableau as their solution to begin the journey towards consistent data and analytics. They partnered with Sendero to design and build a Tableau executive dashboard to champion better analytics capabilities and business insight through visualization of key performance indicators.
Sendero began by conducting on-site requirement gathering sessions with key executive and IT stakeholders. From these meetings, we:
- Defined a range of over 30 KPIs within four different business areas
- Mapped 11 data sources
- Defined key data gathering processes and owners for each KPI
After determining initial requirements, we collaborated with the IT team and business owners to gather data required from 11 data sources, including Microsoft SQL Server and Excel, and completed additional data transformation and formatting by developing and modifying SQL views and Excel files to ensure Tableau could effectively consume the data.
Our team leveraged their skills to develop 38 Tableau worksheets and used an iterative process to review and adjust the visualizations with client stakeholders. Working together effectively to compile each worksheet into a Tableau dashboard, we published the final product to Tableau Online for end-user consumption and access.
We successfully developed and implemented the Tableau executive dashboard, delivering the self-service-analytics solution to executives within a short timeframe amidst obstacles regarding data availability, process inconsistencies, and data source limitations.
The dashboard included the following tabs:
- Executive Dashboard
- Consolidated Sales
- End User Shipments
- Operations and Engineering
- Key Product SKU Metrics
Although the dashboard was initially intended to be used solely by the company’s CEO, other executives found value in it and began to utilize the tool. The Sendero team developed an additional Tableau dashboard to enhance the original and meet a specific request of the CEO. The client was extremely satisfied with the dashboard, and continues to enhance their IT practices and data analytics processes.