BI Infrastructure Using SSIS And Tableau
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.
- 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)
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
- Automated jobs for extracting data from external data sources
- Scheduled data transformation and process before loading into data warehouse