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





To analyse customers engagement and performance of email campaign.


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


Business Impact

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

Case Studies