Data Analysis and Visualization using SQL, Tableau, Power BI, Ms Excel, D3, Javascript and Vega-Altair

Sprocket Central Pty Ltd, a medium size bikes & cycling accessories company, is looking to boost business by analysing their provided customer dataset to recommend which of these 1000 new customers should be targeted to drive the higher value for the company

A collection of projects showcasing my learning in Excel

The tasks involve data exploration, data modeling, and building visualizations to deliver data-driven insights and solutions using tools like Powerpoint Presentation and Excel.

📊 An Excel-based healthcare data analysis project exploring medication usage patterns, patient transitions between drugs, dosage trends, and breakeven cost modeling. Includes insights using advanced Excel formulas, pivot tables, and logic functions.

Dynamic coffee sales analysis using MS Excel, XLOOKUP, VLOOKUPS, Pivoting, pivot table visualizations and data analytical principles.

This project analyzes road accident data using MS Excel to identify trends, patterns, and contributing factors to accidents. Through data visualization techniques and statistical analysis, it provides insights that can inform safety measures and policy decisions, aiming to enhance road safety and reduce accident rates.

Performed E-commerce Sales Analysis to identify trends, optimize sales, and improve decision-making. Analyzed customer patterns, seasonal trends, and product performance using Python, SQL, and Power BI. Delivered actionable insights to enhance revenue, streamline inventory management, and boost customer engagement.

Auditing Invoice Data Python Project