B Chandu
ENTRY - LEVEL DATA ANALYST
Hi, I'm Chandu, an aspiring Data Analyst with experience analyzing real business datasets and building dashboards that support data-driven decisions. I have worked with SQL, Python, Power BI, and Excel to analyze thousands of customer transactions, uncover revenue trends, and visualize KPIs that help organizations understand their data better. From identifying high-value customer segments to analyzing insurance complaint trends, I focus on translating complex data into clear and actionable insights. This portfolio highlights my analytics projects, dashboards, and data-driven problem-solving approach.
Flight Log
Data Analyst Intern
Rubixe · Bangalore, India
Aug 2025 — Dec 2025
- Examined 10K+ customer transactions using SQL, Excel, and Power BI to identify key revenue drivers, revealing adults contributing 58–62% and female customers generating 60–65% of total revenue.
- Assessed customer payment behavior and discovered cash transactions accounted for 50–55%, providing insights to support digital payment adoption strategies.
- Developed interactive Power BI dashboards with 10+ KPIs including Revenue, Average Order Value (AOV), and Purchase Frequency, enabling faster data-driven business decision-making.
- Conducted automobile insurance complaint analysis (2009–2016), categorizing thousands of cases and performing trend analysis on complaint ratios and premiums to uncover insurer performance gaps and customer grievance patterns.
Mission Payloads
Customer Data Analysis
Performed data analysis on 10K+ customer transactions across age, gender, revenue, and payment methods, uncovering key revenue-driving segments. Identified adult customers contributing 58–62% of total revenue, making them the highest-value segment. Discovered female customers generated 60–65% of revenue, indicating stronger purchase frequency. Evaluated payment behavior, spotted cash as dominant payment method (50–55%), indicating opportunity to improve digital payment adoption. Designed and built dashboards in Power BI with 10+ KPIs (Revenue, AOV, Purchase Frequency) to enable data-driven decisions.
Automobile Insurance Complaints Ranking
- Analyzed historical automobile insurance complaint data (2009–2016) across multiple providers to evaluate performance gaps and complaint outcomes. - Identified high-risk outliers by calculating complaint ratios, uncovering significant grievance patterns and upheld case trends across major insurers. - Investigated multi-year trend analysis on premiums and claims frequency, correlating financial fluctuations with regulatory changes and market conditions. - Implemented a standardized ranking framework using KPIs such as complaint-to-premium ratios to facilitate objective benchmarking of industry peers. - Engineered interactive Power BI and Excel dashboards to visualize complaint severity, rankings, and historical performance trends. - Executed comprehensive data cleaning and transformation on raw insurance records to ensure high data integrity for statistical modeling and reporting.
Systems & Tech
Training Academy
B.C.A in Computer Science
Mohan Babu University · Tirupati, Andhra Pradesh, India
Jun 2022 — Jul 2024