Glossary term
What is Key?
In Apex Flow Academy, "Key" means: A column that should be different on every row, such as order_id, or that links two tables, such as customer_id. It is taught in Data Analytics From Scratch: Answer Real Business Questions and Power BI: Build Dashboards People Actually Use. Related terms include Grain, Data dictionary, CSV file and Raw data.
- 2 courses teach it
- plain-word definition
The facts
What is Key?
A column that should be different on every row, such as order_id, or that links two tables, such as customer_id. (From Data Analytics From Scratch: Answer Real Business Questions. 1 other course defines it for their own subject, so each definition follows.)
What does Key mean in Data Analytics From Scratch: Answer Real Business Questions?
A column that should be different on every row, such as order_id, or that links two tables, such as customer_id.
What does Key mean in Power BI: Build Dashboards People Actually Use?
A column that links two tables, such as ProductID. On the one side of a relationship, its values must be unique.
Where is Key taught?
Key is defined in Data Analytics From Scratch: Answer Real Business Questions and Power BI: Build Dashboards People Actually Use.
Data Analytics From Scratch: Answer Real Business QuestionsPower BI: Build Dashboards People Actually Use
Which lessons cover Key?
These lessons name it in their title or objectives:
- Data Analytics From Scratch: Answer Real Business Questions, lesson 6.3: Package a Repeatable Case Study With an Answer Check
Which terms are related to Key?
Next to Key in the course glossaries: Grain, Data dictionary, CSV file, Raw data, Seed, Fingerprint (hash), Synthetic data, Personal data, Lookup table and One-to-many relationship.
GrainData dictionaryCSV fileRaw dataSeedFingerprint (hash)Synthetic dataPersonal dataLookup tableOne-to-many relationship
The hard questions, answered straight
Bold questions people really ask. Each answer comes from the course data or a settled Academy fact.
Do I need experience before I learn Key?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner level:
- Data Analytics From Scratch: Answer Real Business Questions: You can save and find a file on your computer.
- Power BI: Build Dashboards People Actually Use: You have access to a Windows computer; no coding or database experience is needed.