Portfolio - Nikhil Durge

Hello, I am

Nikhil Durge

Data Aspirant

Resume

2

PowerBI
Projects

1

Excel
Project

About

Hello there! I'm Nikhil Durge, a passionate and detail-oriented Data Analyst with a knack for turning raw data into actionable insights. My journey in the world of data analytics has been driven by a curiosity to unveil patterns, solve complex problems, and contribute meaningfully to data-driven decision-making.
-Proficient in data analysis tools such as Power BI, SQL, and Python.
-Experienced in cleaning and modeling data for accurate analysis.
-Adept at crafting compelling data visualizations for effective communication.
I have had the privilege of working on impactful projects, these experiences have not only enhanced my technical skills but also deepened my appreciation for the strategic role of data in decision-making.

Key

Skills

Python

SQl

Advanced Excel

DAX

My

Projects

Business Insights 360

Spearheaded the development and deployment of a comprehensive business itelligence solution utlizing Power BI, My-SQL and Excel; provided real-time data analytics and enabled data-driven decision-making, resulting in a 40% reduction in customer churn and a 15% increase in customer satisfaction.

Sales and Finance Analytics Report of AtliQ Hardware

Transformed your business perspective with a project centered on Customer Performance Assessment and Finance Report Analysis. Harnessed advanced skills in data processing and analysis, utilizing tools like Power Query and Power Pivot. Crafted user-friendly reports to provide Insights.

Call Center Dashboard

The Call Center Dashboard project is designed to provide a provide real-time insights into call center performance, optimize agent productivity, and improve customer satisfaction

Awards

& Certificate

Accenture Data Analytics and Visualization Job Simulation

KPMG Data Analytics Consulting Virtual Internship

PWC Power BI Job Simulation

TATA Data Visualisation: Empowering Business with Effective Insights

Contact Me

Email

[email protected]

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

Call

+91 9595996736

Nikhil Durge

Data Aspirant

Download Resume

Resume

PowerBI Project

Business Insights 360

View Project
Engagement

his is the home page for BI 360 Insights where clicking the icons lands you in a separate analysis page.

Finance View: describes P&L statements year wise and with other filters as well.

Project Details

AtliQ Hardware, an international consumer goods electronics company, experienced a significant setback in Latin America due to the limitations of their data analytics capabilities. Recognizing the need for a robust data analytics solution, the company's leadership decided to invest in a comprehensive data analytics project.
As a Data Analyst👨‍💻, I spearheaded the development of bespoke reports tailored to the unique needs of various teams, including Finance, Sales, Marketing, Supply Chain, and Executive. These reports, rich in actionable insights, have empowered each team at AtliQ to make data-driven decisions, thereby equipping them with a strategic advantage.

Project Phases:
➡ Initiation: Kick-off Meeting & Project Charter
➡ Execution: Data Collection, Transformation, & Report Generation
➡ Review: Stakeholder Feedback & Dashboard Implementation

Domains Addressed:
➡ Finance
➡ Sales
➡ Marketing
➡ Supply Chain
➡ Executive (For Stakeholders)

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics Report of AtliQ Hardware

View Project
Engagement

Top 10 Prodects and Customers

Market Performance Vs Target

Project Details

Empowering Business Growth through Sales Insights: I crafted a dynamic Excel sales report, unlocking valuable strategies for effective customer engagement, smarter negotiations, and international expansion opportunities. The reports offer practical advice, optimizing sales tactics, enhancing customer satisfaction, and boosting revenue.

Here's what I learned:

➡️Pivot Table
➡️Power Query
➡️DAX(Basics)
➡️Advanced Excel functions (e.g., VLOOKUP, IF statements)
➡️Mastering sales metrics
➡️Conditional Formatting
➡️Presenting captivating reports
➡️Data validation and cleansing techniques

This project equips businesses with essential tools to monitor, refine, and supercharge their sales efforts. By analyzing sales data, companies discover avenues for improvement, fuel growth, and thrive in a dynamic market landscape.

PowerBI Project

Call Center Dashboard

The Call Center Dashboard project is designed to provide a provide real-time insights into call center performance, optimize agent productivity, and improve customer satisfaction

View Project
Engagement

Call Center Dashboard

Project Details

Led the development of a dynamic call center dashboard to enhance operational visibility and streamline performance. Integrated real-time data feeds, providing instant insights into call volumes, agent availability, and service levels. Designed interactive dashboards for analyzing key performance indicators, resulting in a 20% increase in team productivity. Automated reporting mechanisms reduced manual efforts by 40%, recognized for impactful contributions to call center efficiency and service quality.
● Developed a comprehensive call center dashboard, resulting in a 73% query resolution rate.
● Achieved a 3.4 average satisfaction rate.

Hello, I am

Nikhil Durge

2

1

About

Key

My

Business Insights 360

Sales and Finance Analytics Report of AtliQ Hardware

Call Center Dashboard

Awards

Contact Me

Email

Linkedin

Call

Nikhil Durge

Download Resume