BI Infrastructure Using SSIS And Tableau

Authored by Ameex Technologies on 04 Sep 2019

A series of interactive dashboards to track the email campaign and member engagement KPIs for a leading liability insurance provider to schools, colleges and universities.

Problem Statement

  • Client is a world’s leading liability insurance and risk management service provider to education institutes
  • Data from multiple different external data sources were extracted in flat files and reports were generated manually
  • Client wants to automate the reports and generate an integrated dashboard(s)

Our Approach

Tableau

Dashboard

v4

Objective

To analyse customers engagement and performance of email campaign.

Features

This dashboard includes various features

  • Drilldown, filter and spotlight particular category
  • View the members enagement and impact of email campaign
  • Dashboard access to only relevant stakeholders

Visualization Tool

Tableau

Business Impact

  • Automated jobs for extracting data from external data sources
  • Scheduled data transformation and process before loading into data warehouse

Case Studies