I have imported Jira Align data to a visualization tool (ThoughtSpot) but I am having a hard time connecting the tables and having correct joins due to which I am facing duplication of data.
I need help knowing how the tables are connected to each other and using which joins.
@Aniket Mallick On the Jira Align Knowledge Base you can download the Enterprise Insights data schema document. You will need to create a login through the Sign In button. The schema document has a tab called FK Mapping which provides the Foreign Key mapping relationships. If you are seeing duplicates it could be that there is a circular relationship in your mapping. An example of this is if you join the Feature table on the Program Increment table and then join the Feature table with the Story table. Then join the Story table to the Program Increment table. Some data visualization software will display a relationship be a circular relationship has been established through the Program Increment table. I know that Power BI doesn't handle these types of circular relationships and Tableau seems to handle them a little better. You may need to write custom SQL in Thoughtspot to prevent these types of circular relationships.
The roadmap challenge for large scale agile enterprises Regardless of the agile framework you use, the agile enterprise has a massive scale with the challenge to connect hundreds of teams and thous...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events