Ram Narayan Senapati's Work | ContraWork by Ram Narayan SenapatiRam Narayan Senapati
Data Analyst | Excel, SQL, Python & AI
SQL Retail Sales Data Cleaning & Analysis Cleaned and analyzed a synthetic retail sales dataset using Python and Pandas. Loaded and inspected CSV data, standardized text and categories, converted data types, removed duplicate records, handled missing values, recalculated revenue, and validated the cleaned dataset. Performed KPI analysis, revenue analysis by category and city, and monthly revenue trend analysis using Python and Matplotlib. Self-created portfolio project for learning and demonstration purposes. Cleaned and organized a synthetic retail dataset using Microsoft Excel. Identified and addressed duplicate records, missing values, inconsistent city and product formatting, date issues, and data-quality inconsistencies. Standardized the data, handled missing values, removed duplicates, and recalculated revenue to create an analysis-ready dataset. Self-created portfolio project for learning and demonstration purposes. Analyzed a synthetic 2025 retail sales dataset using Microsoft Excel. Performed data cleaning, validation, exploratory data analysis, KPI analysis, revenue analysis, and data visualization to identify product, category, city, and monthly sales trends. Self-created portfolio project for learning and demonstration purposes.