BHAGYASHRI SARANGI

Data Analyst

Bangalore, Karnataka, 560090 0+ yrs exp 81 · Excellent

About

Data Analyst with 6 months of hands-on experience in data analysis, reporting, and business intelligence. Proficient in SQL, including Joins, Sub-queries, and Database Operations, for data extraction and analysis. Skilled in Advanced Excel, utilizing Pivot Tables, Charts, Dashboards, and functions such as INDEX-MATCH, VLOOKUP, HLOOKUP, and OFFSET for data cleaning, transformation, validation, and reporting. Experienced in Power BI, including Power Query Editor, DAX Functions, Data Modeling, Data Visualization, Dashboard Development, and Power Pivot Integration to create interactive dashboards and generate actionable insights. Strong understanding of KPI analysis, trend analysis, and data-driven decision-making, with excellent analytical and problem-solving skills. Proficient in Microsoft Office Applications and passionate about transforming raw data into meaningful business insights to support organizational growth.

Skills & Expertise (22)

Power BI Intermediate

6.0/10

0.5

Years Exp

SQL Intermediate

5.6/10

0.5

Years Exp

Trend Analysis Intermediate

5.6/10

0.5

Years Exp

Advanced Excel Intermediate

5.6/10

0.5

Years Exp

KPI Analysis Intermediate

5.6/10

0.5

Years Exp

Data Visualization Intermediate

5.6/10

0.5

Years Exp

Power Query Editor Intermediate

5.6/10

0.5

Years Exp

Data Cleaning Intermediate

5.6/10

0.5

Years Exp

Pivot Tables Intermediate

5.6/10

0.5

Years Exp

Charts Intermediate

5.6/10

0.5

Years Exp

Dashboards Intermediate

5.6/10

0.5

Years Exp

Dashboard Development Intermediate

5.6/10

0.5

Years Exp

VLOOKUP Intermediate

5.6/10

0.5

Years Exp

DAX functions Intermediate

5.6/10

0.5

Years Exp

Joins Intermediate

5.2/10

0.5

Years Exp

Sub-queries Intermediate

5.2/10

0.5

Years Exp

HLOOKUP Intermediate

5.0/10

0.5

Years Exp

Index-match Intermediate

5.0/10

0.5

Years Exp

analytical skills Intermediate

5.0/10

0.5

Years Exp

Problem-solving skills Intermediate

5.0/10

0.5

Years Exp

OFFSET Beginner

4.8/10

0.5

Years Exp

Data Modeling Beginner

4.8/10

0.5

Years Exp

Work Experience

Analyst Trainee

Gutsy Innovation

Feb 2023 - Aug 2023

Analyzed and extracted data using SQL and Advanced Excel, performing data cleaning, transformation, validation, and trend analysis to generate accurate reports and actionable business insights. Developed interactive dashboards and reports in Power BI and Excel using Power Query, DAX, Pivot Tables, and Charts to monitor KPIs, sales performance, profitability, and regional trends. Collaborated with cross-functional teams to deliver weekly, monthly, quarterly, and annual business reports, supporting data-driven decision-making through category, subcategory, and gross margin analysis.