Dive into a dynamic world where data meets hospitality. This project harnesses the power of Power BI to deliver deep, actionable insights through comprehensive data analysis and visually stunning dashboards. From the initial stages of data extraction to the final, polished dashboards, we cover every aspect of the ETL (Extract, Transform, Load) process to help stakeholders make informed and strategic decisions.
- DATA IMPORT: First I Gathered data from UNIFIED mENTORS and imported it into Power BI for data transformation.
- DATA TRANSFORMATION: Used Power Query to clean the data, removed nulls and duplicates, and fine-tuned data types.
- DATA LOADING AND MODELLING: Imported the transformed data into Power View for analysis. After completing the necessary cleaning, and transformation, I create the necessary relationships between the tables.
- DATA IMPLEMENTATION: I used different DAX functions to create calculated measures and columns, refining the data for deeper insights.
- REPORTS CREATION: First I designed a theme for my report from canva and then imported it to Power BI. After that, I Crafted a user-friendly report/dashboard that helps the organization make important decisions.
- Revenue: Shows the total revenue generated and realized (1709M).
- Total Booking: Displays the total number of bookings (135K).
- Average Rating: Gauge indicating the average rating of the properties (3.62 out of 5).
- Capacity: Total capacity across all properties (233K).
- Successful Booking: Shows the number of successful bookings (94K).
- Occupancy Percentage: Indicates the proportion of available rooms that are being occupied over a specific period (57.87%)
- Total Cancelled Bookings: Indicates the number of cancelled bookings (33K).
- Month: Allows selection of data for specific months.
- City: Filters data based on the city (Bangalore, Delhi, Hyderabad, Mumbai).
- Property: Filters data by property (Atliq Bay, Atliq Blu, Atliq City, Atliq Exotica, Atliq Grands, Atliq Palace).
- Platform: Filters data based on the booking platform (direct offline, direct online, journey, logtrip, makeyourtrip, others, tripster).
- Revenue by Booking Status: Bar chart showing the sum of revenue generated and realized for checked-out, cancelled, and no-show bookings.
- Booking by Days: Pie chart illustrating the proportion of bookings made on weekdays (70.65%) versus weekends (29.35%).
- Revenue by Room Type: Bar chart displaying revenue generated by different room types (Elite: 50K, Standard: 38K, Premium: 31K, Presidential: 16K).
I welcome contributions to improve this dashboard. If you have suggestions or improvements, please create an issue or submit a pull request.
For any questions or support, please contact me at [rupal95@outlook.com].