Our processes are for consolidated data for Insurance agents, Insurance premiums and Insurance claims. The client has different sources of data i.e. XML, JSON, SQL, ADO.net & Excel sheets. We did this using SQL Server Integration Services(SSIS). After that I created multiple Dashboard for Insurance insights using PowerBI.