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

Short Term Housing Provider Optimizes Inventory and Maximizes Profit

Sisense Logo
Customer Company Size
SME
Region
  • Europe
Country
  • Netherlands
Product
  • Sisense
  • Sisense Elasticube
Tech Stack
  • SQL
  • Excel
  • Google Analytics
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
  • Digital Expertise
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
About The 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.
The 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.
The 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.
Operational Impact
  • Employees are empowered to build, create, and analyze their own dashboards without relying on IT.
  • Sisense charts include 20-week comparisons for the current and previous year, allowing employees to evaluate performance effectively.
  • Kamernet uses Sisense to analyze market-share data, enabling quick assessment and targeted planning for in-demand cities.
  • Sisense has created a culture of employee engagement, driving conversations at company brainstorming sessions and meetings.
  • Employees can make quick, on-the-spot analysis in real-time, using Sisense as a crucial tool to diagnose business health and implement evidence-backed change.
Quantitative Benefit
  • Kamernet offers over 100,000 rooms annually.
  • The company deals with over five-billion records to analyze.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.