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

Sommige informatie wordt in het Engels weergegeven.

Nigeria

Ik spreek Engels

604 bestellingen voltooid

Data Analyst, Financial Data Analyst

I have a background in Accounting with over 7 years working with lots of clients in various capacities. I specialize in working with startups and small businesses, with a keen interest in Business ...

Niveau 2

Voldoet aan hoge prestatiecriteria en heeft een bewezen staat van dienst in het voldoen aan de verwachtingen van de klant.

Over deze dienst

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

Branche:

Zakelijk

Mode

Detailhandel en groothandel

Platform:

Amazon

Taal:

Engels

Mijn portfolio