My background is in medical IT, and after I joined Dntl Bar, I used to be stunned to see the variations between medical and dental Follow Administration Methods (PMS). Don’t get me flawed: a contemporary dental PMS is a mature, refined resolution for managing a solo or group dental workplace. However these options had been designed for on-premises use and weren’t constructed to scale throughout a number of clinics. They make back-end knowledge out there to customers solely by standardized studies or actually gigantic spreadsheets. We had been pleased with our PMS database however wanted to make extra use out of the data it gave us. 

Use case

The same old method to this type of drawback is to ask an SQL developer to create a set of customized studies. However constructing and sustaining a library of greater than 300 studies is a large burden on IT. And builders don’t essentially perceive all the things area consultants want from a report—there’s numerous back-and-forth communication to create each. As an alternative, we divided duties: IT would construct clear knowledge units, and area consultants would create their very own studies. We simply needed to discover the precise device for them to make use of. 

I knew from expertise that Domo may meet our necessities for each scale and ease of use, so we adopted it even earlier than we opened our second location. We now use it for all our knowledge warehouse, extract, remodel, load (ETL), and data-cleansing operations. We consolidate and add 10-12 tables from all our areas each night time right into a grasp ledger desk within the cloud. That desk feeds Domo, which powers 100% of our reporting. 

Area consultants construct the studies, dashboards, and analyses they want or adapt them from Domo templates. In consequence, we had been in a position to exchange weekly spreadsheet-crunching with knowledge evaluation that strikes the corporate ahead. Within the uncommon case that our PMS doesn’t seize the info we want, we observe it in Notes and construct a pipe to the precise vacation spot. It’s the quickest approach so as to add performance to a stable system.

Conclusion

Domo offers us one of the best of each worlds: a mature database we will belief and the flexibleness to construct a brand new enterprise mannequin for customer-focused dental providers.