Your Homework:

Build the First Draft of a Gold Layer for One Business Domain

Use Case: DAMA Blueberry Farms

At DAMA Blueberry Farms, we discovered that every department had a different definition of a blueberry. Marketing called them Premium Berries, Finance called them Revenue Units, and Operations called them Inventory. That’s when we realized we needed a Gold Layer.

DAMA Blueberry Farms grows, packages, and sells blueberries across North America. The company sells fresh blueberries directly to grocery chains, local markets, and distributors. Leadership wants to improve reporting, forecasting, and decision making by establishing a Gold Layer.

Your task is to identify for the Farm Sales Ops Data Domain:

  • Candidate Facts

  • Candidate Dimensions

  • Grain

  • Bus Matrix

Business Questions

  1. How many pounds of blueberries did we harvest this season?

  2. Which fields produced the highest yield?

  3. Which blueberry varieties are the most profitable?

  4. How much revenue did we generate this quarter?

  5. Which customers purchased the most blueberries?

  6. Which regions generate the most revenue?

  7. How much product was lost due to spoilage?

  8. Which employees harvested the most berries?

  9. How accurate were our harvest forecasts?

  10. Which products are growing the fastest?

Metrics

  1. Lbs Harvested

  2. Yields per Acre

  3. Harvest Cost

  4. Inventory on Hand

  5. Total Revenue

  6. Units Sold

Business Processes

  1. Blueberries are picked from fields.

  2. Harvested blueberries are cleaned, sorted, and packaged.

  3. Packaged blueberries are stored and tracked.

  4. Customer orders are received and fulfilled.

  5. Products are shipped to customers.

  6. Expected harvest yields and demand are estimated.

Business Entities Known

  1. Field

  2. Blueberry Variety

  3. Customer

  4. Employee

  5. Harvest

  6. Region

  7. Order

  8. Shipment