Consulting Services Data Integration Data Validation Reporting Analytics Outcomes Research Project Management Business Intelligence

(1)

Consulting Services

1



Data Integration



Data Validation



Reporting



Analytics



Outcomes Research



Project Management



Business Intelligence

(2)

Data Means Full Spectrum

of Expertise

Consulting Services

: Data Integration &

Validation

Analytics &

Reporting

Rx & OTC

Data

Calls &

Samples

Alignment

Demographic

Promo &

Third Party

Call

Plan

Automated Data Process

Data Standardization,

Summarization & Validation

Analytical Data Creation

Targeting

Promotion

Response

Samples

Optimization

Segmentation

Customer Life

Time Value

Ad Hoc

Brand Reviews Marketing Executive Mangmnt Field Force Support Call Plan

The Data

The Processes

The Analytics

The Reports

(3)

Examples of Projects that we support

Project Name

Client’s Pain Points

Data Means Approach

Data Migration

Validation

Client must validate 100% the data in

the new Data Warehouse with limited

resources before it goes live.

Data Means proven automated QC

methodology will save client

resources time, identify differences

and potential differences sources.

Needs solution to

present sales results in

an efficient fashion

across geographies ,

products and other

categories to support

marketing and sales

forces. User must have

ability to compare and

bench mark results

Does not have the resources or skills to

develop efficient process to generate

the data files and the front end

application to house the data and

generate interactive reports via the

web or desktop application

With Data Means Sales & Marketing

Express 2.0 or Lux1.1, client has a

working solution to deliver info to its

clients and focus on business . Data

Means will create a flexible and

automated approach to generate the

data files and develop front end

solution to query display results.

Client needs to improve

promotion response

across brands and

channels

Does not have a functional area that

interacts across brands and channels to

analyze promotional process to explore

synergies, reduce waste, improve

process and measure impact

Data Means “Performance

Improvement Philosophy” will provide

client objective analysis of

promotional process and a structure

to continuously improve and

quantified results

(4)

Data Integration

Consulting Services

Validation

Data Means helps clients to integrate their data into a logical and efficient structure

to support analytical, call plan and reporting areas.

Our approach to data integration has the following goals:

•

Optimize the data structure and data management processes

•

Minimize manual process

•

Maximize access to the data

•

Minimize duplicate data process

•

Automated data QC and minimization of data errors

•

Synchronization of analytical and load data process

(5)

Rx

Patient

Alignment

Calls

Activity

Demo

Promotion

Activity

Managed

Caret

Call

Plan

Market &

Products

Defs

Data Means works hand

in hand with business

users and IT counterparts

to ensure the optimum

solution and process to

integrate data in support

of reporting, targeting

and analytics

Sandbox

Integrated

Data

Supports

•

Innovation

•

Call Plan

•

Reporting

•

Analytics

•

Ad hoc

Drives Sales

Meet Targets

Data Means approach to data integration

reduces errors, manual process, saves time

and optimize data value

Consulting Services

Validation

Data Integration

(6)

Current

Database

New

Database

Both files

Current and new

matched

It is only in

the current

database

It is only in

the new database

Data Migration Making

Sure that your Data is Right

Detect Differences

For large data warehouses migration validating the data is a daunting process

With our extensive experience,

skills, and methodology clients save

time and reduce errors

Data Validation

Consulting Services

Validation

(7)

Data Validation Process

Develop process, for

series of files

,

in

anticipation of file

delivery.

A batch of

files to be

compared

is

delivered

Run QC

Programs on

the batch

files

Assemble

report on

batch files

(concurrent

w/ run)

QC Programming

Review/ annotate

FAIL

Investigate /

fix action

items

If files are close

user runs reports

with new file and

compares results

Pass

log as

file done

Consulting Services

Validation

(8)

Client has a data

analysis, reporting or

processing critical need

or idea that can not be

met through current

systems or resources

Data Means works on an end to

end fixed cost project or on a

contingent labor basis

Data Sources Efficient Data Processing & Validation Process Final Data

Data Means works

with client to

come up and

implement the

most efficient and

cost effective

solution for

clients needs

Dynamic &

efficient

process to

conduct data

analysis or

reporting

Clients & Consultants get on going Data Means know how to project

support

Consulting Services: Reports

(9)

Custom made

Interactive

reports for

business units

to drill down

and

benchmark.

Ability to see

competitive

and

geography

landscape

with click of

the mouse

Consulting

Services: Reports

9

(10)

Consulting Services: Reports

10

Efficient support maintenance and enhancements of client’s

applications using our already build applications and procedures

Extensive

international

data

