Comparing accommodation prices and quality without checking booking sites by hand, and without losing the history.
Projects / Scraping + Power BI
Hotel finder (Gran Canaria)
Automated data capture plus a Power BI dashboard to explore accommodation prices, ratings and trends.
Interactive dashboard · best viewed on a computer or tablet
A pipeline that captures the data, normalises it, stores it in a database and feeds an interactive Power BI report.
- A weekly view of price and rating trends.
- Comparisons by area, room type and dates.
- Less manual work and a traceable history.
How it works
Capture
Automated scraping (Selenium) with set parameters: dates, area and guests.
Cleaning
Normalisation with Python/Pandas and derived metrics such as price per night.
Storage
Load into a database (Azure SQL) to keep the history and query it efficiently.
Consumption
A Power BI report connected to the database for exploration and comparisons.
Technical details
- Typical frequency: weekly run.
- Data captured: name, location, room type, price, reviews and rating.
- Design goal: minimise manual work and keep a history for trend analysis.