This content, written by Josh Siegel, was initially posted in Looker Blog on May 16, 2014. The content is subject to limited support.
As data lovers building a platform for data analysts, it's a special kind of excitement when we see our customers coming up with novel use cases that leverage Looker's modeling layer and dashboarding features in clever ways. Here are some of our recent favorites:
1) Order lookup dashboard (E-Commerce)
In most businesses, it all comes down to the transactions. Whether a company's data resembles an e-commerce, marketplace, subscription billing, or mobile app model, what happens before and after a transaction is the key to growth. When you can get all the information about any transaction at your fingertips, you have a powerful tool. At one of Looker's e-commerce customers, a data analyst recently created a dashboard for the online marketing team. It's pretty simple: The user types in an order ID or related information, and Looker executes a few queries with that order as a parameter (and visualizes them when appropriate).
- Order details: What did the customer buy? This includes the image inline, price, category, and name of each item.
- Customer details: Who is this customer? Where does she live? How many purchases has she made over time (visualized) and what segmentation do we group her in?
- Path to purchase (clickstream): What was this customer's stream of events leading up to order? Did he click a Facebook ad, visit the men's category page, view four products, add two to his cart, then buy one a week later? In the 14 days leading up to the order, did he come in from a Google Display ad, a friend referral, and/or an e-mail marketing source?
The great thing is that none of these widgets is a dead end. If the Looker business user sees that an order came from an AdRoll ad, he can jump to the marketing source dashboard and look up details about that campaign's performance during the same period. Each answer might prompt another question, and that's exactly as it should be.
2) Back office tool integration (Financial Services)
Often companies search far and wide for integrated data solutions that will solve a niche case, such as fraud monitoring for peer-to-peer loans. The flexibility of Looker is great for this: They can model their data to help flag suspicious activity, surface trends early, and empower business users to explore data on their own.
One of our financial services customers uses Looker as an all-in-one source of answers and questions for the business. Through a Looker dashboard, they look up new loan applications and credit-line approvals, flag instances of potential fraud, link to external tools, and automate back-office actions—in a single browser-based application.
3) FEC donations (Public Data Set)
We like to demo Looker on real-world public datasets to show how flexible and easy it is to explore data. An example is the . Wil, one of our visualization engineers (and also a policy wonk), decided to build a Looker on FEC data. We can now explore all elections and campaign finance data in Looker, folding it, unfolding it, and refolding it in infinite new ways. Type in a state, party, or candidate name and explore all the data at your fingertips: