Practicing Exploring Data

On this Page
Docs Menu

The best way to learn Looker is to try to answer some questions. This page has puzzles that ask questions of our demo databases. To work with them, you'll need an account on learn.looker.com, Looker’s learning environment. Contact support@looker.com to get access.

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 explore.

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 sold?

Answer 4

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

Answer 5

6. Which brand has the highest sell through rate?

Answer 6

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

Answer 7

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

Answer 8

9. Which category of items has the most money tied up in inventory?

Answer 9

Still have questions?
Go to Discourse - or - Email Support
Top