Paul’s first task was to replace the 45-page PDF that arrived in people’s inboxes every morning. It showed the most recent sales numbers by divisions, by business line, and by facility.
Paul created a viz that not only contained the answers in the spreadsheet but also enabled people to ask follow-up questions. The viz also had row-level security, meaning teams would only see data they had permission to view.
Once people realized they could ask their own questions of the data, the response was almost immediate, says Paul.
“We started getting phone calls: ‘Can you add this filter?’ ‘I want to see the data in this fashion,” says Paul.
With different requests pouring in, Paul tried to create a visualization that would serve all of their needs. And here’s what he came up with:
Click through the sequence in the upper-right corner to see the viz come alive.
In short, Paul realized there is no perfect visualization. It’s a myth, a unicorn.
“What we've found is that no matter what visualization you put out to 170 distinct manufacturing facilities, someone's always going to want to see the data in their own way.”
It was clear people wanted to see the data in their own ways. So Paul, with the help of several analysts, created a library of viz templates containing vetted data. Using web authoring, people can use these vizzes as a starting point for their own analysis and share their findings.
“We can give them a data set with predefined measures and dimensions, and they can build their own intelligence through the web-authoring tool. And it’s one single source of truth,” says Paul.