# Verbetering: BI omgeving uitgebreid

**URL:** <https://praatmee.planaday.nl/t/verbetering-bi-omgeving-uitgebreid/215>\
**Category:** BI & Rapportage\
**Tags:** release, competenties, bi, powerbi, 202407\
**Created:** [31 juli 2024 om 11:17 UTC](https://praatmee.planaday.nl/t/verbetering-bi-omgeving-uitgebreid/215 "2024-07-31T11:17:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefan](https://praatmee.planaday.nl/user_avatar/praatmee.planaday.nl/stefan/32/5_2.png) [@stefan](https://praatmee.planaday.nl/u/stefan)\
**Post date:** [31 juli 2024 om 11:17 UTC](https://praatmee.planaday.nl/t/verbetering-bi-omgeving-uitgebreid/215/1 "2024-07-31T11:17:13Z")

</div>

> Release 202407.1.4, Artikel aangepast op 1/8

Zojuist hebben we een update gedaan aan de BI omgeving!

We synchroniseren nu nog meer informatie, zodat je nog betere dashboards en rapportages kan maken!

Het datamodel wat nu beschikbaar is, is het volgende:

 ![image](https://praatmee.planaday.nl/uploads/default/original/1X/c5806a8ef6abcd1e19baacdcb458e4796842d0ba.png)

| Table | Description |
| --- | --- |
| company | Companies |
| company\_company | Table to determine the relation between companies (vestiging/moederbedrijf) |
| company\_extrafields | Extrafields for companies |
| competence | Competences |
| course | All planned courses |
| course\_company | Companies which are connected to incompany courses |
| course\_daypart | Dayparts belonging to courses |
| course\_extrafields | Extrafields for courses |
| course\_label | Labels connected to courses |
| coursetemplate | Coursetemplates |
| coursetemplate\_daypart | Dayparts beloning to coursetemplates |
| daypart | Dayparts |
| daypart\_extrafields | Extrafields for dayparts |
| daypart\_instructor | Instructors plannend on a daypart |
| daypart\_label | Labels connected to a daypart |
| daypart\_location | Locations planned for a daypart |
| daypart\_material | Materials reserved for a daypart |
| daypart\_student | Students plannend on a daypart |
| daypart\_task | Tasks to do for a daypart |
| employee | Employees of your own company |
| employee\_competence | Competences of own employees |
| employee\_extrafields | Extrafields for own employees |
| instructor | Instructors |
| instructor\_competence | Instructors compentences |
| instructor\_extrafields | Instructors extrafields |
| label | Labels |
| location | Locations where coursedayparts can be given |
| material | Materials which can be reserved for dayparts |
| student | Students (both private and from companies) |
| student\_code95 | Code95 periodes/amount for a student |
| student\_competence | Competencens for a student |
| student\_course | Followed courses by students (history) |
| student\_extrafields | Extrafields for students |
| task | Tasks which can be done for dayparts |

---

<div class="post-metadata">

**Author:** ![Priscilla-PCB](https://praatmee.planaday.nl/letter_avatar_proxy/v4/letter/p/7ea924/32.png) [@Priscilla-PCB](https://praatmee.planaday.nl/u/Priscilla-PCB)\
**Post date:** [1 augustus 2024 om 09:10 UTC](https://praatmee.planaday.nl/t/verbetering-bi-omgeving-uitgebreid/215/2 "2024-08-01T09:10:54Z")

</div>

Mag er ook een daypart\_extra fields bijkomen?

---

<div class="post-metadata">

**Author:** ![stefan](https://praatmee.planaday.nl/user_avatar/praatmee.planaday.nl/stefan/32/5_2.png) [@stefan](https://praatmee.planaday.nl/u/stefan)\
**Post date:** [1 augustus 2024 om 11:46 UTC](https://praatmee.planaday.nl/t/verbetering-bi-omgeving-uitgebreid/215/3 "2024-08-01T11:46:03Z")

</div>

Scherp! Deze was ik inderdaad vergeten.

Ik voeg de volgende ook nog toe:

- company\_extrafields
- course\_extrafields
- daypart\_extrafields

Ik pas bovenstaand artikel aan met nieuwe afbeelding + tabel!