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
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