Telangana Rainfall & Humidity BI-Report Using GCP Cloud SQL Server & SSIS Package
admin
July 28, 2023
- July 28, 2023
- Case Studies, Cloud, Data Analytics, Telecom
- By admin
Source data which is coming in the form of CSV files, when there are multiple files, need to merge or integrate them using SSIS package tool
Destination or GCP Cloud SQL to store the Excel data in the form of tables such as Dimensions and Fact tables where each dimension table is getting connected to the fact table using primary – foreign key relationship
Data integration, cleansing, and data loading tool from excel or CSV files.
Visualization tool to build BI reports.