Data Analyst Intern
Trainity
08.2024 - 10.2024
- Company Overview: Completed a comprehensive data analysis internship at Trainity, where I gained hands on experience in developing data visualization dashboards, conducting exploratory data analysis and applying various statistical methods to extract actionable insights and enhance operational efficiency
- Analyzed and extracted call data using advanced analytics tools, leading to actionable recommendations that optimized workload balancing, resulting in a 25% reduction in average handling time
- Analyzed car feature data using advanced visualization techniques, identifying critical features that correlated with a 20% increase in product appeal and informing design decisions to enhance market competitiveness
- Performed exploratory data analysis on features of car, identified key car features using statistical methods, enhancing insights for targeted marketing strategies and increasing product appeal by 20%
- Applied data visualization and transformation techniques to pinpoint key car features linked to sales growth, supporting a data informed approach to product design
- Utilized advanced Excel functions like- VLOOKUP, Pivot Tables and conditional formatting for cleaning and analyzing dataset of about 50,000 loan applicants reducing its analysis time
- Analyzed loan approval/rejection factors and conducted in depth analysis on key loan parameters to identify patterns in approval and default rates increasing decision accuracy by 30%
- Applied advance excel methods such as- index match, conditional formatting, pivot tables and slicers to obtain actionable insights from over 3000 genres
- Performed in-depth analysis of IMDB movie data in excel, identified patterns in ratings, genres, and release years to support insights into audience trends and recommended high performing genres that could increase viewer engagement by 15%
- Crafted and executed SQL queries to derive meaningful insights such as - jobs reviewed in November 2020, percentage share of each language in last 30 days, 7 days rolling average of throughput etc
- From extensive dataset
- Transformed raw data into insightful reports with SQL, influencing strategic initiatives facilitating informed decision making for stakeholders saving 3 hours per week in data handling
- Completed a comprehensive data analysis internship at Trainity, where I gained hands on experience in developing data visualization dashboards, conducting exploratory data analysis and applying various statistical methods to extract actionable insights and enhance operational efficiency
