Download PDF
Cube Dev > Case Studies > Building Advanced Analytics with Cube Semantic Layer and Vue.js: A Qualibrate Case Study
Cube Dev Logo

Building Advanced Analytics with Cube Semantic Layer and Vue.js: A Qualibrate Case Study

Technology Category
  • Application Infrastructure & Middleware - Event-Driven Application
  • Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
  • Cement
Services
  • System Integration
The Challenge

Qualibrate, a SaaS company based in Amsterdam, was seeking an effective way to provide its users with the flexibility of advanced reporting and simplicity in generating dashboards. While there were several great products available in the market such as Kibana and Grafana, Qualibrate wanted to offer a seamless experience within their own platform. The challenge was to find a solution that would integrate well with their current platform which uses Vue.js. After considering various options, they found Cube from Statsbot.co to be a perfect fit for their use case. However, there was a significant caveat - Cube did not have an implementation for Vue.js. This led Qualibrate to consider working with the community to improve the MongoDB connector and integrate Cube into their workflow.

About The Customer

Qualibrate is a Software as a Service (SaaS) company headquartered in Amsterdam, The Netherlands. The company operates within a team of 11-50 employees and uses a tech stack that includes MongoDB and React. Qualibrate's primary goal is to provide its users with a seamless experience on their platform, particularly in terms of advanced reporting and dashboard generation. They are committed to leveraging the best tools and technologies available to achieve this goal, and are not averse to collaborating with the wider community to improve their offerings. Their recent project involved integrating Cube from Statsbot.co into their workflow to enhance their platform's reporting capabilities.

The Solution

Qualibrate decided to leverage the power of community collaboration rather than trying to replicate an existing product. They started using Cube in their workflow and began to work on improving the MongoDB connector. Once they were able to map their database schemas and curate their relationships, they started to match the React components as closely as possible in Vue.js. They set up a demo backend using MongoDB, created a new Vue CLI project, and installed the @cubejs-client/vue dependency. They also added vue-multiselect, vue-chartkick, and Chart.js for this example. They then configured the Vue application's configuration variables through a .env file and set up global components in the src/main.js file. They used the QueryRenderer and QueryBuilder components of Cube to fetch data and generate queries. They also added the capability to select dimensions and measures, which would update the query and render the content accordingly.

Operational Impact

  • By integrating Cube into their workflow and improving the MongoDB connector, Qualibrate was able to provide a seamless and enhanced user experience on their platform. They were able to offer advanced reporting and simple dashboard generation capabilities to their users. The use of Cube's QueryRenderer and QueryBuilder components allowed them to fetch data and generate queries efficiently. The addition of the capability to select dimensions and measures provided users with more flexibility and control over their reporting and dashboard generation processes. This collaborative approach not only improved their product but also strengthened their relationship with the wider tech community.

Related Case Studies.

Case Study
Digital Transformation of Atlanta Grout & Tile: An IoT Case Study
Atlanta Grout & Tile, a Tile, Stone & Grout restoration company based in Woodstock, Georgia, was facing challenges with its traditional business model. Despite steady growth over the years, the company was falling behind the web revolution and missing out on the opportunity to tap into a new consumer base. They were using independent software from different vendors for each of their department information and workforce management. This resulted in a lot of manual work on excel and the need to export/import data between different systems. This not only increased overhead costs but also slowed down their response to clients. The company also had to prepare numerous reports manually and lacked access to customer trends for effective business decision-making.
Learn more
Case Study
Revolutionizing Construction Equipment Rental: A Case Study on ProsRent and ENO8
ProsRent, a startup that won the 'Best Financial Opportunity' and 'Best Pitch' at CodeLaunch 2016, aimed to revolutionize the way construction professionals source and rent heavy equipment. In the construction industry, project managers and contractors typically rent heavy equipment from supply companies. However, predicting inventory can be challenging, and finding the required equipment at the right time and place can be a hassle. If the preferred vendor doesn't have the required equipment, it results in wasted time and money in searching for it, often leading to higher costs due to non-preferred rates and increased delivery costs if the vendor is located far from the job site. Suppliers, on the other hand, desired access to a wider base of trusted renters that they didn't have to vet themselves and wanted to offer dynamic rental pricing based on demand and availability in their market. ProsRent's challenge was to produce a minimum viable product that was fast and first to market but also strong enough to engender loyalty and repeat business from the target market.
Learn more
Case Study
IoT Solution Enhances Comfort and Energy Efficiency at Apple Valley Commons Office
Apple Valley Commons, a mixed-use office complex built in 1986, was facing significant comfort and energy efficiency challenges. The building, which houses a variety of businesses, was experiencing extreme temperature imbalances, causing discomfort to employees and clients. Despite outdoor temperatures being consistently high during summers, occupants had to use space heaters to keep warm. The electricity bills from the constant operation of the heat pump were exorbitant. The building's elevator room on the roof was also overheating, reaching temperatures of 130 to 140 degrees, causing the elevator equipment to shut down. The building's existing controls solution did not provide a front end for diagnostics or remote control. The building management was seeking a solution that could address these temperature issues, improve occupant comfort, reduce operational costs, and increase building visibility.
Learn more
Case Study
Revamping EE's Legacy ERP: A Case Study on BT's Strategic Transformation
EE, even after its merger with BT, was operating its ERP estate on legacy infrastructure, hosted on the premises of a third-party supplier. This outdated system resulted in a volume-based operational model, higher time to market, longer delivery cycles, and unsatisfactory customer experience. BT recognized the need for a strategic transformation of these aging ERP systems and sought a partner who could proactively manage application services. The partner was also expected to handle development requirements associated with application management services, drive accountability, and ownership with a time and target-driven transformation of these services. BT's primary goals were to improve customer experience, reduce cycle time, and measure these improvements with precision.
Learn more
© 2015-2024 IoT ONE Limited | Privacy Policy

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.