iiinova — where your digital self keeps evolving

Anthony Smoak @anthonysmoak.bsky.social · 14/01/2026

Prescriptive analytics enables you to tell a business exactly what to DO, like how to maximize profits given constraints or limited resources. I created a two-part video series walking through a simple linear programming model in #Excel. Start learning here: youtu.be/9yaO87KfG1Y #dataanalytics

youtu.be

Linear Programming Optimization with Excel Solver

YouTube video by Anthony Smoak

010

Anthony Smoak @anthonysmoak.bsky.social · 02/08/2025

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

040

Anthony Smoak @anthonysmoak.bsky.social · 29/07/2025

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

020

Anthony Smoak @anthonysmoak.bsky.social · 16/05/2025

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

020

Anthony Smoak @anthonysmoak.bsky.social · 10/04/2025

I didn't know #Syracuse alumns in Atlanta were rolling this deep. Glad I came out to make a few new connections!

010

Anthony Smoak @anthonysmoak.bsky.social · 09/04/2025

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

010

Anthony Smoak @anthonysmoak.bsky.social · 30/03/2025

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

300

Anthony Smoak @anthonysmoak.bsky.social · 24/03/2025

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.

000

Anthony Smoak @anthonysmoak.bsky.social · 23/03/2025

I added a couple titles to the #data library. Looking forward to getting into these.

000

Anthony Smoak @anthonysmoak.bsky.social · 11/03/2025

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

010

Anthony Smoak @anthonysmoak.bsky.social · 12/02/2025

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

youtube.com

Advanced SQL | Advanced GROUP BY with ROLLUP & CUBE

YouTube video by Anthony Smoak

000

Anthony Smoak @anthonysmoak.bsky.social · 04/02/2025

This is your year! Share your wins in the workplace and get the recognition you deserve! #careeradvice #dataanalyst

000

Anthony Smoak @anthonysmoak.bsky.social · 15/01/2025

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.

youtube.com

Create Dynamic Excel Drop Down Lists - The Easy Way

YouTube video by Anthony Smoak

031

Anthony Smoak @anthonysmoak.bsky.social · 01/01/2025

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.

010

Anthony Smoak @anthonysmoak.bsky.social · 12/12/2024

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

000

Anthony Smoak @anthonysmoak.bsky.social · 10/12/2024

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

000

Anthony Smoak @anthonysmoak.bsky.social · 09/12/2024

A snap from Delta Airlines company winter Xmas party 2024. Happy holidays all!

010

Reposted by Anthony Smoak

Brent Dykes @analyticshero.bsky.social · 03/12/2024

While visualization SHOWS, storytelling EXPLAINS. Data storytelling is more than just highlighting with a bold color and an annotation. www.linkedin.com/posts/brentd...

021

Anthony Smoak @anthonysmoak.bsky.social · 02/12/2024

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

000

Anthony Smoak @anthonysmoak.bsky.social · 25/11/2024

In your analytics work, focus on clarity, simplicity, and actionable insights. #data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence

100

Anthony Smoak @anthonysmoak.bsky.social · 23/11/2024

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.

000

Anthony Smoak @anthonysmoak.bsky.social · 22/11/2024

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

010

Anthony Smoak @anthonysmoak.bsky.social · 22/11/2024

Thursday night #ACC action! It was a cold and windy night in Atlanta but Tech pulled out the win by 1 point. #GeorgiaTech

010

Anthony Smoak @anthonysmoak.bsky.social · 20/11/2024

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

010

Anthony Smoak @anthonysmoak.bsky.social · 19/11/2024

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

021

Anthony Smoak @anthonysmoak.bsky.social · 18/11/2024

Shoutout to Isaac Oresanya who shared this insightful graphic of YouTube channels to follow for data analysts. I may have underlined a familiar name. #data #dataanalyst #dataanalytics www.linkedin.com/feed/update/...

001

Anthony Smoak @anthonysmoak.bsky.social · 17/11/2024

Snapped a foggy night in midtown #Atlanta last week. I can hear the Glenn Frey playing 🎷🎵🎶 #ATLsky

030

Anthony Smoak @anthonysmoak.bsky.social · 17/11/2024

Last year I had great time as a guest on the Ten Minute Tuesday podcast with Sekou Tyler. We talk about the advice I would give to anyone looking to get started in a #data career, and more. Full video here: www.youtube.com/watch?v=QVin... #SQL #Tableau #Excel #PowerBI #dataanalyst #dataanalytics

020

Anthony Smoak @anthonysmoak.bsky.social · 16/11/2024

At Georgia Tech Homecoming '24 I had the great pleasure to meet and have a brief conversation with the new Dean of the Scheller School of Business, Anuj Mehrotra! He's got the vision for keeping Tech climbing in the rankings! #georgiatech #schellerlife #schellermba

000

Anthony Smoak @anthonysmoak.bsky.social · 16/11/2024

I absolutely have to have this as part of my feed. What a great win by the Jackets over a top 5 undefeated Miami! @gtfootball.bsky.social #GeorgiaTech

