About
Highly analytical and results-driven Data Analyst with a robust foundation in data analytics, visualization, and machine learning, eager to drive data-driven decision-making. Proficient in Python, SQL, MS-Excel, and Power BI, with hands-on experience transforming complex datasets into actionable insights. Proven ability to build interactive dashboards, perform in-depth statistical analysis, and develop predictive models, consistently delivering high-impact solutions to optimize business performance and enhance strategic initiatives.
Work
Guna, Madhya Pradesh, India
→
Summary
Designed and developed a dynamic Power BI dashboard to visualize retail sales, profit, and performance metrics across various dimensions for enhanced business understanding.
Highlights
Designed a dynamic Power BI dashboard to visualize sales, profit, and performance across cities and categories, improving data accessibility and understanding.
Established robust data-model relationships between Sales, Products, and Customers for effective cross-filtering and detailed analysis.
Developed critical DAX measures for KPIs such as Total Sales, Profit %, and Average Order Value (AOV), presented via interactive cards, lines, and bar charts for executive review.
Guna, Madhya Pradesh, India
→
Summary
Analyzed PhonePe user engagement and transaction patterns across Indian states and districts using Python and Pandas to guide strategic development.
Highlights
Analyzed extensive user engagement and transaction patterns across diverse Indian states and districts utilizing Pandas, revealing key regional insights.
Executed in-depth Exploratory Data Analysis (EDA) and visualized critical KPIs with Matplotlib and Seaborn, enhancing data interpretation.
Extracted key metrics including Average Transaction Value (ATV), app opens, and user penetration, directly informing strategic guidance.
Guna, Madhya Pradesh, India
→
Summary
Conducted comprehensive SQL-based analysis on an e-commerce dataset to identify critical customer behavior, revenue patterns, and product trends.
Highlights
Performed SQL-based analysis on a large e-commerce dataset to identify key customer behavior, revenue patterns, and product trends.
Developed complex SQL queries using JOINs, Subqueries, and CTEs to extract high-value insights, facilitating data-driven strategic planning.
Identified top-selling products, customer retention strategies, and repeat-buyer ratios, providing actionable recommendations for performance optimization.
Guna, Madhya Pradesh, India
→
Summary
Led the development of an interactive Excel dashboard to track and visualize CPI inflation across sectors, providing stakeholder-ready insights for informed decision-making.
Highlights
Developed an interactive Excel dashboard utilizing Pivot Tables, Slicers, and Conditional Formatting to track inflation across diverse sectors, improving data accessibility and insights.
Transformed raw CPI data into stakeholder-ready insights by segmenting trends by month and industry, enabling more targeted analysis and reporting.
Automated visual reporting to highlight inflation spikes and historical comparisons, enhancing decision-making efficiency and clarity.
Education
Jiwaji University, Gwalior
→
Bachelor
Arts + Education
Certificates
Data Science and Analytics
Issued By
Coding Ninjas
Skills
Data Analysis & Visualization
Data Pre-processing, Statistical Analysis, Data Wrangling, Database Design, Data Querying, Exploratory Data Analysis (EDA), KPI Tracking, Report Automation, Dashboarding, Data Modeling, Data Relationships, Data Validation, Conditional Formatting.
Programming & Databases
Python, SQL, Pandas, Numpy, Matplotlib, Seaborn, Jupyter Notebooks, File Handling, Loops, Joins, Aggregations, Subqueries, Window Functions, CTEs, Database Management.
Business Intelligence & Reporting
Power BI, MS-Excel, Pivot Tables, Charts, VLOOKUP, Index-Match, IF Statements, DAX Measures, Slicers, KPI Cards, Bar Charts, Line Charts, Map Visuals, PDF Exporting.
Machine Learning
Supervised Learning, Logistic Regression, Linear Regression, Random Forest, Unsupervised Learning, K-Means, Scikit-learn.