Desarrollo de un dashboard para presentar información de venta y alquiler de terrenos en Quito

Abstract

To address the problem of data fragmentation between platforms such as Mercado Libre, Plusvalía and Properati, this project developed a dashboard that centralizes and presents statistical information on land sales and rentals in Quito, helping to eliminate difficulties in accessing unified information and providing benefits to sellers, buyers and owners interested in the local market. Using web scraping techniques, the collection of key data such as prices, location and dimensions of the land was automated, ensuring the accuracy and updating of the information, which was stored in a SQL Server database. A rigorous cleaning and structuring process was carried out, integrating the information with .NET technology and visualizing it through Power BI; this allowed the dashboard to offer graphics and filters that facilitate the analysis of the land. This project facilitates the comparison between properties by unifying fragmented data, which also contributes to the optimization of informed decision-making for the purchase, sale or leasing of land and validates the use of modern technologies such as web scraping, while highlighting the potential of technological tools such as .NET and Power BI for data management and analysis. Ultimately, this tool not only supports the resolution of the current need of the land market, but also promotes the development of innovative solutions for the analysis of the local market, contributing to a better understanding of its dynamics and trends.