Powered by
Codebasics DA Bootcamp

Md Nafeel Ahmad

Data Analyst

+91 7488684134 [email protected]

Resume

Hello, I am

Md Nafeel Ahmad.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

1

Python Project

About Me

Hello there! I'm a dedicated Data Analyst with a strong background in BSc Chemistry Honours, which adds a unique perspective to my data analysis approach. Currently, I work in a dynamic environment where my primary role is to gather data from APIs and transform raw data into meaningful insights. I mainly utilize tools like Excel and Power BI to achieve this.

My proficiency in Excel, Power BI, SQL, and Python complements my expertise in data analysis. I've completed several impactful business projects, all highlighted in my portfolio. My goal is to continue leveraging my skills and passion to drive data-driven innovations in a Data Analyst role.

Let's team up and explore the endless possibilities of data! Feel free to reach out, and let's make data work for us.

Key Skills

sql

python

My Projects

My Experience

Data Analyst, Web. Soft. Dev. , Patna

Mar 2024 – Jul 2024

Facilitated the transition from MS-Excel reporting to Power BI Dashboard, enhancing data visualization and 10 % reporting efficiency.
Accessed 2 underperforming sales regions through detailed analysis, contributing to a significant 5% operational cost savings.
Delivered in-depth Power BI workshops to a 10-member team, enhancing their data visualization skills.
Improved decision-making speed by 30%, resulting in a 25% increase in productivity and report accuracy.
Conducted ERP Training for different departments like Sales, Back office, Admin, and Accountant.

Awards & Certificate

Applied Machine Learning Course

Applied Machine Learning Course

CodeBasics Resume Challenge Project-7

CodeBasics Resume Challenge Project-7

PwC PowerBI Job Simulation

PwC PowerBI Job Simulation

Accenture Data Analytics and Visualization Job Simulation

Accenture Data Analytics and Visualization Job Simulation

Career Essentials in Generative AI by Microsoft and LinkedIn

Career Essentials in Generative AI by Microsoft and LinkedIn

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/md-nafeel-ahmad-22a0b51a5/

+ 91 7488684134

https://github.com/NafeelAhmad

PowerBI Project

Business Insights 360

Business Insights 360 is the project that have different views Like Finance View, Sales View , Marketing View, Supplychain View & Executive View. This Dashboard enables stakeholder to get valueale insights that help in data driven decision making

View Project
Engagement

View Project
on GitHUB

Business Insights 360

Executive View

Business Insights 360

Data Modeling

Project Details

Atliq Hardware is a consumer goods electronics company that sells computer Peripherals
worldwide.
Their business is growing rapidly and they still depended on excel files for data analytics.
Excel files are hard to consume and not effective in generating insights,
due to which they facing major loss in region Like latin America.

Senior executives of this company have decided to invest in a data analytics project
and have assigned a team for this work.

The Product owner of the company wants to build a dashboard for the differnet department.
So that different team members can trace the KPI's and make useful insights to overcome the problem. 🧧

✨ We have created Power BI dashboard that's I called Business Insights 360 to fulfill the demands of the Product Owner and the
stakeholders. ✨

In this dashboard we have created
◼ Sales View
◼ Finance View
◼ Marketing View
◼ Supplchain View
◼ Executive View

Project video

Live Interactive Dashboard

PowerBI Project

Codebasics Resume Challenge -6 Business Insights for CodeX A German Beverage Company

This Project is about to show Informative Insights from the Survey Conducted by CodeX which is a German based Company that aims to mark in Indian market and wants to increase the brand awareness, market share & product development. The tools used to do Data Analysis are Ms-Excel, PowerBI & Fotor.

View Project
Engagement

View Project
on GitHUB

Codebasics Resume Challenge -6 Business Insights for CodeX A German Beverage Company

Different Marketing Campaigns, Offer

Codebasics Resume Challenge -6 Business Insights for CodeX A German Beverage Company

Product recommendations for CodeX

Project Details

CodeX is a German beverage company that is aiming to make its mark in the Indian market. A few months ago, they launched their energy drink in 10 cities in India.

Their Marketing team is responsible for increasing brand awareness, market share, and product development. They conducted a survey in those 10 cities and received results from 10k respondents. I am Md. Nafeel Ahmad, a marketing data analyst is tasked to convert these survey results to meaningful insights which the team can use to drive actions.

So As Marketing Data analyst I have answered certain question from different area like Demographic Insights, Consumer Preferences, Competition analysis, Marketing Channel, Brand Awareness and more so that it is easy to take data driven decision making.

Project video

Live Interactive Dashboard

Excel Project

Sales & Finance Report for AtliQ Hardware

