Data Flashcards
First Party Data
Data collected by an individual or group using their own resources.
Second Party Data
Data collected from a group from its audience and then sold.
Third Party Data
Data collected from outside sources who did not collect it directly.
Population
All possible data values in a certain dataset.
Sample
A part of a population that is representative of the population. This is useful when looking to analyse data on an entire population as collecting such a massive amount of data would be challenging.
Time Series Data
This is data that includes dates and is useful when looking to analyse trends over time.
Qualitative Data
This is data that can’t be counted, measured or easily expressed using numbers. Examples include names, categories and descriptions.
Quantitative Data
This is data which can be measured, counted and then expressed as a number. This is data with a certain quantity, amount or range.
Discrete Data [Quantitative Data]
This is data that’s counted or has a limited number of values. It’s not fractional data composed of whole numbers or points such as 10, 50 and 365.
Continuous Data [Quantitative Data]
Data that is measured and can have almost any numerical value. An example is 110.0356 minutes.
Nominal Data [Qualitative Data]
A type of qualitative data that’s categorized without a set order. This type of data doesn’t have a sequence.
Ordinal Data [Qualitative Data]
This is a type of qualitative data with a set order or scale.
Internal Data
Data that lives within a company’s own systems. This is usually more reliable and easier to collect.
External Data
Data that lives and is generated outside of an organisation.
Structured Data
Data that’s organised in a certain format such as rows and columns. Spreadsheets and relational databases can stored data in a structured way.
Unstructured Data
This is data that is not organised in any easily identifiable manner such as audio and video files.
Data Model
A model that is used for organising data elements and how they relate to one another.
Data Elements
Pieces of information, such as people’s names, account numbers, and address.
Data Modelling
Data modelling is the process of creating diagrams that visually represent how data is organised and structured. These visual representations are called data models.
3 Most Common Types of Data Modelling
- Conceptual data modelling
- Logical data modelling
- Physical data modelling
Conceptual Data Modelling
Conceptual data modelling gives a high-level view of the data structure, such as how data interacts across an organisation. A conceptual data model doesn’t contain technical details.
Logical Data Modelling
Logical data modelling focuses on the technical details of a database such as relationships, attributes, and entities. It doesn’t spell out the actual names of database tables. That’s the job of a physical data model.
Physical Data Modelling
Physical data modelling depicts how a database operates. A physical data model defines all entities and attributes used; for example, it includes table names, column names, and data types for the database.
Spreadsheet Data Types
- Number
- Text or string
- Boolean [a result that can only have one of two possible values: true or false.]
Record
This is data contained in a row.