Programming & Database Environment Worksheet

Programming & Database Environment Worksheet

 
Description



Create three sources of origination of where the data will originate from.



Example;



1. Hard copy file: CSV



2. Database Environment (another database resource)



3. API



You will need to create CSV files with real data,



Create 3 different Data Marts



1. Data Mart 1 will represent business intelligence reporting



2. Data Mart 2 will represent Data Science (Analytics)



3. Data Mart 3 will represent Big Data (Hadoop)



Data Warehouse: Identify the database organization that you want to use



for your data warehouse. Research what different data warehouses are



available, and why you are going to use the one that you chose.



Create a diagram of the blue print of the data architecture, and include in



your document the information around the data warehouse.