Sonos Data Dashboards.
Design and development of data
dashboards and forecast model
DATA | USER-INTERFACE DESIGN
UC BERKELEY, 2014
TEAM: ZACH MULDEr, CHRIS AU,
JEFF KHVU, WINNE YAN
As our senior project, our team collaborated with the consumer electronic company Sonos in an effort to consolidate data and metrics across their Operations departments and to provide executives with a high-level view of the company’s growth. The company’s current state of hyper-growth brought about the need for a Key Performance Indicator (KPI) dashboard to allow for communication between departments and to provide business insights.
Our team designed and built a comprehensive dashboard including KPIs from six departments: Global Planning, Global Logistics, Regional Operations, Manufacturing, Quality Assurance, and Customer Service. Each page of the dashboard was constructed to provide clear visualizations regarding the health of the department and the health of the company overall.
Along with the visual representations, our team utilized two analysis techniques to offer Sonos more insight regarding the relevance of the KPIs they were currently tracking and the accuracy of their forecasting methods. Principal Component Analysis (PCA) was performed on the company’s data sets to identify patterns in their data in multiple dimensions to determine the relationships between the parameters and to determine the appropriate weighting that should be placed on the metric. The Bass Diffusion Model was utilized in an attempt to assist Sonos in transitioning from short-term forecasting methods to methods that were better for the long term.
- team lead and project management
- user-interface design and prototyping
- design and implementation of Bass Diffusion model and PCA
Microsoft Access | VBA | data visualization | forecasting | Python