- For the purprose of data storage we used a blob storage sanctioned via Azure cloud platform.
-
For data transformation and loading to data base we used Azure databricks by running Pyspark queries in order to create the following fact and dimension tables.
-
- Fact
-
- Country
-
- Commodity
-
- Transport Mode
-
- Direction
-
- Measure
- For data loading and storage we use SQL server deployed in azure cloud
By leveraging tabeleau's comprehensive dashboard creation utilities we are able to create a consolidated dashboard as shown in Book2.pdf