Draup Outsourcing Deals Data - Sample

**Overview**
Draup’s Outsourcing Deals dataset provides deep visibility into how enterprises engage with service providers to delegate business functions and workloads. It captures structured intelligence on outsourcing partnerships, including deal scope, project timelines, workloads involved, and the skills or technologies applied. By linking company and provider profiles, the dataset surfaces the context of vendor engagements and their alignment with strategic priorities.
This data enables sourcing, strategy, and market intelligence teams to benchmark outsourcing practices across industries, identify major service provider relationships, and evaluate workload distribution by geography and function. It supports sales teams in spotting active deals and competitive activity, while advisors and vendor managers can use it to assess partnership intensity, monitor vendor ecosystems, and inform negotiation strategies.

**Methodology & Quality**
Outsourcing data is aggregated from a combination of public disclosures, proprietary signals, and curated sources, then normalized into a consistent schema of companies, service providers, workloads, and business functions. Draup standardizes vendor taxonomies and workload classifications, applies evidence tagging for digital technologies, and refreshes data frequently to capture new deals and contract updates. This ensures accuracy, comparability across industries, and the ability to trace relationships over time.

**Key Tables Include**
o Company–Service Provider Engagements: outsourcing projects with company, service provider, locations, workloads, functions, project timelines, technologies, and skills.
o Deal Intensity Metrics: engagement footprint, outsourced workload intensity, and geographic distribution of service providers.
o Relationship Insights: highlights of provider–company partnerships, outsourced size, key locations, and notable relationship details.

**Use Cases:**

***Discover Accounts that outsource to a India for Data Engineering work***

Use Draup’s outsourcing deals data to identify which companies are using outsourcing services from where for specific functions. Filter by provider, client location, vendor location and function to target high-potential companys with offshore dependencies.

SELECT
company_name,
service_provider_name,
service_provider_location,
outsourced_workloads,
outsourced_business_function
FROM deals_company_service_providers
WHERE LOWER(service_provider_location) LIKE '%india'
AND LOWER(outsourced_workloads) LIKE '%data engineering%';

***Uncover Competitors’ Workload Share Across Verticals***

Quickly identify how rival service providers distribute their outsourcing workloads across industries and business functions, and benchmark their customer footprint against your own.

SELECT
service_provider_name,
service_provider_primary_vertical,
COUNT(*) AS projects_count,
CAST(COUNT(*) AS DOUBLE) * 100 / SUM(COUNT(*)) OVER (PARTITION BY service_provider_name) AS workload_share_percentage
FROM
deals_company_service_providers
GROUP BY
service_provider_name,
service_provider_primary_vertical
ORDER BY
service_provider_name,
workload_share_percentage DESC;

***Map the Service Provider Partner footprint for a Target Account***

Get a comprehensive view of all the service provider partner ecosystem of the company. Get deeper insights with the ability to filter the outsourcing deals data by service providers, functions, workloads, tech stack leveraged or the delivery location. This can enable understanding competitive landscape or partnership opportunities.

SELECT
company_name,
service_provider_name,
service_provider_location,
service_provider_primary_vertical,
outsourced_business_function,
outsourced_workloads,
digital_product,
skills
FROM deals_company_service_providers
WHERE company_name = 'Microsoft'
OR service_provider_name IN ('Accenture', 'Tech Mahindra')
OR service_provider_location IN ('India', 'USA')
OR outsourced_business_function LIKE '%IT%'
OR LOWER(outsourced_workloads) LIKE '%cloud%'
ORDER BY service_provider_name;

***Understand the client landscape of a competing Service Provider in a function***

Use Draup’s outsourcing deal intelligence to explore the client base of a competitor service provider for a specific function (e.g., IT, Finance, Engineering). Identify served industries, deal sizes, and delivery locations to benchmark penetration and uncover whitespace opportunities.

SELECT
deals_company_service_providers.company_name,
deals_company_service_providers.company_location,
company_overview.primary_vertical AS Client_primary_vertical,
company_overview.verticals AS client_verticals,
deals_company_service_providers.service_provider_name,
deals_company_service_providers.service_provider_location,
deals_company_service_providers.service_provider_vertical,
deals_company_service_providers.service_provider_primary_vertical,
service_providers_insights.outsourced_size,
deals_company_service_providers.outsourced_workloads,
deals_company_service_providers.outsourced_business_function
FROM
deals_company_service_providers
INNER JOIN
deals_company_service_providers_insights as service_providers_insights ON deals_company_service_providers.company_id = service_providers_insights.company_id
AND deals_company_service_providers.service_provider_id = service_providers_insights.service_provider_id
INNER JOIN
company_overview ON deals_company_service_providers.company_id = company_overview.company_id
WHERE
deals_company_service_providers.service_provider_name = 'Accenture'
AND deals_company_service_providers.outsourced_business_function = 'IT';

***What workloads does a Company outsource to vendors and who are their top vendors?***

Draup’s outsourcing deal data helps map the workloads and business functions outsourced by a company, along with its primary service providers. Analyze deal attributes by function, delivery location, or contract size to understand vendor strategy and whitespace opportunities.

SELECT
outsourced_workload,
COUNT(*) AS project_count
FROM
deals_company_service_providers
LATERAL VIEW explode(deals_company_service_providers.outsourced_workloads) t AS outsourced_workload
WHERE
deals_company_service_providers.company_name = 'Microsoft'
GROUP BY
outsourced_workload
ORDER BY
project_count DESC;