Please enable JavaScript.
Coggle requires JavaScript to display documents.
Chapter 8: Accessing and Sorting Data (each box represents a table of data…
Chapter 8: Accessing and Sorting Data
tracking down data
what is the problem?
what is the unit of analysis?
accessing data sourcing, moving to matrix
must remove data that isn't useful
use identity combinations to to join sources
external data requires APIs
problems start w/ internal data
removing columns that are not relevant
if in doubt, keep the data
write down identity columns
each box represents a table of data
customers
indiv. orders
order details
Order ID
Order date
Shipped date
Customer ID
employees
Employee ID
one-to-many relationship
must be able to connect date together through sources