DMC’s client needed to gather clear analytics into different aspects of their business such as their sales funnel, revenue, and hours worked. They also needed a way to more efficiently match their healthcare providers to hospitals looking for providers with specific skills.
Before Power BI, the client was manually creating reports on a weekly/monthly basis to send to their company. Our work provided the client with a clean interface and an easy way to analyze their business data. DMC also increased reporting speed as the new reports automatically refresh.
The first Power BI report we built provided the client with a mechanism to match healthcare providers to hospital orders. We were able to match providers with hospitals based on location preference, specialty, and certification. The client can use Power BI’s drill through functionality to display only the orders a specific provider in their system qualifies for.
DMC continued to build Power BI dashboards using the client’s Azure SQL database as a data source and also built out a SharePoint site where they could store Excel documents that were used as data sources for some of the Power BI reports.
We created several types of reports: some of which were designed for management to view live and accurate numbers of order counts, submittals, revenue, and other metrics that help them follow the process of matching orders to healthcare providers.
Then, we built dashboards that allowed recruiters to view their own numbers in real time and track their performance from a recruiting standpoint. We used Power BI’s row level security to ensure that the recruiter could only view their own data.
DMC has had great success in building Power BI dashboards to give clients powerful insights into their data. We are also a proud Microsoft Solutions Partner with a designation in Data & AI (Azure) and held the Microsoft Gold Certified Partner status for 19 consecutive years prior. Our Microsoft partnership exemplifies our track record of creating great solutions using Microsoft Power Bi and the rest of the Microsoft stack of technologies.
DMC continues to build out the Power BI environment for the client to provide increased insight into their business data.
Learn more about our Microsoft Consulting Services, and contact us today for your next project.