Logo

Загрузка...

About Product

PhaDataPro Matching is an analytical system tool pdp.viortis that provides unification, transformation and transmission of data from different sources using Primary Key Vi-ORTIS

The product forms a unified standardized data array, provides visualization in Power BI and helps pharmaceutical companies and partners conduct accurate analysis, comparison and matching of information.

Primary key from Vi-ORTIS

Unique and "living" directory, structured information on the subject area, according to state or internal regulated names

Types of directories in the pharmaceutical market:

  • Full trade names of products, separately there is the possibility of linking ATC or INN groups
  • Client names, region and addresses with reference to legal name

Data Unification Example

Data Unification Example

A unified directory of all pharmacies and drugs converts all sources to a single format and spelling of positions, eliminates duplicates

Загрузка видео...

Data Sources

100% By market coverage

Market Audit
Sell In, Sell Out
Consulting
Geomarketing, MedRep Office, SPA, Weighted / Numeric Distribution
Partner Data
Pharmacy chains and Distributors
Software Systems
SAP, 1C, CRM

Data Processing Methodology

The product uses a unique methodology adapted to the specifics of the Kazakhstan market

1

Report Information Processing

All distributor reports, initially having an individual format, go through a transformation stage, during which the format becomes unified

2

Primary Processing

Data from all sources are consolidated into one general report, counterparties and goods are matched with a unified Primary Key standard

3

Secondary Processing

Processing returns, movements between pharmacies, data filtering

4

Primary Key Actualization

We daily update all our directories:

  • Pharmacy directory – calling through our Call Center
  • Product directory – according to monitoring of dari.kz website

PhaDataPro Matching - data processing on Outsource

IT structure for data transformation

Goods movement scheme from distributors to pharmacies

Technical Specifications

  • 5 currencies: tenge, dollar, euro, ruble, pound sterling
  • Data type: Original, processed
  • Price type: CIP price, Wholesale price, Retail price
  • Sales channel: Sell In, Sell Out, Movement, Inventory, Ecom, MTZ
  • Plan/Fact
  • Product selection: Brand, SKU
  • Standardized data (pharmacy chain name, legal name, chain point)
  • Pharmacy potential monitoring by purchase (RX, OTC, LS, BAA, OTC + BAA)
  • Pharmacy categorization by Sell out
  • Shipments: distributor, branch
  • Chain potential monitoring by purchase ATC/INN/ICD
  • Sum/Package
  • Growth/Amounts/Growth of packages
  • Package share/Amount share
  • Plan fulfillment percentage
  • Preview
  • Summary table view
  • Excel export
  • Excel pivot table
  • My report: saving individual reports
  • Unlimited number of users

Analytical and IT EcoSystem of Vi-ORTIS products

Vi-ORTIS is the only local provider of a full range of analytical and IT services for the pharmaceutical market.

Vi-ORTIS Analytical Ecosystem

Advantages

Service

  • Microsoft Power BI integration
  • Personal technical manager
  • Quarterly Pharmaceutical Market REVIEWS

Accuracy

  • 20 years of experience working with data
  • Primary Key – unified data consolidation standard

Geography

  • Country
  • 17 regions
  • 18 cities

Speed

  • Decade / Monthly

Methodology

  • PhaDataPro uses a unique methodology, taking into account the market conditions of Kazakhstan

Price

  • Flexible pricing policy
  • Vi-ORTIS products are a constructor

Working with us

Loading news...

Загрузка...

PhaDataPro Matching - Viortis | Viortis