Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
@mayankyadav23
mayankyadav23
Follow

Mayank Yadav mayankyadav23

🎯
Focusing
Data Analyst & Insights Expert | Driving Business Growth through Data-Driven Decisions | Proficient in Python, SQL and Data Visualization

Block or report mayankyadav23

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
mayankyadav23 /README.md

🌟 Hi, I'm MAYANK YADAV

Data Analyst | Business Analyst | Insights-Driven Decision Making | Predictive Modeling Enthusiast

I specialize in transforming complex data into actionable insights that drive business strategies. With extensive experience in data analytics, visualization, and predictive modeling, I bring a unique approach to analyzing data trends and solving problems using tools like Python, SQL, Power BI, and Excel.


πŸ’‘ Skills & Expertise:

Data Cleaning Data Preprocessing EDA Visualization Predictive Modeling Machine Learning Storytelling Data Transformation Data Profiling Data Modeling

  • Data Cleaning & Preparation: Ensuring data quality for accurate insights.
  • Exploratory Data Analysis (EDA): Deriving key trends from raw data.
  • Data Transformation: Processing and converting raw data into a usable format.
  • Data Profiling: Assessing data quality and ensuring it meets analysis standards.
  • Data Modeling: Structuring datasets for analysis and machine learning tasks.
  • Data Visualization: Creating dynamic dashboards using Power BI, Tableau, and Excel.
  • Predictive Modeling: Using machine learning to forecast trends and outcomes.
  • Storytelling with Data: Communicating insights effectively through reports and presentations.

πŸš€ Technologies & Tools:

Languages & Tools Expertise
Python Pandas, NumPy, Scikit-Learn, Matplotlib, Seaborn
SQL PostgreSQL, MySQL
Excel Advanced Functions, Power Query
Power BI DAX, Visualizations
Jupyter Notebook Data Analysis
Google Analytics Traffic Analysis, Conversion Tracking
MS Word Documentation, Reports
MS PowerPoint Presentations, Data Storytelling
MS Outlook Communication, Email Management
GitHub Version Control, Collaboration

πŸ”§ Featured Projects:

πŸ“Š Exploring the 2024 T20 World Cup!
Dive into a detailed Jupyter Notebook showcasing player performances 🏏, match stats πŸ“ˆ, and team insights from the 2024 T20 World Cup.
Jupyter Data Cleaning Visualization


πŸ“ˆ Powering data-driven insights with Python
This repository showcases data analysis projects using Python libraries like Pandas, NumPy, Matplotlib, and Seaborn. Projects include medical data visualization, time series analysis, and more. Python Pandas Scikit-learn Data Analysis


πŸŽ₯ Your next favorite movie, predicted!
A Python-based project that suggests movies based on user input. Using a pre-calculated similarity matrix of 4,800+ movies, it ranks and displays the top 30 recommendations.
Scikit-learn Machine Learning


πŸ“Š Predicting sales trends using data science
Using a dataset of 8,500+ entries, this project develops a predictive model for sales based on product and store attributes.
Python Sales Forecasting Data Science


πŸ™οΈ NYC Airbnb Listings Analysis
Data analysis of NYC Airbnb listings focusing on key metrics such as host performance, neighborhood trends, pricing, and customer reviews.
Power BI Business Intelligence


πŸ• Discovering the secret behind top-selling pizzas!
Using SQL to analyze 20,000+ pizza sales data and uncover patterns in customer preferences, top-selling pizzas, and peak order times.
SQL Data Analysis


🌟 Data Analytics for a social media client
In this job simulation, I analyzed datasets for a social media client, providing insights through visual presentations.
Excel Forage


πŸ”’ Cracking the leaked password database
Part of the Goldman Sachs Software Engineering virtual internship, I solved a password database challenge and produced a detailed analysis.
Security Software Engineering


πŸ“Š Analyzing customer transaction data
Through the Quantium Data Analytics Job Simulation, I analyzed customer transaction data and provided strategic insights for business decisions.
Jupyter Customer Analytics


πŸ“Š Driving informed decisions with data
This project focuses on data visualization, creating impactful visuals to communicate business insights effectively for TATA.
Data Visualization Forage


🎬 Exploring Netflix Data
A comprehensive analysis of Netflix’s data using PostgreSQL, focusing on database normalization, reducing redundancy, and optimizing query performance.
Excel Python Tableau


πŸ“Š Analyzing Blinkit’s sales and customer satisfaction
A Power BI dashboard analyzing Blinkit’s total sales, item visibility, and customer ratings.
Power BI DAX


πŸš— Predicting used car prices
Predicts car prices with 92% accuracy using a Random Forest model. It takes you through data cleaning, feature engineering, and model evaluation.
Python Machine Learning Regression


πŸ“ˆ What I’m Focusing on Now:

  • Advanced Data Visualization: Enhancing skills in Power BI and Tableau.
  • Time Series Forecasting: Predicting future trends using advanced models.
  • Data Science in Business: Applying machine learning techniques to real-world business challenges.

πŸ“« Connect with Me:

LinkedIn GitHub Email


🌱 Always Learning:

  • Enhancing my knowledge of machine learning models.
  • Best practices for business reporting and data storytelling.
  • Advanced SQL and database optimization techniques.

Pinned Loading

  1. Air-BNB-Data-Analysis Air-BNB-Data-Analysis Public

    Data analysis and insights from NYC Airbnb listings, focusing on key metrics such as host performance, neighborhood trends, pricing, and customer reviews. Comprehensive documentation of ETL process...

    1

  2. Movie-Recommendation-Engine-ACG Movie-Recommendation-Engine-ACG Public

    A Python-based project that suggests similar movies based on user input. 🌟 It uses a pre-calculated similarity matrix from a dataset of 4,800+ movies to display the top 30 recommendations. πŸ“ˆ The en...

    HTML 1

  3. Advanced-Power-BI-Projects Advanced-Power-BI-Projects Public

    This repository πŸ“‚ features a collection of advanced Power BI projects, diving into data analysis across diverse domains like finance 🏦, healthcare πŸ₯, retail πŸ›’, and more. Each project includes inter...

    12

  4. T20I-World-Cup-2024-Analysis T20I-World-Cup-2024-Analysis Public

    Explore my Jupyter Notebook πŸ“Š featuring comprehensive datasets and visualizations from the 2024 T20 World Cup analysis. Discover key insights into player performances 🏏, match statistics πŸ“ˆ, and tea...

    HTML 1

  5. HR-Analytics HR-Analytics Public

    This HR Analytics project analyzes employee attrition using the dataset to identify key factors driving turnover. It applies machine learning models to provide insights for improving retention str...

    Jupyter Notebook

  6. Heart-Disease-Prediction Heart-Disease-Prediction Public

    This project predicts the risk of Coronary Heart Disease (CHD) using Machine Learning models based on patient data, such as age, blood pressure, and cholesterol levels. Key models developed include...

    Jupyter Notebook

AltStyle γ«γ‚ˆγ£γ¦ε€‰ζ›γ•γ‚ŒγŸγƒšγƒΌγ‚Έ (->γ‚ͺγƒͺγ‚ΈγƒŠγƒ«) /