Diwali Sales Analysis(EDA)

Performed data cleaning and manipulation Performed exploratory data analysis(EDA) using pandas, matplotlib and seaborn libraries Improved customers experience by identifying most selling product categories and products, which can help to plan inventory and hence meet the demands.

Empoyes Dashboard (PowerBI)

This was my freelancing project, for a company where i built a dashboard to montior each activities and licences and shown in as a reports to reporting manager's. used data modelling and DAX Queries, to build that Report, Visual Charts and Bars to visulaize the Data. and was Shared.

Ecommerce Sales Dashboard

Created interactive dashboard to track and analyze online sales data Used complex parameters to drill down in worksheet and customization using filters and slicers Created connections, join new tables, calculations to manipulate data and enable user driven parameters for visualizations, DAX queires.

SuperStore_Sales Dashboard

This Super Store Sales Dashboard provides a comprehensive, interactive view of sales performance. Key elements include regional filtering, essential KPIs like Sales, Quantity, Profit, and Average Delivery. It effectively visualizes sales distribution by payment mode, state, and customer segment.

Catalogue Automation

Automate Catalogue Products - Upload/ Delete / Remove / Approve It breaks down the manual flow hence saving more time and energy. it takes input in excel file and automates the task.

Bulk Update Macro

It updates the catalogue status automatically and update upto 5000+ sku's and even more in a excel file and save it to desire location

Allocation Leads- Macro

Its Allocates Lead to the Desired Agent combining the onboarding report and the main allocation report.

Bulk Email Macro

It allows to send bulk mail to different users with an attachment, we can edit subject, body, attachments and combine multiple email's to the send or assign in cc.