Name: Adarsh Singh

Job Role: Data Analyst & Business Analyst

Experience: 8 Months

Address: Mumbai, India

Skills

PYTHON 95%
SQL 85%
Data Visualization(Power BI, Tableau) 90%
Statistical Analysis 80%
Machine Learning 50%

About

About Me

With a Master's in Computer Application and a Bachelor's in Information Technology, I specialize in data analysis and software development. Proficient in Python, SQL, Power BI, and Excel, I excel at automating data tasks, creating databases, and designing data visualizations. My track record includes leading projects that boost efficiency and inform decision-making.

  • Profile: Data Analytics &business Analytics
  • Domain: Retail, Ecommerce, BFSI & Digital Marketing
  • Education: Masters in Computer Application
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI, Tableau
  • Other Skills: Google Analytics, Git, MS Excel, Canva, MS Word, PowerPoint & ChatGPT
  • Interest: Traveling, Sport Analysis(Cricket & Football), Esport

0 +   Projects completed

LinkedIn

Resume

Resume

Dedicated Data Analyst with a robust academic background and hands-on experience in data analysis, database management, and software development. Proven ability to drive business strategies through data-driven insights and enhance decision-making processes using advanced data visualization techniques. Skilled in Python, SQL, Power BI, Tableau, and Excel, with a track record of improving data processing efficiency and developing user-centric applications.

Experience


Feb 2024-Present

Python Data Analyst Intern

Aloyt The Technology Company, Mumbai

A leading technology solutions provider specializing in data-driven strategies and innovative software development.

  • Analyzed ad campaigns, clickstream, and customer surveys data, identifying an increasing demand and launching a strategic product line.
  • Developed time series forecasting models to predict sales and optimize marketing budgets, achieving a model performance of 92%.
  • Designed and executed A/B tests and performed rigorous statistical analysis, leading to a 20% MoM increase in the conversion rate.

Oct 2023- Dec 2023

Python Programmer Intern

CodSoft, Mumbai

CodSoft is a company that provides internships, offering hands-on experience in real-world projects.

  • Acquired extensive knowledge of collaborative environments like Git, enhancing effective teamwork and version control through hands-on projects.
  • Gained practical skills in developing Tkinter GUI applications, leading to a deeper understanding of user interface design and implementation.
  • Analyzed ad campaigns, clickstream, and customer survey data to identify increasing demand trends, resulting in the successful launch of a strategic product line.



Education


2022-2024

Masters in Computer Application

Mumbai University

CGPA: 8.11 CGPA.

2019-2022

Bsc in Computer Science

Mumbai University

CGPA: 8.98 CGPA.

Projects

Projects

Below are the sample Data Analytics projects on SQL, Python, Excel, Power BI & Tableau.

Python

Amazon Sales Analysis using Python

Executed an Amazon sales analysis using Python to uncover sales trends and optimize strategies using advanced Python (Pandas, Matplotlib, Seaborn).

Diwali Sales Data Analysis using Python

Performed exploratory data analysis on diwali sales data using Python to improve the customer experience.

Ecommerce Data Analysis in Brazil using Python

Leveraged Python (Pandas, Matplotlib, Seaborn) to reveal market trends through in-depth analysis of Brazilian ecommerce data.

Lok Sabha Election 2024 using Python

Explored Lok Sabha Election 2024 data using Python (Pandas, Matplotlib, Seaborn) to uncover and visualize electoral patterns and outcomes.

Youtube Analysis for a Company using Python

Executed a YouTube analysis for a company using Python, Pandas, Matplotlib, and Seaborn to uncover trends and optimize content strategy.

Movies Rating Data Analysis using Python

Explored movie rating trends with Python (Pandas, Matplotlib, Seaborn) to create compelling visual narratives and actionable insights.

SQL

Covid Deaths Data Analysis using SQL

Utilized SQL to analyze COVID-19 deaths data, uncovering patterns and insights to inform public health strategies.

Music Store Analysis Data Analysis using SQL

Analyzed Music_Store data using advanced SQL queires to identify gaps and increase the business growth.

National Housing Data Analysis using SQL

Analyzed National Housing data using SQL to reveal trends and insights in housing market dynamics.

Pizzas Sales Data Analysis using SQL

Unveiled pizza sales patterns with SQL to drive strategic decisions and enhance market performance.

Walmart Sales Data Analysis with SQL

Dissected Walmart sales data with SQL to reveal deep insights and drive strategic retail decisions.

FIFA 21(E-Game) Analysis using SQL

Delved into FIFA 21 game data using SQL to unearth strategic insights and optimize gameplay analysis.

Power BI

IPL Analysis Power BI dashboard Project

Designed a power bi dashboard for IPL_Analysis to track and analyze the online sales data acorss India.

Spotify Power Bi Dashboard

Crafted a Spotify Power BI dashboard to visualize and analyze music streaming trends and listener behavior.

Nike Sales Power BI dashboard Project

Crafted a dynamic Power BI dashboard to visualize Nike sales, revealing actionable insights and driving strategic decisions.

Car24 Power BI dashboard Project

Engineered a Power BI dashboard for Car24, turning vehicle sales data into compelling visual stories and strategic insights.

OTT (Netflix, Prime, Hotstar) Power BI Dashboard Project

Designed a Power BI dashboard to unravel viewing patterns across Netflix, Prime, and Hotstar, offering deep insights into OTT content performance.

Road Accident Power BI dashboard Project

Designed a Power BI dashboard to analyze road accident data, revealing critical patterns and enhancing road safety insights.

Tableau

British Airways Tableau dashboard Project

Built a Tableau dashboard for British Airways to explore and display essential performance metrics.

Covid-19 deaths in India Tableau dashboard Project

Visualized Covid-19 deaths in India using Tableau to identify trends and patterns.

Zomato Restaurants Analysis Tableau Dashboard

Unveiled dining trends and customer insights through Zomato restaurant data visualization in Tableau.

UT Mart Tableau Dashboard

Developed a Tableau dashboard for UT-Mart to visualize sales trends and performance metrics.

Harry Potter Movies and cast Analysis Tableau Dashboard

Analyzed Harry Potter movies and cast in Tableau to reveal insights on performance and characters.

FIFA WorldCup Analytics 1930-2014 Tableau Dashboard

Analyzed FIFA World Cup data (1930-2014) using Tableau to uncover historical trends and insights.

Excel

Coffee Sales Excel dashboard Project

Developed a Coffee Sales dashboard in Excel to analyze sales trends and performance.

Netflix Excel dashboard Project

Crafted an interactive Excel dashboard to analyze Netflix content trends and viewer engagement.

Bike Sales Excel dashboard Projects

Created a dynamic Excel dashboard to visualize and explore trends in bike sales data.

59 Years of Humans In Space Excel Dashboard

Developed an Excel dashboard to explore six decades of human space exploration milestones.

MCD South America Sales Excel dashboard Project

Designed an Excel dashboard to analyze MCD's sales performance in South America, highlighting key market trends.

0 Internships
0 Projects
6 Achievements
0 Certification

More projects on Github

I love to solve business problems & uncover hidden data stories


GitHub

Contact

Contact Me

Below are the details to reach out to me!

Address

Mumbai, India

Contact Number

+91 9696129703

Download Resume

resumelink



Have a Question? Click Here