Excel Cannot Achieve (probably) -- Show the difference from Previous Month.

i was asked by my friend. "Teach me the difference from Excel".

........

It's way different, anyway, try to explain with using very simple example.

We use same data which were posted the otehr day.

Tableau View:

f:id:skn_0410:20160213114444p:plain

Excle View:

f:id:skn_0410:20160215233358p:plain

To add lavel, already had problem which mean I needed to add 5 different lable for each.. I gave up to modify the number format x 5 times....

Plus, I could not find a way to add sum of each month on tpo of Bar chart, which we already done in Tableau last week. 

Anyway, up to his point no significant difference.

 

Now we want to show the diference from last month.  Let's do that in both softwares.

 

Excel:

f:id:skn_0410:20160216000233p:plain

f:id:skn_0410:20160216000310p:plain

f:id:skn_0410:20160216000419p:plain

End Results by Excel

f:id:skn_0410:20160216000511p:plain

 

I don't know the way to show vertical ordered two graphs, but only horizontal ordered two graphs.

 

Tableau :

f:id:skn_0410:20160216000842p:plain

f:id:skn_0410:20160216000923p:plain

f:id:skn_0410:20160216000952p:plain

Concept is same as Excel Pivot.

Then drag to Rows.

f:id:skn_0410:20160216001300p:plain

End Results in Tableau.

f:id:skn_0410:20160216001350p:plain

Side by Side (Excel vs Tableau)

f:id:skn_0410:20160216001628p:plain

 

Further more,

I tired to compare each company's difference from previous month.

I even don't want to create something with Excel for this request here....

It requres 3 company x 2 (standard, delta) graphs.....

On the other hadn with Tableau, just drag "Company" on Row.

f:id:skn_0410:20160216002017p:plain

 

Now you can get the Sales by month, diffdrence from previous by Company.

With same scale of "Y-axis" automatically. 

(<== this is important for us, in the past in my company , we wasted time to discuss "BiG' delta of "Small" absolite value.   But if you need to create indivicula chart independently. this is also pretty troublesome.)

f:id:skn_0410:20160216002133p:plain

You can find couple of highlights immediately from these charts.

Company A is pretty stable acroos products, but three data point have big delta.

Company B has big fructuation on Prod.3.

Company C has big fructuation  on Prod.4.

f:id:skn_0410:20160216002345p:plain

 

Furtehrmore, with selecting "Prod.5"(or any other dimension) in color legend, you can highlight "Prod.5" in the graph.

f:id:skn_0410:20160216003021p:plain

Above is just one simple example we don't want to struggle with Escel any more,  : ) 

And Tableau became Savior to me.

<<Link to workbook on Tableau Public>>

Let's play aruojnd and Enjoy!