Hotel energy consumption and occupancy monitoring

🌟 Excited to Share My Latest Data Analysis Project! 📊

I'm thrilled to unveil a project that combines data analysis and hospitality expertise! This interactive dashboard tracks key performance indicators (KPIs) for a hotel chain, helping them optimize energy consumption and occupancy rates.

Here's a sneak peek into what this project entails:

🔍 Tracking Vital KPIs that contain:

· Holistic Data View: Tracks total water, gas, and electricity consumption across all hotels.

· Granular Occupancy Insights: Analyzes occupancy rates by hotel, room type, and size.

· Guest Understanding: Unveils guest demographics based on nationality, providing valuable insights for targeted marketing.

· Data-Driven Decisions: Equipped management with actionable data to improve resource allocation and guest experience.

Behind the Scenes:

Data Wrangling: Preprocessed data with Power Query for seamless analysis.

📈 Data Modeling Mastery: Leveraging my expertise, I constructed a robust star schema to seamlessly connect various fact tables with essential dimensions, ensuring a clear and concise view of the data landscape.

🎨Visually Appealing UI: Using Figma, I designed visually appealing dashboards with custom themes and color palettes, aimed at enhancing user experience and engagement.

💡Enhanced User Experience: Implemented custom tooltips for clear visualizations and hover-over effects for detailed information.

Drill-Down Functionality: Enabled users to explore data further through interactive drill-down features.

What are your thoughts on leveraging data for smarter hotel management? Let's discuss in the comments! ⬇️