下载PDF
Cube Dev > 实例探究 > 使用 Cube 改进自定义报告和成本效率:FeedMe 案例研究
Cube Dev Logo

FeedMe's Custom Reporting Enhancement with Cube

技术
  • 功能应用 - 库存管理系统
  • 功能应用 - 仓库管理系统 (WMS)
适用行业
  • 设备与机械
  • 零售
适用功能
  • 销售与市场营销
用例
  • 库存管理
  • 零售店自动化
服务
  • 系统集成
挑战
FeedMe 希望提供一个强大的报告系统,允许用户生成自己的自定义报告。然而,他们之前基于 SQL 查询和 JavaScript 来处理 MongoDB、CouchDB 和 BigQuery 数据的解决方案变得越来越难以维护和扩展。
关于客户
FeedMe 是东南亚食品和饮料行业的销售点 (POS) 系统提供商。他们向客户提供报告服务,包括销售报告、营销分析和库存管理。他们的后端系统是用 JavaScript 编写的,并在客户端 POS 系统中使用 CouchDB。
解决方案
FeedMe 通过 Google 搜索找到了 Cube,并决定采取分阶段的方式部署 Cube。在第一阶段,他们使用 Cube 的动态架构创建迁移了部分数据架构。在下一阶段,他们迁移了其余的数据模式并实现了更高级的功能,例如预聚合和多维数据集存储。
运营影响
  • The implementation of Cube has significantly improved FeedMe's reporting system. The company now has a more flexible caching mechanism, which allows them to customize refreshKey and rollup definitions. This has not only reduced their BigQuery cost but also improved the speed of data queries. The data that used to take several minutes to query can now be accessed in less than 10 seconds when cached and pre-aggregated. This has greatly enhanced the user experience for their customers. Furthermore, the FeedMe team has found the Cube community to be very collaborative, especially on Slack, as they were navigating different features such as rollupJoin, pre-aggregations, and Cube Store. They have also been able to provide feedback to the Cube Dev team, contributing to the continuous improvement of the system.

数量效益
  • FeedMe’s BigQuery cost is down by about ⅔ with the implementation of Cube pre-aggregations and Cube Store.

  • Without pre-aggregations, it could take several minutes for their customers to query several months of sales data. When the data is cached and pre-aggregated, a similar query would take less than 10 seconds.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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