My boss told me..

Posted on June 12 2014 in Tableau & Microsoft Dynamics

My boss indicated that my travel costs were a little high and it gave me the perfect opportunity to test Tableau in real life.

Please note that all numbers in this example are fictitious and any resemblance to real persons, living or dead, is purely coincidental.

  1. I found the General Ledger account where the travel expenses are posted in Dynamics AX.
  2. I selected all the rows and copied them with <CTRL><C>
  3. I saved the rows as an Excel file.
  4. I connected live to that Excel file in Tableau.
  5. Now I was ready to analyze.


Ledger account
First I selected Purpose and Amount:

Purpose
Then I added Name and Date and dropped Purpose on the color button on the Marks card:

travel2
Now I have an overview:

Color mark

If I want, I can analyze on my data only:

Keep Only

I can see the underlying data:

View data

travel6
And I can sleep peacefully because my travel costs have already dropped dramatically by 2014.

Dashboard

no comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>