Data Analyst | Dashboard Report Developer | Amazon/Shopify VA
As a Professional Data Analyst and/or Amazon/Shopify Virtual Assistant, it is my utmost responsibility to ensure the quality and accuracy of data reporting and analysis and data visualization, for a better understanding of the business's strategic decisions.
✅Database Management, Data Cleansing, Data Reporting and Analysis
🔸 Microsoft Excel: Functions such as pivot table, conditional formatting, name manager, data validation, text to columns; Basic to Advance Formulas such as vlookup, hlookup, text, if, ifError, concatenate, left, mid, right, sumif and sumifs, countif and countifs
🔸 Google Sheets: Functions such as pivot table, slicer, conditional formatting, alternating colours, data validation, protect sheets and ranges, named ranges, split text to columns; Basic to Advance Formulas such as query, arrayformula, split, vlookup, hlookup, text, concat, concatenate, left, mid, right
✅Dashboard Report Development
🔸 Microsoft Excel: complex dashboards using excel table, pivot tables, pivot charts, slicers, timeline
🔸 Google Sheets: functions such as alternating colours, pivot tables, pivot charts, slicer
🔸 Google Data Studio: data source from google sheets, charts, simple tables, pivot tables, scorecards, controls like drop-down list, fixed-size list, date range control, slider
✅Amazon/Shopify Virtual Assistance
🔸 Pulled out or downloaded various sales data from Amazon Seller Central, consolidate, encode and create reports in Excel/Google Sheets and Google Data Studio (FBA Shipments Data Collection)
With my willingness to learn other skill sets, below is a list of services I can also offer to help you with your daily needs:
✅Email Management and Administrative
✅Web Research and Web Scraping
✅ Lead Generation
✅Simple Content Creation using Canva
✅Project Management using Trello and Airtable
✅Customer Relationship Management using Hubspot
✅Social Media Management
Being well-equipped with all these capabilities, it would be a great opportunity for me to help you unload your day-to-day handling of different tasks, especially data reporting and analysis. I am learning continuously and willingly accept positive criticism to be worthy of being part of your growing business.
If my profile fits your needs, I would definitely love to hear from you at the soonest possible time. Thank you! 🌻