Telangana Rainfall & Humidity BI-Report Using GCP Cloud SQL Server & SSIS Package
motivitylabs
July 28, 2023
Telangana Rainfall & Humidity BI-Report Using GCP Cloud SQL Server & SSIS Package

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.
Motivity Labs is an award-winning IT Services company that focuses on Cloud, Mobile, Big data, and Innovation.
5525 N MacArthur Blvd
Suite # 690,
Irving TX 75038
1221 Brickell Centre,
Miami, FL, 33131
Dallas Center, 6th & 7th Floor, 83/1, Plot No A1, Knowledge City Rd, Rai Durg, Hyderabad, Telangana 500032.