Download PDF
BizCover Accelerates Data Connectivity by 90% with Fivetran
Technology Category
- Functional Applications - Warehouse Management Systems (WMS)
- Platform as a Service (PaaS) - Application Development Platforms
Applicable Industries
- Electrical Grids
- Finance & Insurance
Applicable Functions
- Sales & Marketing
- Warehouse & Inventory Management
Use Cases
- Inventory Management
- Usage-Based Insurance
Services
- Cloud Planning, Design & Implementation Services
The Challenge
BizCover, Australia’s largest online business insurance provider, was facing a significant challenge in connecting data from various sources. The company's team of engineers had to build unique connectors using their own code, each requiring 40 to 80 hours of engineering time. This approach initially worked when connecting and syncing data from their database and Google Analytics. However, as the number of data sources increased, the task became overwhelming. BizCover needed to pull data from over 20 data sources into its centralized Snowflake data warehouse, with each source requiring its own connector. The company’s data engineers were managing this largely manual process, and BizCover needed to disseminate the insights they were gaining from the data across the core business more efficiently.
About The Customer
BizCover is Australia’s largest online business insurance organization, with over 180,000 SMEs currently protecting their business through BizCover’s proprietary platform. Founded in 2008, BizCover disrupted the insurance market by creating an online service to simplify comparing and buying business insurance from some of Australia’s leading insurers. To date, over one million business insurance policies have been sold through the BizCover platform across Australia, New Zealand, and the US. BizCover also provides market-leading solutions to the General Insurance Broking Industry through their BizCover for Brokers and ExpressCover brands. Innovation is at the heart of BizCover, frequently incorporating digital technologies such as Artificial Intelligence and automation across its platform.
The Solution
In search of a solution to their data connectivity challenge, BizCover's Information Management team turned to Fivetran, a recommendation from Snowflake. After a successful proof-of-concept pilot run, the team found Fivetran's platform easy to use and the onboarding process straightforward. Fivetran also provided excellent support and documentation, answering all questions around data security. With Fivetran, the BizCover team was able to set up a connector in just 4-8 hours, a 90% decrease in time and cost. Fivetran’s turn-key automated alerts also minimized the risk of reporting or acting on inaccurate data. This allowed the team to focus on using the data instead of building their pipelines and connectors.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Hydro One Leads the Way In Smart Meter Development
In 2010, Ontario’s energy board mandated that time-of-use (TOU) pricing for consumers be available for all consumers on a regulated price plan. To meet this requirement, Hydro One needed to quickly deploy a smart meter and intelligent communications network solution to meet the provincial government’s requirement at a low cost. The network needed to cover Hydro One’s expansive service territory, which has a land mass twice the size of Texas, and its customers live in a mix of urban, rural, and remote areas, some places only accessible by air, rail, boat or snowmobile. Most importantly, the network needed to enable future enterprise-wide business efficiencies, modernization of distribution infrastructure and enhanced customer service. To meet these needs, Hydro One conceptualized an end-to-end solution leveraging open standards and Internet Protocols (IP) at all communication levels. The utility drew upon industry leaders like Trilliant to realize this vision.
Case Study
Selling more with Whirlpool
Whirlpool wanted to add connectivity to appliances and transform the company's relationship with customers. Traditionally, Whirlpool interaction with customers was limited to purchases made once every ten years. Connected washer and dryers provide exciting new features like remote management of start times and inter-machine communication.
Case Study
Real-time In-vehicle Monitoring
The telematic solution provides this vital premium-adjusting information. The solution also helps detect and deter vehicle or trailer theft – as soon as a theft occurs, monitoring personnel can alert the appropriate authorities, providing an exact location.“With more and more insurance companies and major fleet operators interested in monitoring driver behaviour on the grounds of road safety, efficient logistics and costs, the market for this type of device and associated e-business services is growing rapidly within Italy and the rest of Europe,” says Franco.“The insurance companies are especially interested in the pay-per-use and pay-as-you-drive applications while other organisations employ the technology for road user charging.”“One million vehicles in Italy currently carry such devices and forecasts indicate that the European market will increase tenfold by 2014.However, for our technology to work effectively, we needed a highly reliable wireless data network to carry the information between the vehicles and monitoring stations.”
Case Study
SAS® Analytics for IoT: Smart Grid
Companies face falling revenues, rising infrastructure costs, and increasing risk of outages caused by inconsistent energy production from renewable sources. Less money is coming in as more people and organizations take steps to curb their energy use. Utilities are paying more to maintain and build infrastructure due to increasing complexity, resulting from the rising number of intermittent and variable renewable energy sources connected in the distribution grid.
Case Study
Enel Secures Italian Power Generation Network
Electric energy operators around the world are working to increase the reliability and cyber resiliency of their systems. This includes Enel, a global power company that manages and monitors the Italian power grid. This grid:• Serves 31 million customers• Has a net installed energy capacity exceeding 31 gigawatts• Includes more than 500 power generation plants,including hydroelectric, thermoelectric, and wind• Is managed and monitored by Enel 24/7/365• Is operated by Terna, the Italian Transmission System Operator (TSO)Enel is responsible for the availability of the grid’s underlying ICS and industrial network. It also manages Regional Control Centers and Interconnection Centers which connect with the TSO. The TSO manages the flow of energy to the grid plus controls and remotely regulates the power generation of power plants, increasing and decreasing power production as required. The complex system of interaction and cooperation between Enel and the TSO has strong security implications as well as operational and business challenges.
Case Study
IoT based Energy Quality Availability Monitoring Solution
There were several challenges faced:Since this data would be in the public domain, accuracy and authenticity of this data were of paramount importance. It should be able to withstand scrutiny.It is challenging to build an appliance that can withstand a wide range of voltage fluctuations from as low at 90v to as high as 320v. Since the device would be installed in remote locations, its resilience was of paramount importance.The device would have to deal with poor network coverage and have the ability to store and re-transmit data if networks were not available, which is often the case in rural India. The device could store up to 30 days of data.The platform that deals with the data should be readily available and highly reliable and never lose a packet of data.
