Hi, I'm Rahul Chandavolu, a data analytics graduate with hands-on experience working with real-world datasets using SQL, Python, R, and Excel.
I enjoy analyzing data to understand customer behavior, uncover business trends, and transform raw datasets into actionable insights.
Through academic projects and self-driven learning, I have built strong skills in data cleaning, exploratory data analysis (EDA), data visualization, and analytical storytelling.
This repository showcases my analytics projects, dashboards, and open-source contributions.
• SQL
• Python (Pandas, Matplotlib)
• R (Tidyverse, ggplot2)
• Excel (Pivot Tables, Dashboards)
• Data Cleaning & Data Preparation
• Exploratory Data Analysis (EDA)
• Data Visualization
• Statistical Analysis
Goal
Analyze 50 years of USDA Producer Price Index (PPI) data to identify food inflation trends, volatility patterns, and historical comparisons across decades.
Key Analysis Areas
• Inflation trend analysis across decades
• Volatility comparison between decades
• Historical comparison between the 1970s oil crisis and 2020s inflation
• Identification of long-term inflation patterns in food prices
Skills Used
Data cleaning, EDA, trend analysis, statistical comparison
Technology
Python (Pandas, Matplotlib)
Project Repository
food-price-inflation-analysis
Goal
Segment customers based on purchasing behavior and generate insights to support targeted marketing.
Description
This project analyzes customer transaction data to identify meaningful customer segments. The analysis includes data cleaning, exploratory data analysis, and clustering techniques to understand customer purchasing behavior.
Skills Used
Data cleaning, EDA, customer segmentation, clustering, visualization
Technology
R, Tidyverse, ggplot2
Project Folder
Customer-Segmentation-Recommendation-R
Goal
Analyze sales performance and create an interactive dashboard for business reporting.
Description
This project focuses on analyzing sales data using Excel and presenting insights through a dashboard to support decision-making.
Skills Used
Data cleaning, KPI analysis, pivot tables, dashboard design
Technology
Microsoft Excel
Project Folder
Excel-Sales-Dashboard
Contributed documentation and SQL analysis examples for global trade datasets in the ModelEarth open-source project.
Key Contributions
• SQL import workflow examples
• Trade dataset folder structure documentation
• SQL trade analysis example queries
• Trade insights documentation
LinkedIn
https://www.linkedin.com/in/rahulchandavolu