Anthony Smoak
@anthonysmoak.bsky.social
Your Favorite Data Analyst's Favorite Data Analyst | SQL, Excel, Tableau, Power BI | Data Analytics Consultant | Follow me on YouTube 3.5 million views @ http://youtube.com/c/AnthonySmoak
This is a thank you post to everyone who has subscribed to my channel over the many years.
To everyone who’s watched, liked, shared, or even just paused to learn something new; thank you! You are the reason my YouTube channel thrives and evolves!
#Tableau #data #dataanalytics #dataanalyst #SQL
To everyone who’s watched, liked, shared, or even just paused to learn something new; thank you! You are the reason my YouTube channel thrives and evolves!
#Tableau #data #dataanalytics #dataanalyst #SQL
August 2, 2025 at 10:38 PM
This is a thank you post to everyone who has subscribed to my channel over the many years.
To everyone who’s watched, liked, shared, or even just paused to learn something new; thank you! You are the reason my YouTube channel thrives and evolves!
#Tableau #data #dataanalytics #dataanalyst #SQL
To everyone who’s watched, liked, shared, or even just paused to learn something new; thank you! You are the reason my YouTube channel thrives and evolves!
#Tableau #data #dataanalytics #dataanalyst #SQL
If you are a data, SQL and NBA nerd then this is the preview video for you. I recently analyzed the 2018 NBA Draft by vibe-coding with Windsurf and testing the agentic IDE's SQL capabilities.
Full video can be seen here: www.youtube.com/watch?v=bQob...
#SQL #dataanalytics #dataanalyst #WindsurfAI
Full video can be seen here: www.youtube.com/watch?v=bQob...
#SQL #dataanalytics #dataanalyst #WindsurfAI
July 29, 2025 at 2:17 AM
If you are a data, SQL and NBA nerd then this is the preview video for you. I recently analyzed the 2018 NBA Draft by vibe-coding with Windsurf and testing the agentic IDE's SQL capabilities.
Full video can be seen here: www.youtube.com/watch?v=bQob...
#SQL #dataanalytics #dataanalyst #WindsurfAI
Full video can be seen here: www.youtube.com/watch?v=bQob...
#SQL #dataanalytics #dataanalyst #WindsurfAI
I had fun editing these snippets from the second entry in my Advanced Tableau Dashboard Build series.
In the full length sequel (for members of my channel), I tackle the meticulous container approach it takes to complete the dashboard build we started in part 1.
#data #dataviz #Tableau #datafam
In the full length sequel (for members of my channel), I tackle the meticulous container approach it takes to complete the dashboard build we started in part 1.
#data #dataviz #Tableau #datafam
May 16, 2025 at 2:36 AM
This is a PREVIEW of the long awaited SEQUEL of “Create a Stunning Advanced Dashboard in Tableau”.
In this video I introduce you to the detailed process of sizing and arranging multiple Tableau chart components that we learned how to build in part one.
youtu.be/yKMXwZkIwRs
In this video I introduce you to the detailed process of sizing and arranging multiple Tableau chart components that we learned how to build in part one.
youtu.be/yKMXwZkIwRs
April 9, 2025 at 12:27 AM
This is a PREVIEW of the long awaited SEQUEL of “Create a Stunning Advanced Dashboard in Tableau”.
In this video I introduce you to the detailed process of sizing and arranging multiple Tableau chart components that we learned how to build in part one.
youtu.be/yKMXwZkIwRs
In this video I introduce you to the detailed process of sizing and arranging multiple Tableau chart components that we learned how to build in part one.
youtu.be/yKMXwZkIwRs
I've worked in organizations that have needed more SQL processes than Excel spreadsheets.
But I've never worked at an organization where they've needed more Excel spreadsheets than SQL processes.
When to use SQL:
✔ Handling Large Datasets
✔ Automating Processes
✔ Ensuring Data Security
But I've never worked at an organization where they've needed more Excel spreadsheets than SQL processes.
When to use SQL:
✔ Handling Large Datasets
✔ Automating Processes
✔ Ensuring Data Security
March 30, 2025 at 10:00 PM
I've worked in organizations that have needed more SQL processes than Excel spreadsheets.
But I've never worked at an organization where they've needed more Excel spreadsheets than SQL processes.
When to use SQL:
✔ Handling Large Datasets
✔ Automating Processes
✔ Ensuring Data Security
But I've never worked at an organization where they've needed more Excel spreadsheets than SQL processes.
When to use SQL:
✔ Handling Large Datasets
✔ Automating Processes
✔ Ensuring Data Security
I’m happy to share with my network that I’ve been accepted into The Fuqua School of Business at Duke University to pursue a Master's degree in Quantitative Management - Business Analytics.
I enjoy data analytics and there is always something new to learn.
I enjoy data analytics and there is always something new to learn.
March 24, 2025 at 12:28 PM
I’m happy to share with my network that I’ve been accepted into The Fuqua School of Business at Duke University to pursue a Master's degree in Quantitative Management - Business Analytics.
I enjoy data analytics and there is always something new to learn.
I enjoy data analytics and there is always something new to learn.
I attended SQL Saturday Atlanta and got to observe my talented Protiviti teammates Jeff Levy and Vernon Gomes in action. They gave an informative presentation on the pros and cons of using a #Microsoft Fabric Lakehouse vs. using a Fabric Warehouse.
#SQLSaturday
#SQLSaturday
March 11, 2025 at 1:00 AM
I attended SQL Saturday Atlanta and got to observe my talented Protiviti teammates Jeff Levy and Vernon Gomes in action. They gave an informative presentation on the pros and cons of using a #Microsoft Fabric Lakehouse vs. using a Fabric Warehouse.
#SQLSaturday
#SQLSaturday
This one is for the channel members.
ROLLUP and CUBE in #SQL are useful in ad hoc reporting as they allow you to efficiently gauge your metrics by multiple grouping levels.
Join the channel to get access to members only vids!
www.youtube.com/watch?v=NlOw...
#SQLServer #data #dataanalyst
ROLLUP and CUBE in #SQL are useful in ad hoc reporting as they allow you to efficiently gauge your metrics by multiple grouping levels.
Join the channel to get access to members only vids!
www.youtube.com/watch?v=NlOw...
#SQLServer #data #dataanalyst
Advanced SQL | Advanced GROUP BY with ROLLUP & CUBE
YouTube video by Anthony Smoak
www.youtube.com
February 12, 2025 at 2:06 PM
This one is for the channel members.
ROLLUP and CUBE in #SQL are useful in ad hoc reporting as they allow you to efficiently gauge your metrics by multiple grouping levels.
Join the channel to get access to members only vids!
www.youtube.com/watch?v=NlOw...
#SQLServer #data #dataanalyst
ROLLUP and CUBE in #SQL are useful in ad hoc reporting as they allow you to efficiently gauge your metrics by multiple grouping levels.
Join the channel to get access to members only vids!
www.youtube.com/watch?v=NlOw...
#SQLServer #data #dataanalyst
This is your year! Share your wins in the workplace and get the recognition you deserve!
#careeradvice #dataanalyst
#careeradvice #dataanalyst
February 4, 2025 at 3:56 AM
This is your year! Share your wins in the workplace and get the recognition you deserve!
#careeradvice #dataanalyst
#careeradvice #dataanalyst
This #Excel dynamic dropdown technique requires minimal preparation and only uses 3 functions.
In this tutorial, I'll use 1 dropdown list to select a position and the other dropdown list will dynamically populate with members of the NBA 75th Anniversary Team who were selected at that position.
In this tutorial, I'll use 1 dropdown list to select a position and the other dropdown list will dynamically populate with members of the NBA 75th Anniversary Team who were selected at that position.
Create Dynamic Excel Drop Down Lists - The Easy Way
YouTube video by Anthony Smoak
www.youtube.com
January 15, 2025 at 3:16 AM
This #Excel dynamic dropdown technique requires minimal preparation and only uses 3 functions.
In this tutorial, I'll use 1 dropdown list to select a position and the other dropdown list will dynamically populate with members of the NBA 75th Anniversary Team who were selected at that position.
In this tutorial, I'll use 1 dropdown list to select a position and the other dropdown list will dynamically populate with members of the NBA 75th Anniversary Team who were selected at that position.
Godspeed President Carter.
He was easily the most moral, selfless and decent president in history.
I was extremely fortunate to meet him when I was a graduate student at Georgia Tech years ago.
He was easily the most moral, selfless and decent president in history.
I was extremely fortunate to meet him when I was a graduate student at Georgia Tech years ago.
January 1, 2025 at 9:26 AM
Godspeed President Carter.
He was easily the most moral, selfless and decent president in history.
I was extremely fortunate to meet him when I was a graduate student at Georgia Tech years ago.
He was easily the most moral, selfless and decent president in history.
I was extremely fortunate to meet him when I was a graduate student at Georgia Tech years ago.
Yet another new pair of JMM Enzos. This is the Sabre colorway, number 340 of 500.
These black and reds will look good at #ClarkAtlantaUniversity homecoming!
#sunglasses #jacquemariemage
These black and reds will look good at #ClarkAtlantaUniversity homecoming!
#sunglasses #jacquemariemage
December 12, 2024 at 4:21 AM
Yet another new pair of JMM Enzos. This is the Sabre colorway, number 340 of 500.
These black and reds will look good at #ClarkAtlantaUniversity homecoming!
#sunglasses #jacquemariemage
These black and reds will look good at #ClarkAtlantaUniversity homecoming!
#sunglasses #jacquemariemage
Writing SQL is rarely just about writing the syntax.
Anyone can write a query that returns data.
But writing effective SQL that returns the correct data?
That can be a real challenge.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #data #sql
Anyone can write a query that returns data.
But writing effective SQL that returns the correct data?
That can be a real challenge.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #data #sql
December 10, 2024 at 4:14 AM
Writing SQL is rarely just about writing the syntax.
Anyone can write a query that returns data.
But writing effective SQL that returns the correct data?
That can be a real challenge.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #data #sql
Anyone can write a query that returns data.
But writing effective SQL that returns the correct data?
That can be a real challenge.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #data #sql
A snap from Delta Airlines company winter Xmas party 2024. Happy holidays all!
December 9, 2024 at 12:12 AM
A snap from Delta Airlines company winter Xmas party 2024. Happy holidays all!
Reposted by Anthony Smoak
While visualization SHOWS, storytelling EXPLAINS. Data storytelling is more than just highlighting with a bold color and an annotation.
www.linkedin.com/posts/brentd...
www.linkedin.com/posts/brentd...
December 3, 2024 at 6:17 PM
While visualization SHOWS, storytelling EXPLAINS. Data storytelling is more than just highlighting with a bold color and an annotation.
www.linkedin.com/posts/brentd...
www.linkedin.com/posts/brentd...
Learn to automate and visualize your data.
Once you learn these two crucial #data skills, keep on learning.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #sql #datavisualiation
Once you learn these two crucial #data skills, keep on learning.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #sql #datavisualiation
December 2, 2024 at 11:49 PM
Learn to automate and visualize your data.
Once you learn these two crucial #data skills, keep on learning.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #sql #datavisualiation
Once you learn these two crucial #data skills, keep on learning.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #sql #datavisualiation
Conventional data punditry suggests that #SQL isn’t difficult to learn. Of course it’s easy to write SQL that returns data; however, it can be very difficult to write SQL that returns the CORRECT #data.
#dataanalyst #dataanalytics
#dataanalyst #dataanalytics
Hot Take: SQL is Difficult
In this blog post I am here to defend the art of working with SQL and its talented practitioners. Here is my hot take, it can be very difficult to write SQL. Conventional data punditr…
anthonysmoak.com
November 30, 2024 at 10:58 PM
Conventional data punditry suggests that #SQL isn’t difficult to learn. Of course it’s easy to write SQL that returns data; however, it can be very difficult to write SQL that returns the CORRECT #data.
#dataanalyst #dataanalytics
#dataanalyst #dataanalytics
In your analytics work, focus on clarity, simplicity, and actionable insights.
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
November 25, 2024 at 9:07 PM
In your analytics work, focus on clarity, simplicity, and actionable insights.
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
As I was shutting down my virtual desktop, I was presented with the following error, "Cannot quit Microsoft Office Excel". Yeah you and me both.
November 23, 2024 at 2:48 AM
As I was shutting down my virtual desktop, I was presented with the following error, "Cannot quit Microsoft Office Excel". Yeah you and me both.
Wide left! Not going to lie, from the stands this looked like it went through. Great win @gtfootball.bsky.social over NC State! #ACC #GeorgiaTech
November 22, 2024 at 6:55 AM
Wide left! Not going to lie, from the stands this looked like it went through. Great win @gtfootball.bsky.social over NC State! #ACC #GeorgiaTech
Thursday night #ACC action! It was a cold and windy night in Atlanta but Tech pulled out the win by 1 point. #GeorgiaTech
November 22, 2024 at 6:49 AM
Thursday night #ACC action! It was a cold and windy night in Atlanta but Tech pulled out the win by 1 point. #GeorgiaTech
I've been working on some challenging analytics this year, and these three data tips have been top of mind.
What would you add to this short list?
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
What would you add to this short list?
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
November 20, 2024 at 1:54 AM
I've been working on some challenging analytics this year, and these three data tips have been top of mind.
What would you add to this short list?
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
What would you add to this short list?
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
Love it or hate it, developing an online professional brand starts with a LinkedIN profile.
This short is an excerpt from a webinar I participated in, discussing the importance of a professional brand for early career workers.
You can watch the full webinar here
www.youtube.com/watch?v=-SfS...
This short is an excerpt from a webinar I participated in, discussing the importance of a professional brand for early career workers.
You can watch the full webinar here
www.youtube.com/watch?v=-SfS...
November 19, 2024 at 2:32 AM
Love it or hate it, developing an online professional brand starts with a LinkedIN profile.
This short is an excerpt from a webinar I participated in, discussing the importance of a professional brand for early career workers.
You can watch the full webinar here
www.youtube.com/watch?v=-SfS...
This short is an excerpt from a webinar I participated in, discussing the importance of a professional brand for early career workers.
You can watch the full webinar here
www.youtube.com/watch?v=-SfS...