Download PDF
Short Term Housing Provider Optimizes Inventory and Maximizes Profit
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
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.
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 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
Quantitative Benefit
Related Case Studies.
Case Study
Leading Tools Manufacturer Transforms Operations with IoT
Stanley Black & Decker required transparency of real-time overall equipment effectiveness and line productivity to reduce production line change over time.The goal was to to improve production to schedule, reduce actual labor costs and understanding the effects of shift changes and resource shifts from line to line.
Case Study
Jaguar Land Rover Speeds Order-to-Cash Cycle
At Jaguar Land Rover, vehicles physically move around the facility for testing, configuration setting, rework and rectification, leading to a longer search time to get each vehicle to its next process facility. The main goal is to minimize the vehicles' dwell time between end of line and the delivery chain which was previously a manually intensive process. Jaguar Land Rover's goal was to build on the success of an earlier RFID project and improve the efficiency of delivering vehicles to meet dealer orders.
Case Study
Improve Postal Mail and Package Delivery Company Efficiency and Service
Postal mail and package delivery company wanted to replace legacy yard management system, increase inbound and outbound yard velocity, improve priority parcel delivery time and accuracy, reduce workload and overtime, reduce driver detention and measure performance and utilization of yard resources.
Case Study
Hospital Management Solution
The Oncology Diagnosis and Treatment Center of Brasov wanted to give patients as much freedom to roam as possible, while at the same time ensuring optimal patient safety and security. The centre was in need of an adequate wireless voice communication and messaging solution that would give patients the confi dence that medical staff is always on call, and reduce stress levels of nurses and doctors when called in case of urgent need.
Case Study
Worker Tracking & Safety Monitoring in Construction
One of the main challenges facing the technology was to create a network within underground tunnels and another was to provide products that can withstand harsh working environment. The team used amplifiers to enhance bandwidth and Litum produced IP67-rated hardware that is durable for harsh working conditions.
Case Study
Samsonite Track&Go
Travellers spend their lives discovering new places and meeting new people from all around the world. It can be such a wonderful experience, but sometimes it can turn into a disaster when your luggage gets lost. In 2014 alone, more than 24 million pieces of baggage were lost. Fortunately, 95% of them were found and returned to their owners. However, that leaves more than 1 million items of baggage that have never been recovered.
