Excel
Project
Power BI
Projects
SQL
Project
Data Analysis
Projects
Hello! I’m Bhuvaneswari Kapuluru—a curious mind passionate about uncovering insights through data.
I specialize in translating complex datasets into clear, actionable stories that drive strategic decisions.
From Excel dashboards to SQL queries and Python-powered visualizations, I enjoy exploring patterns that spark innovation.
With every project, I aim to bridge the gap between raw data and real-world impact—whether in business performance, customer behavior, or operational efficiency.
If you believe data has the power to tell stories and shape decisions, I’d love to collaborate and create something meaningful!
Domain: E-commerce Sales
Function: Business Intelligence & Churn Risk
This project delivers key insights into customer purchase behavior and business performance using SQL, Excel, Python (RFM + EDA), and Power BI.
Domain: Consumer Goods
Function: Business Intelligence
This project delivers actionable insights using SQL & Power BI by solving 10 real-world business questions for strategic decisions in sales, products, and markets.
Domain: Retail Analytics
Function: Customer Behavior & Sales Strategy
This project analyzes over 500,000 transactions to uncover customer patterns using RFM segmentation, churn prediction, and exploratory data analysis using python libraries.
Domain: IT Hardware
Function: Sales Analysis
This Excel project evaluates customer and market-wise sales performance by analyzing trends, comparing targets, and summarizing profits & losses to support strategic decision-making.
Skills Used: SQL, Excel, Python, RFM Analysis, Power BI
As a global e-commerce giant, Amazon generates massive volumes of transaction data every day. However, to stay ahead of competition and improve decision-making, Amazon’s analytics team needs deeper insights into key business areas that impact both revenue and customer satisfaction.
The goal is to build a unified, interactive dashboard that delivers insights on:
Domain: E-commerce Sales
Function: Business Intelligence & Sales Optimization
This project analyzes Amazon's 2025 sales dataset to deliver insights on customer behavior, revenue patterns, RFM segments, and churn risk. SQL and Python were used for cleaning, modeling, and extracting insights, while Power BI visualizes patterns interactively.
This project focused on solving 7 real-world SQL business questions and followed by a dynamic dashboard in Power BI. It covered:
Skills Used: Python, Pandas, Seaborn, Matplotlib, RFM Segmentation
A fast-growing retail company is sitting on a large volume of historical sales data—over 500,000 customer entries. However, they lack clarity on which customers are churning, how to measure customer value, and where to focus retention efforts.
As a Data Analyst, your challenge is to transform this raw data into meaningful customer insights using techniques like RFM (Recency, Frequency, Monetary) analysis and churn detection. The output must be an interactive executive dashboard that enables senior leadership to:
Domain: Retail Analytics
Function: Customer Behavior & Sales Strategy
This project explores transactional behavior of customers from a UK-based online retailer. Through deep Exploratory Data Analysis, RFM segmentation, and churn prediction visuals, the project uncovers patterns in customer loyalty, seasonal sales, and segmentation-based marketing strategy using Python.
This project analyzes over 500,000 transactions using Python libraries to answer key business questions and identify loyal or churning customers. Key modules include:
Skills Used: Excel (Pivot Tables, Charts, Data Cleaning), Word (Summary Reports)
A leading consumer hardware company is looking to strengthen its market strategy by understanding key business metrics across different regions and timeframes. The management team wants to track how actual performance aligns with business targets, and identify where profits or losses are occurring.
With operations spanning multiple regions and years, the company lacks a centralized view of its:
Domain: IT Hardware
Function: Sales & Financial Performance
This project provides sales performance insights for an IT hardware company using Excel. It includes dynamic dashboards that evaluate market-wise and customer-wise sales performance, compare sales vs target, and break down profit & loss for strategic decisions. A professional summary report is included using Microsoft Word.
Skills Used: MySQL, Power BI
AtliQ Hardware, a global supplier of electronic devices and components, is actively hiring for the role of Data Analyst. As part of their selection process, candidates are asked to solve 10 real-world business problems that test data handling, analytical thinking, and visualization skills.
This Executive Insights Dashboard was developed in response to those challenges. It delivers interactive and actionable sales insights through Power BI, embedded inside a fully responsive HTML interface. The dashboard enables AtliQ’s leadership team to:
Each insight provided by the dashboard aligns with a specific business scenario presented by AtliQ—ranging from identifying underperforming product lines to forecasting regional sales growth. The objective of this project is to showcase how powerful visual storytelling can help stakeholders make smarter, faster, and more impactful business decisions.
Domain: Consumer Goods
Function: Business Intelligence
This project delivers actionable business insights for Atliq Hardware, a global consumer electronics brand, by solving 10 real-world business questions using MySQL and visualizing the results in Power BI. The goal was to assist business stakeholders in making faster decisions across sales, product, and market strategy using a clean, analysis-ready relational dataset.
This project focused on answering 10 SQL-driven business questions followed by a dashboard summary in Power BI. It covered:
Dec 2024 – Mar 2025
Data Analytics Certificate – Deloitte
Top 20 Contributor – GSSoC 2024
Python: For Beginners