r
ruchirawat1825

Ruchi Rawat

@ruchirawat1825

I will do excel data cleaning and formatting, excel data analysis

Indien
Englisch, Hindi
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
I am a Data Analyst with a strong focus on Excel-based solutions, helping clients transform raw data into clean, structured, and actionable insights. With a solid understanding of data handling and reporting, I ensure accuracy, consistency, and efficiency in every project. What I Offer: Data Cleaning (removing duplicates, fixing errors, handling missing values) Data Formatting (structured layouts, proper alignment, standardized formats) Data Reporting (creating dashboards, summaries, and insightful reports) Excel Functions & Formulas (VLOOKUP, HLOOKUP, Pivot Tables, IF, etc.)... Mehr lesen

Kompetenzen

r
ruchirawat1825
Ruchi Rawat
offline • 
Durchschnittliche Antwortzeit: 6 Stunden

Meine Dienstleistungen

Datenbereinigung
I will clean ,format, merge and split excel data
Ab15 $ / ProjektWeitere Details

Arbeitserfahrung

Accenture

Data Analyst

Accenture • Teilzeit

Apr 2024 - Mar 2026 • 1 yr 11 mos

I analyzed large-scale fintech datasets using Python, Excel, and SQL to extract meaningful insights from complex and unstructured raw data. The process involved data cleaning, transformation, and normalization—handling missing values, removing duplicates, and restructuring inconsistent formats to ensure data accuracy and reliability. Using SQL, I performed advanced querying, joins, aggregations, and filtering to efficiently manage and retrieve relevant data from relational databases. With Python (primarily using libraries like Pandas and NumPy), I automated data preprocessing, conducted exploratory data analysis (EDA), and generated statistical summaries to uncover trends and patterns. In Excel, I leveraged advanced features such as Power Query, Pivot Tables, and dynamic formulas to further refine the dataset and prepare it for visualization. Finally, I transformed the cleaned and structured data into an interactive dashboard, enabling real-time insights through charts, KPIs, and filters. The dashboard provides a clear view of financial performance, transaction trends, customer behavior, and key business metrics, supporting data-driven decision-making.