Search the Knowledgebase
For urgent issues and immediate concerns, please contact the HITS Service Desk at 734-936-8000. We're available 24 hours a day, 7 days a week.
A number of different business intelligence and reporting applications are available to use at Michigan Medicine. Depending on your need, one tool might fit your needs better than another. In this article we will discuss a selection of options available to you.
Crystal Reports is a desktop application that can be used to generate reports from a wide variety of sources, including Excel, Oracle, Microsoft SQL, Business Objects, or plaintext. It does not support web-based dashboards. A 30 day trial can be installed, but use after 30 day trial requires the purchase of an individual license, which currently costs ~$450.
Getting Crystal Reports
A CoreImage package is available from HITS, though the package installs the 30-day trial. Users who want to upgrade must purchase a license (contact HITS for purchasing assistance). The license code can then be entered to convert the trial version to the full version. Users not on CoreImage workstations can download the trial version from SAP using the following link:
Tableau Desktop allows users to connect to data, create dashboards, and share them on Tableau Server. Tableau Server is a resource that allows users to view, interact, and edit dashboards through a web browser or mobile app. HITS Analytics and Business Intelligence is a resource for Tableau inquiries. They are available for consulting and getting users started.
A CoreImage package for Tableau Desktop is available. If you decide you want this software installed, contact HITS for assistance with the installation. You will need to purchase a license for Tableau Desktop. Tableau Server is licensed for all of Michigan Medicine.
Another option is Oracle Hyperion Interactive Reporting, which is an update to the BrioQuery product that used to be used quite a bit about around UMHS. Depending on your needs, it might be a solution to consider. Note that this product uses a financial data model, so it may not be appropriate to use it for things outside of finance.