Situation
Myriad Art Group is a collection of art consulting and publishing brands serving the design community. They create artwork for the hospitality, corporate, healthcare, senior living, and residential markets.
Challenge
-
Myriad’s financial team and investors had to spend time manually combining 7+ reports out of 2 separate systems to compile consolidated sales, backlog and bookings reporting.
- Manually exporting, managing and combining multiple different Excel files every week was a time burden.
Action
-
Connected to 2 unique systems and pulled in all their disparate data tables.
- Automated and filtered the flow of data into a single Excel file, eliminating the need for manual updates.
Result
14 Days
from connections to completed, automated Excel data feed
15 - 20 Hours
of manual time exporting, cleansing and combining data in Excel eliminated every month
Working with BUCS has been a game-changer for Myriad. Their expertise in identifying, organizing, and creating seamless data feeds has drastically improved our visibility and accessibility to key company data. By providing us with real-time access to our metrics, they’ve saved us significant time generating KPIs and given us invaluable, immediate insights into our performance. Their support throughout the process has been exceptional, making complex data management simple and effective.
Griffin Peavey
Systems Integrated
1 creo Instance
1 IBM AS/400 Instance
