Commercial Data Analysis for Business Insights

seeking an experienced and detail-oriented freelance data analyst to help us compile, clean, and analyze commercial data from six Excel files. The aim is to generate actionable insights that will guide our customer visit strategy, retention planning, and business development priorities.

Project Scope:
You will be provided with 6 Excel files covering:

All quotations (2020–2025)

All quotations (2023–2025)

Completed jobs and actual revenue (2020–2025)

Completed jobs and actual revenue (2023–2025)

Lost business (2020–2025)

Lost business (2023–2025)

Deliverables Required:
Data Compilation & Cleaning

Consolidate all relevant data into a master sheet

Remove duplicates, normalize customer names

Organize data by key fields (customer, date, value, status, etc.)

Customer & Revenue Analysis

Identify our biggest customer(s) over the past 5 years and 3 years sorted by total sales

Identify top customers from 2023 to present

List customers we haven’t worked with in the past 12 months

(If data allows) Spot customers who started strong but declined over time

Tag “Tier 1 / Tier 2 / Tier 3–4” customers based on historical revenue, frequency, and quote conversion

Highlight high-potential but underperforming clients

Suggest priority clients for immediate visit or reactivation

Reporting

Final Excel file with cleaned and analyzed data

Pivot tables, summary sheets, and charts

Optional: PowerPoint summary or dashboard (Excel or Power BI)

Ideal Freelancer Profile:
Expert in Excel (pivot tables, VLOOKUP/XLOOKUP, conditional formatting)

Experience in B2B sales data or logistics/supply chain analysis preferred

Able to identify trends, customer segmentation, and actionable insights

Communicates findings clearly in English or Turkish

Needed: powerpoint presentation file for executive summary seperately for 2020-2025 and 2023-2025


PS: NDA should be signed.