Add:
Business intelligence architecture matrix
Introduction.
In another portfolio project (link to the analysis of adoption of technology by organizations' data), talk about business not adopting technology and its impact
About Data source:
One of the major sources of data for most of my projects is free source and publicly available data from government organizations , regulatory bodies (Ontario Energy Board, Ontario Open Datasets, Ontario Ministry of infrastructure etc). This source the data from Statistics Canada's website and this project is no di. To demonstrate how data marts can be build
Data Preparation
Data used for this project was from Statistics Canada "International trade monthly interactive dashboard" with link : https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2020013-eng.htm
Building the Staging Database
To build the staging tables, DAX Studio was employed to move the data from SSAS Tabular Models and Deploy on SQL Server Database. Doing this ensures we have a Database for these Data sources and do not have to connect to flat files in the future.
Data Modeling
Comentarios