091

Anthony Smoak @anthonysmoak.bsky.social · 16/11/2024

My first bluesky post! I'm hoping a vibrant #data community eventually develops here.

120

Anthony Smoak @anthonysmoak.bsky.social · 11/08/2023

Come on out to the #blackistech conference and hear me talk about my favorite topic #data!

000

Anthony Smoak @anthonysmoak.bsky.social · 17/04/2023

Data and technology skills are starting to be an expectation and not a nice to have in today's workplace. The WSJ specifically mentions #Excel, #Tableau, #SQL, and #PowerBI as coveted skills worth knowing....

100

Anthony Smoak @anthonysmoak.bsky.social · 29/03/2023

Encourage upskilling and invest in your #data and #analytics talent. "Given the scope and complexity of demands being placed on D&A teams, the lack of available talent has quickly become a top impediment to D&A...

100

Anthony Smoak @anthonysmoak.bsky.social · 28/03/2023

Do you need a degree in computer science for a successful data career? 💻🎓As a data professional with 20 years of experience and a computer science degree, I'll give you the real spiel! #CareerAdvice #data #dataanalytics ►https://www.youtube.com/shorts/MGp2q4j4o-A ►...

100

Anthony Smoak @anthonysmoak.bsky.social · 27/02/2023

I'll teach you an efficient and novel way to compare lists of data in #Excel. And since we're using NBA player names, I'll tell you who should have been the real MVP. Watch until the end! ► 🎥📊https://youtu.be/vE-RklYD6jE

000

Anthony Smoak @anthonysmoak.bsky.social · 26/02/2023

It was super cool to finally meet a few of the people I respect in the #data game at SQL Saturday ATL. Shoutout to @sqlsekou and @patrickdba.

000

Anthony Smoak @anthonysmoak.bsky.social · 02/02/2023

The author endorses upskilling and specialization to avoid "extinction". "If you want to make yourself distinct, work at being the best at one particular thing." #Career www.psychologytoday.com/us/blog/opt…

psychologytoday.com

Are You Making Yourself Distinct or Extinct?

Are you afraid of being extinct in the workplace? Here ar...

000

Anthony Smoak @anthonysmoak.bsky.social · 29/01/2023

Who's preparing for the #Tableau Certified Data Analyst Exam? I recently shared a blog post on the same subject but I decided to also make a video version as a different way to absorb the material. Be sure to check it out! 📽️📽️https://youtu.be/Ep_tZwOrqJ4

000

Anthony Smoak @anthonysmoak.bsky.social · 19/01/2023

This is one of those hacks that you need in your #Tableau bag of tricks to improve dashboard user experience. Watch and learn (and like 👍) ► bit.ly/3wgUyP0

000

Anthony Smoak @anthonysmoak.bsky.social · 08/01/2023

Oftentimes in #Excel, we need to get data out of #SQL Server dynamically and without the manual effort. By using cells as parameters, we can more easily change the input values for our queries without having to modify any underlying SQL code. 📽️📽️ bit.ly/3WSdlvx

000

Anthony Smoak @anthonysmoak.bsky.social · 23/12/2022

Learn to dynamically filter and manipulate #data in your #SQLServer database based upon user entered #Excel values (without Power Query). Watch the video at ➡️https://youtu.be/7xsL_gHf9Ws #dataanalyst #businessintelligence #datascience #dataanalytics

000

Anthony Smoak @anthonysmoak.bsky.social · 05/12/2022

Glad to share that I recently passed the #Tableau Certified Data Analyst exam. Hopefully my experience can help others as they prepare. 📊https://bit.ly/3VUB1i9

010

Anthony Smoak @anthonysmoak.bsky.social · 26/10/2022

Get ready to learn 4 new #Excel functions that you probably aren't using but absolutely should be using. ► youtu.be/V8-JC_G1j40 You'll also get my correct opinion on the greatest college hoops team of all time. #Excelformulas #ExcelTips

000

Anthony Smoak @anthonysmoak.bsky.social · 03/10/2022

In this video I demystify the PARTITION BY clause in #SQL. It's a statement that allows you to have the best of both worlds when it comes to #data analysis. ► youtu.be/wN1egFA2GvU

010

Anthony Smoak @anthonysmoak.bsky.social · 20/09/2022

Sometimes you have to break the rules when transforming #data for ad hoc analyses. Here is an underrated yet elegant #SQL function used to combine data values across multiple rows into a single cell. #dataanalytics #tsql ► lnkd.in/gmj6nZQ6

000

Anthony Smoak @anthonysmoak.bsky.social · 29/08/2022

This is one of those simple hacks that you need in your #Tableau bag to improve dashboard user experience. Watch and learn (and like👍) ► youtu.be/ywaiJBc4znM

000

Anthony Smoak @anthonysmoak.bsky.social · 23/08/2022

We all have those to-do lists when starting a new project. I share my list in the video. What do you do when ramping up on a new #data project? ► youtu.be/KdcNJRa0WUg

000