Project Details

This Excel project aims to provide comprehensive insights into the company's financial performance and market positioning through the creation of various reports like "Customers Net Sales Performance", "Market Performance vs. Target", etc. These reports are designed using both basic & advanced Excel functionalities to ensure accurate data analysis.

📊 Excel Mastery: ~Learned Excel from its foundations to an advanced level. ~Mastered various functions like VLOOKUP, XLOOKUP, INDEXMATCH, and more. ~Became proficient in using Tables to manage and analyze data effectively. ~Created visually appealing Charts to represent data insights.

🧹 Data Cleaning and Analysis: ~Acquired skills to clean and transform messy data. ~Explored techniques to handle bad data and ensure accuracy. ~Calculated essential business metrics such as P&L, Mean, Mode, Median, Variance, and Standard Deviation.

🔌 Power Query Proficiency: ~Gained expertise in using Power Query for data transformation

Live Interactive Dashboard

Project Details

AtliQ Grands operates a chain of five-star hotels located throughout India and has a 20-year history in the hospitality industry. However, they are currently experiencing a decline in both market share and revenue within the luxury and business hotel sector due to competition from rivals and ineffective management decisions. To address this situation, the managing director of AtliQ Grands is pursuing a strategic plan to incorporate "Business and Data Intelligence" into their operations with the goal of regaining market share and increasing revenue.

TASKS PERFORMED

Develop metrics as per the provided metric list.
Construct a dashboard based on the mock-up provided by stakeholders.
Generate insightful information that goes beyond what is outlined in the metric list and the mock-up dashboard.

SKILLS APPLIED

1. Power BI
2. SQL
3. Excel
4. DAX Studio

Live Interactive Dashboard

Project Details

🎯 Objective: Crafting impactful reports to unveil performance insights at AtliQ Hardware.

🛠️ Execution: Loaded data into MySQL Workbench, generated insightful reports, and exported them to CSV files. Formatted and visualized data using CSV files when necessary.

📚 Core Competencies:

✅ Data Retrieval: Implemented SELECT, WHERE, DISTINCT, LIKE, BETWEEN
✅ Sorting & Filtering: Utilized ORDER BY, LIMIT, OFFSET
✅ Aggregation Mastery: Applied SUM, MIN, MAX, AVG, GROUP BY, HAVING
✅ Advanced Query Tactics: Executed Joins, Subqueries, Correlated Subqueries
✅ Sophisticated Analytics Techniques: Utilized CASE, YEAR, CURYEAR, IF, CTEs, User Defined Functions, Window Functions
✅ Database Administration: Implemented DDL, DML, Data Types, Views.

🚀 In-depth Analysis & Outcomes: Developed reports covering Finance (sales overview, Market Badge), Sales (top markets/products/customers), Net Sales (global market share). These reports provide stakeholders with actionable insights.