Select Page
Business Intelligence for Medical Practices

Allscripts Dashboards

Does your practice need Allscripts® custom reports or Allscripts dashboards? Allscripts has some canned reports, but waiting for reports to run and getting exactly what you need to see can be frustrating.  Sophisticated practices can be discouraged with the limitations of the built-in reports. Exporting your data to Excel, cleaning up all of the extraneous headers and footers, cutting and pasting, creating your analysis, and then starting over again from scratch the next time you need a report takes way, way too long.

There is a better way.

Moore Solutions, Inc. connects Allscripts data to analysis tools like Excel, Power BI,  and SQL Server Reporting Services to create reports, Pivot Tables, dashboards, and email that update automatically.  See the data exactly the way you need to simply by opening the report.  One well designed Pivot Table can replace dozens and dozens of canned reports.  Getting an email to tell you there’s a problem without even having to open a spreadsheet is even better.  The time savings can be enormous.

Savvy physicians and managers recognize that all kinds of good information is trapped in the database, unavailable in canned reports.  For example, we have built business intelligence with Allscripts data that:

  • Automatically generate physicians’ monthly financial data, saving the CPA more than a day a month.
  • Track hit rate — how many new patient visits result in surgeries or procedures.
  • Pulls all charges and payments into one Excel spreadsheet with Power Pivot with custom calculations that drive business decisions.
  • Carefully track reimbursement data by payer and procedure code to ensure the practice is being paid according to contract.

Canned reports can only take your practice so far.  Get Allscripts custom reports and Allscripts dashboards today.

We began working with Nate in 2019.  Nate has been able to transform our practice in the last two years due to the data he is able to get out of Allscripts PM.  We started using Allscripts in 2017 and were frustrated with the reports available.  Nate was able to take the ideas we had in our head and pull the data out of existing information from Allscripts.   Nate allowed us to get information accurately and timely.  Before, we were compiling data from various sources and was over 3 months old by the time we got all the data.  Nate also brought ideas of what other practices request which helped us refine our data to more useful information. The reports he built refresh nightly and give us the information we need to run the practice.

Josh Rudd, CPA

Administrator, Neurosurgical Associates, Knoxville, TN

Nate Moore is a magician!  He transformed data hidden away in the recesses of our PM/EHR into a treasure trove of usable information.  For the first time, we are running the reports we want to run…and we are doing it with ease, thanks to Nate.  Retaining Nate is one of the wisest things I have ever done.  The ROI on our engagement was immediate and continues to pay dividends.


Lucien Roberts, III

Practice Administrator, Gastrointestinal Specialists, Inc., Richmond, VA

Allscripts Dashboards

Watch Nate Moore explain why Pivot Tables are so much easier to use than canned reports.