Forum Discussion
Solved
Denormalized table for project data
Hello Gurus I have an excel file as an input with project data. The data shows how many departments have worked on the project. The raw data looks like this: Project name Project description ...
Ahh, i see.
I uploaded a .pbix here.
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
NickolajJessen I have division-department tables in the datawarehouse like mentioned in the question.
| Division_PK | Division |
| 1 | Division IT and digital |
| 2 | Division Management and consultancy |
| 3 | Division bank housing purchase and business development |
And we have table also for department which connects to division.
| Department_PK | Department | Division_FK |
| 1 | Digital customer services | 1 |
| 2 | Real Estate Management | 2 |
| 3 | ABC Bank | 3 |
So is it possible to map the departments I get in the project with the table in DWH and create the list? Then with that I can get the corresponding division via Division_FK in the department table.
PP
Ahh, i see.
I uploaded a .pbix here.
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
Thank you so much! Will this work with my original department table with 590 rows?
Only one way to find out 😉