Glossary term
What is Lookup table?
In Apex Flow Academy, "Lookup table" means: A table that describes things, such as products, stores or dates. Each row is one thing, listed once. It is taught in Power BI: Build Dashboards People Actually Use. Related terms include Fact table, Key, Data type and One-to-many relationship. Every Apex Flow Academy course lists the official sources it checked.
- 1 course teaches it
- plain-word definition
The facts
What is Lookup table?
A table that describes things, such as products, stores or dates. Each row is one thing, listed once.
Where is Lookup table taught?
Lookup table is defined in Power BI: Build Dashboards People Actually Use.
Which lessons cover Lookup table?
These lessons name it in their title or objectives:
- Power BI: Build Dashboards People Actually Use, lesson 3.1: Why Separate Tables: Facts and Lookups
Which terms are related to Lookup table?
Next to Lookup table in the course glossaries: Fact table, Key, Data type, One-to-many relationship, Append, Star schema, Staging query and Date table.
Fact tableKeyData typeOne-to-many relationshipAppendStar schemaStaging queryDate table
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 Lookup table?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner level:
- Power BI: Build Dashboards People Actually Use: You have access to a Windows computer; no coding or database experience is needed.