(11)

        matrix covariance the is distance. s mahalanobi with the up come we metric distnce in the variables among n correlatio the e incorporat to reasoning similar a Using ellipsoid an of equation the is Which ) ( ,.... , b ,.... , a ation. transform a requires ch center whi the from distance the computing en account wh into x of ty variabili the take to like would we distance this g calculatin in However, center the from x of distance the fashion to same in the contribute x n observatio an of components all in which spheroid a of equation the Satisfying 1 ,.... 2 , 1 1 2 2 1 1 2 2 1 1 1 y -x d Distance s Mahalanobi c 1 2 2 ... 2 2 2 2 1 1 0 , , 2 ... 2 2 2 2 2 1 1 1 , c 2 ... 2 2 2 1 2 x of norm Euclidian the is 0 , So ..0 0,0,0,0... y all that assume s Let'                                                                                                                                                                 S s s s diag D Where y x D y x s y s y s y s x s x s x y x S x D T x p s x s x s x x d b a d s p y p x s y x s y x b a d x T x p x x x x x d T T p t p p p p p

A lot?

A few?

None?

•

Dinner meetings

•

Symposia

•

Speaker training

•

Teleconferences

•

DTC

•

Web casting

•

Conferences

•

Detailing and samples

•

Journal advertisement

•

Physician/Patient support programs

•

Other

•Do you understand what you know?

•Do you know what you don’t know?

•How hard is to know and use what you

know?

•How much additional prescriptions are generated by direct promotion to physicians?





                              n x n .... 2 x 2 1 x 1 0 e 1 n x n .... 2 x 2 1 x 1 0 e x ,... x , x Attend p ₁ ₂ _n

(12)

12

Inputs

Prepare

Execute

Output

Evaluate

1

2

3

4

5

6

Ideas

Information

Data

Understand

the

Problem

Set Goals

Estimate

Opportunity

Build

Consensus

Develop

Program

Get Support

Form Team

Set Work Plan

And

Milestones

Develop

Evaluation

Methodology

Run

Program

Review

Interim

Results

Make

Program

Adjustments

NRx Sales

Productivity

Gains

Adherence

Evaluate

&

Measure

Develop

The Promotional Event Process

Inputs

Transformation

Output

Evaluation

Planning

Execution

Results

G(PER) Project Cycle

(13)

13

Data Means has extensive experience designing, and completing health care quality improvement and outcomes research studies. Health claims studies to measure treatment or clinical guideline aberrance are our especially. We help clients to complete their regulatory mandated studies or identify areas where opportunities for health care improvement exists.

Some of the studies that we support are:

•Risk Adjustment •Quality of life

•Treatment and Clinical Guidelines Compliance •Switching Analysis

•Utilization Management •Adverse Events

(14)

14

As firms attempt, to “see” ahead, they deal with a great amount of information available or potentially available which may be unstructured, scattered, unformatted, abundant but most of the times lacking consistency and ability to be be used in an efficient fashion.

So, there are inherent limitations to make the best usage of the information captured. The challenge is to harness and process the information in a methodological and analytical way so companies can measure the what it matters.

Data Means Project Management division help companies meet these challenges:

•Vision: Help clients to respond and shape their environment. Be agile and deliver results which allow our customers

to harness the process and to look beyond the numbers. This is our Performance Improvement Philosophy (PIP).

•Mission:Work with our customers strategy, project management, process improvement, technology, systems and

people and become Partners in PROCESS EXCELLENCE.

•Goal:Client satisfaction is top priority, so we aim to meet and exceed demanding expectations.

•Strategy: Three Critical Factors of Success (CFS) CFS-1 Enhancing Service Delivery

CFS-2 Blend Project Management and Process Improvement Methodology

CFS-3 Robust Project Execution

•Plan: Relate CFS to tangible items/actions subject to a metric analysis.

Data Means approach has a nimble, methodological and practical approach to do what it does best: provide “information” required by the customer, in time, on cost and leaving a legacy of trace ability.

(15)

Identifying Client’s Position in the

Analytics Evolution

0

100

200

300

400

500

600

700

800

Lags

Some

Medium

High

Champion

Analytical Integration

Accuracy

Adhoc

Advanced Analytics

Reporting

Data & Process Efficiencies

Automation

Opportunity Loss

(16)

Data Means Approach to Enterprise Analytical Solutions Integration

Business Intelligence + Data Warehousing + Inventory Management + Data Mining + Marketing Optimization + Forecast + Marketing Automation + Predictive Modeling +

16

Data Means expertise allows to help clients in cross functional areas and build

synergies at the same time With Data Means extensive

technical expertise, clients can streamline data intensive process and achieve significant efficiencies

Our continuous

improvement approach to projects helps clients to identify opportunities to save time, resources and reduce errors

We help clients gaining insight as to what, how, where and when important business factors are changing.

Our approach is systematic. So clients can duplicate and expand on our work

We help clients make sense maximize and optimized the value of their data

(17)

Data Means Helps Clients to Move

to Higher Level

Know +What… +When…. Understand +How…. Optimize Process +Do it better +Grow the market +Increase sales

17

As we learn and

understand more,

there is no limit to

improve in making

better business

decisions