SURBHI YADAV

Data Analyst | Business Intelligence Specialist

Khargone, IN.

About

Results-driven and highly analytical professional with hands-on experience in leveraging SQL, Excel, Power BI, and Python to transform complex data into actionable insights. Proven expertise in data cleaning, dashboard development, reporting automation, and workflow optimization. Adept at supporting strategic business decision-making across diverse data and operations teams through compelling data visualization and analysis.

Work

RealtyEase AI

|

Intern - Data & Operations Analyst

→

Summary

Supported data analysis and operational improvements for a remote-first organization, focusing on enhancing efficiency and data-driven decision-making.

Highlights

Designed and implemented Payroll Analytics dashboards in Excel/Google Sheets for 15+ employees, enhancing payment cycle visibility and monthly reporting accuracy.

Streamlined data collection and cleaning of daily logs (SOD/EOD) from 15+ team members to enable efficient task tracking and analysis.

Developed and documented 5+ Standard Operating Procedures (SOPs), boosting process clarity and reducing new hire onboarding time by 25%.

Conducted comprehensive research on 30+ virtual assistants and property managers, compiling data into structured reports to inform strategic decision-making.

Collaborated with operations and client teams to optimize data collection methodologies.

Certificates

PwC Power BI Job Simulation Certificate

Forage

HackerRank SQL Gold Badge

HackerRank

Skills

Data Analytics & Databases

SQL, MySQL, PostgreSQL, Data Cleaning, ETL, Data Modeling, Query Optimization.

Business Intelligence & Visualization

Power BI, DAX, Power Query, MS-Excel, PivotTables, Charts, Data Storytelling.

Programming & Data Processing

Python, Pandas, NumPy, Matplotlib, Seaborn, Web Scraping, BeautifulSoup, API Requests.

Other Tools & Platforms

GitHub, MS Office, Power BI Service, Bitrix24(CRM).

Projects

Spotify Analysis

→

Summary

Analyzed Spotify listening data using SQL to identify music trends and improve user recommendations.

YouTube Analysis

→

Summary

Performed an in-depth analysis of YouTube video performance and audience engagement using Python.

Walmart Sales Analysis

→

Summary

Conducted a comprehensive analysis of Walmart sales data using Python and SQL to identify trends and inform operational strategies.

Online Courses Analysis

→

Summary

Built a Power BI dashboard to analyze online course data, identify trends, and enhance learner engagement.

Chocolate Sales Analysis

→

Summary

Analyzed chocolate sales data using Power BI to uncover key insights and support data-driven decision-making.