Data Analyst · SQL · Power BI · Excel · PostgreSQL
Hyderabad, India |
LinkedIn |
ganeshtejai616@gmail.com
Entry-level Data Analyst skilled in transforming raw datasets into business-ready dashboards and actionable insights. I work across the full analytics workflow — data cleaning, SQL querying, KPI tracking, and stakeholder visualization — using Power BI, Advanced Excel, and PostgreSQL. Prior background in Java Full Stack gives me a solid understanding of data pipelines and backend systems.
| Area | Tools |
|---|---|
| Query & Databases | SQL · PostgreSQL · MySQL |
| Visualization & BI | Power BI · DAX · Data Modeling · Slicers · Drill-Through |
| Spreadsheet Analytics | Advanced Excel · Pivot Tables · Pivot Charts · KPI Cards · Lookup Functions |
| Analytics Concepts | EDA · Data Cleaning · KPI Reporting · Trend Analysis · Segmentation |
| Supporting | Git · GitHub · Python (basics) |
- Designed an interactive Power BI dashboard analyzing 1,000+ call records tracking 5 core KPIs: total revenue ($96K+), call volume, avg handle time (89K+ seconds), CSAT (3.9/5.0), and happy customer rate
- Authored DAX measures to automate weekly/monthly trend analysis — reducing manual reporting effort by ~60%
- Built rep-level drill-down with slicer filtering across 3 operational locations
- Queried and analyzed 5,000+ SKU-level records using 20+ advanced SQL queries (joins, window functions, GROUP BY, HAVING)
- Improved data quality by ~85% through NULL handling, deduplication, and category standardization
- Identified top 3 revenue-driving categories and flagged low-stock high-demand segments for restocking
- Built executive dashboard on 10,000+ transactions surfacing $2.3M+ revenue, $292K+ profit, 10K+ orders
- Engineered dynamic Pivot Tables with multi-variable slicers for self-service data exploration
- Identified Technology as top revenue contributor and flagged 3+ low-margin sub-categories
- Building my Data Analyst portfolio with real-world datasets
- Open to Data Analyst · Business Analyst · BI Analyst roles in Hyderabad & Remote
- Learning Python for data analysis (pandas, matplotlib)
If you find my work useful, feel free to star a repo — it helps a lot!