You are leaving our main website to go to our chinese website hosted in China. For legal reasons there will not be any links pointing back to the main website.

Go to chinese website
Logo - Keyrus
Logo - Keyrus
  • Playbook
  • Services
  • Insights
  • Partners
  • Careers
  • About us
    Company purpose
    Innovation & Technologies
    Committed Keyrus
    Regulatory compliance
    Investors
    Management team
    Brands
    Locations

Success story

Modernizing insurance marketing reports with Tableau

Background

Our client serves one in three households across British Columbia with a variety of insurance products and related services. Recently, the company migrated its data warehouses to Redshift Spectrum, and began looking to migrate much of its reporting from an end-of-life system to Tableau. Our team was hired to jump-start this process by developing a new reporting foundation using data visualization and Tableau best practices.

Specifically, the project targeted the marketing database department, which is responsible for providing business intelligence and reporting on marketing strategy and sales and marketing performance. Prior to the migration to Tableau, the reporting system consisted primarily of numerous pages of tables used to compare different scenarios or show performance over time.

At the beginning of the engagement, the client selected a set of five critical reports for our team to migrate. Shortly after the completion of these five reports, the client brought us back to build two more dashboards focused on yet another product.

Challenge

Our client uses a relational database structure to store customer master data, and stores daily and monthly snapshots of the master data to access their history. Since one of the main applications of the dashboards is analyzing changes to the benchmark data, it was necessary to access many snapshots, which resulted in significant data source bloat and performance issues.

Our team was able to produce responsive dashboards without having to apply a complete rework of the database structure, by strategically aggregating data and reviewing the value of certain features with the client.

Approach

  • Interviewed key stakeholder to understand current processes and potential gains in implementing a modern solution.

  • Designed and built clearer and more actionable dashboards in Tableau to replace existing 5+2 reports.

  • Installed Tableau Server on a Canadian region EC2 (AWS Elastic Computing) instance with a single sign-on configuration.

  • Documented and performed knowledge transfer sessions to enable the client's team to take ownership of the Tableau solution and continue migrating reports.

Key Results

  1. A modern reporting and analytics environment allowing for a safe migration and a sunset process for the legacy reporting solution.

  2. A radical move from multi-page reports to visual dashboards providing faster access to key performance indicators and performance trends over time.

  3. Ability to answer some business questions that were previously impossible to answer.

  4. Prepared client staff for continued modernization and development.

whatsapptwitter
linkedinfacebookworkplace
newsletter.svg

Never miss an insight

Stay updated on the latest articles, events, and more

Your email address is only used to send you the Keyrus newsletter and for commercial prospecting purposes. You can use the link in our emails to opt-out at any time. Learn more about the management of your data and your rights.

Continue reading

Webinar

Live Webinar: Drive value from your pool of Alumni

January 10, 2023

Thursday, February 2nd, 2023 @ 12:00PM Eastern Time (Canada)

Blog post

Keyrus Canada launches November Together!

November 7, 2022

Keyrus Canada supports the Centraide association and launches the “November Together” project This year our team has decided to support the United Way, an association that works locally for vulnerable people by creating more inclusive communities and solidarity projects.

Blog post

International Corporate Volunteering "ICV" at Keyrus Canada

October 20, 2022

In order to experimente the international corporate volunteering, young graduates aged of 18 to 28 come to work in the data’s world at Keyrus Canada.

Success story

Mining unstructured contractual text data to automate billing processes

August 2, 2022

Keyrus' team has put in place a solution to support a North American logistics company with more than 75 distribution sites. Find out below how we have fixed and developed the process automation, data extraction and interpretation to increase their productivity.

Podcast

Take Tableau to the cloud - Replay

May 16, 2022

As more and more data sources, platforms, and services become cloud-based the reasons for maintaining infrastructure to host a BI tool become less and less practical. Security and performance concerns are no longer the roadblocks they once were to many SaaS products, and ease of access for end users is significantly improved. This leaves many organizations with on-premises BI tools wondering if the move is right for them.

Webinar

Take Tableau to the cloud

May 2, 2022

As more and more data sources, platforms, and services become cloud-based the reasons for maintaining infrastructure to host a BI tool become less and less practical. Security and performance concerns are no longer the roadblocks they once were to many SaaS products, and ease of access for end users is significantly improved. This leaves many organizations with on-premises BI tools wondering if the move is right for them.

Event

Embedded Analytics - 3 stories on the value of buying vs. building

February 2, 2022

Tableau embedded analytics is the vehicle that can get your external solutions faster to market and start your journey towards data monetization. With Tableau embedded analytics, any organization can deliver more value to its customers by putting data that matters right at the front.

Press release

Keyrus celebrates its 25th anniversary by offering businesses an inspiring new vision

October 13, 2021

Levallois-Perret, October 14, 2021 - An international player in consulting and technology as well as a Data and Digital specialist, Keyrus announces new goals in the market through a renewed and inspiring vision stemming from 25 years of expertise in data exploitation. Keyrus has also redesigned its visual identity, creating a new logo and slogan: “make data matter.”

Event

Alteryx + Snowflake = Driving Analytic & Data Science Outcomes in the Data Cloud

July 28, 2021

In this pre-recorded webinar, we conduct a demo on the technical and business benefits of using Alteryx and Snowflake together as a modern strategy for cloud data analytics at scale.

Event

Using Tableau To Visualize Canadians' Mental Health & Substance Use During The Pandemic

July 28, 2021

Watch this 30-minute webinar showcasing how the Centre for Addiction and Mental Health (CAMH) used data and visual analytics to better understand and communicate the impact of COVID-19 on Canadians’ mental wellness.

Logo - Keyrus
Montreal

75 Queen St. – Suite 1400 H3C 2N6– Montréal, Québec

LinkedInInstagram
PlaybookServicesInsightsPartnersCareersAbout us
Company purposeInnovation & TechnologiesCommitted KeyrusRegulatory complianceInvestorsManagement teamBrandsLocations
Legal notice & Terms of use
Privacy policy
Data protection