下载PDF
How Rental One Replaced Complex Excel-Based Processes with Robust Analytics
技术
- 分析与建模 - 实时分析
- 分析与建模 - 大数据分析
适用行业
- 建筑与基础设施
适用功能
- 商业运营
用例
- 实时定位系统 (RTLS)
- 质量预测分析
服务
- 数据科学服务
挑战
Rental One 是一家顶级设备租赁公司,它正在努力处理庞大的 Excel 电子表格,该电子表格用于跟踪全公司财务数据的关键绩效指标 (KPI)。随着数据的积累和扩展,电子表格变得越来越繁琐。该过程部分自动化,但大多数内容都是手动添加的。随着变量数量和内容数量的增加,电子表格不断增长,变得越来越难以处理。每个月末,都会准备额外的合并报告,以提供高管对业务绩效的审查。然而,Excel 电子表格产生了错误的结果,不同的用户根据电子表格的解释方式和他们运行的数据堆栈得出不同的结论。基于 Excel 的系统陷入停滞,影响了业务的多个方面。
关于客户
Rental One 位于德克萨斯州科利维尔,是一家一流的设备租赁公司,为当地和全州客户提供各种最佳建筑设备和最个性化的服务。该公司通过 11 个零售点开展业务,为来自广泛市场的客户提供服务。Rental One 自 60 多年前作为家族企业成立以来,已经取得了长足的发展。尽管公司不断发展壮大,但公司对卓越的承诺以及良好的工作依赖于可靠性、正直、诚实和团队合作的信念从未动摇。Rental One 将继续支持其客户的项目,无论设备、供应或服务需求如何。
解决方案
Rental One 决定用商业智能 (BI) 平台取代基于 Excel 的流程。他们需要一个可以消除 Excel 缺点、解锁和整合 ERP 数据、简化即席查询并自动为组织中的每个人生成正确、一致结果的 BI 平台。他们之所以选择 Dundas BI,是因为它在数据可视化领域的长期领导地位,以及它能够满足 Rental One 的关键要求,特别是在高级数据准备方面。Dundas BI 的高级数据准备功能使 Rental One 能够更加主动,专注于他们需要的数据,并从那里轻松丰富数据。借助 Dundas BI,Rental One 能够定期直接从其来源检索数据。这意味着他们可以在仪表板上实时显示数据,为用户提供对存储信息的不受限制的访问,并使他们能够精确地跟踪 KPI。
运营影响
数量效益
相关案例.
Case Study
IoT System for Tunnel Construction
The Zenitaka Corporation ('Zenitaka') has two major business areas: its architectural business focuses on structures such as government buildings, office buildings, and commercial facilities, while its civil engineering business is targeted at structures such as tunnels, bridges and dams. Within these areas, there presented two issues that have always persisted in regard to the construction of mountain tunnels. These issues are 'improving safety" and "reducing energy consumption". Mountain tunnels construction requires a massive amount of electricity. This is because there are many kinds of electrical equipment being used day and night, including construction machinery, construction lighting, and ventilating fan. Despite this, the amount of power consumption is generally not tightly managed. In many cases, the exact amount of power consumption is only ascertained when the bill from the power company becomes available. Sometimes, corporations install demand-monitoring equipment to help curb the maximum power demanded. However, even in these cases, the devices only allow the total volume of power consumption to be ascertained, or they may issue warnings to prevent the contracted volume of power from being exceeded. In order to tackle the issue of reducing power consumption, it was first necessary to obtain an accurate breakdown of how much power was being used in each particular area. In other words, we needed to be able to visualize the amount of power being consumed. Safety, was also not being managed very rigorously. Even now, tunnel construction sites often use a 'name label' system for managing entry into the work site. Specifically, red labels with white reverse sides that bear the workers' names on both sides are displayed at the tunnel work site entrance. The workers themselves then flip the name label to the appropriate side when entering or exiting from the work site to indicate whether or not they are working inside the tunnel at any given time. If a worker forgets to flip his or her name label when entering or exiting from the tunnel, management cannot be performed effectively. In order to tackle the challenges mentioned above, Zenitaka decided to build a system that could improve the safety of tunnel construction as well as reduce the amount of power consumed. In other words, this new system would facilitate a clear picture of which workers were working in each location at the mountain tunnel construction site, as well as which processes were being carried out at those respective locations at any given time. The system would maintain the safety of all workers while also carefully controlling the electrical equipment to reduce unnecessary power consumption. Having decided on the concept, our next concern was whether there existed any kind of robust hardware that would not break down at the construction work site, that could move freely in response to changes in the working environment, and that could accurately detect workers and vehicles using radio frequency identification (RFID). Given that this system would involve many components that were new to Zenitaka, we decided to enlist the cooperation of E.I.Sol Co., Ltd. ('E.I.Sol') as our joint development partner, as they had provided us with a highly practical proposal.
Case Study
Splunk Partnership Ties Together Big Data & IoT Services
Splunk was faced with the need to meet emerging customer demands for interfacing IoT projects to its suite of services. The company required an IoT partner that would be able to easily and quickly integrate with its Splunk Enterprise platform, rather than allocating development resources and time to building out an IoT interface and application platform.
Case Study
Bridge monitoring in Hamburg Port
Kattwyk Bridge is used for both rail and road transport, and it has played an important role in the Port of Hamburg since 1973. However, the increasing pressure from traffic requires a monitoring solution. The goal of the project is to assess in real-time the bridge's status and dynamic responses to traffic and lift processes.
Case Study
Bellas Landscaping
Leading landscaping firm serving central Illinois streamlines operations with Samsara’s real-time fleet tracking solution: • 30+ vehicle fleet includes International Terrastar dump trucks and flatbeds, medium- and light-duty pickups from Ford and Chevrolet. Winter fleet includes of snow plows and salters.
Case Study
Condition Based Monitoring for Industrial Systems
A large construction aggregate plant operates 10 high horsepower Secondary Crusher Drive Motors and associated conveyor belts, producing 600 tons of product per hour. All heavy equipment requires maintenance, but the aggregate producer’s costs were greatly magnified any time that the necessary maintenance was unplanned and unscheduled. The product must be supplied to the customers on a tight time schedule to fulfill contracts, avoid penalties, and prevent the loss of future business. Furthermore, a sudden failure in one of the drive motors would cause rock to pile up in unwanted locations, extending the downtime and increasing the costs.Clearly, preventative maintenance was preferable to unexpected failures. So, twice each year, the company brought in an outside vendor to attach sensors to the motors, do vibration studies, measure bearing temperatures and attempt to assess the health of the motors. But that wasn’t enough. Unexpected breakdowns continued to occur. The aggregate producer decided to upgrade to a Condition Based Monitoring (CBM) sensor system that could continually monitor the motors in real time, apply data analytics to detect changes in motor behavior before they developed into major problems, and alert maintenance staff via email or text, anywhere they happened to be.A wired sensor network would have been cost prohibitive. An aggregate plant has numerous heavy vehicles moving around, so any cabling would have to be protected. But the plant covers 400 acres, and the cable would have to be trenched to numerous locations. Cable wasn’t going to work. The aggregate producer needed a wireless solution.