Hi
I am trying to analyze data from different datasources but within the same project for porject management reasons.
So I have different issues from Jira and issues from a 3D-modeling software for buildings and I want to make a combined analysis of all issues within the project. Both datasets have 'diciplins' which the issues are assigned to. However in Jira the diciplins can appear in 2 columns; one colum specifying From which diciplin the issue is craeted from and one columnt spcifying To which deciplin the issue is assigned to.
For ex. in Jira
- Issue 1 is created FROM the architect TO the electrician
- Issue 2 could be created FROM the electrician TO the architect (hence "From" is a column and "To" is another column in the Jira dataset and both columns can have the same value, e.g. architect, electrician, projectmanager, etc)
issues from the other dataset only include the Diciplin-column corresponding to the TO-column in Jira; e.g
- Issue 1 is assined TO the electrician
- Issue 2 is assigned TO the archiect
Furthermore the diciplines are not named the same in the different datasets. In Jira there is e.g. "architecht-A1"; "architecht-A2" (hence there are may be multiple architechts but named differently in the same dataset) and in the modelling dataset all architects are only named "A", which then would represent "architecht-A1" and "architecht-A2" from the Jira dataset.
Since my goal is to analyze all issues from both datatsets together I would create a table "DIM-Diciplines" and include all diciplines from both datasets and then assign each one to a new column which I name "Category". Thus, "architecht-A1"; "architecht-A2" and "A" are assigned to the same categoriy "Architechts"
However I can get it all to work in Power BI. So my question:
What do I do in the Jira dataset, since there I have colum "From" and "To" which both should be able to correspond to the same DIM-Diciplin table.
Is this possible, considering I later want to visulize both the "From" and "To" column" simultaniously?
Or should I rather create a DIM-FromDiciplin and a DIM-ToDiciplin? However then I would have 2 DIM-tables with the same information which seems quite useless, doesnt it?
Or should I maybe somehow use the unpivot function on the Jira-dataset first?
Am I on the right track?
Since I have confuced myself quite a lot now any tip will do 🙂
