Case Study
Hospitality Company
Hospitality company uses Snowflake to integrate IoT and weather data to improve their overall customer experience
Case Study
Hospitality Company
Hospitality company uses Snowflake to integrate IoT and weather data to improve their overall customer experience
Background
We worked with an innovative hospitality company that has multiple locations. Each location uses several software applications and technology systems to collect data.
They wanted to leverage the data they were collecting to increase visibility into their overall business performance and better understand their customers' needs and wants.
Specifically, they wanted to analyze customer trends, such as: how many customers they served at each location, what services they booked most often, and how outside influences (i.e. weather conditions) impacted their business.
Background
We worked with an innovative hospitality company that has multiple locations. Each location uses several software applications and technology systems to collect data.
They wanted to leverage the data they were collecting to increase visibility into their overall business performance and better understand their customers' needs and wants.
Specifically, they wanted to analyze customer trends, such as: how many customers they served at each location, what services they booked most often, and how outside influences (i.e. weather conditions) impacted their business.
The Challenges
Our client had developed a basic data mart using Postgres database.
However, their existing solution was insufficient to handle the large amount of IoT data they collected. One of the other challenges was that their current solution did not integrate all their data sources (i.e., IoT and external weather data). Their key objective was to collect and integrate all of their data.
They needed to modernize their cloud data infrastructure and business intelligence strategy to do this. This is where Infostrux became involved.
The Challenges
Our client had developed a basic data mart using Postgres database. However, their existing solution was insucient at handling the large amount of IoT data they were collecting. One of the other challenges was their existing solution did not integrate all of their data sources (i.e. IoT and external weather data). Their key objective was to collect and integrate all of their data. To do this, they needed to modernize their cloud data infrastructure and business intelligence strategy. This is where Infostrux became involved.
The Results
Deploying our Infostrux DataFoundry Starter package, we worked with their IT and business teams to create common data definitions for the company. We then integrated and built a foundation on Snowake with the focus of having a secure data architecture on top of AWS. This enabled our client to pull their data from the CRM and POS systems and join it together in one place so that it easily accessible. We also provided a data model that enables them to connect Power BI to do data analysis. Lastly, we established a data roadmap and are continuing to provide ongoing support through our Infostrux Managed Services.
To enrich the data even further, we used free weather information from Snowflake Marketplace Datasources.
Enriching data with Snowflake Marketplace Datasources
Deploying our Infostrux DataFoundry Starter package, we worked with their IT and business teams to create common data definitions for the company. We then integrated and built a foundation on Snowake with the focus of having a secure data architecture on top of AWS. This enabled our client to pull their data from the CRM and POS systems and join it together in one place so that it easily accessible. We also provided a data model that enables them to connect Power BI to do data analysis. Lastly, we established a data roadmap and are continuing to provide ongoing support through our Infostrux Managed Services.
The Results
Deploying our Infostrux DataFoundry Starter package, we worked with their IT and business teams to create common data definitions for the company. We then integrated and built a foundation on Snowake with the focus of having a secure data architecture on top of AWS. This enabled our client to pull their data from the CRM and POS systems and join it together in one place so that it easily accessible. We also provided a data model that enables them to connect Power BI to do data analysis. Lastly, we established a data roadmap and are continuing to provide ongoing support through our Infostrux Managed Services.
To enrich the data even further, we used free weather information from Snowflake Marketplace Datasources.
Enriching data with Snowflake Marketplace Datasources
Deploying our Infostrux DataFoundry Starter package, we worked with their IT and business teams to create common data definitions for the company. We then integrated and built a foundation on Snowake with the focus of having a secure data architecture on top of AWS. This enabled our client to pull their data from the CRM and POS systems and join it together in one place so that it easily accessible. We also provided a data model that enables them to connect Power BI to do data analysis. Lastly, we established a data roadmap and are continuing to provide ongoing support through our Infostrux Managed Services.
Key Benefits
- Modernize their cloud data infrastructure and business intelligence strategy
- Acquire new decision-making capabilities based on KPIs
- Integrate data from IoT and external weather forecasts and analyze trends
- Create common data definitions for the company
- Integrate and build a Snowflake foundation with the focus of having a secure data architecture on top of AWS
Key Benefits
- Modernize their cloud data infrastructure and business intelligence strategy
- Acquire new decision-making capabilities based on KPIs
- Integrate data from IoT and external weather forecasts and analyze trends
- Create common data definitions for the company
- Integrate and build a Snowflake foundation with the focus of having a secure data architecture on top of AWS