In addition to quarterly reports sent to all leaders, the CMI team is responsible for handling random data requests from leaders and decision makers from all across the system. While team is pushing to improve our data science and forecasting capabilities, we also have to balance responding to data requests on a daily basis.
User Research and analysis
Sketches & Wireframes
Design
Prototyping
Usability testing
While also reducing our current work load and free up our time and resources to build a best in class health care data science and consumer insights team.
To allow us focus on building an advanced data science and consumer insights function.
Being a large organization made up of multiple acquisitions spread across almost a third of the state of Michigan, we wanted to make sure we got as much information from a diverse cross section of leaders - both clinical and corporate.
The research plan:
Directors or above
Busy schedules.
Managing large teams.
Mostly corporate but also supporting clinical business units.
Want data at their fingertips without asking an analyst.
Want a single source of truth
Breakdown siloes and provide a clear line of visibility to all relevant data.
Don't always know where to look or who to call to get certain data.
Want a tool that's easy to navigate
Simple to read, understand, and share without an analyst.
Faster than usual CMI data request.
Need simple data points to answer questions during meetings.
Spectrum Health's I.T infrastructure has very strict security standards, and created a unique challenge for us making it almost impossible to deploy any application that pulls live data.
We created a Low-Code solution with a simple frontend user interface that compiles the user's selections into a url and then takes them to filtered a Tableau dashboard.
We built out every possible path with options we chose based on years or experience handling data requests.
The final link that takes the user to the right dashboard is created based on the users choices. Compiled with Javascript.
We needed to ensure that everyone could easily find data and get the answers they were looking for, without sending an email or calling the CMI team.
A lot users are familiar with Tableau, a company wide tool for data and anlytics dashboard, but a only a handful clearly understand how to drill down in to charts, market definitions, and how use advanced filters effectively.
We created videos for all the dashboards, explaining their data sources, data definitions, filters, and how to share reports.
Launched April 2018 - available to all employees as the systemwide tool for simple data and analytics.
Reduced turn around time for data requests from several days to minutes.
The CMI portal changed how both clinical and corporate leaders made strategic decisions at Spectrum Health, using a web app to get instant access to business data without waiting on an analyst.
My one takeaway from this project - being open to using "Low-Code/No-Code" solutions, rather than relying on custom development, especially when it helps build and launch solutions faster.
