I just joined Datameer about a month ago and have come across a number of features that I think are really cool and helpful. However, I wanted to share one in particular that I think is a “hidden gem.” I find that when I’m working in a workbook that has a number of different sheets, it’s sometimes hard to remember how the data from each sheet relates to the data in other sheets. Sure, I have a descriptive title, but the order of the sheets is not immediately clear.
Enter Sheet Dependencies. As you can see looking at the tabs in the image above, I have a 11 different sheets. When I click on the Sheet Dependency icon, I can now visually see how each worksheet relates to other worksheets in a single workbook:
Now I can clearly see which sheets are referenced by one sheet or another. Note that if a join is used, both parent sheets are clearly shown:
Check out the video tutorial for more guidance and also remember to sign up for your free Datameer trial here: http://www.datameer.com/datameer-trial.html