Download PDF
AmFam's Transformation through Tableau Embedded Analytics
Technology Category
- Analytics & Modeling - Edge Analytics
- Application Infrastructure & Middleware - Database Management & Storage
Applicable Industries
- Consumer Goods
- Finance & Insurance
Applicable Functions
- Sales & Marketing
Use Cases
- Personnel Tracking & Monitoring
- Tamper Detection
Services
- System Integration
The Challenge
American Family Insurance (AmFam), a private mutual insurance company, faced challenges in providing data support to its local and regional agencies. These agencies, organized as independent contractors, are a crucial part of the AmFam data ecosystem, utilizing corporate data to optimize their sales and customer service contributions. However, the existing system was siloed and offline, making it difficult for agencies to access and analyze data. AmFam sought to improve the delivery of analytics to its agents, particularly around product availability, performance metrics, and expected business results. The challenge was to replace the siloed data sources and offline workflows with a secure portal that integrates insights into existing user interfaces (UI).
About The Customer
American Family Insurance (AmFam) is a private mutual insurance company that offers a variety of consumer and commercial products, including property, casualty, life, health, and homeowners coverage, along with investment and retirement planning products and services. AmFam's corporate teams use Salesforce CRM products to generate, manage, and analyze data for a wide range of activities, from account management and customer service to business development and executive planning. Beyond corporate implementations of CRM, AmFam also supports local and regional agencies that sell AmFam products. These agencies are organized as independent contractors who are licensed to transact with end customers and incentivized to meet performance targets.
The Solution
AmFam used Tableau Embedded Analytics to create a new self-service analytics web portal, myDashboard, for agencies and corporate users. This portal integrated into the existing workflows and UI that the agencies were accustomed to, providing vital insights without disrupting their work. The myDashboard solution offered customization, allowing agencies to adapt the portal to match their branding and UI workflows. It also provided pre-built dashboards for common metrics such as revenue, premiums, new business, and retention, along with preset filtering and customizable search. This made the portal user-friendly and reduced the learning curve for non-technical users. Additionally, the solution ensured security and governance with row-level security in Tableau, enforcing data access permissions based on various roles. AmFam also adopted Tableau single sign-on, allowing users to view reports and dashboards without leaving the myDashboard UI context.
Operational Impact
Quantitative Benefit
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
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.”
