Data Analyst Intern
● Conducted in-depth Customer Sales Analysis to improve sales and identify the patterns between demographics and customers.● Utilized SQL for data sorting and cleaning from customer sales databases using clauses like JOIN, UNION, and EXTRACT.● Monitored and analysed website performance, web traffic patterns, user behaviors and extracted the data, transforming and filtering the data by using aggregating and filtering functions to improve reporting process.● Translated data into actionable insights providing recommendations to improve user engagement and conversion rates by automating report generation and data visualization using Tableau, providing key insights that led to a 12% increase in sales through targeted marketing campaigns.● Compared current inventory with historical sales data to determine availability and identify trends, optimizing the inventory management for effective sales planning.