business intelligence case study

customer snapshot

A privately held company with $75 million in sales focused on recycling for the restaurant industry.
Mahoney-Environmental-sized
challenge-icon

Challenge

Department heads needed faster and better insight into departmental spending and expense allocation. The company was extremely reliant on Excel and the management team felt they were spending too much time on operational reporting. Their operational reports were not easily accessible and their internal reporting team was overwhelmed with reporting requests. The company needed a modern self-service reporting solution.
solution-icon

Solution

Peters & Associates analyzed the client’s data flows as well as the linkages between their Dynamics SL accounting system and other financial systems. Peters & Associates leveraged Microsoft SQL Server, SQL Server Integration Services, SQL Server Analysis Services, Azure Active Directory, and Power BI to provide three different departments with better access to their spending and budgeting information.
results-icon

Results

Power BI dashboards provided the trending and budget information that needed to be visualized as well the insight they required into when vendors were being paid and who was signing off on the vendor invoices. Department heads now have a snapshot into their departmental spending which has provided them with the insight that they needed to ensure spending is being property allocated. Department heads also have the ability to view vendor invoices on their own without having to rely on the accounting team.

Have a challenge we can solve?

free trials

Off-board your IT management to industry experts to keep your business tech secure and optimized so your teams can get back to business initiatives. Contact one of our IT consultants in Chicago to find out what secure, scalable, and optimized solutions are right for you.

SECURITY REVIEW FOR OFFICE 365
FREE TRIAL

ONE TIME PHISHING TEST
FREE TRIAL

VULNERABILITIES SCAN & REPORT
FREE TRIAL