MIT$681-1$ Assignment $3$

Your recommendations about Big Data and Data Warehousing as they involve the new DA function

Describe YOUR RECOMMENDATED PLAN for your client regarding the use of Big Data and Data

Warehousing for creation of the new data analytics $($DA$)$ system.

The name of your client company is:

The type of industry your client is in

Database Recommendations $($Click your recommendations$)$

$$ Recommend a Database

$$ Data Warehouse $($Salesforce Data Cloud$)$

$$ Other Database $($name

$$ SQL$-$based $-$ formatted data

$$ Non$-$formatted data

$$ Big Data source #$1$ POS System

$$ Big Data source #$2$ Social Media and Online

Reviews

$$Big Data source #$3$ Finance and Accounting

Systems

$$Big Data source #$4$ Human Resources $($HR$)$

Data

$$Big Data source #$5$ Property Management

System $($PMS

Hadoop product for data $($name$)$

$$ Schema

$$ Format Data on Store

Format Data on Read

$$DFD

$$WFD

$$ ETL product $($Integrate$.$io$)$

$$ ELT product $($name$\text{'}$

$$ Est annual support $($FTEs$)$

$$ DB$/$DW to be supported by Salesforce

$$ Recommend OTS DB SW $($name

$$ Est cost $

$$ To be supported by

$$ Recommend CSP$-$supplied DB SW

$$Est cost $$15000$ p a

$$ DB services from CSP $($Salesforce$)$

$$ Data backup provided on$-$prem

$$ Data backup service by CSP

$/\_\backslash$ Are the DB$\text{'}$s with Big Data in cloud?

$$ Tools for data capture $($Change Data

Capture$)$

Add $1-2$ paragraphs below describing why you make the above Data Warehouse recommendations

for the data analytics $($DA$)$ system. Also, what are the sources of the data that make up Big Data?

Show your three diagrams here: $(1)$ the DFD$,$ and $(2)$ the WFD$,$ and $(3)$ the Schema.

Please draw DFD$,$ WFD and schema and share as jpg$.$ TIA