Sai Charan Thallapelli

About Me

I’m a passionate Data Analyst with a strong background in Business Intelligence and Data Storytelling. My expertise includes designing compelling dashboards, building complex queries, and turning data into strategic insights using tools like Power BI, SQL, and Python.

Projects

Superstore Sales Dashboard (Excel Project)

Tools: Excel, PivotTables, Charts

• Performed data profiling and cleaning on 9800 records; handled missing postal codes and formatted date and currency fields.
• Extracted Year/Month from Order Date and created KPI cards for Total Sales, Orders, Customers, and Average Sales.
• Built charts for regional, segment, category, and shipping performance using PivotTables and conditional formatting.
• Compiled visuals into a dashboard sheet with slicers for Region, Year, Segment, and Category.
• Top Insights: West region highest in sales, Technology is top category, Consumer segment leads, Q4 peak season.

📊 View Project

E-Commerce Sales & Customer Behavior Analysis

Tools: Oracle SQL, Power BI, DAX

• Performed end-to-end E-Commerce data analysis with SQL and Power BI to deliver insights on sales, product performance, customer behavior, and delivery efficiency.
• Cleaned and transformed 8 datasets using SQL, created 25+ Queries for KPIs and Business Requirements.
• Validated Power BI visual outputs with SQL query results to ensure data accuracy.
• Developed 4-page interactive Power BI dashboard: Executive KPIs, Sales/Customer Trends, Product/Delivery Analysis, and Payment Behavior.
• Key Insights: Revenue concentrated in a few states, delivery delays in high-revenue regions, and opportunities for product diversification and customer retention improvement.

📊 View Full Project 📊 View SQL Project

Marketing Campaign Performance Analysis

Tools: Python, Power BI

• Analyzed Facebook and Google AdWords ad performance for a 1-year campaign.
• Performed data cleaning and correlation analysis using Python.
• Built interactive Power BI dashboards covering KPIs, trends, funnels, and efficiency.
• Derived actionable insights to improve cost per conversion and channel ROI.

📊 View Project

Customer Churn Analysis Using Looker Studio

Tools: Google Looker Studio, Google Sheets

• Analyzed customer churn data for a telecom company with 7,000+ records.
• Built interactive Looker Studio dashboard to visualize churn rate, contract types, tenure groups, and service impacts.
• Identified highest churn among Fiber Optic customers and Month-to-Month contracts.
• New customers (0-6 months tenure) showed the highest churn rate.
• Developed recommendations to reduce churn through improved onboarding, long-term contracts, and service quality enhancements.

📊 View Project

Power BI Car Sales Dashboard

Tools: Power BI, Excel

• Designed and developed an interactive Power BI dashboard to analyze car sales data, enabling data-driven business insights.
• Visualized key KPIs such as Total Sales (371M), Total Vehicles Sold (13K), and Average Car Price (27.99K).
• Built dynamic charts including gender-wise and color-wise vehicle purchase distribution.
• Analyzed monthly sales trends to identify seasonal performance.
• Segmented buyers by income for targeted analysis.
• Implemented slicers for Year, Engine Type, Transmission, and Body Style to enhance interactivity.
• Demonstrated a 24% year-over-year increase in sales through comparative analysis.
• Improved data storytelling and dashboard aesthetics by applying intuitive design and layout techniques.