Tuesday 12 July 2022

Consultancy Work Template for an Internet Based Service Company

Discover the company data base

  1. Query of the raw DB tables
  2. Find out if there is a Primary Key for each table 
  3. Find out if there is a Meta Data table
  4. Try to draw the Relation Diagram
  5. Don't leave any of the fields unnamed and no meta data entry
  6. Try to find out data patterns
  7. Try to locate any faulty data or blanks in the data (imputation)
  8. Use WEKA
  9. Use KNIME
  10. Data warehouse design