Project Details

• Target Alignment: Ensured alignment with strategic objectives by closely scrutinizing market performance against predefined targets.

• In-Depth Insights: Generated comprehensive insights illuminating critical aspects of sales operations.

•Metric Development: I designed and implemented essential financial metrics such as Net Sales, COGS, Gross Margin and Gross Margin % for the purpose of
creating a P&L statement.

• Decision-Making: These metrics are responsible for generating valuable insights to perform data-driven decision-making .

• Tools Used: Employed MS Excel, utilizing tools like Pivot Tables, Power Pivot, and Conditional Formatting.

Project Details

•Customized Dashboard: Developed a multi-functional Power BI dashboard to specifically meet AtliQ Hardware's needs, allowing them to gain insights into their various departments.

•Data Integration: Data was sourced from disparate locations, including Excel/CSV files and a MySQL database, and seamlessly integrated into Power BI for comprehensive analysis.

•Data Model and Visualizations: A robust data model was developed within Power BI, enabling the creation of visually appealing and interactive visualizations to represent key performance indicators (KPIs).

•Performance Optimization: The dashboard's performance was significantly improved using DAX Studio, resulting in a 5% increase in report efficiency.

•Data-Driven Decisions: AtliQ Hardware can now analyze trends across different departments, empowering them to make data-driven decisions.

Live Interactive Dashboard

Project Details

In the Sales Performance Enhancement project, our mission was to empower decision-makers with actionable insights. Focused on boosting sales, key priorities included:

1. Executing In-Depth Data Queries
2. Informing Decision-Making Strategies
3. Enhancing Overall Sales Performance

Throughout this project, I developed the following skills:

1. Proficiency in SQL data querying, covering diverse business questions.
2. Mastery of data interpretation and strategic decision support.
3. Selection of effective visualizations for clear data representation.
4. Successful implementation of SQL solutions in a business context.
5. Comprehensive analysis of key sales metrics for informed decision-making

Project Details

AtliQ Grands, a fictional legacy hospitality powerhouse with a presence in four cities, embarked on a profound data-driven exploration to conquer challenges impacting their market share and revenues and chart a course for strategic business expansion.
𝗧𝗵𝗲 𝗽𝗿𝗼𝗷𝗲𝗰𝘁 𝘂𝗻𝗳𝗼𝗹𝗱𝘀 𝗶𝗻 𝘁𝗵𝗿𝗲𝗲 𝘀𝘁𝗮𝗴𝗲𝘀:

Data Cleaning:
- Cleaned the invalid guests
- Eliminated outliers.
- Addressed NaN/Null values.

Data Transformation:
Converting raw data into actionable intelligence:
-Created new columns as per the required need.
nsights:
1. Mumbai is the top in revenue realization.
2. Total revenue per month peaks in May 22.
3. Delhi has highest occupancy but the least realized revenue.
4. Top 3 hotel types by revenue realized are - Atliq Exotica, Atliq Palace ,Atliq City
5. Only 10% bookings are coming from direct online but majority i.e. 41% are coming from mixed platforms (i.e. others), 20% are from makeyourtrip and 11% from logtrip

Project Details

The objective of this pilot project is to conduct a thorough examination of customer growth and revenue patterns at Shield Insurance Company.

⚒️Tools Used :
✅Ms-Excel
✅Power-BI

🎯 Key Focus Area:
✍ Tracking customer and revenue
✍ Daily revenue and customer growth rate
✍ Sales mode Analysis
✍ Trends in customer and revenue growth
✍ Age group analysis

🌟 Lessons learned from the dashboard

✨Premium: The amount of money paid by the policyholder to the insurance company for coverage.

✨Policy: The contract between the insured and the insurer that outlines the terms and conditions of the insurance coverage.

✨Coverage: The protection provided by the insurance policy against specific risks or events.

✨Claim: A formal request made by the insured to the insurance company to seek compensation for covered losses or damages.

Live Interactive Dashboard