Esi Ahemah Aidoo
VIRTUAL ASSISTANT · ADMIN & DATA SUPPORT

I keep businesses organised,
and turn their data into decisions.

I'm Esi, a Ghana-based Virtual Assistant with over 2 years of administrative and operations experience. I help busy founders and small teams with inbox and calendar management, records and reporting, CRM, email marketing and simple automations.

Projects

Real tasks, done step by step, with the results to show for them.

Sales Data Analysis: Ama's Fashion Store

3 months of sales (July–September 2026) · 2 shops in Accra: East Legon and Osu

Data analysis
GHS 138,445Total revenue
490Valid sales after cleaning
1,031Items sold
+79%Revenue growth, July to September

The task

Ama owns two clothing shops and wanted to know what to buy more of for her next stock order. Her sales sheet had 500 rows, but it was messy and couldn't be trusted as it was.

How I cleaned the data

  • Removed 10 duplicate sales (500 → 490 rows)
  • Fixed 4 wrong prices, e.g. a GHS 95 shirt typed as 950
  • Standardised spellings ("MoMo" → "Mobile Money", "Top" → "Tops")
  • Put dates written three different ways into one format
  • Flagged 9 sales with no payment status for follow-up
  • Kept a cleaning log of every change, so nothing was hidden

What the data showed

My recommendations to Ama
  • Stock more Ankara Dresses and Linen Shirts. One brings in the most money, the other sells the most items.
  • Collect GHS 8,495 in unpaid or unconfirmed sales before the next order.
  • Look into why Osu earns GHS 20,755 less than East Legon before shifting stock between shops.
  • Keep Mobile Money fast and reliable at both shops, since it carries 62% of revenue.

Tools I used

Microsoft ExcelPivotTablesCharts & dashboardData cleaning logGoogle Sheets

Training project completed at Soronko Academy using a sample business dataset.

More projects coming soon

Email marketing in MailchimpSign-up form, landing page, welcome workflow and newsletters
Social media content calendar3-week plan in Notion, scheduled in Metricool
Lead generationVerified leads, customer profile and outreach messages

About me

I hold a BSc in Mathematics from KNUST and have worked in administration and operations in Ghana's petroleum sector, where I built a stock tracking system that cut inventory discrepancies by 15%. I've trained in General Virtual Assistance with Affluence Academy and I'm studying data analysis with Soronko Academy. I speak English and Twi, work in GMT+0, and can cover UK, European and US hours.

Google WorkspaceMicrosoft OfficeTrelloAsanaNotionAirtableHubSpotMailchimpMetricoolBufferCalendlyZapier