August | 2025 | Smoak Signals | Data Analytics Blog
2 posts published by anthonysmoak during August 2025| Smoak Signals | Data Analytics Blog
2 posts published by anthonysmoak during August 2025| Smoak Signals | Data Analytics Blog
As a reader of my blog, no doubt you have wandered over to my YouTube Channel at some point over these many years. For that, I really want to thank you. This is a thank you and appreciation post for everyone who has subscribed, shared a video with a colleague, or left an encouraging comment […]| Smoak Signals | Data Analytics Blog
I had been toying around with writing SQL code to redraft one of the most talent rich drafts in NBA history (my apologies to the 1984 and 2003 NBA drafts) and sharing the results on my YouTube chan…| Smoak Signals | Data Analytics Blog
Wal-Mart has long been associated with innovations in its home-grown information technology systems, which in turn have exerted tremendous influence on its business strategy of everyday low prices.…| Smoak Signals | Data Analytics Blog
The Wait is Over. Watch this Tableau Dashboard Container Layout Video! This video was a long time coming. If you’ve ever dealt with layout containers in Tableau (which are about as intuitive as a Thomas Pynchon novel) you know they can leave you scratching your head if you’re new to the tool. And yes, I […]| Smoak Signals | Data Analytics Blog
So I recently had the opportunity to speak about building your online presence during a webinar. I firmly believe that an online presence can open up doors for you, especially if you are looking to…| Smoak Signals | Data Analytics Blog
Performance matters! I decided to break down some quick tips to help you write faster, more efficient SQL queries. 1. Limit Your Use of SELECT * While SELECT * seems like a quick and easy solution,…| Smoak Signals | Data Analytics Blog
In this blog post I am here to defend the art of working with SQL and show some appreciation for its talented practitioners. Here is my hot take, it can be very difficult to write …| Smoak Signals | Data Analytics Blog
This article is also published on LinkedIn. How many times have you executed a SQL query against a million plus row table and then engaged in a protracted waiting game for your results? Unfortunate…| Smoak Signals | Data Analytics Blog
I have always recommended that if you develop SQL based analytics, you should have some understanding of indexes when it comes to speeding up queries. Sometimes we do not have access to create inde…| Smoak Signals | Data Analytics Blog
Over the years I have conducted a number of interviews with candidates who claimed to know SQL, but could not clearly verbalize their understand of some basic concepts. I want you to understand the…| Smoak Signals | Data Analytics Blog
Since Tableau Public was recently upgraded to enable local saving (It’s about time), I decided to look and see what new dashboards were out there that I could learn from, and subsequently teach oth…| Smoak Signals | Data Analytics Blog
Let’s learn how to build a histogram in Excel with some interesting NBA data. Personally, I use the histogram in my data analyses to help me understand how my data is distributed and to identify an…| Smoak Signals | Data Analytics Blog
