Project Details

📈 Task: Creating Easy-to-Understand Reports on Sales, Market Analysis, Yearly & Monthly Profits, and Expenses.

🛠️ Approach: Using Tools Like Pivot Tables for Insightful Reports, Power Query to Organize Data, and Power Pivot for Strong Data Models.

📚 Key Learning Points:

✅ Understanding How Things Work

✅ Making Data Look Good

✅ Organizing Data Nicely

✅ Using Special Formulas

✅ Making Fancy Tables

✅ Tweaking Things Perfectly

✅ Making Reports That People Love

🚀 Achievements & Results: We've made awesome reports that helped people understand the numbers better. Our work led to more than three times higher sales and a 36.4% increase in profit margins.

Project Details

Project Description*Project Walkthrough:
📝Planning: Defined the scope, targeting Finance,Sales,Marketing,Supply Chain
📊 Data Collection: SQL for extraction. Ensured accuracy and data completeness.
🔄 Data Loading: Integrated data into Power BI via MYSQL.
✅ Data Validation: Checked Power BI data against benchmarks.
🛠 Data Transformation:Power Query for data shaping; added columns, merged tables.
🧪 UAT: Collaborated with stakeholders for dashboard accuracy
🔄 Feedback: Implemented end-user suggestions.
⚙️ Optimization: DAX Studio for enhanced performance.
🚀 Deployment: Used Power Bi Desktop Service and Gateways for live connection.

Learnings:
- Power Query & DAX
- Data modeling with snowflake schema
- Creating & formatting visuals.
- Dashboard design principles.
- Using bookmarks.
- Deployment in Power BI service.
- Stakeholder feedback implementation.
- Metrics creation for different departments.

Live Interactive Dashboard

Project Details

1. **RevPAR (Revenue Per Available Room):** RevPAR measures the revenue generated per available room, regardless of occupancy. It assists hotels in assessing their revenue-generating performance and setting accurate room prices.

2. **ADR (Average Daily Rate):** ADR is the ratio of revenue to the total rooms booked or sold, indicating the average payment for rooms sold during a given timeframe.

3. **DBRN (Daily Booked Room Nights):** DBRN reveals the average number of rooms booked per day within a specified time period.

4. **DSRN (Daily Sellable Room Nights):** DSRN indicates the average number of rooms ready for sale per day within a given timeframe.

5. **DURN (Daily Utilized Room Nights):** DURN measures the average number of rooms successfully utilized by customers per day within a specified time period.

Live Interactive Dashboard

Project Details

📊 **Project Highlight: HR Analytics Dashboard for Employee Attrition**

I am excited to share my latest project where I developed a comprehensive HR Analytics Dashboard using Power BI. Leveraging my skills in data analysis and visualization, I created an intuitive interface to analyze employee attrition rates within our organization.

**Project Overview:**
- **Data Loading:** I integrated data from Excel files, ensuring seamless export-import processes.
- **Data Validation:** Rigorous validation against benchmarks to ensure accuracy and reliability.
- **Data Transformation:** Utilized Power Query for in-depth data shaping, including adding columns and merging tables for a comprehensive view.
- **Feedback Integration:** Actively incorporated end-user suggestions for an improved user experience.
- **Optimization:** Implemented advanced techniques using DAX Studio to enhance the dashboard's performance

Live Interactive Dashboard