Xero is the emerging global leader of online accounting software that connects small businesses to their advisors and other services. The cloud-based software is used in more than 180 countries by more than one million subscribers. As a data-driven organization from the top down, Xero employees constantly talk about data and how to leverage it. To support the data needs of the rapidly growing company, a small business intelligence (BI) team was tasked to create a new data warehouse.
The software company chose Microsoft SQL Server for its data warehouse platform and WhereScape® RED to automate the development, deployment and operation of the new data warehouse. After rapid success deploying the new data infrastructure, the team turned its attention to the cloud. WhereScape RED is now automating the migration from SQL Server to Amazon Redshift, giving Xero a quick and easy path to creating a data warehouse in the cloud.
- Rapidly developed and deployed new data warehouse on SQL Server
- Generates consistent models so that anyone on the BI team can pick up the code and continue working
- Helped “upskill” new BI team members quickly as the team grew from 2 to 20
- Enables migration from SQL Server to Amazon Redshift seamlessly and quickly, data sources reconfigured in three weeks or less