BACKGROUND
Carr Company is a manufacturer’s representative, that has been helping manufacturers and distributors gain momentum and market share for 56 years. Carr Company was spending hours monthly manually downloading 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 and money by creating an automated dashboard in Power BI to see the data in easy-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
