Em: I'm tired a lot! I workout when kids are asleep. Husband watches the kids when I run on Saturday morning. I blog or viz on the weekends when when the kids go to bed. However, I never have enough time and most of my viz stuff takes forever to finish because of such little time I have to work on it. When it comes down to it, I like to keep busy (Emily does mean industrious) and I know that I'm not going to be able to do everything well, but it doesn't mean that I don't try my best.
Em: It really depends on the workout. For strength, protein is key. Protein shakes are best, but I also like Quest nutrition bars (I’m not a super huge fan of protein shakes). For cardio, something like fruit (bananas, berries), Greek yogurt, almond/peanut butter, or egg whites.
Ask: Why do you do data viz?
Em: There was a phrase in a handbook at work about MIS and turning data into information (by which to make well informed decisions). I really took to that! And I like how I get to be creative when designing a viz. I loved my Mother's Day viz from a creativity perspective, which was meant to look like a card. Professionally, I do viz work on my own time about non-work topics because I think it helps me oversee our vizzes at work. Plus, the biggest reason is that I like doing it. And I do what I like.
Ask: I was asked at work to find the number of workdays between two days excluding weekends and put it in tableau. It took me a while to find it, so could you pass it along to your readers?
Em: Of course (it is reason why I thought to start this feature)! To do this in tableau, create a calculated field with the following caclulation. Note: Created and completed dates may be called something different on your data.
DATEDIFF('week',[Created Date],[Completed Date])*5 - MIN(DatePart('weekday',[Created Date]),6) + MIN(DatePart('weekday',[Completed Date]),6)