Welcome to the Business Intelligence Developer challenge! We're thrilled to assess your skills in various aspects of Business Intelligence development. Please carefully review the guidelines before you begin.

• 🔍 M-Query: Understand and demonstrate proficiency in M-Query for effective data transformation.
• 🔧 Query Engineering: Showcase your ability to engineer queries to optimize data retrieval and processing.

• 🔄 Model Multiple Relative Data Sources: Demonstrate your skills in modelling by integrating and managing data from multiple sources.

• 📊 DAX (Data Analysis Expressions) / Or Any Other Measurement Builders:
  • Create Calculated Tables, Columns, and Measures to extract meaningful insights from the data.

• 🎨 Layouting: Design visually appealing and user-friendly dashboards.
• ✨ Aesthetics and CSS Animation: Enhance the user experience through thoughtful aesthetics and CSS animations.

• 🚀 Navigation and Perspective Bookmarks: Implement effective navigation and use perspective bookmarks.
• 🗺️ Page Navigation: Showcase your skills in creating seamless transitions between pages.
• 🔍 Drill Through Filters: Demonstrate the use of drill-through filters for in-depth analysis.

• 🔐 Row Level Permissions: Implement and showcase your understanding of row-level permissions to ensure data security.

1. Choose any Business Intelligence (BI) tool of your preference (preferably Power BI).
2. Complete each section according to the specified requirements using your chosen BI tool and the selected open data type.
3. document your thought process and any assumptions made.
4. Once completed, submit the repo/the BI file link via the contact email at the end.

Your submission will be evaluated based on the following weighted criteria:

• Accuracy and effectiveness of data transformation and modelling: 20%
• Proficiency in BI expressions for data analysis: 20%
• Creativity and attention to detail in UI/UX design: 20%

• Implementation of navigation and interaction features: 10%
• Robust implementation of data-level security: 10%
• Implementation of sub-topics within each main axis: 10%

Have you ever wondered when the best time of year to book a hotel room is? Or the optimal length of stay to get the best daily rate? What if you wanted to predict whether or not a hotel was likely to receive a disproportionately high number of special requests?

Use this dataset to answer any question or conduct any analysis that best showcases your abilities and expertise in BI.

This data set contains booking information for a city hotel and a resort hotel and includes information such as when the booking was made, length of stay, the number of adults, children, and/or babies, and the number of available parking spaces, among other things.

All personally identifying information has been removed from the data.

You can download the data through this link: hotel_bookings.csv

Please submit your Business Intelligence project repository or solution to the email address from which you received the challenge.