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:
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).
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.
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.
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 FEC's Public Data Sets. 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: