The Scattered Treasure Map (When Nobody Can Find Anything)
The Problem
Your analytics solutions are everywhere. SharePoint folders 47 levels deep. Email attachments from 2019. That one guy's personal portal. Custom apps nobody remembers building. A user needs sales data and has to check 8 places—and still isn't sure they found the right one. It's like running a retail store where products are randomly scattered across 12 warehouses with no inventory system. Users waste hours hunting. Your team fields the same "where do I find X?" questions 50 times a week. Meanwhile, great solutions sit unused because nobody knows they exist.
The Principle
Build one front door. Amazon doesn't make you search 12 websites to buy a book. Create a single analytics portal with search, filters, categories, and ratings—just like eCommerce. Every solution in one catalog. Users search once, find it, done. Track what people search for (reveals gaps). Track what they click (reveals value). The magic happens when finding analytics becomes as easy as online shopping. Think retail: customers need one store, one search bar, instant results.
3 Steps to Take Action
- 1
**Audit the Chaos** List every place analytics lives today: - SharePoint sites/folders - Email distribution lists - Custom portals - BI tool folders - Network drives - Wikis/intranets Count total solutions. Ask: can a user find what they need in <2 minutes? If no, you have a scattered treasure map problem. Track 'time to find' for 10 common requests. If average >5 minutes, build the catalog.
- 2
**Build the eCommerce Catalog** Create one analytics portal with: - Search bar (like Amazon) - Filters (department, topic, data source, tool) - Cards for each solution (title, description, rating, thumbnail) - Categories/tags - 'Recently viewed' and 'Popular this week' Migrate or link everything into the catalog. Don't move files—just catalog them with metadata and links. Test with 5 users: 'Find the sales dashboard.' Time them. Iterate until <2 minutes.
- 3
**Track Everything Like eCommerce** Instrument the portal: - Who searched for what (reveals gaps) - Who clicked what (reveals value) - What didn't get results (missing content) - Star ratings and reviews (crowdsource quality) Build a 'sales dashboard' for your analytics: - Solution count - Search volume by term - Click-through rate - Most/least used solutions Review monthly. Kill unused content. Build solutions for top un-fulfilled searches.
💡 Inspired By
A major bank's eCommerce-inspired analytics portal (2014-2016). Borrowed from Amazon, Walmart, Target—the idea that customers need one store, not a scavenger hunt.
This is what Analytics Pitfalls & Principles is about: people helping people.
In Practice
A major bank's BI team had analytics scattered across SharePoint (12 sites), email distribution lists (47 active), custom portals (6), and BI tools (8 platforms). Users couldn't find anything. Team spent 60% of time answering "where's the X report?" Built one eCommerce-style portal: search bar, department filters, star ratings, detailed descriptions. Trained users: "Pretend you're shopping for reports." Usage tracking showed what people searched for (product gaps) and clicked on (valuable content). Time-to-find-report dropped from 45 minutes to 2 minutes. Support tickets dropped 73%. Best part? Users started rating and reviewing reports, crowdsourcing quality signals. One catalog, infinite value.
