Portfolio - Nikhil | Codebasics

Excel Project

Sales Analytics(FMCG)

Created two 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
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

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

Project Details

In this project , I created a sales report using excel picot tables which enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

ALIiQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. my goal is ta implement an advanced analytics solution using Power BI .

View Project
Engagement

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

User friendly landing page as a part of dashboard design

data modelling involving 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

PowerBI Project

Marketing Insights on CodeX

CodeX, a German beverage company, recently launched its energy drink in India. The marketing team aims to increase brand awareness, market share, and product development. To gather insights, a survey was conducted in 10 cities, generating responses from 10,000 respondents.

View Project
on GitHUB

I have created a interactive dashboard which shows all the details and KPI's and easily understandable to all users.

data modeling with 3 tables and different category.

Project Details

In the codebasics Resume Project Challenge, I analyzed survey data for CodeX using Excel, MySQL and Power BI. Key findings revealed a strong male consumer base, a significant youth demographic, and the effectiveness of online ads.
Consumers favored energy drinks with caffeine and natural ingredients, with potential for expansion in Tier 2 cities.

Actionable recommendations included collaborating with online influencers, enhancing products with natural alternatives, and strategic pricing for different city tiers. Strengthening partnerships with supermarkets and considering Virat Kohli as a brand ambassador were suggested for brand enhancement.

This project honed my data analysis skills, providing valuable insights for CodeX's marketing strategies.

Hello, I am

Nikhil

1

2

About

Key

My

Sales Analytics(FMCG)

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Marketing Insights on CodeX

Contact Me

Email

Github

Linkedin

Call

Nikhil

Download Resume