Data Analyst
Czech Inn Hotels · hotel group, Prague
Power BI and Excel reporting for the sales team: occupancy, cancellations and revenue across the group’s hotels.
- 01
Power BI dashboards
Built and extended the dashboards: connected data sources, created new and reworked existing visuals for occupancy analysis — bookings, cancellations, month-over-month and property-by-property comparison of key metrics.
- 02
Excel reporting
Collected the data, built pivot tables and charts, validated the numbers and tracked down errors before reports went out.
- 03
Revenue monitoring
Designed Power BI visuals comparing room rates and total revenue across periods, with indicators that flag anomalies and sharp changes for the senior analyst.