Portfolio - Abhishek Negi | Codebasics

Powered by
Codebasics DA Bootcamp

Abhishek Negi

Data Analyst

EMAIL

[email protected]

PHONE

+91 9654632562

Download CV

About Me

Data Analyst with 2.5 years as an Application Development Analyst in SAP, providing deep insight into enterprise data. I leverage a Computer Science degree and a modern analytics toolkit—SQL, Python, Power BI, and Advanced Excel—to transform raw data into actionable intelligence. My portfolio demonstrates this fusion of business acumen and technical skill, showcasing my ability to deliver clear, impactful narratives that drive strategic decisions. I am eager to apply my unique perspective to a dedicated data role.

1

Excel Project

2

PowerBI Projects

Key Skills

Excel

Power BI

DAX

SQL

Effective Communication

My Projects

My Experience

Application Development Analyst | Accenture | Hyderabad, India

Oct 2019 – Jun 2022

• Hands-on experience working with SAP technologies, specializing in the Supplier Relationship Management (SRM) module, with a solid understanding of the Materials Management (MM) module.

• Launched a self-service knowledge base for SRM functionalities, including shopping cart creation and PO processing, resulting in a 50% reduction in support tickets for these tasks.

• Managed client interaction and support, consistently addressing user concerns and enhancing the overall system experience, leading to a 25% increase in operational efficiency.

Awards & Certificate

Excel: Mother of Business Intelligence

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

SQL Beginner to Advanced For Data Professionals

Let's Work Together!

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

[email protected]

Call Me

+91 9654632562

LinkedIn

https://www.linkedin.com/in/negiabhishek97

GitHub

https://github.com/ZoroJuro97

PowerBI Project

Business Insights 360

Domain/Function: Finance - Sales - Marketing - Supply Chain - Product

Transformed AtliQ Hardware's decision-making process by building an integrated Power BI dashboard. Consolidated data from Sales, Finance, Marketing, and Supply Chain into a single source of truth, utilizing advanced analytics to provide actionable insights and support executive-level strategy.

View Project
on GitHUB

Other Tools

Excel

SQL

DAX

Business Insights 360

Business Insights 360 home dashboard showcasing multiple views like Finance, Sales, Marketing etc. for stakeholders.

Business Insights 360

Built a data model integrating forecast, actual sales, post-invoice deductions, costs, market share etc. for enhanced insights and decision-making.

Project Details

🌟 Project Overview
This project is designed to streamline and enhance multiple business functions at AtliQ Hardware, including Finance, Sales, Supply Chain, Executive Management, and Marketing.

💡Key Highlights:
✔ Stakeholder Views: Finance, Sales, Marketing, Supply Chain, and Executive levels.
✔ Tools & Techniques: Power BI (visualization), Power Query Editor (data transformation), DAX Language (advanced calculations).
✔ Advanced Features: Data modeling (Star & Snowflake Schema), Measures, KPIs, Conditional Formatting, Filters, Slicers, and Dynamic Refresh Dates.
✔ Visualizations: Cards, Slicers, Pie, Donut, Line Charts, Ribbon, Waterfall, and Matrix.
✔ DAX Functions: CALCULATE, FILTER, SAMEPERIODLASTYEAR, DIVIDE, IF, SWITCH, and more.

Live Interactive Dashboard

Excel Project

Customer Finance and Sales Analytics

Domain/Function: Finance and Sales Analysis

Developed a comprehensive Sales and Finance Analytics Report for AtliQ Hardware using advanced Excel (Power Query, Power Pivot, and DAX), transforming raw data into structured insights to empower data-driven strategic decisions.

View Project
on GitHUB

Customer Finance and Sales Analytics

AtliQ Hardwares Report: P & L report for all FY

Customer Finance and Sales Analytics

AtliQ Hardwares Report: Customer Net Sales Performance for all FY

Project Details

🌟 Project Objectives

📈 Sales Report
✔Customer Performance Report
Create a detailed analysis of customer performance over the years, highlighting sales figures and growth percentages.
✔ Market Performance and Sales Targets Comparison
Conduct a comprehensive comparison between market performance and sales targets, providing insights into the success of sales strategies.

💵 Finance Report
✔ Profit and Loss (P&L) Reports by Fiscal Year and Months:
Create a detailed analysis of customer performance over the years, highlighting sales figures and growth percentages.

🚀 Conclusion
This project served as a valuable opportunity to apply and expand my technical capabilities while fostering continuous learning and development. The experience has been pivotal in shaping my growth as a data professional, and I am eager to leverage these skills in future data-driven initiatives.

PowerBI Project

Strategic Insights for Mitron Bank

Domain/Function: Finance - Product

Analyzed customer spending behavior with AtliQ Services to uncover key trends. Leveraged these insights to design targeted special offers aimed at enhancing customer satisfaction and loyalty, ultimately contributing to Mitron Bank's business growth.

View Project
on GitHUB

Strategic Insights for Mitron Bank

Dashboard Home page

Strategic Insights for Mitron Bank

Data Model

Project Details

Mitron Bank is gearing up to launch a brand-new set of credit cards aiming to broaden its product offerings and reach in the financial market. Analyzed customer spending behavior with AtliQ Services to uncover key trends.

💡 Key Findings
✔Identified key spending trends, with Bills, Groceries, and Electronics as the top categories, and Mumbai emerging as the leading region in overall expenditure.
✔Income impact analysis revealed that Salaried IT professionals, Business Owners, and Other Salaried groups are the highest spenders.
✔City dynamics analysis shows Mumbai as the leading market, with diverse spending patterns observed in Delhi NCR, Bengaluru, and Chennai.
✔Gender and marital status analysis indicates that male and married individuals are the predominant card users.

🚀 Learnings
✔Developed targeted offers tailored to specific demographic segments.
✔Introduced category-specific features.
✔Adopted a holistic approach considering age, location, and profession.

Live Interactive Dashboard