You are viewing a public preview
Sign in to save your progress, do assignments, join discussions and get feedback.
Concepts and types of data; quantitative and qualitative data; structured, semi-structured and unstructured data; the relationship between data, information, knowledge and wisdom; data analysis in business contexts. The slides cover datasets, records and variables, independent and dependent variables, and the nominal, ordinal and quantitative (interval and ratio) data types with the operations each allows.
Learning outcomes
The lecture slides for this lesson are below.
By the end of this lesson you can:
Key idea: Before you draw any chart, know what kind of data each field holds. The data type decides which comparisons are meaningful, and therefore which charts and calculations are honest.
The lecture defines a typical dataset as n records (r1, r2, ..., rn). Each record holds m observations or variables (v1, v2, ..., vm), with m at least 1. In a spreadsheet, a record is a row and a variable is a column.
Variables can play two roles:
In business charts the independent variable usually goes on the horizontal axis (Order Date) and the dependent variable on the vertical axis (Sales).
The lecture groups data into nominal, ordinal and quantitative, and splits quantitative data into interval and ratio.
| Type | What it is | Allowed operations | Examples |
|---|---|---|---|
| Nominal (N) | Labels or categories with no order | =, ≠ | Fruit {apple, orange, pear}; colour {red, green, blue} |
| Ordinal (O) | Values with a meaningful order | =, ≠, <, > | Film ratings G < PG < PG-13 < R; small < medium < large |
| Interval (Q) | Ordered numbers with equal spacing but no absolute zero | =, ≠, <, >, − | Calendar dates, clock time, temperature in °C |
| Ratio (Q) | Numbers with an absolute zero | =, ≠, <, >, −, % | Height, weight, price, quantity |
Each type adds one operation to the type above it. With interval data you can measure a distance or span ("the order shipped four days after it was placed"), but you cannot say that one date is "twice" another. As the lecture notes, 14 September 2010 cannot be described as a ratio of 1 January 2011. With ratio data, statements such as "twice as much" or "a 20% share" make sense because zero really means "none".
Numbers are not automatically quantitative. A customer tier coded 1, 2, 3 is ordinal, and an order number is nominal even though it contains digits. A quick test: does adding or averaging these values mean anything?
Tableau works best with structured data, so other data are usually converted into tables first.
The DIKW pyramid describes how value is added as data move up the chain:
Data analysis in business is the work that moves an organisation up this pyramid: collecting, cleaning, summarising and interpreting data so that managers can decide. Visualization is one of the strongest tools for the step from data to information, because people see patterns in pictures much faster than in rows of numbers.
The course practice data describe a fictitious office-supplies retailer. In the spirit of the classification exercise in the slides, classify some fields of the Orders and Customer tables.
So you can sum Sales, sort Ship Mode by speed, only count Segment values, and put Order Date on a time axis.
Flashcards · Data and Data Analysis
10 wordsOne row of a dataset: a single observed item or event described by one or more variables.
A variable that is not affected by other variables in the dataset; time is the classic example.
A variable whose values change with one or more independent variables.
Unordered categories or labels; only equal and not-equal comparisons are meaningful.
Categories with a meaningful order, so greater-than and less-than comparisons are valid.
Ordered numbers with equal spacing but no absolute zero; differences are meaningful, ratios are not.
Numbers with an absolute zero, so differences and ratios such as 'twice as much' are meaningful.
Data organised with tags or keys but without a fixed table schema.
Data with no predefined model, which must be processed before it can be charted.
The chain data, information, knowledge, wisdom, showing how analysis adds context and judgement to raw facts.