Data Analytics Overview

Med-Peds has invested time and resources to increase our in-house data analytics capacity.  With a dedicated analyst, project management team, and senior leadership advisor, we have produced both division wide and resident projects. 

These efforts are a joint venture between our division and the Office of Population Health & Accountable Care (OPHAC). Our division manages the intake process, while OPHAC manages the execution of the request as they are the knowledge experts.

Below is guidance for submitting a CareConnect data mining requests.

CareConnect Data Request Types & Guidance

The QI team can help division members create an adhoc data pull, reoccurring reports, or dashboard. 

CareConnect Adhoc Data Pull

• One-time snapshot that can be sent directly to project team. This type of request can be fully executed within the med-peds division.
• Adhoc data pulls are produced as Excel files and live in a specific Box folder.
• Adhoc data pulls requires a minimum of three weeks for development.

CareConnect Reoccurring Reports

Reports serve the purpose of providing a deep-dive view into a data set and tend to concentrate on a single item or event. They require development in a UCLA Health database and working with another team at UCLA, the Office of Health Informatics and Analytics (OHIA). 

• Reports can be generated at any of the following cadences: biweekly, monthly, quarterly, etc.
• Reports are produced as Excel files and live in a specific Box folder.
• Reports take a minimum of five weeks for development.

Tableau Dashboard

Dashboards primarily serve as a tool for monitoring trends. They tend to have a high-level view of broad amounts of data and are created to answer a single question. Data dashboards are a summary of different, but related data sets, presented in a way that makes information easier to understand at-a-glance. 

To begin development of a dashboard, a project team must have established metrics, something they want to measure that would help inform them about the population. 

• Dashboards are updated monthly.
• Dashboards live on the Tableau website. You must have a mednet to access the Tableau site.
• Dashboards take a minimum for 12 weeks for development.

Not sure if your project warrants a report or a dashboard? Use the decision tree below to guide your decision. 

General Lifecycle of CareConnect Data Requests

Below is the general lifecycle of data requests within our division. All requests begin with the completion of an intake form. 

1. Stakeholder sends request or completed intake form to MPPMdata@mednet.ucla.edu.
2. If the intake form was not already completed, data team asks stakeholder to complete intake form.
3. Med-Peds leadership prioritizes request.
4. Med-Peds and OPHAC confirm request during weekly prioritization meeting.
5. OPHAC team manages all efforts once request has been prioritized.
6. OPHAC team organizes project kick-off meeting and if applicable, any maintenance meetings.
7. OPHAC team communicates all project updates and shares deliverables.
8. Updates to active projects are managed by OPHAC.
9. OPHAC handles closure of request.
10. After the request is closed, if stakeholder wants to make updates to a report or dashboard, they will need to submit a new request to MPPMdata@mednet.ucla.edu and enter prioritization queue again.