Codebasics Logo

Powered by
Codebasics DA Bootcamp

Home

About

Projects

Experience

Certificates

Contact
Hello, I am

Ankit Jaiswal

Data Analyst
Resume
Ankit Jaiswal

2

PowerBI
Projects

1

SQL
Project

1

Python
Project

About

Me

I am a passionate Data Analyst with a strong ability to uncover insights that drive data-driven decisions. Skilled in Python, SQL, Advanced Excel, and Power BI, I thrive on transforming raw data into clear, impactful visualizations and dashboards.
Problem-solving is one of my key strengths, and I am always excited to explore new tools and techniques in Data Analytics and Machine Learning to deliver meaningful results. As a fresher, I am eager to apply my skills to real-world challenges and continue learning as I contribute to impactful projects.

Key

Skills

Power BI

SQL

Excel

Python

Numpy

Pandas

Seaborn

Matplotlib

Statistics

Data Modelling and Dashboarding

DAX

Story Telling

Decision Making

Forecasting & Time Series

Visualizations

My

Projects

Data-Driven Sales Intelligence for Automotive Dealerships
Data-Driven Sales Intelligence for Automotive Dealerships

Domain/Function: Sales & Marketing

This interactive dashboard provides a real-time view of key car sales metrics, including YTD totals, weekly trends, and regional performance. It utilizes visualizations like line charts, pie charts, and maps to help stakeholders gain valuable insights.

See My Work PowerBI
FINANCE AND SUPPLY CHAIN ANALYTICS OF ATLIQ HARDWARES
FINANCE AND SUPPLY CHAIN ANALYTICS OF ATLIQ HARDWARES

Domain/Function: Finance and Supply Chian

📊 Problem Tackled: Addressing the challenges of Excel's file size constraints, enhancing decision-making processes, and streamlining operations through MySQL analytics.

See My Work SQL
Interactive Lending and Financial Performance Dashboard
Interactive Lending and Financial Performance Dashboard

Domain/Function: Finance

I recently worked on a project to create a Bank Loan Report using Power BI, designed to provide deep insights into lending activities, loan portfolio health, and customer trends. This project allowed me to combine domain knowledge with technical expertise to draw actionable insights for decision-mak

See My Work PowerBI
AtliQ Hotels Data Analysis Project USING PYTHON
AtliQ Hotels Data Analysis Project USING PYTHON

Domain/Function: Hospitality

"AtliQ Grands faced intense competition, resulting in a decline in revenue. Recognizing the need for data-driven strategic insights, they lacked internal expertise. My goal is to perform an in-depth analysis using Python, equipping AtliQ Grands with valuable insights for enhancing customer retention

See My Work Python

My

Experience

As a passionate data enthusiast, I bring expertise in SQL, Python (NumPy, Pandas, Matplotlib, Seaborn), Power BI, and Excel, coupled with a keen interest in machine learning and a strong passion for data engineering. Through academic projects and independent learning, I have developed the skills needed to analyze and optimize data workflows, transforming raw data into actionable insights.

✅Key Highlights From My Personal Projects:

  1. SQL Expertise: Designed and optimized complex SQL queries to analyze sales performance, market trends, and supply chain efficiency.
  2. Python for Data Analysis: Conducted exploratory data analysis (EDA) to uncover patterns in customer behavior and market dynamics, integrating visualizations for impactful storytelling.
  3. Power BI Proficiency: Built dynamic dashboards to represent key financial metrics, enabling real-time insights for stakeholders. These dashboards showcased trends in market share, customer contributions, and gross sales.
  4. Excel Automation: Leveraged advanced Excel features to simplify repetitive tasks and deliver detailed financial reporting.
  5. End-to-End Data Solutions: Combined SQL-based data retrieval with Python and Power BI to create intuitive, actionable reports and dashboards.
  6. Machine Learning Aspirations: Currently learning machine learning to expand my capabilities in predictive analytics and advanced modeling, further enriching my data analytics skillset.

✅What I Bring to the Table:

  • The ability to replicate SQL-based analytics in Power BI to build intuitive, visually appealing dashboards that cater to diverse business needs.
  • A knack for simplifying complex data workflows, automating reporting, and improving overall efficiency.
  • Strong problem-solving and storytelling skills to communicate insights effectively to non-technical stakeholders.

✅While I am a fresher with no prior corporate experience, my hands-on project work and expertise in data tools prepare me to make an immediate impact in a data-driven role.

Awards

& Certificate

CB Cert

Excel: Mother of Business Intelligence

CB Cert

Get Job Ready: Power BI Data Analytics for All Levels 3.0

CB Cert

SQL Beginner to Advanced For Data Professionals