Challenge
Horizons operates in a dynamic environment, relying on many tools and platforms such as Jira, Power BI, HubSpot, Xero, and more. With data dispersed across these diverse sources, the company faced the challenge of aggregating and consolidating data for accurate reporting and data visualization to drive business insights. Initially, they started building ad-hoc reports for different departments; however, the forefront of their efforts was getting automated reports within Power BI. Recognizing the need for a seamless and time-saving solution to orchestrate different data sources, Horizons began its search for the ideal data integration tool.
With the company's fast-paced growth, the need for on-demand data and reporting became pressing. We chose to leverage Power BI to provide access to insights throughout the company. I built the first set of reports for business stakeholders leveraging our platform data. With the success of this deployment, stakeholders started to ask for reporting on data from other tools we use internally. It became clear that we needed a solution to integrate with each tool and automate data capture and ingestion into Power BI.