Data Analysis of Company Aquisition

Data Analysis of a multitude of datasets for a large company aquisition with over 10,000 employees, thousands of products/inventory and hundreds of business units of which all to consider during the acquisition. I was tasked with providing analytics to both upper managment/stakeholders and technical leaders on strategic ways to improve both businesses.

Cost Structure Analysis

Patient Volume

Staff Productivity

HR & Organizational Structure

Growth Forecasting

Want to know more?

Images and files to come, attempting to mask private and proprietary data or recreate with fictional data for expanded use.

1. Cost Structure Analysis
Role: Identify and compare fixed and variable costs across both companies.
Tasks: Analyze operational expenses, procurement data, and vendor contracts to spot redundancies or inefficiencies.
Goal: Highlight opportunities for cost savings and synergies post-merger (e.g., consolidating software licenses or facilities).

2. Patient Volume Role: Evaluate historical patient volume trends and forecasting future demand.
Tasks: Merge patient intake and service utilization data from both entities to assess overlap, peak periods, and underserved areas.
Goal: Inform decisions on resource allocation and service line optimization.

3. Staff Productivity Role: Analyze productivity metrics across teams and departments.
Tasks: Use KPIs like patients per provider, tasks per hour, or billing per staff member to benchmark performance.
Goal: Identify high-performing teams, underutilized staff, and potential for workforce rebalancing or training needs.

4. HR & Organizational Structure Role: Provide data-driven insights into workforce composition and roles.
Tasks: Map organizational hierarchies, assess compensation structures, and analyze turnover and tenure.
Goal: Aid in developing a unified org structure, reducing redundancies, and ensuring role clarity.

5. Growth Forecasting Analytics Role: Project future financial and operational performance under the merged entity.
Tasks: Build predictive models using historical trends, market data, and macroeconomic indicators.
Goal: Support strategic planning, investment decisions, and scenario modeling for growth opportunities.

Overall Contribution: The data analyst ensures the merger is grounded in factual, quantitative insights by integrating data systems, standardizing metrics, and delivering clear visualizations and reports to stakeholders. Their work supports informed decisions, risk mitigation, and value creation in the post-merger integration process.