Success ETL Plus Archives - Management Information Analysis

Success Stories: Hospital

March 19, 2015 by miawebadmin

The Challenge:

This case study might qualify for Super Hero status. The client brought us multiple systems with 17 different lists of physicians, including different identifiers, specialties, type of practice, status, and clinic locations. Many of the lists did not agree.

The Methods:

MIA took the data from all sources. We matched the data, ran it through a scoring system looking for commonality (the system dynamically “learns”) and created one central “correct” list (ETL Plus*).

This list was then used by marketing, planning, (including MIA patient segmentation) and in house analytic groups (operation support) for reporting
In the state of TX and surrounding states, having one single point of contact helped marketing outreach – and the web front end allows the company to override
There is no front end that you see – the data is the final product (Custom App Development)

The Results:

Obviously, the clutter and waste are gone. So are the criticisms and complaints. The grudging sound of success; “We started talking about the need for this ten years ago.” Oh well, now we will go hang up our capes.

Success Stories: Propane Delivery

March 19, 2015 by miawebadmin

The Challenge:

This client had been using a system designed for another industry to run their business – they were using 7 different, separate systems in total. Many labor hours were spent aligning and consolidating retail sales, operating costs and inventories for a look at the health of the business. It was also a real challenge to forecast sales based upon this mish-mash of data.

The Methods:

MIA migrated all of the client data to new system.
We then created and launched a centralized data warehouse (ETL Plus*) and wrote a custom reporting engine for more effective financial reporting.
We added new systems, including billing and statements, mailings, CRM data transmission, customer websites for service and credit card payments (Custom App Development).

The Results:

With the improved information systems facilitated by our system integration over a 9 year period, during which sales increased by double-digit annual percentages and labor headcount decreased from 82 to 35 employees, the client built themselves into such a profitable and attractive operation that they were ultimately acquired by a national group.

Success Stories: Medical Client

March 19, 2015 by miawebadmin

The Challenge:

This joint venture client had approximately 14 different providers and a $2 million per year operating budget. They rarely shared information. Drill down a level and you discover that the client provided sliding fee scale care for approximately 85,000 unique individuals who accessed one or more of the providers. Yikes!

So how do you get data from all different providers, standardize it, crosswalk all individuals across all systems – dealing with cumulative data over 3 years and 150,000 unique individuals.

The Methods:

In order to obtain a single unified data set, MIA assembled and de-identified all of the data (ETL Plus*).

The dataset was then sent to an actuarial firm who ran the unified data through their system and came up with what the cost would have been had Medicare reimbursed the cost of care.
MIA was then able to build a budget using that data for the client as a whole (Planning Analytics).

The Results:

Client was able to:

Send MIA back the cost weekly so they can see what the specific costs are for each diagnostic grouping
Identify a subset of patients with the largest bills to create health protocols which lessen the cost of service.
Note; this last outcome is extremely powerful. Once you can identify the “heavy users” you can create an action plan that works to lower utilization of the most valuable categories of assets – like trauma centers.