What is the most practical way to structure a big data for Tableau?

tableaucommunity@tableau.com — Wed, 11 Jun 2014 22:23:02 GMT

I have a big data and am struggling with structuring to an appropriate form to tackle it with Tableau. I would really appreciate some help here. I included a representative sample from it in the excel attached.

		SalesWeek	W6	W7	W8	W9
Family	Machine	ForecastWeek	W2	W2	W2	W2
BT1	Xc	forecast	61	62	62	61
BT1	Xc	sales	50	5	3	3
BT1	Xo	forecast	45	45	45	45
BT1	Xo	sales	44	40	42	39
BT2	Gt	forecast	28	29	28	28
BT2	Gt	sales	22	17	9	17

The attached file shows a flat table that belongs to weekly forecasts and sales for machines. For sales weeks (W6 to W9), I have multiple versions of forecasts made on forecast weeks (W2 to W5). I am trying to analyse performance of different versions of the forecasts at Family or Machine level.

How should I structure this data? I tried putting weekly forecasts to separate worksheets, and sales as a separate sheet. The challenge is there are 500+ machines, and over 10+ weeks of forecast versios exploding the dimensionality making this an intractable choice…

Thank you!

Iso

Content in Tableau Community Forums

What is the most practical way to structure a big data for Tableau?