Optimizing Customer-Facing Analytics with Luzmo and ClickHouse
Technology Category
- Analytics & Modeling - Edge Analytics
- Infrastructure as a Service (IaaS) - Cloud Databases
Applicable Industries
- Buildings
- Cement
Use Cases
- Building Automation & Control
- Construction Management
Services
- System Integration
About The Customer
TEIMAS, a software company that builds solutions for waste management, has been using Luzmo for its customer-facing analytics for over three years. Their platform's backend runs on MySQL, but as they dealt with more data, they felt the need for a separate analytical database like ClickHouse. Iago Elizechea, CTO at Teimas, stated that they needed to connect directly to an analytical database to improve the speed of their dashboards and ensure the performance of the entire platform. They chose ClickHouse because of its accessibility and amazing performance, especially for certain types of queries.
The Challenge
Software applications generate terabytes of data that can be used to make informed decisions. However, transforming this data into visual insights for users can be a challenge. The task of delivering analytics in SaaS is two-fold: providing an easy-to-use, interactive, and personalized experience for end-users, and building a coherent and high-performing data architecture with tailored visualizations quickly and painlessly. The more advanced the analytics, the harder it becomes for developers to maintain. Additionally, there is the complexity of data security, ensuring that each user only has access to their personal data. The challenge lies in scaling tailored insights to hundreds or even thousands of users.
The Solution
The solution to these challenges is the use of embedded analytics tools, which combine an easy-to-use UI for non-technical users with a powerful and consistent API for developers. Luzmo, an embedded analytics platform, allows for the injection of personalized reports and dashboards, interactive exploring, and fast-loading dashboards into a platform with one snippet of code. Luzmo's powerful API allows developers to plug Luzmo's analytics straight into their platform, re-using any authentication or business logic already built inside the software. This speeds up the development cycle while retaining full control over the analytics feature set. ClickHouse, a columnar database designed with aggregations in mind, provides a high-performance and scalable database solution for customer-facing, ad-hoc aggregations and analytics.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
System 800xA at Indian Cement Plants
Chettinad Cement recognized that further efficiencies could be achieved in its cement manufacturing process. It looked to investing in comprehensive operational and control technologies to manage and derive productivity and energy efficiency gains from the assets on Line 2, their second plant in India.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Commercial Building Automation Boosts Energy Efficiency
One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.
