Duplicating Datasources for Fun and Profit

Posted on Leave a commentPosted in Uncategorized

This short post was inspired by a Tableau Forum post forwarded to me by Wilson yesterday: https://community.tableau.com/thread/239017 To Summarize: I want to select a month in a time series view and use it to see that month in comparison to other months. This sounds simple but because of the way filter actions work it can be tough to achieve. Basically, a filter action restricts the target views to only the data contained in the selection you made – that means when we pick one month, we lose the context required to do month-over-month comparisons. There are some ways re-design the dashboard so it does what we want – We could require the user to select two months (by clicking-and-dragging or holding down the ctrl key). That works, but it could be a little confusing for our end user. Or, we could use quick filters or parameters to control the target view in a different way than by using filter actions. Clear directions on the dashboard would make this easy to use. But it might not be as delightful as clicking directly on the visualization. Finally, we could write an L.O.D. expression – the FIXED command operates before filters on the target view, meaning if we’re clever […]

The Subject-Oriented Data Mart

Posted on Leave a commentPosted in Uncategorized

In my last post I mentioned the “subject-oriented data mart” as a useful concept to understand when thinking about Tableau Server. This is not a new term – the idea of a Data Mart has been present for decades in the form of small databases, cubes, or even applications that are built for the exploration or analysis of a particular subset of an Enterprise’s data. However, I think the term takes on new meaning and importance when applied to the concept of Tableau. A subject-oriented data mart both aids in logistical challenges with the structure and exploration of heterogeneous data and allows businesses to put rules in place. This allows everyone to explore and make decisions based on data without the harsh limitations that keep people from real insight. Common Challenges You probably already know the challenge – business people turn to tools like Tableau because traditional reporting through B.I. platforms doesn’t answer their questions. Tableau offers the flexibility that they are used to experiencing with tools like Excel, but business users often prefer it because of its ease of use and ability to make beautiful graphics. Technology teams like the idea that Tableau ties back to their data warehouse, […]