Name: Mayank Agrawal

Job Role: Data Analyst

Projects: 5+ Academic & Personal Projects

Address: Delhi, India

Skills

SQL 95%
PYTHON 85%
Data Visualization 90%
Excel 85%
Power BI 80%

About

About Me

I am Mayank Agrawal, an MCA student and aspiring Data Analyst with a strong foundation in Python, SQL, Excel, and Power BI. Instead of formal work experience, I have focused on building real-world projects such as a Retail Sales Dashboard, SQL query optimization, and exploratory data analysis with Python. I have also completed certifications like Google Data Analytics and SQL for Data Science. Currently, I am sharpening my skills in data visualization, database management, and problem-solving while working on new projects to apply my learning. Based in Delhi, India, I am passionate about turning raw data into meaningful insights and preparing myself for professional opportunities in analytics.

  • Profile: Data Analytics
  • Domain: Retail, Ecommerce, BFSI & Digital Marketing
  • Education: Master Of Computer Appplications
  • Language: English, Hindi
  • BI Tools: Microsoft Power BI & Tableau
  • Other Skills: Python, SQL, Numpy, Matplotlib, Pandas, Excel, Git,
  • Interest: Writing, Cooking, Art

Resume

Resume

Aspiring Data Analyst | MCA Student | Skilled in Python, SQL, Excel & Power BI

Achievements


  • Designed a Power BI dashboard for a retail dataset (50,000+ records), revealing key seasonal sales trends.
  • Performed exploratory data analysis (EDA) on 100,000+ rows using Python, improving data cleaning efficiency by 30%.
  • Completed Google Data Analytics Professional Certificate and SQL (Intermediate) certification on HackerRank.



Education


2024-2026

Master Of Computer Appplications

JSS University

Coursework: Data Analytics, Machine Learning Techniques, Database Management

2021-2024

Bachelor Of Computer Applications

GLA University

Extracurricular: Active member of Coding Club and volunteered in annual cultural fest.

Projects

Projects

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

Digital Music Store Data Analysis using SQL

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

Data Analysis using Python Project for Beginners

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

Power BI Sales dashboard Project for Beginners

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


Sales Forecast- Time Series Forecasting

Used multiple machine learning models to forecast sales (retail store) and performed time series analysis.

Customer Segmentation using clustering model

Developed a ML model to give various recommendations of financial products & services on target customer groups.

0 Achievements
0 Projects
0 Sql Queries Written
0 Dashboards Created

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

Delhi, India

Contact Number

+91 8755759063

Download Resume

Click Me