How do primary and foreign keys differ?
A primary key uniquely identifies a row. A foreign key refers to a key in another table so related records can be connected.
Study Data Foundations and Quality with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
How do primary and foreign keys differ?
A primary key uniquely identifies a row. A foreign key refers to a key in another table so related records can be connected.
How should an analyst communicate a data-quality issue?
Report the issue and its consequence: for example, missing product categories may make category-level totals too low. Document the treatment rule and assess its effect.
How do completeness and accuracy differ?
Completeness concerns whether required records and fields are present; accuracy concerns whether values reflect the real entities or events. Complete data is not necessarily accurate.
Why might purchase records be unsuitable for studying all customers?
A transaction source may reliably record completed purchases but omit people who never bought. Its suitability depends on whether the question concerns purchasers or a broader population.
How should the product code `00127` be interpreted?
Treat `00127` as a text identifier, not a quantity. Storing it as a number could remove its leading zero or invite meaningless arithmetic.
What does completeness measure in data quality?
Completeness asks whether the required records and fields are present. It does not show whether the values present are accurate.
What happens to grain when customer records join to many orders?
A customer with many orders appears in multiple joined rows. The result is at the order grain rather than one row per customer.
Why distinguish missing values from zero and empty strings?
A missing value, zero, an empty string, and “not applicable” can mean different things. Do not silently treat them as equivalent.
What does grain tell you about an order-line table?
Grain is what one record represents. If each row is one order line, counting rows counts lines, not orders; an order may contain several lines.
How should questionable data values be handled?
Do not automatically delete or fill questionable values. Document the treatment rule, assess its effect, and retain information needed to explain the result.
What should you examine to judge whether a data source fits a question?
Assess the source’s scope, collection method and timing, update frequency, definitions, units, filters, transformations, and grain against the intended question.
What does a relational table’s schema document?
A schema documents table and column names, data types, and often rules such as whether values may be missing or must be unique.
Learn how entrepreneurs identify meaningful customer problems, evaluate potential solutions, and use evidence to decide whether and how to pursue a venture.
Review how globalization shapes international business through cross-border connections, institutions, technology, economic forces, and risks.
A medium-difficulty quiz on applying job-related selection practices, making documented hiring decisions, and planning effective onboarding.
Learn how to identify employee learning needs, design and deliver suitable training, and evaluate its effects on learning and workplace performance.
Learn how to identify employee development needs, design and deliver suitable training, and evaluate whether learning transfers to work.
A 14-question quiz on mortgage structures, loan costs, amortization, and real estate financing. Questions progress from core concepts to calculations and applied analysis.
Learn the stages of real estate development, from site selection and feasibility through construction, opening, and operations.
A medium-difficulty quiz on applying the stages, decisions, and key concepts involved in real estate development.
Learn how to select transportation modes and carriers, plan shipments, compare total logistics costs, and measure transportation performance.
Review the principles and practices that support effective communication, employee engagement, fair conflict resolution, and collective labor relations.
Learn how to design and coordinate international operations while balancing efficiency, local responsiveness, resilience, supply-chain risk, cross-cultural partnerships, and responsible business conduct.
A medium-difficulty quiz on organizational culture, change, design, and organization development. Apply the concepts to workplace situations.