When a well-known data consulting firm was founded over twenty-five years ago, the founders never expected the company would grow into one of the leading voices in the cloud industry. Decades of top-of-the-line data and cloud knowledge has strengthened the company’s foothold over the modern data environment in the United States and Canada. Having a compact team of around seventy employees allows the company to focus on hiring only the highest performers who bolster a growth mindset. Every team member is integral as they seek innovative ways to modernize their company strategies and efforts. This company needed to automate manual business processes in order to retain industry recognition and support their reputation as a modern technology leader.
Consulting firms must ensure that all their clients comply alongside industry regulations. This firm was tasked with assigning each of their customers an award status in order to receive industry recognition and funding. Originally, the client prepared Excel reports based on data in an SQL database that outlined the current award status of each of their customers. Then, the customer account owner assigned to each client manually reviewed these Excel reports to verify that each of their customers were awarded the correct status. Creating an automated solution that monitored the award status of the entire organization’s new and existing clients was crucial.
“Our client serviced hundreds of customers, and each customer needed to have the correct award status so that our client would receive the proper sponsored funding,” explains BlueGranite Staff Consultant, Elayne Jones. “The company relied on the manual oversight of Excel reports, which was very time-consuming as the entire process could take several days, and was also quite error-prone, requiring the company to follow up with employees who were late or made errors.”
The challenge was determining how to formulate a solution that eliminated both the Excel report creation and the reliance on manual reviews of the data. “It was apparent that the current system was inefficient and redundant,” recalls Elayne. “Our client was determined to find a solution that cut out manual overhead. An automated solution brought the client closer to the truth in a more efficient and reliable manner.” After initial investigatory discussions, BlueGranite decided to implement the Modern Data Platform with Azure’s Logic Apps.
Logic Apps are a solution in the Azure cloud where users create and run automated workflows to complete business tasks. “Once we introduced Logic Apps to the organization, they were thrilled at the prospect of saving time and increasing the accuracy of their data. We were amazed at how receptive they were to shift towards an automated solution. The Logic Apps freed the company from the drudgery of creating Excel reports each month and managing employees’ reviews. Further, the company became ensured that the results were always on time and accurate.”
BlueGranite built two separate Logic Apps to satisfy the organizational needs for both new and existing customers.
For new clients, the goal was to ensure that the client received the correct award status within their first contractual month. The Logic App:
For existing clients, the goal was to ensure that the entire organization database maintained the proper award status each month. The Logic App:
If the MoM percentage change dropped below -0.2, the Boolean variable was set to True. Otherwise, the Boolean variable was set to False.
BlueGranite helped this organization achieve its goals for monitoring its data in a more efficient and comprehensive manner. This Logic Apps solution adoption allowed the organization to cut down on manual business processes, thereby saving time, increasing accuracy of analysis, and maintaining their industry recognition. The organization no longer has to create redundant Excel reports each month, send the report to all their employees, and manage the quality and timeliness of the employees’ responses.
By implementing the Modern Data Platform tools, the organization automatically received the relevant data directly from the source, on the same day each month, while “cutting down on the noise” by only alerting on relevant missing information or information that fell out of an identified threshold. The reliability of an automated solution allowed the organization to meet industry deadlines in a timely manner each month, cut out manual overhead, and continue to foster an attitude of business optimization. Now, this company can spend their time making meaningful insights from the data and strengthening their relationships within the industry.
To learn more about how BlueGranite can help streamline your business processes, contact us today.