Portfolio - Neha panjabi | Codebasics

Powered by
Codebasics DA Bootcamp

Hello, I am

Neha panjabi

Data Analyst

1

Excel
Project

1

PowerBI
Project

1

SQL
Project

About

Me

👋Hi there! I'm Neha Panjabi, a passionate Data Analyst with a strong background in Engineering and a knack for Analytics.

Although I hold a bachelor’s degree in civil eng, I discovered my real talent lies in data analysis.

I am proficient in Excel, Power BI, SQL, and Python, and I use these tools to analyze data and uncover trends that drive business decisions.

I’ve completed several business projects, which you can explore in my portfolio below. Each project reflects my ability to ask the right questions, analyze complex data sets, and present insights in a way that informs stakeholders.

I am eager to bring these skills to a dynamic team and contribute to meaningful data-driven decisions.

Key

Skills

Advanced excel

Power BI

MySQL

Stakeholder Management

Effective communication

Presentation skill

Problem Solving

My

Projects

Sales And Finance Analytics Reports

Sales And Finance Analytics Reports

Domain/Function: FMCG

The objective of this project is to analyze the company's financial health and market position. I created various reports from over half a million sales records, including "Customer Net Sales Performance" and "Market Performance vs. Target," using both fundamental and advanced Excel techniques.

Business Insights 360 Dashboard

Business Insights 360 Dashboard

Domain/Function: FMCG

AtliQ Hardware, a fast-growing consumer electronics company, struggles to compete with data-driven companies as many reports are still in Excel. My goal is to implement an advanced analytics solution with Power BI, empowering the company to gain insights and make data-informed decisions.

Consumer Goods Ad-hoc Insights

Consumer Goods Ad-hoc Insights

Domain/Function: FMCG

I worked on a project in the consumer goods domain for AtliQ Hardware, a leading computer hardware manufacturer in India with a global presence. I was tasked with addressing 10 ad-hoc data requests using SQL queries to provide management with actionable insights that support decision-making.

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

Contact Me

Email

[email protected]

Github

https://github.com/Nehapan123

Linkedin

https://www.linkedin.com/in/neha-panjabi-51a642213/

Neha panjabi

Data Analyst

Excel Project

Sales And Finance Analytics Reports

Domain/Function: FMCG

The objective of this project is to analyze the company's financial health and market position. I created various reports from over half a million sales records, including "Customer Net Sales Performance" and "Market Performance vs. Target," using both fundamental and advanced Excel techniques.

View Project
Engagement

View Project
on GitHUB

Sales And Finance Analytics Reports

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Sales And Finance Analytics Reports

This report provides insights into the Profit and Loss (P&L) by financial year, broken down by division.

Project Details

In this project, I have created various sales and finance reports using Excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries.
The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

Throughout the journey, I've mastered key skills such as:

1. Pivot table
2. Power Query
3. Basic DAX Functions
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales and finance activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard

Domain/Function: FMCG

AtliQ Hardware, a fast-growing consumer electronics company, struggles to compete with data-driven companies as many reports are still in Excel. My goal is to implement an advanced analytics solution with Power BI, empowering the company to gain insights and make data-informed decisions.

View Project
Engagement

View Project
on GitHUB

Business Insights 360 Dashboard

Finance View: Highlighting important metrics and trends from the dashboard.

Business Insights 360 Dashboard

Data modelling involving 10+ tables

Project Details

In this project, the goal is to create a report that stakeholders from sales, marketing, finance, and executive teams could use.

The focus is made on the following:

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project:

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

Domain/Function: FMCG

I worked on a project in the consumer goods domain for AtliQ Hardware, a leading computer hardware manufacturer in India with a global presence. I was tasked with addressing 10 ad-hoc data requests using SQL queries to provide management with actionable insights that support decision-making.

View Project
Engagement

View Project
on GitHUB

Consumer Goods Ad-hoc Insights

A report of the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.

Consumer Goods Ad-hoc Insights

A complete report of the Gross sales amount for the customer “AtliQ Exclusive” for each month.

Project Details

I followed a three-step workflow for delivering ad-hoc insights to AtliQ Hardware in their consumer goods domain:

- Ad-hoc Query Handling: Efficiently addressed 10 real-time data requests using SQL fundamentals such as WHERE, GROUP BY, ORDER BY, JOINS, CTEs, and WINDOW FUNCTIONS. Ensured data accuracy and optimized query speed for each task.

- Power BI Visualization: Converted query results into clear, impactful visualizations using Power BI. Employed a variety of chart types—bar, pie, map, donut, and line—to effectively communicate the data.

- Insight Presentation: Delivered insights through a compelling video presentation, clearly explaining key observations and offering actionable recommendations. Focused on delivering clear, understandable insights to support decision-making.

Through this approach, I understood the importance of not only technical skills but also effective storytelling in data analysis.

Project video