INSYNTIVEAcademy
IDEN
Sign inSign up

Module 04 · Master data & calendar

Bring in the three Master Data tables

Departemen, Kategori and Budget in one go through the Navigator, then loaded into the Data Model.

Step by step6 minLesson 15 of 37 Members

The Expense table only stores codes, such as D04 and K08. For the dashboard to say "Marketing" or "Iklan & Promosi" and to compare spending against the budget, you need three tables from Master Data.xlsx: Departemen and Kategori as code lookups, plus Budget with each department’s monthly budget. You will bring in all three at once, check their data types, and load them into the Data Model exactly like Expense.

Members only

Continue this course with a membership

Modules 1–2 of the Excel course are free. This lesson and 27 more are open to active members.

  • 5 steps with a numbered picture
  • All 37 Excel lessons, plus the Power BI, Tableau & Data Viz courses
  • A new Excel & dashboard template every day, with resell rights
  • Take paid client projects on the Project Board
Become a member & unlock allAlready a member? Sign in

One payment for 12 months, no automatic renewal. Back to the free lessons