Skip to content

Latest commit

 

History

History
53 lines (31 loc) · 2.89 KB

Visualizations and Charts.md

File metadata and controls

53 lines (31 loc) · 2.89 KB

Visualizations and Charts in Power BI:

  1. Cards:

Cards Visualization

The cards visualization includes the following key metrics:

  • Total Revenue: Displays the overall revenue generated by the hotels.
  • Average ADR (Average Daily Rate): Represents the average cost per room per day.
  • Total Nights: This shows the total number of nights guests have stayed in the hotels.
  • Average Discounts: Indicates the average discounts offered to different market segments.
  • Car Spaces: Highlights the number of parking spaces utilized by guests with personal cars.
  1. Sparkline Line Chart:

Sparkline Line Chart Visualization

The sparkline line chart is a customized line chart designed as sparklines, placed below each card. It utilizes the same measures used in the cards as fields and values. This visualization provides a quick visual trend of revenue, ADR, nights, discounts, and car spaces over time.

  1. Slicers for Filtering:

Slicers for Filtering Visualization

The slicers for filtering enable users to interactively filter the data. They include the following:

  • Hotel Slicer: Allows stakeholders to filter data by different hotels in the group.
  • Country Slicer: Enables filtering data by the country of the hotels.
  • Date Slicer: Helps in filtering data specifically for a particular year.
  1. Line Chart:

Line Chart Visualization

The line chart visualizes trends in revenue by segmenting the data by year and hotel type. This allows stakeholders to observe revenue growth or decline over the years for each hotel type.

  1. Matrix Table:

Matrix Table Visualization

The matrix table provides insights into the required car parking spaces, grouped by hotel type and year. It enables a quick comparison of parking space demand between different hotel types over time.

  1. Donut Chart:

Donut Chart Visualization

The donut chart compares the revenue generated by the two hotel types. It offers an easy-to-understand visual representation of the revenue share between the hotel types.

Report Interactivity GIF

Imgur

The GIF showcases the interactivity of the visualizations, allowing users to explore and analyze the data in a dynamic and engaging way.

These visualizations and charts have been carefully designed to provide a comprehensive overview of the hotel revenue analysis. The combination of cards, sparklines, line charts, matrix tables, and donut charts allows stakeholders to quickly grasp key insights, and trends, and make data-driven decisions to optimize revenue and improve services. The interactive slicers further enhance the user experience by enabling dynamic filtering of data to focus on specific segments and time periods.