Data Warehouse Plan DAT/390

Data Warehouse Plan The goal is to transform our current operational structure into a data structure that is capable of handling a large volume of data. The reason we elected to utilize a data warehouse is because we need it exclusively for reporting. The beginning point for our transformation starts with the area of extraction or where data is collected. We can collect it from the internet, disbursements, recipients, spreadsheets and flat files. So here we are extracting data from the various sources that will then be stored into the data warehouse database. A way to elevate the process is to utilize ETL which stands for extract transform load which is crucial process when it comes to a data warehouse. With ETL we extract data from the sources where...