I will build a black friday sales, margin and stock dashboard in excel

E
emillyv_pro
E
emillyv_pro
Emily Scot

About this gig

Black Friday can bring record revenue and still lose you money. Deep discounts, ad spend and stockouts can eat the profit before you notice.

I build an Excel dashboard that lets you track your sale event day by day, so you can make decisions while the sale is still running:

  • Daily sales vs your target
  • Margin after discounts, fees and ad spend, so you see which promos actually make money
  • Discount depth vs profit, to spot products that sell but lose money
  • Ad spend and ROAS tracking
  • Stock days of cover with low-stock flags, so your best sellers dont run out mid-sale
  • Black Friday to Cyber Monday comparison, plus a post-sale review of returns and net profit

Works with Shopify, Amazon, Etsy, WooCommerce or any store that exports CSV or Excel.

HOW IT WORKS

  1. Message me with your platform and sale dates.
  2. Send your product list, costs and planned discounts.
  3. I build the dashboard and set up a simple daily update (you paste in your latest export and everything refreshes).
  4. Use it through the sale and the weeks after.

Fast delivery options available so youre ready before the sale starts. No special software needed, only Microsoft Excel.


Get to know Emily Scot

Emily Scot

Data Analyst

  • FromUnited States
  • Member sinceMay 2026
  • Languages

    English, German, French, Spanish
Hi, I’m Emilly, an Excel dashboard specialist who turns messy business data into clear, actionable insights. I build custom dashboards for ecommerce profit and stock tracking, budget vs actual reporting, and cash flow forecasting, using PivotTables, formulas, slicers and clean charts. Every dashboard is accurate, easy to use, and built so you can update it yourself and make faster, smarter decisions. I work with clients in the USA, UK and Europe and reply quickly. Message me before ordering and tell me what you want to track.

My Portfolio

Other Data Visualization Services I Offer