Hello, I am

Sangeeta Yadav.

1

Excel Project

3

PowerBI Projects

About Me

👋 Hi, I’m Sangeeta – A Data-Driven Problem Solver with extensive expertise in Data Analytics, Reporting, and Visualization! I specialize in transforming complex data into actionable insights that drive strategic decisions. 🚀

✨ I specialize in transforming complex datasets into actionable insights that drive smarter decisions. Proficient in Power BI 📊,Tableau 📈Excel 🟢, SQL 🛠️ and Python 🐍, I have hands-on expertise in data cleaning, analysis, and visualization to uncover trends and support strategic goals.

📊 Core Competencies:

Visualization & Dashboards: Create impactful reports using Power BI 📊 and Tableau 📈.
Data Management: Skilled in cleaning, validation, and modeling 🛠️ for accurate insights.
Advanced Analytics: Identify trends and opportunities through statistical modeling 📉.
Business Intelligence: Translate data insights into actionable strategies 💡.

💻 Tools Expertise: Excel 🟢 | SQL 🛠️ | Power BI 📊 | Python 🐍 | Tableau 📈

Key Skills

Data Analysis Tools

Database Management

Statistical Analysis

Data Cleaning and Preprocessing

Data Visualization

Power BI

MySQL

Advance Excel

Python

My Projects

My Experience

Finance Data Analyst (SWO )
Bank of Baroda

In my role as a Financial Data Analyst in the Retail Banking sector, I leveraged advanced tools like Excel and Power BI to analyze large datasets, ensuring accuracy and delivering actionable insights. Key contributions include:

Data Management and Organization: Consolidated and cleaned extensive datasets from multiple banking systems using Power Query, pivot tables, and advanced filtering techniques, ensuring data reliability.
Dynamic Reporting and Dashboards: Designed interactive dashboards and automated Excel reports to track KPIs, such as customer retention, product performance, and revenue growth, supporting strategic decision-making.
Customer Segmentation and Analysis: Conducted customer profiling and segmentation using advanced Excel functions (VLOOKUP, INDEX-MATCH, SUMIFS) to support targeted marketing strategies and boost customer engagement.
Risk Assessment and Trend Analysis: Performed detailed risk analyses, identified fraud patterns, and highlighted trends using techniques like conditional formatting, data validation, and statistical methods.
Process Optimization and Automation: Automated repetitive reporting tasks and optimized workflows with Excel macros and VBA scripting, reducing turnaround times and enhancing process efficiency.