Piyush Tyagi
Data Analyst
New Delhi
Summary
Highly motivated and detailed-oriented candidate passionate about using data to improve business performance and customer experience. Skilled at leveraging data to develop actionable solutions to business challenges and utilizing data mining and data visualization to create meaningful insights. Excellent technical aptitude and knowledge of programming languages, data analytics and data visualization.
Overview
6
6
years of post-secondary education
2
2
Certifications
Work History
Data Analyst Trainee
Trainee
New Delhi
12.2022 - 04.2023
- Completed data cleaning and data validation of existing spreadsheets to promote robust data management platform, resulting in accurate data analysis and entry.
- Identified, analyzed, and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Education
Bachelor of Science - Mathematics
Delhi University
New Delhi, India 12.2020 - 05.2023
High School Diploma -
Spring Meadows Public School
New Delhi, Indiai 04.2019 - 02.2023
Skills
Python/R
SQL/MySQL
MS Excel
Tableau/Power BI
Data wrangling, Exploratory Data Analysis (EDA)
Data Manipulation and Analysis: Data mining, Data Cleaning, Exploratory Data Analysis (EDA), Trend Analysis
Statistical Analysis: Hypothesis Testing, Regression Analysis, Time Series Analysis
Data Visualization: Matplotlib, Seaborn, Tableau
Python Libraries : NumPy and Pandas
SOFT SKILLS : Analytical Thinking, Problem-Solving, Communication Skills (Verbal and Written), Interpersonal Skills, Attention to Detail, Time Management
Projects
XYZ Ads Airing Report
- Employed a dataset of XYZ ad airing information spanning a year, including 700,000+ data points.
- Calculated the cost per impression for each ad slot, with an average of $0.02 per impression.
- Analyzed the geographic distribution of ad viewership and Discovered a concentration of 70% in urban areas.
IMDB Movie Analysis
- Conducted a comprehensive analysis of a dataset containing information on over 3000+ movies from IMDB.
- Dominating box office earnings among movies released in four different decades, the 2010s emerged as the most successful decade.
- Earning the title of being the most profitable, movies rated 8.5 or higher showcase exceptional average earnings.
Bank Loan Case Study
- Analyzed a dataset of 50,0000+ bank loan applications using Python.
- Founded 5,000 loan defaulters with a default rate of 10%.
- Built a predictive model with an accuracy of 85% to determine potential loan defaulters.
Certification
Google Data Analytics Professional Certificate
Timeline
Google Data Analytics Professional Certificate
02-2023
Data Analyst Trainee
Trainee
12.2022 - 04.2023
Programming with Python Certificate
07-2022
Bachelor of Science - Mathematics
Delhi University
12.2020 - 05.2023
High School Diploma -
Spring Meadows Public School
04.2019 - 02.2023