Gautam Anand

Data Analytics Intern

Internship Studio•  April 2024 - May 2024•  Work from Home

Cleaned and standardized customer transaction data using SQL and Python (pandas), addressing missing values and inconsistencies. Leveraged pandas, matplotlib, seaborn, and NumPy in Jupyter notebook to identify trends. Used time series and cohort analysis to inform strategic decisions.

Excel Automation Intern

Internship Studio•  April 2024 - May 2024•  Work from Home

Developed a multi-region sales analysis dashboard in Microsoft Excel, involving recording macros, creating pivot tables and charts, connecting slicers, analysing trends and patterns, and utilizing VBA for automation and enhanced functionality.