About Us Icon About Us Icon Business Analyst Icon Business Analyst Icon CEO Icon CEO Icon Datameer Icon Datameer Icon Envelope Icon Envelope Icon Facebook Icon Facebook Icon Google Plus Icon Google Plus Icon Instagram Icon Instagram Icon IT Professional Icon IT Professional Icon Learn Icon Learn Icon Linkedin Icon Linkedin Icon Product Icon Product Icon Partners Icon Partners Icon Search Icon Search Icon Social Networks Icon Social Networks Icon Share Icon Share Icon Support Icon Support Icon Testimonial Icon Testimonial Icon Twitter Icon Twitter Icon

Datameer Blog

How-to: Use Sheet Dependencies to Visualize Workbook Data Relations

By on May 2, 2014

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. How-to: Use Sheet Dependencies to Visualize Workbook Relations

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:

How-to: Use Sheet Dependencies to Visualize Workbook Relations

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:

How-to: Use Sheet Dependencies to Visualize Workbook Relations

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

Connect with Datameer

Follow us on Twitter
Connect with us on LinkedIn, Google+ and Facebook

Joel Stewart