Ganesh
G

Hi, I'm Ganesh 👋

Data Analyst focused on turning data
into actionable insights.

I specialize in SQL, data cleaning, and building dashboards that help businesses make better decisions.

View Projects → Download Resume ⬇

Introduction

About me

Ganesh
G
DATA ANALYST · SQL · POWER BI · 📊

I'm a Data Analyst passionate about transforming raw, messy datasets into clear, meaningful insights. I work with SQL to extract and manipulate data from relational databases, use Power BI to create interactive dashboards that stakeholders can act on, and apply Excel for in-depth data cleaning and transformation. My approach is always business-first — every analysis I do is anchored in the question: what decision does this data help us make?

Skills

SQL, Power BI, Excel, Data Analysis, Data Cleaning

Education

Graduate — Computer Science

Projects

3+ real-world data projects completed

Tools I use

SQL Power BI Excel PostgreSQL Data Cleaning Dashboarding

What I offer

What I Do

Specialized data analytics services that help organizations understand their numbers and act on them with confidence.

Data Cleaning & Transformation

Raw data is almost always messy. I clean, deduplicate, standardize, and restructure datasets so they're analysis-ready and reliable.

See examples →

SQL Data Analysis

I write efficient, optimized SQL queries to extract, join, filter, and aggregate data — uncovering trends, anomalies, and business patterns.

See examples →

Dashboard Creation (Power BI)

Interactive Power BI dashboards that turn complex data into clear visuals — KPIs, drill-throughs, and filters that empower decision-makers.

See examples →

Business Insights & Reporting

Converting analytical outputs into business-ready reports with clear narratives, recommendations, and next steps for stakeholders.

Get in touch →

My portfolio

Projects

Real-world data analysis projects demonstrating SQL querying, Power BI dashboarding, and business insight generation.

🛒 Zepto Inventory
SQL · PostgreSQL

Zepto Inventory Data Analysis

End-to-end SQL analysis of a retail inventory dataset — cleaning dirty records, transforming structures, and extracting strategic business insights.

Key Insights

  • Identified top 10 overstocked SKUs causing ~23% excess inventory cost
  • Discount analysis revealed high-discount items with negative margin contribution
  • Revenue estimation by category helped prioritize restocking strategy
SQLPostgreSQLData CleaningInventory Analysis
View Project ↗
📞 Call Center KPIs
Power BI · DAX

Call Center Performance Dashboard

Interactive Power BI dashboard tracking agent performance, call trends, and customer satisfaction metrics in real time.

Key Insights

  • Mapped peak call hours to optimise agent shift scheduling
  • High abandonment rate correlated with average handle time above 4 min
  • CSAT score improved 12% following dashboard-led coaching decisions
Power BIDAXKPI TrackingDashboard
View Project ↗
🍫 Chocolate Sales
Power BI · Excel

Chocolate Sales Dashboard

Regional product contribution and shipment trend analysis visualized in Power BI to support marketing and inventory planning.

Key Insights

  • Top 3 products drove 61% of total revenue across all regions
  • Seasonal Q4 shipment peaks identified — enabled proactive inventory planning
  • Underperforming regions flagged for targeted sales strategy review
Power BIExcelSales AnalysisRegional Trends
View Project ↗
🛒 Retail Analytics
SQL Server · Power BI

Olist Retail Analytics

End-to-end e-commerce analytics project using SQL Server and Power BI to analyze sales, customers, products, sellers, delivery, reviews, and payments.

Key Insights

  • Analyzed sales and order trends to understand business performance
  • Compared delivery performance and customer review ratings
  • Created four interactive Power BI dashboard pages
SQL ServerPower BIDAXData Modeling
View Project ↗ View PBIX ↗
View all on GitHub →

Technical expertise

My Skills

Core competencies in data analytics, supported by foundational web skills.

Primary — Data Analytics

SQL Power BI Dax ETL Excel Data Cleaning Data Analysis PostgreSQL Dashboarding Business Reporting

Secondary — Web & Dev

HTML CSS JavaScript Java

Connect with me

Get in touch

Open to data analyst roles and freelance projects. Fill in the form or reach me directly through the links.

Please enter your name.
Please enter a valid email.
Please enter a message.

✅ Message sent! I'll get back to you soon.

Or reach me directly

Email

ganeshteja1616@gmail.com

LinkedIn

Ganesh Sattu

GitHub

codeganesh452

Resume

Download PDF