1 of 1 people found this helpful
In general Tableau runs much faster when using tall narrow data sets over short and wide ones. Having fewer columns also makes it easier to use in Tableau. The first thing I would do before flipping all the content is check to see what you actually need to use in your reports. Leaving unnecessary content behind can save space and help speed things up. Looking at the calculation you need to use I would lean towards keeping those columns side by side rather than summing up separate chunks of the same column to divide against each other. I would also consider if there are columns that can be combined before bringing in Tableau or if the data set can be rolled up to the hour or day level. Without seeing more of the data set all I can honestly give are general guidelines.