BACKGROUND
Carr Company is a manufacturer’s representative,that has been helping manufacturers and distributors gain momentum and marketshare for 56 years. Carr Company was spending hours monthly manuallydownloading data from there website and then reviewing internally in Excel,with no clear way to validate the data.
BBB Techs helped them save that valuable time andmoney by creating an automated dashboard in Power BI to see the data ineasy-to-understand visualizations.
OBJECTIVES
- Save time and resources by creating an automatic process.
- Have ways to validate data to ensure the information is correct.
- Be able to see data in a way that is easy to make data-driven decisions.
- Better understand the market and market-share to grow business.
ACHIEVEMENTS
- Built easy to view dashboards in Power BI that show all relevant information needed.
- Created a heat-map that allows leadership to see and comprehend current market share.
- The data pulled into the dashboards is now validated to ensure accuracy.
- Using the data, leadership can now make data driven decisions in all aspects: staffing, capital, and locations.
- Created an automatic process that gets rid of the need to manually gather the data.
KEY RESULTS
- 20 hours on average saved monthly
- 50% increase in sales
