Excel Refreshable Reports
Posted: Wed Oct 11, 2023 9:48 am
Have you heard of connected reporting from Excel. Just connect excel to the OpenDental DB, add your query and you can refresh and update your reports at the click of the refresh button. I have been working with connected reports for 20 years. 13 years with dental data.
This is the BEST and easiest way to pull data, KPI & Metrics.
You can build out your own reports in excel using 1 or more queries. All refreshable. You can even automate the reports to run on a schedule when you are not there. Great for summary reports or even setting up a report for Doctors payroll that could pull detail on collections, production even adjustments for a time period.
If you have not heard of this, would be interested in being a part of live stream where i show how to do this? I will post details of the stream if there is interest so please let me know.
This will change how you report from Open Dental.
Thanks
Patrick
This is the BEST and easiest way to pull data, KPI & Metrics.
You can build out your own reports in excel using 1 or more queries. All refreshable. You can even automate the reports to run on a schedule when you are not there. Great for summary reports or even setting up a report for Doctors payroll that could pull detail on collections, production even adjustments for a time period.
If you have not heard of this, would be interested in being a part of live stream where i show how to do this? I will post details of the stream if there is interest so please let me know.
This will change how you report from Open Dental.
Thanks
Patrick