ravikoti samyuktha

Data Analyst

Hyderabad, India 85 · Excellent

About

Detail-oriented and results-driven Data Analyst with an M.Sc. in Statistics and Silver Medal distinction. Proficient in SQL, Python, Power BI, DAX, Power Query, Tableau, and Excel. Experienced in data cleaning, data transformation, data modeling, data visualization, KPI reporting, and business intelligence dashboard development. Built two end-to-end Power BI dashboards across healthcare and retail domains implementing RFM customer segmentation, ABC product classification, and time-series analysis.

Skills & Expertise (25)

Power BI Advanced

8.5/10

Years Exp

DAX Advanced

8.0/10

Years Exp

Power Query Advanced

8.0/10

Years Exp

Business Intelligence Reporting Intermediate

7.5/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Microsoft Excel Intermediate

7.0/10

Years Exp

Data Cleaning Intermediate

7.0/10

Years Exp

Data Manipulation Intermediate

7.0/10

Years Exp

Python Intermediate

6.5/10

Years Exp

Statistical Modelling Intermediate

6.0/10

Years Exp

Tableau PivotTables Data Modelling Data Transformation Time Series Analysis Predictive Analytics Regression Analysis Hypothesis Testing Aggregations CTEs Subqueries Window Functions Joins Charts VLOOKUP

Work Experience

Retail Sales and Customer Insights Dashboard

Personal Project

Jan 2025 - Jan 2025

Designed a 4-page interactive Power BI dashboard analysing 2.78M in retail sales across 4 regions, 3 categories, and 793 customers (2014-2017). Developed 18+ DAX measures including Year-over-Year growth, Month-over-Month change, Sales YTD, Profit Margin %, and Average Order Value for KPI reporting. Implemented RFM customer segmentation and ABC product classification using DAX to identify high-value customers and prioritise inventory decisions. Scatter plot analysis revealed discounts above 40% directly cause profit losses; designed Executive Summary page with bookmark navigation.

Healthcare Inpatient-Outpatient Analysis Dashboard

Academic Project

Jan 2025 - Jan 2025

Built an interactive Power BI dashboard using Power Query and DAX to analyse patient flow, admission types, length of stay, and cost trends. Identified elderly patients (65+) had highest LOS and costs; top 5 diagnoses contributed to 60%+ of total volume and cost via drill-through analysis. Analysed weekday patient traffic patterns to support data-driven staffing and scheduling decisions for healthcare management.