![]() The four Sales tables can be analyzed independently, but if they are unioned, we recommend renaming the union “Sales” or something similar.We recommend renaming the logical table of Book joined with Info “Book” or something similar.The Series table can only be used once the Info table is part of the data source.The Book and Info tables can be related or joined, but it must be on the calculation BookID = +.The Publisher and Sales tables must be related to the Edition table.The Staff Comment field contains summaries and reviews for some of the books.The ItemID and OrderID fields are hierarchical.The ISBN is represented in the barcode and is tied to the price. ISBN stands for International Standard Book Number and is a unique 13 digit identifier given to each edition of a book.Everything other than “Hardcover” could be considered “Paperback”. The Format field is a detailed breakdown of the format.The Rating field in the Ratings table is on a scale of 1-5 with 5 being high.Some fields may need a little explanation. An edition is a physical version of the book, with attributes such as format (hardcover, paperback), publication date, and page count. A book is a concept with attributes such as author, title, and genre. Note: A central concept for this data set is the idea of a book versus an edition. tdsx and double click it (or select it then click Open).īookshop consists of 13 tables, combined in the following manner: ![]() In the Connect pane on the left, choose the More.tdsx file that adds the library tables to Bookshop.tdsx (includes all tables). MinimalBookshop.tdsx - the same tables as Bookshop.tdsx but without any metadata or cleanup.tdsx file with the related data source already built and some metadata customizations added BookshopLibraries.xlsx - additional library tables that introduce many-to-many relationships (contains only the additional library tables). ![]() ![]() You can choose to download the raw data and start from scratch building your own data model, or download one of the pre-built data sources to jump right into analysis with relationships. The Bookshop data set was created for Tableau Desktop 2020.2 to showcase relationships-the new data modeling capabilities for combining data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |