The challenge
Our client, Fincas Florit, is a family-owned business dedicated to tourist apartments in Valencia. They needed to integrate their systems and have all the data together to generate reports.
They wanted to build their reports on Power BI, introduce automated data updates, and add new visualizations to support their strategic planning. They had no BI systems and no cloud services, so we had to start almost from scratch.
What we did
We delivered a tailored BI system, connecting directly to Avantio, their Property Management System (PMS), via API, to make the necessary queries.
Key data domains included:
- Apartments
- Types of clients
- Reservations
- Channels
- Offers
We extracted and structured data going back to 2021. Then, we implemented incremental refresh logic to automatically update the reports twice a day.
Some of our key technical steps in this project were
- API integration with Avantio for historical and current data
- Data stored and refreshed via OneDrive and Power BI
- Advanced modeling using M code in Power BI
- Combined historical and incremental data to avoid duplicates and maintain data quality
What we achieved
These dashboards now help the company monitor trends, adjust pricing, and improve customer engagement in real time.
We delivered a successful BI solution, thanks also to our great communication with the client, and gained valuable expertise in the tourism and hospitality sector.
The client now has the visibility and insights needed to better understand their operations and grow with confidence. Smarter data makes better decisions.
“Thanks to the zenital team, we now launch our marketing campaigns and set prices with much greater accuracy” - Ignacio Moragón, Head of Marketing at Fincas Florit
The challenge
Our client, Fincas Florit, is a family-owned business dedicated to tourist apartments in Valencia. They needed to integrate their systems and have all the data together to generate reports.
They wanted to build their reports on Power BI, introduce automated data updates, and add new visualizations to support their strategic planning. They had no BI systems and no cloud services, so we had to start almost from scratch.
What we did
We delivered a tailored BI system, connecting directly to Avantio, their Property Management System (PMS), via API, to make the necessary queries.
Key data domains included:
- Apartments
- Types of clients
- Reservations
- Channels
- Offers
We extracted and structured data going back to 2021. Then, we implemented incremental refresh logic to automatically update the reports twice a day.
Some of our key technical steps in this project were
- API integration with Avantio for historical and current data
- Data stored and refreshed via OneDrive and Power BI
- Advanced modeling using M code in Power BI
- Combined historical and incremental data to avoid duplicates and maintain data quality
How to change an entire data strategy
I imagine 8wires as that sincere and honest partner that takes you out of all that noise and helps you focus on what is important, no matter how unsexy it may be, to achieve a great long-term goal.
The one who accompanies you through the hard times and helps you through the tough decisions, knowing that there is no easy road. The one who gives you the push or the tools so that you climb and be yourself the one who reaches the summits you propose in a healthy, sustainable and energetic way. And above all, the one who steps aside when he knows that he is not helping you or that he will not be able to give you what you need.
I don't know if it is helpful, but somehow I saw on the web a visual explanation of the problem in the data/technology world (I don't know if with this metaphor) before showing how it is to work with us and finally, another visual explanation of the result.
Like a bridge over troubled waters
I imagine 8wires as that sincere and honest partner that takes you out of all that noise and helps you focus on what is important, no matter how unsexy it may be, to achieve a great long-term goal.
The one who accompanies you through the hard times and helps you through the tough decisions, knowing that there is no easy road. The one who gives you the push or the tools so that you climb and be yourself the one who reaches the summits you propose in a healthy, sustainable and energetic way.
The challenge
Our client, Fincas Florit, is a family-owned business dedicated to tourist apartments in Valencia. They needed to integrate their systems and have all the data together to generate reports.
They wanted to build their reports on Power BI, introduce automated data updates, and add new visualizations to support their strategic planning. They had no BI systems and no cloud services, so we had to start almost from scratch.
What we did
We delivered a tailored BI system, connecting directly to Avantio, their Property Management System (PMS), via API, to make the necessary queries.
Key data domains included:
- Apartments
- Types of clients
- Reservations
- Channels
- Offers
We extracted and structured data going back to 2021. Then, we implemented incremental refresh logic to automatically update the reports twice a day.
Some of our key technical steps in this project were
- API integration with Avantio for historical and current data
- Data stored and refreshed via OneDrive and Power BI
- Advanced modeling using M code in Power BI
- Combined historical and incremental data to avoid duplicates and maintain data quality
How to change an entire data strategy
I imagine 8wires as that sincere and honest partner that takes you out of all that noise and helps you focus on what is important, no matter how unsexy it may be, to achieve a great long-term goal.
The one who accompanies you through the hard times and helps you through the tough decisions, knowing that there is no easy road. The one who gives you the push or the tools so that you climb and be yourself the one who reaches the summits you propose in a healthy, sustainable and energetic way. And above all, the one who steps aside when he knows that he is not helping you or that he will not be able to give you what you need.
I don't know if it is helpful, but somehow I saw on the web a visual explanation of the problem in the data/technology world (I don't know if with this metaphor) before showing how it is to work with us and finally, another visual explanation of the result.
Like a bridge over troubled waters
I imagine 8wires as that sincere and honest partner that takes you out of all that noise and helps you focus on what is important, no matter how unsexy it may be, to achieve a great long-term goal.
The one who accompanies you through the hard times and helps you through the tough decisions, knowing that there is no easy road. The one who gives you the push or the tools so that you climb and be yourself the one who reaches the summits you propose in a healthy, sustainable and energetic way.
