Looker Puzzles

  • 23 March 2015
  • 0 replies
  • 21 views

The best way to learn Looker is to try to answer some questions. This page has puzzles that ask questions of our demo databases. Try to answer the questions before clicking on the answer links.


Ecommerce Store


The following puzzles use Looker’s demo ecommerce database. We’ll start with Inventory. You can answer the set of questions below by using the Inventory Items view.


1. How many inventory items have we ever had in inventory?


Answer 1


2. How many different products have we ever had in inventory?


Answer 2


3. How many inventory items have we ever sold?


Answer 3


4. How many inventory items that we bought in 2012 have been sold?


Answer 4


5. Which category of item has the highest sell through rate (percent sold) for 2012?


Answer 5


6. Which brand name with more than 100 items in inventory, has the highest sell through rate?


Answer 6


7. How much money do we have tied up in inventory?


Answer 7


8. Which category of items has the most $$ tied up in inventory?


Answer 8


0 replies

Be the first to reply!

Reply