AJAY THAKUR

AJAY THAKUR

Aspiring Data Analyst | SQL | Python | Power Bi | Excel | JS | Data-Driven Decision Maker

linkedin
Github
2ajaythakre@gmail.com

Profile Summary

Data Analyst with expertise in Excel, Power BI, SQL, and Python (Pandas), delivering actionable insights through data cleaning, statistical analysis, and interactive dashboards. Proven ability to drive business decisions with a problem-solving approach.

Technical Skills

Python (Pandas, NumPy) SQL Power BI Tableau Excel Data Cleaning Web Scraping Statistical Analysis Data Visualization MySQL JavaScript Node.js (Basics)

Trainings & Certificates

  • Completed Data Science and Machine Learning from GeeksforGeeks (GFG)
  • Gained hands-on experience in data analysis, visualization, and building predictive models
  • Currently an active trainee at Internshala Trainings. Learning comprehensive topics in Data Science including Python, SQL, Machine Learning, and Visualization

Education

Sep 2022 – 2024

Master of Computer Applications

Chandigarh University, Chandigarh

Feb 2019 – Feb 2021

Bachelor of Science in IT

All India Jat Heroes Memorial College, Rohtak, Haryana

Jul 2017 - April 2018

Intermediate (Non-Medical)

Gaur Brahaman Centeral Sr. Sec. School, Rohtak, Haryana

July 2015 – May 2016

Matriculation

Sarvodya High School, Rohtak, Haryana

Experience

Jul 2025

Data Analysis Intern

Cognifyz Technologies (Internship)

  • Solved business queries on a restaurant dataset using SQL, including cuisine popularity, city-wise restaurant count, and average ratings.
  • Analyzed price range distribution, service availability (online delivery, table booking), and correlations between ratings, votes, and services.
  • Created visualizations (histograms, bar charts, maps) to present insights on trends, clusters, and restaurant chain performance.
Jun 2024 – Nov 2024

Freelance Data Analyst

Self-Employed, New Delhi, India

  • Performed data cleaning, outlier detection, and statistical analysis on client datasets using Python (Pandas) and Excel, improving data quality for downstream reporting.
  • Designed and delivered Power BI dashboards to visualize trends and KPIs for small businesses, enabling data-driven decisions (e.g., sales tracking, customer insights).
  • Scraped and processed web data using Python and Brightdata, supporting ad-hoc analysis projects across various domains.

Projects

Walmart Sales Performance Analysis

Walmart Sales Performance Analysis

Comprehensive sales analysis to uncover growth patterns, profitability metrics, and customer purchasing trends using SQL and Power BI.

SQL Power BI Data Storytelling MySQL CTEs
JP Morgan Case Study

Airline Booking Data Analysis Dashboard

AboutAnalyze and visualize airline data for operational insights, passenger management, and ticket booking trends using Power BI

Power-Bi Power Bi Service Business Analysis DAX
JP Morgan Case Study

Auto Sales Insights Dashboard

A clean, visually appealing, and interactive automobile sales dashboard designed in Power BI using custom DAX measures. Built for clear data storytelling, it offers a balance of beauty, performance, and insightful analysis.

Power-Bi Business Analysis DAX Decision Modeling
JP Morgan Case Study

JP Morgan Business Analytics Case Study

Converted a complex business problem into an analytical framework using the CRISP-DM methodology, delivering data-driven strategic recommendations.

CRISP-DM Business Analysis Problem Framing Data Strategy Decision Modeling
Excel Customer Sales Analysis

Excel Customer Sales Analysis

Analyzed customer and sales data using Excel to uncover business insights and opportunities for revenue growth.

Excel Data Cleaning Pivot Tables Data Visualization Customer Segmentation
T20 Cricket Analytics

T20 World Cup Cricket Data Analytics

Created a Power BI report to identify top 11 players for a T20 cricket team by analyzing data from espncricinfo.

Python Pandas Power BI Web Scraping
Revenue Insights

Revenue Insights (Hospitality Domain)

Created a Power BI dashboard to analyze revenue loss for Atliq Grands, helping regain 20% market share.

Power BI Excel Data Analysis
HR Analytics

HR Data Analytics

Designed a Power BI dashboard to track employee data for HR team, saving 3-4 hours of daily work.

Power BI Excel HR Analytics
Inventory App

Sales Analysis

This Power BI dashboard presents a comprehensive Sales Analysis covering key metrics such as Revenue, Profit, Cost, Returns, Product Categories, and Regional Sales. It is designed to be clean, interactive, and insightful, enabling stakeholders to make quick, data-driven decisions.

Power Bi DAX Visualization
HR Analytics

Todo-app

A simple and intuitive ToDo application built using JavaScript, HTML, and CSS. This app helps you manage your daily tasks with ease and efficiency.

HTML CSS JS

Get In Touch

Feel free to reach out. I'd be happy to connect on LinkedIn 🙂

Email Me Call Me