Intern Sales Department
• Collected pricing, categorization, model details, and sales quantities of competitor products across the National Railway Mall, categorized by brands.• Investigated 2K product data set to evaluate the impact of price, cost, and quantity for 5 brands; created visualizations in Excel to highlight market share growth within 1 year.• Developed Excel pivot tables to summarize monthly and daily sales reports and presented them to the sales leadership team.