Portfolio - Nikhil Dhasmana | Codebasics

Powered by
Codebasics DA Bootcamp

Nikhil Dhasmana

Data Aspirant

EMAIL

[email protected]

PHONE

+91 07417419188

Download CV

About Me

Hey there, I’m Nikhil Dhasmana, an aspiring Data Analyst passionate about transforming raw data into actionable insights. With a strong foundation in analytical tools such as Excel, Power BI, SQL, and Python, I specialize in uncovering patterns, solving complex problems, and supporting data-driven decision-making.

While I am yet to begin my professional journey within an organization, I have successfully completed multiple business-focused projects, which you can explore in my portfolio. These projects demonstrate my ability to approach real-world challenges, analyze datasets effectively, and deliver solutions that add measurable value.

I am eager to apply my skills, curiosity, and dedication in a dynamic professional environment—contributing to impactful strategies, optimizing processes, and driving growth through data.

Join me on this exciting journey as we harness the power of data to drive impactful change.

1

Excel Project

2

PowerBI Projects

1

SQL Project

Key Skills

Power BI

Advance Excel

SQL

My Projects

Awards & Certificate

SQL(intermediate)

SQL(intermediate)

Excel: Mother of Business Intelligence

Excel: Mother of Business Intelligence

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

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

SQL Beginner to Advanced For Data Professionals

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 07417419188

LinkedIn

https://linkedin.com/in/3b2b90137

GitHub

https://github.com/NIKHIL50198

Excel Project

Sales and Finance Analytics

Domain/Function: Business Intelligence

The goal of this project is to deeply understand how the company is doing financially and where it stands in the market. I have created different reports like "Customer Net Sales Performance" and "Market Performance vs. Target" using basic and advanced Excel skills.

View Project
Engagement

View Project
on GitHUB

Other Tools

Pivot Table

Power Query

Sales and Finance Analytics

The Customer Performance Report reveals the net sales performance of each customer over multiple years.

Sales and Finance Analytics

The Market Performance vs Target report allows stakeholders to evaluate how well the country is doing and compare it against the target.

Project Details

In this project, I've developed a dynamic sales report using Excel pivot tables, offering businesses invaluable insights into customer discounts, negotiation strategies, and untapped markets. These reports provide actionable recommendations, empowering businesses to refine sales tactics, elevate customer experiences, and maximize revenue.

Throughout this journey, I've honed skills in:

1. Pivot tables
2. Power Query
3. Basic DAX functions
4. Effective Conditional Formatting
5. Report Presentation
6. Sales Domain Metrics

The primary goal is to arm businesses with the tools and insights needed to monitor, assess, and optimize their sales efforts. By leveraging data-driven analysis, businesses can uncover opportunities for growth, adapt to market changes, and maintain a competitive edge in an ever-evolving landscape.

PowerBI Project

Hospitality Analysis

Domain/Function: Hotel chain

I'm on board to help AtliQ Grand, a well-known hotel chain with five-star properties in major Indian cities. Despite its good reputation, they're seeing a drop in revenue and market share. They seek my help to analyze data and offer insights. Using Power BI, I'll chart the course to success.

View Project
on GitHUB

Other Tools

Power BI

Excel

Hospitality Analysis

Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage, average rates and other metrics.

Hospitality Analysis

Examines booking patterns, cancellations, and guest behavior. Generates actionable insights to improve operational efficiency and drive revenue growth

Project Details

I crafted this project as a third-party data analyst to assist AtliQ Grand, a renowned hotel chain, in reclaiming lost market share and boost revenue. Facing tough competition and lacking data-driven decisions, they sought expertise to turn the tide.

This project offers three comprehensive views:

Performance Overview:
Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage. Detailed metrics such as average rates and cancellation percetage are included.

Revenue Breakdown:
Delves into revenue distribution across cities, hotel categories, and booking platforms. These insights are crucial for optimizing sales strategies.

Booking Analysis:
Examines booking patterns, cancellations, and guest behavior. This yields actionable insights to improve operational efficiency and drive revenue growth.

I learned the following things in this project

1. Data Visualization
2. Revenue Analysis
3. Presentation Skills
4.Critical thinking
5. Dax

Live Interactive Dashboard

PowerBI Project

Business Insights 360

Domain/Function: Business Intelligence (BI)

AtliQ Hardwares, a consumer electronics company, is growing fast but struggles to keep up with competitors who use data effectively. Most of their reports are still in Excel. My aim is to set up a smart analytics system using Power BI. This will help the company in making smarter decisions.

View Project
on GitHUB

Other Tools

SQL

Excel

DAX Studio

Business Insights 360

Finance Insights: Unveiling key financial metrics and trends from the project's analytics dashboard.

Business Insights 360

Data Model: Incorporating 10+ Tables.

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. 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

Live Interactive Dashboard

SQL Project

Ad-Hoc Insights

Domain/Function: Consumer goods

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
on GitHUB

Other Tools

MySQL

Power BI

Ad-Hoc Insights

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

Ad-Hoc Insights

This shows the highest and lowest manufacturing cost product.

Project Details

Title: Ad-Hoc Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.

My Task: As a hypothetical applicant, I:

Reviewed 'ad-hoc-requests.pdf' with 10 business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Employed Power BI for impactful visualizations. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.