Project Details

Project Details
𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐑𝐞𝐩𝐨𝐫𝐭: 𝐄𝐧𝐡𝐚𝐧𝐜𝐢𝐧𝐠 𝐒𝐭𝐚𝐤𝐞𝐡𝐨𝐥𝐝𝐞𝐫 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬

𝐎𝐛𝐣𝐞𝐜𝐭𝐢𝐯𝐞: Create a comprehensive report for sales, marketing, finance, and executive teams focusing on robust data modeling, user-friendly design, and drillable insights.

𝐊𝐞𝐲 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:

- Mastered Power Query for data manipulation.
- Developed proficiency in DAX formulas for insightful metrics.
- Implemented complex data modeling with over 10 tables.
- Selected appropriate visuals and formatting for clarity.
- Designed intuitive dashboards following best practices.
- Leveraged bookmarks for seamless navigation.
- Deployed report on Power BI Service for easy access.
- Integrated stakeholder feedback for continuous improvement.
- Incorporated metrics from sales, marketing, finance, and supply chain.

This report empowers stakeholders with actionable insights for informed decision-making.

Live Interactive Dashboard

Project Details

In this project, I made a sales report using Excel pivot tables. It helps businesses figure out good discounts for customers, negotiate better, and spot growth chances in promising countries. The reports give useful tips for improving sales strategies, making customers happier, and earning more money.

I learned:

1. How to use pivot tables.
2. Power Query tricks.
3. Basics of DAX.
4. Making data look better with conditional formatting.
5. Beautifying reports.
6. Understanding sales metrics.

Overall, the goal is to give businesses tools to watch, improve, and boost their sales. Analyzing sales data helps find new opportunities, grow, and stay competitive in the market.

Project Details

Project Overview
This Data Analysis project aims to provide insights into the sales performance of an Pizza Company. By analyzing various aspects of the sales data, we seek to identify the trends, make data-driven driven reccomendations, and gain a deep understanding of the company's performance.

Project Obejectives

MS SQL Server
1. Import Data
2. Creating a DataBase
3. Firing Queries
4. Creating Report

Power BI
1. Conecting with MS SQL Server
2. Data Cleaning
3. Data Wrangling
4. Data Visualization

Feature Engineering: Created some really useful KPI's for the analysis report mentioned below:

Total Revenue
Average Order Value
Total Pizzas Sold
Total Orders
Average Pizzas per Order

Live Interactive Dashboard

Project Details

Introducing a dynamic dashboard tailored for AtliQ Grands' revenue team, addressing challenges in market share and revenue within luxury/business hotels.
The focus is on integrating "Business and Data Intelligence" to regain competitiveness.
The objective is to develop an interactive dashboard enabling monitoring of key metrics across metro cities. Critical metrics include ADR, RevPAR, and occupancy percentage, analyzed over three months to provide actionable insights. Recommendations are provided for pricing model enhancement and cost-cutting strategies to boost revenue and market share.

Key Learning Objectives:
1. Research on Hospitality Metrics
2. Data Modeling
3. Understanding Business Context
4. Mastering Power BI Fundamentals
5. Crafting Effective Dashboards
The overarching objective is to equip businesses with tools to monitor, enhance, and elevate their sales performance. Through the analysis of sales data, businesses can identify new opportunities, foster growth.

Live Interactive Dashboard

Project Details

📈 Project Synopsis: Delved into AtliQ Hardware's sales, products, customers, and regional data to derive critical insights.
🎯 Challenges Conquered: Focused on pivotal aspects like sales reporting, market trend analysis, customer behavior patterns, and predictive supply chain forecasting.

🔄 Notable Discoveries:
➡ Amazon topped net sales with 109.03M in fiscal 2021, closely followed by AtliQ Exclusive at 79.92M.
➡ India emerged as the leading market with the highest net sales of 210.67M in fiscal 2021, with the USA trailing at 132.05M.
➡ Amazon's contribution to total net sales was a significant 13.23% in fiscal 2021.
➡ In the APAC region, Amazon outperformed others with a net sales percentage of 12.99% in 2021.
➡ India claimed the leading position in total gross sales within the APAC region.

Project Details

In the "Consumer Goods Domain" project , I worked on database of Atliq Hardwares. Facing the challenge of data-informed decisions, I answered ten ad-hoc requests to extract actionable insights.
Findings revealed a substantial increase in unique products, a dominant 'Notebook' segment, and a flourishing 'Accessories' category. Sales seasonality and the pivotal role of the 'Retailer' channel were uncovered.
Key learnings included the transformative potential of data analytics for informed decisions, the consumer goods market's dynamic nature, the value of product diversity, the significance of seasonality awareness, and the role of distribution channels in shaping sales outcomes.
The project enhanced my data analysis, problem-solving and contributing to my growth as a data analyst.