Building a New Report with New Billing Analytics

Once your practice has been set up to utilize this feature, you can download the connection file and get to work building new Billing Analytics reports. To do this, use the following steps:

  1. Create a folder where you would like to store your Analytics reports. In this example, it's a folder on the Desktop called 'Analytics.'

  2. In iSalus, navigate to Reports.

  3.  Click Billing Analytics (Adv.) if you have both billing analytics models. Otherwise, click Billing Analytics.

  4.  A pop up will appear prompting you to save the report – click the down arrow next to Save, and click Save as:
     
  5. In the resulting window, name your file whatever you would like your connection to be called in Excel, then save it to the folder you created in Step 1. In this example, it's called 'Analytics'.


  6. Navigate to the folder and open the saved file.

  7. If you receive the following warning, click Enable:


  8. The Excel worksheet will open with a Pivot Table already started. At the top of the screen, click Data, then Queries and Connections:


  9. You will see your saved file name as the name of the connection in the right-hand pane. Double-click this connection:


  10. In the Definition tab of the Connection Properties, ensure that the Always use connection file and Save password boxes are checked (clicking Yes for confirmation), and click OK:


  11. At this point you can save your report, preferably in the same folder as the connection file. If you ever move the connection file, you may need to modify the Connection file property in the Connection Properties window shown above.