Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Project Details

Objective: To create Excel reports on Customer Performance, Various Market Performances, Market Performance vs Target, Product Performance, P&L statement by Fiscal year, quarter and months.

Key Learning Outcomes:

Connection between MySQL and Excel
Exploratory data analysis using MySQL
Creating connections between tables using Data Modelling
Applying Business maths and Statistics like Mean, median, mode, variance and standard deviation
Utilization of Power Query for data transformation
Creating business reports using Pivot tables and Power Pivot
Making use of VBAs and Macros
Gaining functional knowledge on Sales and Finance such as Performance Analysis and P&L statements

Project Details

Project Details
This project, which combines Power BI, SQL, and Excel, centers around addressing operational issues at AtliQ Hardware, a prominent global consumer electronics company. The company's heavy reliance on Excel for data analysis has led to significant losses in some regions. To rectify this, senior management aims to initiate a data analytics project, leveraging data from the previous year to enhance performance and drive improvements.
💼Finance View: shows profit and loss statement like GM,NP,NS etc. and performance over time chart w.r.t to key metrices.
📣Sales View: Shows customers and product performance , unit economics and performance matrix by NS and GM%
📣 Marketing View: Shows region and product performance , unit economics and performance matrix by NS and GM%
🚚 Supply Chain View: shows forecast accuracy, Net Error, trends and key metrices by customers and product.
👨‍🎓 Executive View: shows market share of competitors, trends,revenue by division and channel, top

Live Interactive Dashboard

Project Details

AtliQ Grands encountered tough competition and a decline in revenue. They sought to utilize data and strategic insights but lacked internal expertise. My aim is to conduct a comprehensive analysis using Python to empower AtliQ Grands with insights for customer retention and revenue growth.

Project Details

This dashboard serves as a powerful tool for HR teams looking to leverage data to optimize their workforce management practices. By transforming raw data into meaningful visualizations, it enables organizations to make strategic decisions that foster a productive and engaged workforce.