0 Replies Latest reply on Feb 12, 2014 2:40 PM by Fareeza Khurshed

    Optimal Data Structure when coming from a RDBMS

    Fareeza Khurshed

      So this is a made up example, but I think it approximates my actual data/issue.


      I have 3 tables of information, 2 of which are lookup tables, probably in a SnowFlake Pattern.


      Table 1 - Recipe List - List of recipes with information on the recipes, serving size, calories

      Table 2 - Ingredient List - List of ingredients for recipe's in Table 1, includes items/quantities.

      Table 3 - Food Diary List - List of consumed recipes and the servings consumed.


      Some of the questions I'm looking to be able to answer are:

      How many days did I eat X? Where X is Carrots
      How many days did I eat X and Y?
      How many days did I eat X or Y?

      How many total calories (full meals) did I consume when I ate carrots?


      I'm looking for advice on how to structure my data to bring it in to Tableau. References and links are appreciated.


      Sample data is in attached Excel file.