Snowflake Data Warehouse and BI
for Cloud Provider
A significant issue in operating a colocation and cloud services business is keeping client assets in sync with billing, CRM, asset management, facilities management, and managed services platforms. Doing it across multiple business entities, each with their own toolsets, is really hard without a data integration platform.
ConvX solved the challenge with a cloud data warehouse to bring all their data sources together. We also did the physical inventory of data center rooms for a 100% accurate view of their deployed assets. ConvX built the analytics reports each team needed to do their job. And we automated ETL processes to refresh the data warehouse at any time.
We provided a single point of ownership for the entire project and all technologies – physical inventory, data warehouse, analytics, and automation.
With our help, the data center operator gained new insights into operational gaps that were impossible to see before we integrated their data.
- Cost savings by identifying unused licenses and equipment
- Additional revenue by showing gaps in billing
- Risks mitigated by finding incomplete work orders