Project Details

Empowering Business Growth through Sales & Finance Analytics:
I spearheaded the development of a comprehensive Excel-based Sales and Finance Analytics Report for Atliq Hardwares, revolutionizing their decision-making processes. Leveraging ETL methodology, Power Query, and Power Pivot, I created a customer performance report and conducted in-depth market vs. sales target analysis.

Sales Report:
Crafted dynamic customer performance reports.
Conducted a thorough market performance vs. sales targets analysis.
Utilized ETL methodology, Power Query, and Power Pivot for robust data modeling.
Implemented DAX for calculated columns.
Enhanced negotiation strategies, identified expansion opportunities, and optimized discounts.

Finance Report:
Developed Profit and Loss (P&L) reports by Fiscal Year & Months.
Generated P&L reports by Markets for financial evaluation.
Benchmarked financial performance against industry peers.
Aligned financial planning with strategic goals.

Project Details

🌐 Managed global hardware sales for Atliq Hardwares via diverse channels (Retailers, Direct, Distributors).
📊 Executed the Business Insights 360 Project on Power BI for real-time views: Finance, Sales, Marketing, and Supply Chain.
💹 Finance: Conducted P&L analysis, monitored YoY sales changes, and highlighted key metrics.
📈 Sales: Analyzed net sales, gross margin %, and COGS by customer, emphasizing PC division dominance at 61.33%.
📣 Marketing: Assessed net profit % and gross margin % by segment, noting challenges in APAC with a net profit of -14.62%.
🔄 Supply Chain: Evaluated forecast accuracy, net error, and absolute error by customer, identifying areas for improvement.
📊 Executive: Presented yearly trends in revenue, GM%, NP%, and market share %, providing insights into segment revenue and channel performance.
🚀 Facilitated data-driven decisions by delivering comprehensive insights into financials, sales, marketing, and supply chain dynamics.

Live Interactive Dashboard

Project Details

Objective:
Conducted data analysis to enhance employee satisfaction at AtliQ Hardwares.

Insights and Recommendations:

Leave Patterns:
Notable peak in leave requests on Thursdays (90.42% of total leaves).
Address specific challenges or workload issues on Thursdays.

Remote Work Preference:
Significant preference for remote work on Fridays (12.15%).
Consider formalizing remote work policies for flexibility.

Sick Leave Distribution:
Higher sick leaves on Thursdays (1.30% of total).
Identify factors and implement preventive health measures.
Actionable Recommendations:

Conduct surveys to understand Thursday challenges.
Formalize remote work policies for employee satisfaction.
Investigate causes of increased sick leaves on Thursdays.

Conclusion:
The analysis offers valuable insights into employee presence patterns, guiding targeted strategies to improve overall satisfaction and well-being.

Live Interactive Dashboard

Project Details

Zomato Data Analysis Project Summary 📊

Overview:
Explored a simulated dataset of Zomato, analyzing user signups, transactions, and product details. Key tables include Goldusers_signup, Users, Sales, and Product.

Key Achievements:

Total Spending Analysis 💸:
Identified and calculated the total spending by each Zomato customer.

User Engagement 📈:
Determined the number of days each customer visited Zomato, assessing user engagement.

First Purchases 🛒:
Found the first product purchased by each customer and the item purchased just before becoming a premium member.

Popular Products 🥇:
Identified the most purchased item and its frequency among all customers.

Individual Preferences 🤔:
Determined the most favored item for each customer and the name of their first purchased item.

Membership Insights 🌟:
Analyzed transactions before premium membership, calculating total orders and spending.

Project Details

Finance Analytics & Reporting Project

🚀 Overview:
Implementing SQL-based Finance Analytics and Report Generation for informed decision-making. Utilizing stored procedures, user-defined functions, and optimized queries for efficiency.

🎯 Key Features:
Tailored Reports: Dynamic reports with parameters like in_fiscal_year and in_top_n.
Insightful Metrics: Extracting forecast accuracy, market badge, and monthly gross sales.

📁 Project Structure:

Reports: CSV reports on forecast accuracy, gross sales, top customers, markets, and more.
Functions: Fiscal year and quarter retrieval functions.
Views: Organized views for gross sales, net sales, and discounts.
Stored Procedures: Procedures for forecast accuracy, market badge, and more.
Queries: Utilizing Window Functions and CTEs for advanced analytics.

🔧 Usage:
Report Generation: Execute SQL files in the queries directory, customize input parameters.
Report Viewing: Access generated CSV reports in the reports directory.