You will be primarily governing equipment that is coded as War Reserve Material (WRM) and earmarked to support the Deployable Air Base System (DABS). The products to manage these commodities are spread between various online systems. Exported reports are in various formats such as Comma Separated Value, Tabular Text, or Structured Text.

1) How would you go about analyzing big data (example: 65K rows and 34 columns) from these exported documents and what are some strategies you would use to brevity the information, but also be available for future manipulation?

2) Using the same scenario from above. You have two different electronic reports (e.g. one from DPAS, one from LIMS BI Workspace). You need to consolidate the information but only the lines of data that have a specific identifier (i.e. NSN or Part Number). What are some strategies you would use to generate one product that consolidates the data from both reports and provides information that pertains to the specific identifier?