Brendan MairAI, product & problem solving

Project · Excel, SQL, Tableau

Regional Sales Data

An analysis of which sales channels earn the most profit in each region. Excel, SQL and Tableau.

  1. Regional Sales Data · Excel, SQL, Tableau

    Which sales channels actually make money, region by region.

    Problem
    Revenue showed which channels sold the most, not which ones earned the most once costs were counted.
    My role
    Analyst, end to end: question, data, dashboard, recommendation.
    What I did
    Cleaned and joined the sales data in Excel and SQL, then built profitability views by channel and region in Tableau.
    Outcome
    [2–3 findings from the deck] — owner to confirm
    regional-sales/ profitabilityTableau view
    Top channel[channel]
    Margin gap[n] pts

    Profit margin by channel All regions

    Channel A[n]%
    Channel B[n]%
    Channel C[n]%
    Channel D[n]%
    Highest marginAverage
    Fig. 1 — Illustrative shape only. Channel names and values come from the Tableau workbook: owner to confirm.

The question

Which sales channels earn the most profit in each region, and where is effort going to the weakest ones?

My approach

I cleaned and queried the sales data in Excel and SQL, then built the profitability views by channel and region in Tableau.

What I found

[2–3 findings from the deck] — owner to confirm

Status

Complete. The presentation and the dashboards are linked below.

All projects