Portfolio - Nikhil | Codebasics

Excel Project

Sales and Finance Analytics

Crafted actionable insights through comprehensive sales and financial analytics in the FMCG sector. Empowered businesses with data-driven strategies for growth and expansion. Acquired proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report

Market Performance Report

Project Details

I made a sales report using Excel that helps businesses figure out good discounts for customers, talk better with them, and find new places to grow. The report gives advice on how to make sales better, make customers happier, and earn more money.

I learned to:

1. Use special tables in Excel
2. Work with data in a smart way
3. Do some basic math for data
4. Make things look pretty with colors
5. Make reports nice to look at
6. Know important sales numbers

This project is all about giving businesses the tools they need to watch, understand, and improve how they sell things. By looking at sales info, companies can find chances to do better, grow, and stay ahead in the changing market.

PowerBI Project

Business Insights 360 Power BI Dashboard

AtliQ Hardware, a consumer electronics firm, faces tough competition due to limited data usage, mainly relying on Excel for reports. My objective is to implement a robust Power BI analytics solution, enabling the company to gain crucial insights for smarter decision-making.

View Project
Engagement

Business Insights 360 Power BI Dashboard

Dashboard's Home Page

Finance View

Project Details

In this project, the primary objective was to create a unified report for stakeholders in sales, marketing, finance, and the executive team. Key areas of focus included:

1. Building a Robust Data Model
2. Designing User-Centric Reports
3. Providing Drillable Insights

During this project, I acquired the following skills and knowledge:

1. Proficiency in Power Query, covering both basic and advanced operations.
2. Mastery of basic and complex DAX formulas.
3. Expertise in data modeling with over 10 interconnected tables.
4. Selection of appropriate visuals and formatting techniques.
5. Skill in using bookmarks for enhanced user experience.
6. Deployment on the Power BI service platform.
7. Actively incorporating stakeholder feedback.
8. Analysis and reporting of metrics across sales, marketing, finance, and supply chain domains.

Project video

Live Interactive Dashboard

PowerBI Project

Revenue Insights in the Hospitality Industry

Transformed AtliQ Grands with data insights! Created a dynamic Power BI dashboard analyzing RevPAR, ADR, and more. Explore the interactive dashboard and project details on GitHub. Check out my portfolio for more data-driven successes!

View Project
Engagement

Revenue Insights in the Hospitality Industry

Dashboard's Home Page

Data Model

Project Details

Working with AtliQ Grands, a renowned luxury hotel chain, we implemented "Business and Data Intelligence" strategies to revitalize their market share and revenue. Our primary task was to create a dynamic Power BI dashboard to glean insights from their historical data.

Key areas of focus included:
1. Developing an interactive Power BI dashboard for real-time data analysis.
2. Implementing crucial hospitality domain metrics like RevPAR, ADR, DBRN, DSRN, and DURN.
3. Analyzing historical data to uncover revenue-enhancing opportunities.
4. Providing actionable insights to guide pricing and occupancy decisions.

During this project, I acquired the following skills and knowledge:
1. Proficiency in Power BI for data visualization and analysis.
2. Deep understanding of key hospitality metrics and KPIs.
3. Data-driven decision-making for pricing and occupancy optimization.
4. Effective data presentation to aid in strategic decision-making.

Live Interactive Dashboard

SQL Project

Ad-hoc insights in consumer goods domain

Atliq Hardwares, a fictional company, is a major computer hardware maker in India and abroad. Yet, they lack quick insights for smart decisions. So, a SQL challenge is on the horizon to fill this data gap.

View Project
Engagement

View Project
on GitHUB

Ad-hoc insights in consumer goods domain

Ad-Hoc Requests along with Output & Insights

Gross sales amount for the customer “Atliq Exclusive” for each month.

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making.

Hello, I am

Nikhil

1

2

1

About

Key

My

Sales and Finance Analytics

Business Insights 360 Power BI Dashboard

Revenue Insights in the Hospitality Industry

Ad-hoc insights in consumer goods domain

Contact Me

Email

Github

Linkedin

Call

Nikhil

Download Resume