Candra McRae

2021 Week 27: Can you find the top and bottom performers?

Introduction Like a fine pinot grigio, I really enjoy a good box-and-whisker plot. There is so much good stat stuff in one place like the min/max, median, top/bottom performers, and outliers in the data set.  I have found, however, that they are rarely used and some business end users find them hard to read.    …

2021 Week 27: Can you find the top and bottom performers? Read More

#WOW2021 week 22: Can You Structure the Unstructured?

Introduction Data analyst is supposedly the sexiest job of the 21st century.  Most people think that we spend our time building amazing models, visualizations, or insights all day.  What they don’t know is that you spend nearly most of your time cleaning data.  Some data is nice and refined (aka usable) and other data needs …

#WOW2021 week 22: Can You Structure the Unstructured? Read More

2021 Week 18: Can You Performance Tune This Workbook?

Introduction Learning complex techniques and beautiful design is super important to mastering visual analytics.  But, nothing will stop a user from regularly and joyfully using a dashboard than a poor performing one.  It doesn’t matter if it looks like Michaelangelo designed it or it has the cure for some crazy infectious disease – if it …

2021 Week 18: Can You Performance Tune This Workbook? Read More

2021 Week 14 | Tableau: Can You Recommend Profitable Return Customer Bundles?

Introduction Have you ever purchased something on Amazon and they show an extra random list of products in the “Customers that purchased X also purchased…” section and you think to yourself, “How in the world did they come up with that combination (e.g., sponges and Skittles)?”  They likely have high-powered recommender engines doing all of …

2021 Week 14 | Tableau: Can You Recommend Profitable Return Customer Bundles? Read More

2021 Week 9: Can You Hide A Chart in the Map Layers?

Introduction So, I’m a little late for Mardi Gras – but that didn’t stop me from thinking about King Cake, a New Orleans tradition (with French roots) where a little plastic baby is put inside of a cake that is plastered with green, yellow, and purple frosting with tons of sprinkles. Anyone teeth hurt yet? …

2021 Week 9: Can You Hide A Chart in the Map Layers? Read More

#WOW2021 W05: Can You Predict the Future?

Introduction For this week’s challenge, we wanted to hit two birds with one stone: try out a new feature from the Tableau 2020.4 and celebrate Black History Month with an interesting dataset on Historical Black Colleges and Universities (HBCU). Predictions, table calculations, and parameter actions…oh my!  Consider this a feature sampler, building on some previous …

#WOW2021 W05: Can You Predict the Future? Read More

2021 Week 1: Can You Find the Variance Along the Line?

Introduction For the longest time, I avoided table calculations as much as I could because I thought they were overly complicated (compute using…relative to…sort by…nested…ughhhh) especially when I had LODs in my back pocket.  But, over time, I’ve made my peace with them (dare I say, a fan now) as I recognized how powerful they …

2021 Week 1: Can You Find the Variance Along the Line? Read More

Scroll to Top