Skip to content
ACD-310 · ingestia.biPreviewshared across tracks

Semantic model and dimensional modeling

Course ACD-310 of the Ingestia Academy — 10 lessons, 4.5 h of work.

Level
Intermediate
Estimated load
4,5 h of dedication
Video
10 lessons · 15 min of video

Lessons

  1. One truth: measures hold in BI and in AIExplain the central model, releases, grounding5 minLearnPreviewvideo in production
  2. Fact, dimension, grainIdentify Aurora's fact/dimensions/grain7 minOperatePreviewvideo in production
  3. Aurora star: `vendas` + 4 dimensionsBuild the star model9 minOperatePreviewvideo in production
  4. 1-N, N-1, N-N and anti-fan-outPredict when a sum duplicates8 minOperatePreviewvideo in production
  5. Bidirectional filter, role-playing relationships, M:N bridgeApply role-playing (order × delivery)9 minOperatePreviewvideo in production
  6. Calendar; fiscal, 4-4-5, time zoneCreate a calendar and mark `dateTable`8 minOperatePreviewvideo in production
  7. Calculated columns, hierarchies, data categoryBuild the Região > UF > Filial hierarchy7 minOperatePreviewvideo in production
  8. Folders, certification, dependency graphOrganize measures; read impact7 minOperatePreviewvideo in production
  9. Owner, approver, certification, releasePublish a model release6 minOperatePreviewvideo in production
  10. Visual diagnosis and common mistakesFix orphan keys, nulls, ambiguity6 minOperatePreviewvideo in production

How this course is graded#

Every lesson has a quick check (2 to 3 questions, graded on the server). The course counts as completed when every lesson is completed. The credentials this course feeds require, besides the courses, the exam and the hands-on challenge described on the certification page.

After this course