Data Analyst
Toronto, Ontario, Canada
- Performed Data cleaning on sales data in order to perform inventory analysis based on sales from 2020 to 2023 for data from Etsy, Shopify and Faire- Created Excel files (through Python) that visually highlights 80-15-5 ABC Inventory Analysis Categorization- Created Python notebooks in Kaggle, to show findings about inventory analysis, buying trends and revenue analysis with data visualizations- Performed Queries in BigQuery to fill in NULL values and other data entry mistakes in sales platform and also to add columns and mappings of each product to further enhance dashboard analysis.- Created Dashboards in Power BI and Looker Studio in order for colleagues to play around with the data and see graphs and the performance metrics / KPIs of particular product SKUs.