In this Project, I build different reports Like Customer Net Sales Performance report, Market Performance Report VS Target, Sales report for the Indian Market, P & L Year for Different Markets & GM% by Quarters of Different Sub Zones.

View Project
on GitHUB

Sales & Finance Report for AtliQ Hardware

Different Tables in Power Pivot

Sales & Finance Report for AtliQ Hardware

Building Market Performance VS Target in Pivot Table

Project Details

AtliQ Hardware is stressed with Excel Files. Their Sales & Finance Teams are on a Mission to eliminate these Excel Files. But remember not every Excel file can be replaced. Some Excel Files will remain. Also, they are interested in data analytics. So Excel is a perfect gateway to onboard to analytics.

So as an aspiring Data Analyst, I have come up with some awesome Sales and Finance Analytics reports.

Pipeline: Performed ETL -> Data Cleaning -> Data Modeling -> Created dim_date Table -> Connected dim_date to Data Model -> Performed DAX Formula -> Created Report Using Power Pivot -> Conditional Formatting -> Made User Empathetic Report Design

Finally, I came up with Different Reports Like Customer Net Sales Performance report, Market Performance Report VS Target, Sales report for the Indian Market, P & L Year for Different Markets & GM% by Quarters of Different Sub Zones.

Project video

SQL Project

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

In this project, I have performed analysis with different tools. Data Validation is done in MySQL, Visualizations in PowerBI. Dataset Contains three different sectors, Transport, TS-iPass, Document Registration, and E-challan.

View Project
Engagement

View Project
on GitHUB

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

Data Validation & Running Query in MySQL

Analyse Growth & Present Insights to the Telangana Govt. Resume Project Challenge-7

Secondary Insights for Top 5 Districts

Project Details

The project is part of CodeBasics Resume Project Challenge-7. Telangana government partnered with the CodeBasics Team to extract valuable insights from their official data for a brighter future. So, as a data analyst, I have performed analysis with different tools. Data Validation is done in MySQL, Visualizations in PowerBI.
Dataset Contains three different sectors, Transport, TS-iPass, Document Registration, and E-challan.
We have answered Questions and given Primary and secondary Insights. Last gave the Top 5 insights and recommendations to the Telangana Govt.

Project video

SQL Project

Codebasics Resume Challenge 4 || Provide Insights to Management in Consumer Goods Domain

The project showcases insights to top management to make quick and smart data-informed decisions. Here I have used MYSQL Workbench to get all the reports.

View Project
on GitHUB

Codebasics Resume Challenge 4 || Provide Insights to Management in Consumer Goods Domain

Showing the result of the query in MYSQL

Codebasics Resume Challenge 4 || Provide Insights to Management in Consumer Goods Domain

Top 3 Products in each segment

Project Details

Atliq Hardware (imaginary company) is one of the leading computer hardware producers in India and is well-expanded in
other countries too.

However, the management noticed that they do not get enough insights to make quick and smart data-informed
decisions. They want to expand their data analytics team by adding several junior data analysts.
Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills.
Hence, he decided to conduct a SQL challenge which will help him understand both skills.

So there are 10 ad hoc requests for which the business needs insights.
Here I have used MYSQL to get all the reports.

Project video

Python Project

Haberman Breast Cancer EDA

Domain/Function: Healthcare

💥 About Dataset: Dataset contains cases from study conducted on the survival of patients who had undergone surgery for breast cancer. It is collected from the study of University of Chicago's Billings Hospital between year 1958 to 1970.

View Project
Engagement

View Project
on GitHUB

Haberman Breast Cancer EDA

3D Pair-Plot

Haberman Breast Cancer EDA

Distribution of Nodes for Patients in Year 1961 and 1962

Project Details

🎯 Objective:
To Find Patterns and Insights into the Haberman Cancer Dataset

🎯 Learnings:
Data Acquisition, Data Wrangling, Exploratory Data Analysis - Plotting different graphs like scatter plot , pairplot, istoram, bar plot and get valuable insights and findings that help us to know which type of patients had survived successfully or not survived.

🎯 Conclusion:
Age : 1)Most patients are aged under 50-55. i.e. around 18.3% of the total.
2)10.13% of the Total Patients that have age 40 or less and have lymph node 5 or less have 100% survived from the breast cancer, i.e, almost 94% of their total.

Year :
1) Women had died more in the starting year of treatment 1958-1959.
2) In the Year 59, 60 and 67 recovery rate are above 84% that show really impressive but in year 62 and 65 recovery rate dropped significantly to 18.89% and 20.62% respectively.
Nodes :
1) 80.5% Patients are successfully survived that have nodes 5 or less.
2) 44.4% Patients have 0 node.

Project video