Portfolio - Naveen Jhinjarye

Naveen Jhinjarye

Data Analyst

Resume

1

Excel Project

3

PowerBI Projects

About Me

Hi, I’m Naveen, a Data Analytics enthusiast with an engineering background and a strong interest in transforming raw data into meaningful insights. I specialize in using Power BI, Excel, and SQL to analyze data, build interactive dashboards, and support data-driven decision-making.

I focus on clarity, accuracy, and usability, ensuring insights are not only reliable but also easy to understand. Along with technical expertise, I bring strong effective communication skills, enabling me to explain complex findings to both technical and non-technical audiences.

I am currently pursuing a B.Tech in Computer Science and actively working on real-world analytics projects to strengthen my practical knowledge. I am seeking opportunities where I can contribute value, learn from experienced professionals, and grow as a Data Analyst.

I am always open to collaboration, continuous learning, and meaningful discussions around data and analytics.

Key Skills

Microsoft Power BI

SQL

Excel

Effective Communication

Stakeholder Collaboration

My Projects

Sales & Finance Analytics

Domain/Function: FMCG

Business Insight 360

Domain/Function: Consumer Electronics Industry

Telecom Performance Analysis

Domain/Function: Telecommunication

Atliq Grand Business Insight

Domain/Function: Hospitality Domain

Awards & Certificate

Excel: Mother of Business Intelligence

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

Power BI: Business Intelligence for Beginners To Advanced

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.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/naveen-jhinjarye/

Call Me

+91 8814951348

GitHub

https://github.com/Naveen-Jhinjarye

Excel Project

Sales & Finance Analytics

Domain/Function: FMCG

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

Power Pivot

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

Excel-based P&L analysis for AtliQ Hardware's showing year-wise performance from 2019–2021. Includes Net Sales, COGS, Gross Margin, and GM%, with YoY growth comparison and dynamic filters for customer, market, division, and region.

Project Details

This project focuses on analyzing sales and finance data to create interactive reports and dashboards that help businesses track performance and make informed decisions. The objective was to analyze Net Sales, COGS, Gross Margin, and GM% across year, quarter, country, and sub-zone to support strategic planning.

📌 Objective:
• Analyze sales and finance data to identify trends and profitability
• Enable clear understanding of key business metrics through dashboards

🛠️ Tools Used:
• Microsoft Excel
• Power Query Editor
• Power Pivot

💡 Skills Learned:
• Data Cleaning and Transformation
• Data Modeling and ETL
• DAX (Basics)
• Conditional Formatting and Report Beautification

📊 Impact:
• Simplified KPI tracking and insight extraction
• Helped identify high-performing regions and revenue trends
• Supported decisions related to discounts, negotiations, and business expansion

PowerBI Project

Business Insight 360

Domain/Function: Consumer Electronics Industry

Built an end-to-end Power BI Business Insights 360 dashboard for AtliQ Hardware, delivering executive-level insights on sales, profitability, and performance across countries, products, and channels using advanced DAX, Data Modeling, and Time Intelligence.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power Query

Dax Studio

SQL

Power BI dashboard for AtliQ Hardware – Business Insight 360 with P&L, sales, marketing, supply chain insights (₹ Millions). Enabled data-driven decisions on revenue, margins, and growth.

Data modelling involving 10+ tables

Project Details

📌 Objective:
The main objective of this project was to create a fully interactive Power BI dashboard for AtliQ Hardware to analyze sales and finance data. The dashboard delivers insights on Net Sales, Revenue, Gross Margin %, product performance, country-level results, and discount impact, enabling data-driven decisions, strategic planning, and business performance optimization.

🛠️ Tools Used:

Power BI

SQL

Power Query

DAX

Excel

💡 Skills Learned:

Data Cleaning & Transformation

Data Modeling (Star Schema)

Advanced DAX Measures & Time Intelligence (YoY, YTD, MoM)

Dashboard Design & KPI Development

Performance Optimization using DAX Studio

Business Analytics & Insights Interpretation

📊 Problem Solving & Impact:

Visualized global sales trends, profitability, and channel contributions

Simplified KPI extraction and trend analysis for faster decision-making

Tracked discount impact and identified high-growth products and regions

Project video

Live Interactive Dashboard

PowerBI Project

Telecom Performance Analysis

Domain/Function: Telecommunication

Analyzed AtliQ’s 5G launch impact on users, revenue, ARPU, and market share using Power BI. Built executive dashboards with DAX & Power Query, highlighting city-level adoption trends, pricing gaps, and opportunities for growth and plan optimization.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power Query

Telecom Dashboard Cover: Executive-style dashboard entry screen for AtliQ Telecom. Highlights user and market share analysis modules with refresh metadata—ideal for stakeholder presentations.

Telecom Data Model: Power BI star schema linking telecom metrics, plans, market share, and city data. Demonstrates scalable modeling for strategic 5G impact analysis and KPI tracking.

Project Details

Analyzed AtliQ’s 5G launch impact on users, revenue, and market position, enabling data-driven pricing, growth, and customer strategy decisions.

🔍 Analysis Covered:

Pre- vs Post-5G performance

KPIs: Revenue, Active Users, ARPU, Market Share %

City-wise performance to identify growth and risk areas

🛠️ Dashboard Built Using:

Power Query for data cleaning & transformation

Financial unit standardization (Crores/Lakhs → Millions)

DAX for % change and 5G impact analysis

Executive-focused, clear Power BI dashboard

📊 Insights & Impact:

Uneven 5G adoption across cities

ARPU ↑ but users ↓ → pricing barrier

Users ↑ but revenue ↓ → monetization gap

Guided city-specific offers, plan optimization, and inactive user reactivation

Project video

Live Interactive Dashboard

PowerBI Project

Atliq Grand Business Insight

Domain/Function: Hospitality Domain

Developed Power BI dashboards for AtliQ Grands to analyze revenue and occupancy trends. Enabled data-driven decisions to improve hotel performance, pricing strategy, and profitability across multiple cities.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Power Query

Hotel BI Dashboard: Interactive dashboard showcasing hotel KPIs—revenue, occupancy, RevPAR—across cities. Demonstrates advanced data storytelling and decision-driving analytics.

Data Model Diagram: Robust Power BI data model linking hotel booking dimensions and facts. Highlights strong data modeling skills essential for scalable, insight-rich reporting.

Project Details

This project focuses on solving a real-world hospitality business problem for AtliQ Grands, a luxury five-star hotel chain in India facing declining market share, revenue loss, and rising competition due to non-data-driven decisions. As a third-party Data Analyst, I analyzed historical hotel data and built interactive Power BI dashboards to support executive decision-making.

📊 Analysis Performed:

Revenue analysis to identify performance gaps

Occupancy analysis to evaluate utilization trends

Property, city, and time-based comparisons

🛠️ Tools Used:
Power BI, DAX, Power Query, Excel

🧠 Skills Applied:
Data cleaning & transformation, data visualization, business problem-solving, stakeholder-focused reporting, and data storytelling

📈 Business Impact:
Enabled data-driven decisions, supported revenue optimization and occupancy improvement strategies, and demonstrated how analytics transforms raw data into actionable business value.