Vatcha Vivek Goud
Data Analyst — SQL, Excel, Power BI, Python
New to Contra
Vatcha Vivek is building their profile!
Cleaned and prepared a real-world e-commerce dataset (541,909 transaction records from the UCI Online Retail dataset) for analysis using Python and pandas. Removed exact duplicate rows, dropped records with missing Customer IDs, filtered out cancelled orders and invalid...
Analyzed 2 years of e-commerce order data using SQL, writing queries with window functions to uncover sales trends over time. This query aggregates monthly sales and calculates a running total using SUM() OVER (ORDER BY), showing cumulative revenue growth from $189K in Jan 2023...
Built an interactive Excel sales dashboard analyzing Superstore-style e-commerce data. Tracked $40.37L in total sales, $4.79L in profit, 1,800 orders, and an 11.9% profit margin through KPI cards, a monthly sales-and-profit trend chart, category and segment breakdowns, top-10...
Designed an interactive Power BI sales dashboard analyzing 2 years of e-commerce performance data. Surfaced key metrics — $4.04M in total sales, $479K in profit, and 2K orders — through clean KPI cards, a monthly sales-and-profit trend line, category and segment breakdowns, and...
