Supply Chain Analytics and Enterprise Systems Vocabulary

Vocabulary practice flashcards covering supply chain analytics, data governance, ERP/MRP systems, SQL queries, Excel functions, and inventory planning principles.

Descriptive Analytics

Focuses on summarizing and describing historical business data to make the past legible and understand what has happened, without recommending specific actions.

Predictive Analytics

Utilizes historical data, statistical models, and machine learning techniques to forecast future outcomes and return probabilities or expected values.

Prescriptive Analytics

Recommends optimal courses of action by simulating various decisions and balancing constraints and objectives to determine concrete choices.

Fit-for-Purpose Data

Data that is clean, accurate, timely, and structurally adequate to directly answer a specific business question or problem being investigated.

Data Relevance

Ensuring that collected variables and metrics align with the operational context, avoiding noise and irrelevant data streams that skew analytical insights.

Executive Dashboards

Dashboards tailored for high-level leadership that focus on aggregated, macro-level Key Performance Indicators (KPIs), long-term strategic trends, and financial health.

Operational/Tactical Dashboards

Dashboards designed for floor managers and daily operators that provide granular, real-time metrics to track day-to-day workflow execution and bottlenecks.

Data to Action Framework

A progression pipeline moving sequentially from raw Data to Information, which synthesizes into Insight, and ultimately culminates in operational Action.

Problem Recognition

The critical first step in the problem-solving lifecycle of identifying a performance gap or an unexpected deviation between actual business results and targets.

Data Lakes

Centralized repositories that store massive volumes of raw, structured, and unstructured data in a shared enterprise environment to break down departmental silos.

Shockproof Supply Chain Strategy

A strategy integrating cloud-based technology, deep visibility, and proactive risk management to absorb market volatility and maintain business continuity.

Procure-to-Pay Process

The end-to-end procurement cycle that begins with identifying a need and generating a purchase requisition, followed by purchase order creation, goods receipt, invoice verification, and vendor payment.

Three-way Matching

A financial control check where accounts payable verifies that details on the Purchase Order (PO), Goods Receipt Note (GRN), and Vendor Invoice align before releasing payment.

Material Requirements Planning (MRP)

A computational engine that automatically calculates what materials are needed, how many are needed, and when they are needed to support the master production schedule.

Time-phasing and Lead-time Offsets

An MRP logic that breaks demand down across future time periods (time-phasing) and works backward from required delivery dates by subtracting item lead times (lead-time offsets) to determine component order release dates.

Manufacturing Resource Planning (MRP II)

An expanded closed-loop planning system that integrates capacity planning, labor, machine scheduling, and financial accounting with traditional material requirements planning.

Demand Aggregation

Consolidating consumer purchasing data and order volumes across thousands of retail stores to present massive, unified demand signals to vendors.

Retail Link

A collaborative extranet platform that connects suppliers directly to real-time point-of-sale (POS) data to eliminate information silos.

Automated Replenishment System (ARS)

A backend system that automatically triggers purchase orders to suppliers based on inventory thresholds and actual sales consumption data.

INNER JOIN

A relational SQL join operation that returns only the rows where there is a matching value in both tables being joined.

LEFT JOIN

A relational SQL join operation that returns all records from the left table and matched records from the right table, inserting NULL values where no match is found.

Header/Detail Relationships

A hierarchical parent-child structure in relational data where a single header record links to multiple detail rows.

COUNT vs. COUNTA

COUNT tallies only cells containing numbers, whereas COUNTA counts all non-empty cells regardless of data type.

Paste Values

An Excel operation that transforms active formulas into static data to protect historical records from dynamic recalculation for point-in-time reporting.

Freeze Panes vs. Split

Freeze Panes keeps key header rows or columns locked while scrolling, whereas Split divides the worksheet into separate, independently scrollable quadrants.

XLOOKUP

An Excel lookup function that searches a range or array and returns the corresponding item from another specified range or column.

INDEX Function

An Excel function that retrieves a specific value or reference from a table based on explicit intersecting row and column numeric coordinates.

Reorder Point (ROP) Planning

A planning logic that triggers replenishment orders automatically when inventory drops to a pre-set threshold based on lead time and demand rate.

Safety Stock

Core master data settings configured in ERP systems to buffer against demand uncertainty and lead-time variability.

Minimum Order Quantity (MOQ)

Vendor-imposed restrictions that dictate purchasing batch sizes, which can drive up inventory levels if set too high.

Parameter Governance

The formal oversight, approval workflows, and auditing processes required to maintain accurate master data settings across an organization.