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.
SAP Crystal Reports 2013
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.
Oracle Hyperion Interactive Reporting
Oracle Hyperion Interactive Reporting (IR) Studio (formerly known as BRIO) will be decommissioned December 7, 2018 and has been replaced with Toad Data Point Professional. Software can be requested via the Service Catalog at https://michmed.service-now.com/sp?id=sc_home. Toad Data Point Professional does not replace Oracle Hyperion SmartView or Oracle Hyperion Financial Management.
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.