Sales Trend Analysis & Collection

I’m looking to understand how my sales evolve over time, but I do not yet have all of the raw figures in one place. I need a freelancer who can first gather the data for me—pulling order details from our online sales platforms and combining that with responses we receive from periodic customer surveys—and then build a clear trends-over-time analysis in Excel.

Once the numbers are collected, please clean and structure them so that date fields, product identifiers, and customer segments align consistently. From there, create an Excel workbook that highlights monthly, quarterly, and year-to-date trends. A simple dashboard with charts that I can filter by product and customer segment would be ideal.

Deliverables: • Compiled dataset (online sales + survey results) in a clean, tabular format • Excel workbook with pivot tables, trend charts, and an easy-to-read dashboard • Brief summary (one or two pages) outlining the key movements you observe and any notable seasonality

If you prefer to automate parts of the process with Power Query or a lightweight Python script before handing everything off in Excel, I’m open to that as long as the final files remain fully editable on my end. Accuracy and a clear, visual presentation of the time-based trends are the main success criteria. Rate: USD 15–25/hr Skills: Data Processing, Data Entry, Excel, Statistics, Business Analysis, Data Visualization, Data Analysis, Data Integration, Data Collection, Data Management