Look & Tell London - YPlan on Looker
"The Yplan app helps mobile consumers find things they want to do — tonight, next week, next month — and book them on the spot. Across the company, Yplan has people who are trying to make the product better, others who are trying to find the right consumers to market to, and others who are trying to get a grip on profitability. All of them have really good questions. None of them want to work in SQL. In this presentation, Richard Mapes, Director or Data Science and Analytics at Yplan, talks about how Yplan uses Looker to make data available — and understandable — throughout the company. He explains the techniques they use to present data, including: • Minimizing the number of entities, so there's only one route to every query • Reshaping the data into a form that makes sense to the business user • Optimizing query performance using persistent derived tables • Creating separate dashboards and explores, so users aren't overwhelmed by irrelevant information "