Excel-Based Advanced Sales Reports

I’m looking to turn a growing pile of raw sales data into a set of clear, refresh-ready Excel reports that management can rely on every day. The priority is sophisticated reporting, not just data dumps, so you’ll need deep command of Excel features such as Power Query, Power Pivot, dynamic arrays, and—where it truly adds value—VBA. Here’s what I have: • Clean but unstructured sales exports (CSV and XLSX). • A rough idea of the visuals management wants—trend lines, drill-downs, and comparative views—but no technical framework yet. Here’s what I need from you: • A single workbook (or tightly linked set) that ingests the raw files, applies any needed data cleaning, and produces interactive reports and dashboards. • Slicers or other intuitive controls so non-technical users can explore the figures without touching formulas. • Brief documentation explaining data flow, key formulas, and how to refresh the model when new sales files arrive. Our immediate goal is advanced sales reporting, yet I’m open to suggestions for future workflow automation or deeper MIS integrations as you uncover opportunities. If this sounds like your kind of challenge, let’s discuss your proposed approach, estimated turnaround, and any questions you have about the data sources.

Project ID: 40553563