BI: Lessons Learned

I have been asked for input and resources in reference to securing my Tableau Specialist Certification, so I thought it would be best to write about it in a blog. I would register for this test NOW as the SPECIALIST cert if 50% off until the 1 st of the year (end of 2018).   You can register now and take it months later if you want.  Essentially, tools I used can be broken into these pieces; The hard part right now is the specialist cert is so new there are not a ton of resources for just the specialist but more of the Desktop Qualified Associate.   So hopefully this will help.    .        Classes    .        Resources           Prep for the certification I.Classes : I did not take any of the paid Tableau courses but did take several courses through Linkedin and Udemy. I like Udemy more just because I can go back any anytime and review those where Linkedin wants you to be a premium member to view the classes. Below you will see the courses, but I do not think you

This week I am breaking all the rules on Color Blindness ! NOTE: It is not advised to use Red & Greens in your viz's as it is very difficult for anyone who has color blindness to be able to read.  I decided to just go with the Christmas colors so I apologize to any color blind readers out there. Here is my final Viz; What I learned this week; 1. how to put a viz in side a viz tooltip 2. how to do a formula that looks at a Year over Year comparison (YOY) 3. Struggled with a Dual axis reference line and doubling. 1. Tips of Viz inside of Viz; This is what I ended up with for the tooltip This is what is inside of my tooltip; tricky thing here is that I formatted the sheet by size. <Year> Avg Spend: <SUM(Christmas spend in US$)> | YoY Change: <AGG(YoY Change)> <Sheet name="Trend" maxwidth="400" maxheight="200" filter=""> 2 . Formula for YOY % ages. This is the formula I used for YOY comparisons to j