Skip to content
Back to Data Analytics
PricingLog in

Data Analytics

Analytical data modeling

Design analytical datasets around a clear grain and business meaning.

With Zoonk, your plan starts at this chapter and fits your schedule.

Build my plan

Start free, no account needed.

Where this chapter sits in the course

Lessons

Chapter 17 of 30 · 6 short lessons · 24 min
  1. 1Table grain3 min
  2. 2Facts and dimensions3 min
  3. 3Natural and surrogate keys4 min
  4. 4Historical dimension attributes4 min
  5. 5Additive and non-additive measures4 min
  6. 6Challenge: Analytical data modeling6 min

What you'll learn

  • Define table grain and analytical keys
  • Distinguish facts, dimensions, and historical attributes
  • Choose valid aggregations for different measures

Your plan from this chapter

It follows the course from here, at your pace, with reviews before you forget.

Build my plan

Start free, no account needed.