I will do ecommerce data analysis, ecommerce analytics, inventory management

Business Context: A mid-sized ecommerce business selling across Shopify and Amazon (with ~500 SKUs and monthly revenue between $30K - $80K) was facing critical operational issues:

• Frequent stockouts of top-selling products
• Excess cash tied up in slow-moving inventory
• No clear visibility into top revenue drivers
• Lack of structured inventory tracking system

Plus the data was often messy with inconsistent product names, duplicate orders, missing customer regions, and mixed date formats.

Can you relate to these ecommerce business challenges?

This gig is meant to solve this problem.

Deliverables;

• Cleaned Excel file using Power Query
• Product performance table (top/bottom performers)
• Channel breakdown summary
• Monthly revenue trend with chart
• Dashboard with slicers including relevant KPIs (Inventory metrics, Sales by Channel, Sales by Product category, etc.)
• Short written summary: what sold, what didn't, and where to focus next.

Please kindly send your brief before we proceed.

Tools- Microsoft Excel (Power Query, Data cleaning, Pivot Tables, etc.), Google Sheets, Power BI