Portfolio - Vishwambhar Kulkarni

Excel Project

Sales and Finance Analytics - AtliQ Hardware

The aim of this project is to provide a thorough examination of the company's financial condition and its position within the market. This entails producing various reports like "Customer Net Sales Performance" and "Market Performance vs. Target" by utilizing both basic and advanced Excel techniques

View Project
Engagement

View Project
on GitHUB

Sales and Finance Analytics - AtliQ Hardware

The Customer Performance Report displays the yearly net sales performance for each customer

Market Performance report evaluates the countries' performance over multiple years and compare it to the established targets.

Project Details

The project report is crucial for businesses to optimize customer discounts, streamline negotiations, and explore new markets. My reports provide practical insights to improve sales strategies, enhance customer satisfaction, and boost revenue, aiding businesses in making informed decisions and achieving growth. I have leveraged following technical skills in this project:
1. Data Transformation using Power Query
2. Fundamentals of Data Analysis Expressions (DAX)
3. Improving data visualization through conditional formatting
4. Data modelling
5. Understanding Business Insights through organized data

This project involves integration of technical skills with business acumen. Businesses can unlock significant growth opportunities through thorough analysis of the acquired data.

PowerBI Project

Business Insights 360

Business Insights 360 - A Microsoft Power BI dynamic dashboard that offers AtliQ Hardware a comprehensive view across Finance, Sales, Marketing, and Supply Chain. Our goal is to empower informed decisions, leveraging data insights for heightened competitiveness and accelerated growth.

View Project
Engagement

View Project
on GitHUB

The Landing page of this report - Home page

A Bird eye view of overall performance of AtliQ Hardware - The Executive View

Project Details

Business Insights 360 is a comprehensive dashboard that covers following views:
⏩ Home page: An introductory home page 🏠
⏩ Finance view: Complete Financial analysis 💸 of AtliQ Hardware
⏩ Sales View: Detailed insights into the sales 📊
⏩ Marketing View: Analysis of Marketing performance 💹
⏩ Supply Chain View: Analysis of key metrics in supply chain dynamics.
⏩ Executive View: A bird eye view of overall performance of AtliQ Hardware

These are the technical concepts I have demonstrated in this report:
🌟 Data Modelling
🌟 Creating measures using DAX language
🌟 Creating dynamic report offering valuable insights
🌟 Conditional formatting of visuals
🌟 Page navigation using buttons to ensure hassle free navigation for end users
🌟 Data Validation
🌟 Using KPI Indicators
🌟 PowerBI services, and publishing reports to PowerBI service

Live Interactive Dashboard

PowerBI Project

Hospitality Analysis

Hospitality Analysis is a project where raw data meets transformative insights. This is a Business Intelligence solution for AtliQ Grands, revitalizing market presence and elevating revenue streams. Witness the power of data-driven innovation by navigating through live report!

View Project
Engagement

View Project
on GitHUB

The complete dashboard that contains comprehensive view of necessary insights

The tool-tip for analyzing Revenue by Week no. and Category of hotels

Project Details

AtliQ Grands is embracing "Business and Data Intelligence" to reclaim their market share and revenue in hospitality industry. As part of this initiative, I developed an interactive dashboard using Power BI. This tool empowers AtliQ Grands to extract valuable insights from their data, enabling informed decisions and strategic actions to regain market share and boost revenue in the competitive landscape of luxury accommodations.
Some insights from this project are shared below:
- 𝗥𝗲𝘃𝗲𝗻𝘂𝗲: $ 1.71 Billion
- 𝗥𝗲𝘃𝗣𝗔𝗥: $ 7,347
- 𝗗𝗦𝗥𝗡: 2,528
- 𝗢𝗰𝗰𝘂𝗽𝗮𝗻𝗰𝘆 % - 57.87%
- 𝗔𝗗𝗥 - $ 12,696
- 𝗥𝗲𝗮𝗹𝗶𝘀𝗮𝘁𝗶𝗼𝗻 % - 70.15%

The key concepts I have learned while working on this project are:
➡ Data transformation and loading
➡ Data modelling
➡ Using tooltips for impactful visualization
➡ Creating appropriate visuals from stakeholders’ point
➡ Domain knowledge on Hospitality sector

Live Interactive Dashboard

SQL Project

Ad Hoc Analysis - Consumer Goods Domain

This is a SQL project focused on generating Ad hoc insights in the consumer goods domain. AtliQ Hardware seeks junior data analysts to improve data-driven decisions. Tony Sharma, Head of Data Analytics, organized an SQL challenge to find candidates with strong technical and soft skills.

View Project
Engagement

View Project
on GitHUB

List of Markets in which AtliQ Exclusive operates in APAC region.

Unique product counts for each segment.

Project Details

𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗢𝘃𝗲𝗿𝘃𝗶𝗲𝘄:
AtliQ Hardware (imaginary company), a leading manufacturer of computer hardware in India and other nations, faces challenges in making prompt and wise data-driven decisions. To address this, the management is looking to expand their data analytics team by adding more junior data analysts. Tony Sharma, the head of data analytics, organized a SQL challenge to find candidates who excel in both technical and soft skills.

𝗞𝗲𝘆 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀 𝗨𝘁𝗶𝗹𝗶𝘇𝗲𝗱:
- Joins
- Subqueries
- Common Table Expressions (CTEs)
- Table views
- Temporary Tables
- User-defined functions

Python Project

Ad Hoc Analysis - Hospitality Domain

This is a Python project on Ad Hoc Analysis in the Hospitality domain. AtliQ Grands, a leader in Indian hospitality, faced declining market share and revenue due to fierce competition. The objective: Reclaim market share and boost revenue by integrating Business and Data Intelligence.

View Project
Engagement

View Project
on GitHUB

Exploratory Data Analysis - for each of the fact tables

Data Cleaning - Removing outliers

Project Details

𝗣𝗿𝗼𝗯𝗹𝗲𝗺 𝗦𝘁𝗮𝘁𝗲𝗺𝗲𝗻𝘁: AtliQ Grands, a prominent player in Indian hospitality for over two decades, faced a significant challenge with decreasing market share and revenue in the luxury/business accommodation sector due to aggressive competition.

𝗢𝗯𝗷𝗲𝗰𝘁𝗶𝘃𝗲: To reclaim AtliQ Grands' market share and boost revenue by integrating "Business and Data Intelligence" into their operations.

𝗧𝗼𝗼𝗹𝘀 & 𝗧𝗲𝗰𝗵𝗻𝗶𝗾𝘂𝗲𝘀:
- 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗧𝗼𝗼𝗹: Python (Pandas library)
- 𝗞𝗲𝘆 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀 𝗘𝘅𝗽𝗹𝗼𝗿𝗲𝗱:
- Data Extraction
- Exploratory Data Analysis
- Data Cleaning
- Data Transformation
- Insights Generation (Ad Hoc Analysis)

Hello, I am

Vishwambhar Kulkarni

1

2

1

1

About

Key

My

Sales and Finance Analytics - AtliQ Hardware

Business Insights 360

Hospitality Analysis

Ad Hoc Analysis - Consumer Goods Domain

Ad Hoc Analysis - Hospitality Domain

Contact Me

Email

Github

Linkedin

Call

Vishwambhar Kulkarni

Download Resume