Hi Mynda
I am trying to make a dynamic profile of departements at my place of work.
I want to combine HR data ( Age groups, gender, departments and so on ) and production data.
So far I have managed to do the HR part with slicers and all, but despite quite a number of attempts adding production data, my slicers doesn't work with these. I get the right numbers on my production data, but slicers doesn't work, even though the pivot tables are chosen.
HR data are all SAP data - and from there everything is split up into seperate databases ( Here 6 different dataset ). Only two things are identical across data soruces - "code 02" representing departments, and "MA nr." is the employee #.
"Code 2" is also used in production, but no matter how I try to connect things in the data model, my slicers only works with HR data. I tried to create a "Code 03" with "A-" & "Code 02", but no luck.
Could you please have a look and give me some advice to what has to be different in my data model.
I have attached a picture of the Data model, where the faded dimensions are from the "many" end of a connection.
A few translations from danish to english:
"alder" is age
"medarbejder" is employee name
"MA nr" is employee #
"personalegruppe" is employee group
"POLSAS" is a department code in the production data
"Køn" is gender
"Personaledelområde" is the upper level in the organisation
"Kode 02" is a code for departments/ sections - used in both HR and production data
My first dataset from production is "Organisation - Sager" with number of products in store ( "Beholdning" ) and the average age of these ("Gns. alder" ). Tried a number of ways to connect to the data model - here with my "Kode 03" solution.
I really hope, you can help me here and give me advice on how to bring multiple data sources together and use slicers across data.
Thanks a lot
Erik
Hi Erik,
No image attached. Be sure to click the 'start upload' button after choosing the image file. Note: I suspect the image won't be enough for me to diagnose and I'll need to see the file or at least a smaller sample mock up of the file.
Mynda
Hi Mynda
With a lot of trial and error, I finally succeed in finding a solution that works. I have shown it to upper management, and it has already been approved to be implemented. 
I reduced the number of tables and files in the data model, removed some columns in tables ( duplicate data to other tables ) and made sure never to use values from the "many" end of a relation in the data model.
I must admit though, that I don't fully understand the data model - what works and what doesn't. But I guess that comes with using it and getting experience.
To mention one specific thing of what still puzzles me - combining data from full data sets / tables with aggregated data allways seem to cause problems for me. So for now I choose only one of the two in my Power Query solutions.
By now I only have one unfinished lesson to go, and after that I plan to take your Power Pivot course.
Erik
Glad you figured it out. All that trial and error leads to far better learning, so while it may have been frustrating at times, it's worth it 🙂
The data model and multiple full data sets will become clearer in the Power Pivot course as I have a specific topic on working with multiple fact tables using a budget and actual fact table example.
Mynda
Allready on my next project at work - budget on salary expenses for 600 + emplyees for the next 4 years
I look forward to your Power Pivot course
Erik
