Portfolio - Nitesh Dahiya

Nitesh Dahiya

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

About Me

Recent graduate with a strong foundation in data analysis, seeking an entry-level data analyst position. Proficient in Python, SQL, and data visualization tools. Eager to apply analytical skills and statistical knowledge to derive meaningful insights from complex datasets. Committed to continuous learning and contributing to data-driven decision-making processes

Key Skills

mysql

Python

My Projects

Customer Performance Report

Sales-Dashboard-and-Insights

Credit Card and Customer Performance Report

Awards & Certificate

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

SQL Beginner to Advanced For Data Professionals

Excel: Mother of Business Intelligence

JPMorgan Chase & Co. - Excel Skills Job Simulation

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/nitesh-dahiya

Call Me

+91 9467566226

GitHub

https://github.com/NITESHDAHIYAA

Excel Project

Customer Performance Report

This dashboard uses color-coding to highlight different levels of performance or growth, making it easy to identify top-performing products and customers at a glance.

View Project
Engagement

View Project
on GitHUB

Key features include: Filters for region and division Year-on-year sales figures for each market Comparison of 2021 performance against targets

Key features include: Filters for region, market (set to India), and division Customer-wise sales data for 2019 to 2021 Year-over-year growth

Project Details

Key Features:

Product-wise Total Sales Overview:

Displays total sales for each product in the AtliQ Hardware lineup.
Includes a filter section for region, market, and division, all currently set to "All".
Shows a grand total of sales across all products (277.0M).

Customer Net Sales Performance (India):

Focuses on the Indian market, showing customer-wise sales data.
Presents sales figures for 2019, 2020, and 2021.
Calculates year-over-year growth (2021 vs 2020) in percentage.
Highlights significant growth rates, with many customers showing over 300% growth.

Detailed Customer Sales Analysis:

Provides an expanded view of customer sales across three years.
Includes growth percentage calculations.
Covers a wider range of customers, including retail chains and e-commerce platforms.
Shows a grand total row, indicating overall sales growth from 87.5M to 598.9M, a 304.5% increase.

PowerBI Project

Sales-Dashboard-and-Insights

This Interactive dashboard, allowing users to filter data by year, quarter, region, and customer. It also provides different views (Finance, Sales, Marketing, Supply Chain, Executive) to cater to various stakeholders. The data is presented through a mix of tables, charts, and KPI cards.

View Project
Engagement

View Project
on GitHUB

The Home Tab has link to all the views to make it easy for stakeholders to navigate through the dashboard.

The Finance View has all the required metrics that are needed to make data-driven decisions.

Project Details

Empowers users to explore data, uncover patterns, and gain actionable insights for decision-making.
Dashboards display critical KPIs such as net profit, gross margin, forecast accuracy, and absolute error, allowing for real-time monitoring of key business metrics.
Provide a centralized platform for accessing and visualizing data from various departments and functions.

Live Interactive Dashboard

PowerBI Project

Credit Card and Customer Performance Report

This PowerBI project enables stakeholders to make data-driven decision for the business as it includes Credit Card Performance report and Customer Performance Report.

View Project
Engagement

View Project
on GitHUB

Credit Card Transaction Report View that includes all key metrics and KPIs for better understanding of its performance.

Customer Performance Report View that includes all filters and important performance indicators for better decision making.

Project Details

Developed a comprehensive credit card weekly dashboard that provides real-time insights into key performance metrics and trends, enabling stakeholders to monitor and analyze credit card operations effectively.