Excel
Project
PowerBI
Projects
SQL
Project
Python
Project
Me
Hi! I’m Rachana Hadke, an aspiring data analyst who loves finding the stories in numbers.
I focus on turning raw data into useful insights that help make smarter and quicker decisions.
Whether I’m diving into complex datasets or crafting visually compelling dashboards, I thrive on solving real-world problems with data.
I’ve worked on projects across finance, retail, and sports, where I’ve helped identify trends and improve strategies using data.
I’m also a lifelong learner—constantly upskilling through certifications and challenging projects, pushing the boundaries of what data can achieve.
If you’re looking for someone who can not only analyze data but transform it into a competitive advantage, let’s connect!
Skills
Excel
PowerBI
Effective Communcation
Stakeholder Management
Problem Solving
Projects
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.
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.
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.
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.
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.
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.
Experience
Analyst - Capgemini, Mumbai
Nov 2020 - Dec 2022