Sisense Case Studies Short Term Housing Provider Optimizes Inventory and Maximizes Profit

Edit This Case Study Record

	Short Term Housing Provider Optimizes Inventory and Maximizes Profit Sisense

Short Term Housing Provider Optimizes Inventory and Maximizes Profit

Sisense

Technology Category	Analytics & Modeling - Predictive Analytics Analytics & Modeling - Real Time Analytics Application Infrastructure & Middleware - Data Visualization
Applicable Functions	Business Operation
Use Cases	Real-Time Location System (RTLS)
Services	System Integration Data Science Services
Challenge	With over five-billion records to analyze (and growing), Gianmaria's IT group had reached the limits of manual Excel reporting, realizing that Excel was not a scalable solution for its growing data size and scope. Analyzing Kamernet’s website data was fast becoming a burden on an already taxed IT department. Nearly twice a week, IT staff had to manually extract data from an SQL database, analyze the data, and transform the data in Excel reports. However, Excel reporting once again, proved limited. Employees were not able to arrive at quick, intuitive insights, and were having trouble visualizing their data, primarily reporting on revenue, website subscription data, and market-share information. Read More
About Customer	Kamernet is a popular Dutch student housing site that has been in operation for 15 years. The company offers over 100,000 rooms annually and deals with a vast amount of data, including SQL databases, Excel reports, and Google Analytics reports. These reports cover various aspects such as housing reports, website activity, revenue information, user analysis, website subscriber data, and property information. The company faced challenges with manual, Excel-based reporting, which created an IT bottleneck and made it difficult for employees to intuitively understand their reports. To address these issues, Kamernet sought a new BI reporting tool to improve data analysis and empower employees to create their own reports. Read More
Solution	After evaluating the BI landscape, Gianmaria felt confident in choosing Sisense. He was especially impressed with the Sisense test drive, which successfully connected to their actual data in the Elasticube (rather than demo data), and the ability for Sisense staff to answer all questions about his data with helpful, knowledgeable responses. Kamernet’s front-end developer was especially impressed with the capabilities of the Sisense Elasticube, quickly recognizing its immense value. Gianmaria also appreciates the ability to create custom SQL and automate the Elasticube to sync data at any time, without affecting load to the database. The effect on reporting has been significant. No longer reliant on IT for producing and understanding business reports, employees are empowered to build, create, and analyze their own dashboards. Rather than employees trying to combine graphs or make sense of overly complicated Excel reports, they are able to produce business insights at a glance, with crucial information on financial analysis, especially weekly and yearly revenue figures. Sisense charts include 20 week comparisons for the current and previous year, so employees can effectively evaluate performance measured against the preceding year, and can set benchmarks for future marketing efforts. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Predictive Analytics

Analytics & Modeling - Real Time Analytics

Application Infrastructure & Middleware - Data Visualization

Applicable Functions

Business Operation

Use Cases

Real-Time Location System (RTLS)

Services

System Integration

Data Science Services

Challenge

With over five-billion records to analyze (and growing), Gianmaria's IT group had reached the limits of manual Excel reporting, realizing that Excel was not a scalable solution for its growing data size and scope. Analyzing Kamernet’s website data was fast becoming a burden on an already taxed IT department. Nearly twice a week, IT staff had to manually extract data from an SQL database, analyze the data, and transform the data in Excel reports. However, Excel reporting once again, proved limited. Employees were not able to arrive at quick, intuitive insights, and were having trouble visualizing their data, primarily reporting on revenue, website subscription data, and market-share information.

About Customer

Kamernet is a popular Dutch student housing site that has been in operation for 15 years. The company offers over 100,000 rooms annually and deals with a vast amount of data, including SQL databases, Excel reports, and Google Analytics reports. These reports cover various aspects such as housing reports, website activity, revenue information, user analysis, website subscriber data, and property information. The company faced challenges with manual, Excel-based reporting, which created an IT bottleneck and made it difficult for employees to intuitively understand their reports. To address these issues, Kamernet sought a new BI reporting tool to improve data analysis and empower employees to create their own reports.

Solution

After evaluating the BI landscape, Gianmaria felt confident in choosing Sisense. He was especially impressed with the Sisense test drive, which successfully connected to their actual data in the Elasticube (rather than demo data), and the ability for Sisense staff to answer all questions about his data with helpful, knowledgeable responses. Kamernet’s front-end developer was especially impressed with the capabilities of the Sisense Elasticube, quickly recognizing its immense value. Gianmaria also appreciates the ability to create custom SQL and automate the Elasticube to sync data at any time, without affecting load to the database. The effect on reporting has been significant. No longer reliant on IT for producing and understanding business reports, employees are empowered to build, create, and analyze their own dashboards. Rather than employees trying to combine graphs or make sense of overly complicated Excel reports, they are able to produce business insights at a glance, with crucial information on financial analysis, especially weekly and yearly revenue figures. Sisense charts include 20 week comparisons for the current and previous year, so employees can effectively evaluate performance measured against the preceding year, and can set benchmarks for future marketing efforts.

Impact #1	Employees are empowered to build, create, and analyze their own dashboards without relying on IT.
Impact #2	Sisense charts include 20-week comparisons for the current and previous year, allowing employees to evaluate performance effectively.
Impact #3	Kamernet uses Sisense to analyze market-share data, enabling quick assessment and targeted planning for in-demand cities.

Impact #1

Employees are empowered to build, create, and analyze their own dashboards without relying on IT.

Impact #2

Sisense charts include 20-week comparisons for the current and previous year, allowing employees to evaluate performance effectively.

Impact #3

Kamernet uses Sisense to analyze market-share data, enabling quick assessment and targeted planning for in-demand cities.

Benefit #1	Kamernet offers over 100,000 rooms annually.
Benefit #2	The company deals with over five-billion records to analyze.

Benefit #1

Kamernet offers over 100,000 rooms annually.

Benefit #2

The company deals with over five-billion records to analyze.

Download PDF Version

Overview

Short Term Housing Provider Optimizes Inventory and Maximizes Profit

Operational Impact

Quantitative Benefit