Project

OneSource Distributors -KPI Dashboard

OneSource Distributors is a company of Sonepar that has a focus on electrical and industrial distribution with locations spanning across multiple states. In the next 3 to 4 years, OneSource is suggesting growth of approximately 8.7%. However, due to the onset of COVID-19 the industry as a whole is expected to experience a 2% decline in annual demand. To help ascertain a competitive advantage, OneSource Distributors has requested that we use descriptive analytics to visualize siloed sales and operational data in their enterprise resource planning (ERP) and Job Management Software (JMS) systems. OneSource Distributors requires an observable and data-driven perspective displayed through the use of descriptive analytics in the form of a data dashboard. The requirement for integration with company systems is paramount, promoting the use of Microsoft product suite programs, primarily Power BI. Power BI was used to automate and display key performance indicators (KPIs) to increase visibility and usability for specific end-users and stakeholders. OneSource Distributors is a multifaceted company with various departments and branches. Through the use of a written standard operating procedure (SOP), OneSource Distributor will be able to guide team members through the use of the dashboard. Through the use of descriptive analytics, our team generated data visualizations to display a complete digital story to inform users of the progress made by OneSource team members and their different departments.

Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.