Portfolio - Rachana Hadke

Excel Project

Sales Analytics

Domain/Function: IT Hardware Sales Analysis

This project focuses on analyzing the company's sales performance and market standing. The insights provided by advanced Excel techniques such as Pivot Tables and Power Query, help the sales team optimize strategies, improve customer relationships, and track market goals effectively.

View Project
Engagement

View Project
on GitHUB

Customer Net Sales Performance displays the yearly net sales performance for each customer.

Market Performance vs Target Report

Project Details

In this project, I developed a sales report using Excel Pivot Tables to help businesses understand their sales performance better. This report is a powerful tool for identifying the best customer discounts, making negotiations easier, and finding new markets to explore.

The insights from these reports can help businesses improve their sales strategies, boost customer satisfaction, and increase revenue.

During this project, I learned how to:

1. Use Pivot Tables for quick data analysis.
2. Apply Power Query for smooth data processing.
3. Understand the basics of DAX (Data Analysis Expressions).
4. Use Conditional Formatting to highlight important information.
5. Make reports visually appealing and easy to read.
6. Analyze key sales metrics effectively.

Overall, this project gives businesses the insights they need to enhance their sales efforts and discover new growth opportunities through data analysis.

PowerBI Project

Business Insights 360

Domain/Function: IT Hardware

AtliQ Hardware faced challenges managing data in Excel, limiting insights into key areas. My objective was to transition the company to Power BI, enabling better analysis of finance, sales, and supply chain, utilizing a substantial dataset of 1.8 million entries for informed decision-making.

View Project
Engagement

View Project
on GitHUB

Dashboard's homepage

Data model

Project Details

The main aim of this project was to create a comprehensive dashboard for stakeholders across sales, marketing, finance, and the executive team. The focus areas included:

Robust Data Model: Building a solid foundation for data analysis.
User-Friendly Design: Creating intuitive reports that cater to user needs.
Interactive Insights: Offering drillable features for in-depth data exploration.

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

Project video

Live Interactive Dashboard

PowerBI Project

Sports Insights

Domain/Function: Sports Analysis

This IPL Cricket Analysis project dives into match data to uncover trends and insights. The goal is to evaluate player performances, team strategies, and match outcomes, helping teams and fans understand the game better and make informed predictions for future matches.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Dashboard's Homepage

Batting Stats Page

Project Details

The IPL Cricket Analysis project aims to explore match data to uncover trends, player performances, and team strategies. Using various datasets, I analyzed key metrics such as runs scored, wickets taken, and player statistics to evaluate how different factors influence match outcomes.

I created visualizations to illustrate
- trends over seasons
-highlight top-performing players
-analyze team strengths and weaknesses

This analysis not only provides insights for teams and coaches but also enhances fan engagement by offering a deeper understanding of the game.

Throughout this project, I learned:

1. Data cleaning and preparation techniques.
2. The importance of effective data visualization to communicate insights.
3. Advanced statistical methods to analyze player and team performances.
4. Key cricket metrics that impact game outcomes.

Project video

Live Interactive Dashboard

PowerBI Project

Promotion Effectiveness Insights

Domain/Function: Retail Analytics

This project analyzes the impact of promotional campaigns on AtliQ Mart's branded products during Diwali 2023 and Sankranti 2024. By evaluating sales data and customer response, we aim to identify successful strategies and provide actionable insights for future marketing efforts.

View Project
Engagement

View Project
on GitHUB

Dashboard's Homepage

Product and Category analysis

Project Details

In this Promotion Effectiveness Analysis project for AtliQ Mart, I explored how promotional campaigns during Diwali 2023 and Sankranti 2024 impacted sales of AtliQ branded products. By diving into sales data, I uncovered valuable insights that can shape future marketing strategies.

Achieved Objectives:

1. Established key performance indicators (KPIs) to evaluate promotional success.
2. Developed an interactive dashboard based on stakeholder requirements.
3. Leveraged Power BI for data visualization.
4. Used DAX to create advanced calculations and measures.

This experience enhanced my analytical skills and deepened my understanding of marketing dynamics in retail.

Project video

Live Interactive Dashboard

Python Project

Data analysis in Hospitality Domain using Python

Domain/Function: Hospitality Domain

Analyzed booking data for AtliQ Grands, a hotel chain, using Python to uncover key insights into occupancy rates, revenue trends, and customer behavior. Delivered actionable recommendations to optimize hotel performance, boost revenue, and market share.

View Project
Engagement

View Project
on GitHUB

Data analysis in Hospitality Domain using Python

Data transformation

Pie chart showing revenue generated from different booking platforms

Project Details

- Applied exploratory data analysis (EDA) to uncover trends in occupancy rates, room types, and booking platforms.
- Created key metrics, Occupancy Percentage, to assess performance across cities and room categories.
- Visualized data to identify patterns in revenue realization and occupancy rates.
- Developed actionable recommendations to improve occupancy, optimize pricing strategies, and target underperforming cities.
- Gained hands-on experience in data cleaning, transformation, and visualization, enhancing my Python tool skills for data analysis.

Project video

SQL Project

Data analysis in consumer goods domain using SQL

Domain/Function: Consumer Goods

AtliQ Hardware Sales Analysis: Analyzed sales and operational data to uncover insights on customer segments, product performance, and trends. Used SQL for analysis, Power BI to create impactful visualizations, and applied data storytelling techniques to enhance decision-making.

View Project
Engagement

View Project
on GitHUB

Data analysis in consumer goods domain using SQL

Product Performance

Market Insights

Project Details

Conducted an in-depth analysis of sales and operational data for AtliQ Hardware, focusing on customer insights, product performance, sales trends, and discount effectiveness. Leveraged tools such as SQL and Power BI to extract, clean, and visualize data, creating visuals that highlighted key metrics and actionable insights. Identified top-performing products, high-discount customers, and trends to support strategic decision-making. Applied data storytelling techniques to present findings effectively, demonstrating the impact of data-driven insights. This project not only enhanced my technical skills but also emphasized the importance of aligning analytics with business objectives.

Hello, I am

Rachana Hadke

1

3

1

1

About

Key

My

Sales Analytics

Business Insights 360

Sports Insights

Promotion Effectiveness Insights

Data analysis in Hospitality Domain using Python

Data analysis in consumer goods domain using SQL

My

Awards

Contact Me

Email

Github

Linkedin

Rachana Hadke

Download Resume