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! 🌻