Best-Selling Product Analysis

I have a complete dump of our sales and customer records and I need a clear, data-driven picture of which products and services actually drive revenue. Your task is to take that raw information, clean and consolidate it, then surface an undeniable ranking of our best-sellers.

You will be working with sales and customer data only, with the primary objective of finding the best-selling products or services. Feel free to use Python (pandas), Excel Power Query, Power BI, Tableau or any tool you prefer, as long as the insights are easy for non-technical stakeholders to understand.

Deliverables:
• A ranked list of top-performing products/services with supporting metrics (units sold, revenue, margin if calculable).
• A concise visual report or dashboard so the leadership team can slice results by date range, customer segment, channel and region.
• A short write-up of key observations and recommendations.

Acceptance criteria: the dashboard must refresh from a new CSV dump in under five minutes, and the top-seller list should reconcile to within 1% of the raw totals.

I am ready to share sample files as soon as you confirm, and I can answer any field-mapping questions along the way.