![Anthony Smoak](/img/default-banner.jpg)
- 160
- 3 409 170
Anthony Smoak
United States
Registrace 29. 08. 2013
I love teaching you about data! My name is Anthony B. Smoak and I am a Certified Business Intelligence Professional (CBIP), Georgia Tech MBA and data educator that will make you better at analyzing data. I've built my whole career on empowering decision makers with my data analysis skills. I have a passion for learning and teaching.
Subscribe and come on a learning journey with me and my growing community as we explore various data tools such as Tableau, SQL Server & Excel. When you subscribe to my channel, you WILL do great things with your data!
★☆★ Join this channel to get access to perks: ★☆★
czcams.com/channels/L2ls5uXExB4p6_aZF2rUyg.htmljoin
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Instagram ► @AnthonySmoakData
Facebook ► AnthonyBSmoak/
Tableau Public ► public.tableau.com/app/profile/anthony.smoak
All views/opinions are mine alone, independently researched and do not represent those of my employer.
Subscribe and come on a learning journey with me and my growing community as we explore various data tools such as Tableau, SQL Server & Excel. When you subscribe to my channel, you WILL do great things with your data!
★☆★ Join this channel to get access to perks: ★☆★
czcams.com/channels/L2ls5uXExB4p6_aZF2rUyg.htmljoin
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► anthonysmoak.com/
Instagram ► @AnthonySmoakData
Facebook ► AnthonyBSmoak/
Tableau Public ► public.tableau.com/app/profile/anthony.smoak
All views/opinions are mine alone, independently researched and do not represent those of my employer.
Create a Stunning Advanced Dashboard in Tableau
Now that Tableau Public allows local saves, I decided to take it for a spin. My latest video is definitely not for the Tik-Tok crowd as it is a long form, deep dive into dashboard building. In this over-hour-long video, I demonstrate how to put together all of the visually appealing chart elements from a Tableau Public dashboard created by Dmitry Shirikov. I enjoyed looking underneath the hood and figuring out how to recreate it. Both beginners and seasoned analysts will have something to learn from this one!
★☆★ DASHBOARD LINK ★☆★
public.tableau.com/app/profile/anthony.smoak/viz/SuperstoreDashboardBuild/Dashboard1
★☆★ Join this channel to get access to perks: ★☆★
czcams.com/channels/L2ls5uXExB4p6_aZF2rUyg.htmljoin
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoffee.com/anthonysmoak
★☆★ Support this Channel: ★☆★
👕 Merch ► shop.spreadshirt.com/AnthonySmoak
00:00 Intro
1:02 Dashboard Credits
2:15 Dashboard Overview
3:47 Parameter & Calculated Fields Setup
11:10 Sales Chart 1
14:50 Sales Chart 2
18:40 Sales Chart 3
29:26 Other Sales Charts (Quick Overview)
34:04 Metric Swap Parameter
35:35 Metric Swap Calculations
39:45 Map Creation
47:30 Category Bar Chart
55:33 Segment Bar Chart
57:02 Ship Mode Bar Chart
58:10 State Bar Chart
01:00:54 Button Selector Calculated Fields
01:01:43 Button Selector Worksheet Build
01:09:47 Review and Thanks
01:10:44 Do You Want to Learn How to Arrange the Charts (Video Part 2)?
#Tableau #datavisualization #data #analytics #data #dataanalyst #education #onlinelearning
★☆★ DASHBOARD LINK ★☆★
public.tableau.com/app/profile/anthony.smoak/viz/SuperstoreDashboardBuild/Dashboard1
★☆★ Join this channel to get access to perks: ★☆★
czcams.com/channels/L2ls5uXExB4p6_aZF2rUyg.htmljoin
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoffee.com/anthonysmoak
★☆★ Support this Channel: ★☆★
👕 Merch ► shop.spreadshirt.com/AnthonySmoak
00:00 Intro
1:02 Dashboard Credits
2:15 Dashboard Overview
3:47 Parameter & Calculated Fields Setup
11:10 Sales Chart 1
14:50 Sales Chart 2
18:40 Sales Chart 3
29:26 Other Sales Charts (Quick Overview)
34:04 Metric Swap Parameter
35:35 Metric Swap Calculations
39:45 Map Creation
47:30 Category Bar Chart
55:33 Segment Bar Chart
57:02 Ship Mode Bar Chart
58:10 State Bar Chart
01:00:54 Button Selector Calculated Fields
01:01:43 Button Selector Worksheet Build
01:09:47 Review and Thanks
01:10:44 Do You Want to Learn How to Arrange the Charts (Video Part 2)?
#Tableau #datavisualization #data #analytics #data #dataanalyst #education #onlinelearning
zhlédnutí: 2 489
Video
Learn WHERE vs HAVING in SQL | SQL Interview Question
zhlédnutí 563Před 4 měsíci
Struggling to understand the difference between the WHERE and HAVING clauses in SQL? This video breaks down these two filtering clauses in a clear, concise way, perfect for SQL beginners. This question frequently arises in SQL based interviews, so you should know the difference between the two! We'll dive deep into: When to use WHERE to filter rows before aggregation When to use HAVING to filte...
Unpivot Columns to Rows in SQL Server (SQL Detailed Walkthrough)
zhlédnutí 511Před 5 měsíci
In this video you will learn how to unpivot data using SQL Server via a highly detailed example. We will use Tableau Superstore data to build an aggregation table using a CTE (Common Table Expression). Aggregation tables are useful to data visualization developers as table information is stored with pre-summarized totals at a higher level of aggregation than the most granular fact table. They a...
Easy Excel Sentiment Analysis
zhlédnutí 1KPřed 6 měsíci
Learn how to quickly perform a sentiment analysis in Excel without code!! Sentiment analysis is a technique that allows you to analyze the emotions and opinions of your customers, users, or audience based on their text or speech. In this video, I will show you how to use a free online tool to perform a sentiment analysis in Excel in just a few minutes. You will learn how to extract the polarity...
How to Make a Histogram in Excel
zhlédnutí 223Před 7 měsíci
In this video tutorial, I’ll show you how to create a histogram in Excel, using Kobe Bryant’s playoff points per game as an example. A histogram is a bar chart that shows the frequency of data within different numerical ranges. It can help you understand the shape, spread, and central tendency of your data. I’ll also show you how to customize your histogram, such as changing the bin size, addin...
Advanced Excel Pivot Tables (Masterclass)
zhlédnutí 789Před 8 měsíci
I guarantee there are some tips in this Excel Pivot Table Masterclass that will make you look like a showoff to your colleagues! Over the course of 30 minutes I step through 4 pivot table examples to teach you the best productivity tips that will make you maximize your experience with pivot tables. ★☆★ FOLLOW ME BELOW: ★☆★ bit.ly/m/anthonysmoak Instagram: @anthonysmoakdata Linkedin: Anthony B. ...
Parse and Query JSON Data with SQL
zhlédnutí 3,5KPřed 9 měsíci
Learn to query JSON data in SQL Server with ease by using a few simple functions. I guarantee that you will gain value from reviewing this video if you have to store and analyze JSON data in SQL Server. ★☆★ FOLLOW ME BELOW: ★☆★ bit.ly/m/anthonysmoak ☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕ www.buymeacoffee.com/anthonys... ★☆★ Support this Channel: ★☆★ Me...
How to Conditionally Format Text Cell Color in Tableau (In Under 2 Minutes)
zhlédnutí 995Před 11 měsíci
The "make #Tableau work like Excel" tip you need! Conditionally changing the background color of text in Excel is very easy but requires a hack in Tableau 10.3. Use my video to learn how to conditionally format the cell background of a text or dimension value in Tableau. This is the 2 minute shortened version of a classic video. Watch the full version here: czcams.com/video/ht4pRvuv0II/video.ht...
Supercharge Your SQL Skills with Lead & Lag Functions
zhlédnutí 1KPřed 11 měsíci
Be a super hero and learn to LEAD (and LAG) in SQL. I start out showing you the problem statement in #Excel and then we take it over to SQL Server to script common table expressions using window functions in order to solve a business question on time intervals. #sqlserver #analytics #tsql #groupby #dataanalyst #data 0:00 INTRO 1:08 DATA OVERVIEW IN EXCEL 4:15 GET STRAIGHT TO THE POINT: LAG FUNC...
Mastering the Decomposition Tree in Power BI
zhlédnutí 6KPřed rokem
Mastering the Decomposition Tree in Power BI
Create Stacked Area Chart Totals In Tableau
zhlédnutí 1,1KPřed rokem
Create Stacked Area Chart Totals In Tableau
Tableau's Game Changing Sankey Chart Feature
zhlédnutí 1,7KPřed rokem
Tableau's Game Changing Sankey Chart Feature
How ChatGPT Can Help You Learn the Right Excel Formula (In Under 2 Minutes)
zhlédnutí 272Před rokem
How ChatGPT Can Help You Learn the Right Excel Formula (In Under 2 Minutes)
Create an Advanced Tableau Table (Step by Step Instructions)
zhlédnutí 12KPřed rokem
Create an Advanced Tableau Table (Step by Step Instructions)
Call a SQL Server Stored Procedure using Excel Parameters (Part 2)
zhlédnutí 3,8KPřed rokem
Call a SQL Server Stored Procedure using Excel Parameters (Part 2)
Get Ready to Pass the Tableau Certified Data Analyst Exam with These Tips
zhlédnutí 18KPřed rokem
Get Ready to Pass the Tableau Certified Data Analyst Exam with These Tips
Call a SQL Server Stored Procedure using Excel Parameters
zhlédnutí 16KPřed rokem
Call a SQL Server Stored Procedure using Excel Parameters
Passing Parameter Values from Excel to SQL Server
zhlédnutí 29KPřed rokem
Passing Parameter Values from Excel to SQL Server
Unleash Your Inner Excel Wizard with THESE Functions
zhlédnutí 469Před rokem
Unleash Your Inner Excel Wizard with THESE Functions
Unlock the Secrets of "Must Know" Excel Functions in Just 2 Minutes!
zhlédnutí 438Před rokem
Unlock the Secrets of "Must Know" Excel Functions in Just 2 Minutes!
Combine Multiple Rows into One Cell Using SQL
zhlédnutí 11KPřed rokem
Combine Multiple Rows into One Cell Using SQL
Remove the Highlighting Effect in Tableau
zhlédnutí 4,9KPřed rokem
Remove the Highlighting Effect in Tableau
10 Items to Know When Starting a Data Project
zhlédnutí 491Před rokem
10 Items to Know When Starting a Data Project
How to Swap Sheets on your Tableau Dashboard
zhlédnutí 12KPřed 2 lety
How to Swap Sheets on your Tableau Dashboard
Become a Data Analyst (From a 20 Year Data Pro)
zhlédnutí 710Před 2 lety
Become a Data Analyst (From a 20 Year Data Pro)
Perform Fuzzy Matching in Tableau Prep
zhlédnutí 2,6KPřed 2 lety
Perform Fuzzy Matching in Tableau Prep
Use Excel to Connect to SQL Server Data
zhlédnutí 102KPřed 2 lety
Use Excel to Connect to SQL Server Data
Hi anthony, can I get twbx of this dashboard? Thanks.
Still new to my BI job, this helped!
Glad to hear it, thanks for sharing!
Thank you very much, it's really helpful
@@VIRUSINGH338 Glad to hear it!
have run time error 438 and the bug sits with Active.Workbook.Queries("LimitBalance").Refresh, could you please help?
Thank you.
You're welcome!
This is a great video. Relied on it heavily while building several reports. Thank you very much.
I appreciate you sharing this feedback, thank you!
I love how Anthony unlocks a complex dashboard, and presents in a way that so easy to follow. Thank you! Second Anthony at 20:25 (Tableau devs ... all lines off button pls) 😊
Much appreciated Shirley. We definitely need that all lines off button!
Gov't fiscal analyst here, recently discovered our bloated financial database from the 80s has an SQL endpoint in the form of a DNS address accessible only inside the government network (i.e, within the VPN). I'm diving into the deep end on this. I've connected to APIs using PowerQuery, but I don't think this would be considered an API? Based on this video, I'm guessing "server" would be the DNS address, and "database" would be the database to be queried at that DNS address? Also, I'm totally going to be using this for production workbooks. But you'll be happy to know we move glacially, so a daily refresh automated via VBA keeps everything current. ;) Apparently they've been begging for people to use the SQL endpoint more but it's too complex for most folks so I'm forging new paths in trying to get this working. Thanks for the video, very informative!
I just stumbled across your videos, and I can definitely say great stuff
Thank you; make sure to tell a friend!
Thank you vey much!
Thanks for the comment!
excellent amazing thanks
You're too kind!
Good work 👍🏿
@@brothertoughlove Thank you!
Now I understand the difference. Great video lesson 👍👍👍
Very nice but the video is fast. Please see if you can make it go slow.
Adjust your playback speed in the settings.
Hey, why my SUM(Sales Selected Year) is null?
I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong
@@jaygibbs7218 I assume you have design mode turned off and your code is placed in the on click action?
I still use this method. Are there any other methods, or is it still the same?
It depends on what you're trying to do. There are many ways to color background table values. Scan my earlier Tableau videos for different scenarios.
Hi, thank you, I dont have the option "MAKEDATE", do you know if is it normal? If yes, is there any other formula?
You must be using a live connection which doesn't accommodate MAKEDATE. Try the solution offered here: or switch to an extract community.tableau.com/s/question/0D54T00000C6mzeSAB/makedate-function-workaround
Super !! thx lots .. subscribed
Much appreciated!
Thank you Brother Smoak.
@@USA_to_Asia_in_2024 Thank you!
Hey there, I am following along and I am having trouble entering the calculated fields and getting the intended results. When I look at the data source my calculated fields 'sales selected field' only has calculated terms for one year, and 'sales previous feild have only null values because its the first year in the dataset. Any idea why the calculated field would only work for the first year? I can send you any info and thank for the great video!
Curious: what would I do if the duration would be over 20 years? Would I still have to enter the # of days?
Hello! Where can I find the dataset to follow along? Could you please post it ?
@@jackiehay2914 Just do a Google search for "Tableau Superstore dataset". Some version of the file should be in multiple places.
@@AnthonySmoak Help! I am stuck at the Map portion of this tutorial. At 40:54 of this tutorial, my map shows only 1 color and the color diverging works, but it does not allow me to adjust centering (It appears locked), therefore my map only shows one color. Did I miss a step in the parameter section? Thanks for your help.
So, that is a nice feature. What about the reset button itself? i notice it stays highlighted as well when you click it. Mine does that and it will not remove the highlight until i click it again.
Would better without the music - too distracting
Waiting for Part 2
Thank you, Anthony. Very helpful!
Thank you for the comment!
Amazing video! Watching your Tableau videos makes learning Tableau a lot of fun. Look forward to how to put all the charts together in a dashboard. So if you could also make a video for that one, it would be great!
Thanks for the comment. Recording and editing this video took a lot of effort so it's great to hear that you took some value from watching!
Way to hard to follow and disjointed
Nothing worth having comes easy.
We're having a serious PARTITIONING case here. You the truth man, thanks.
You're the real MVP, thanks for the comment!
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
I'm very glad to hear that, thanks for sharing!
Thank you for the lesson! 👏
Thanks for leaving a comment!
Very clear instructions! I'm learning a lot from your tutorials. However, I can't find a way to make a bullet chart on Tableau Public. I don't see an option for a fixed size when building the bar chart; is this something that's only possible on Tableau Desktop?
This is helpful but when I am downloading the extract from tableau server, I am getting duplicate values
Hey, this was awesome :) i look forward to more guides
Thank you!
How to create a connection when other user opens the Excel file , the data will refresh automatically, without prompting to authenticate to SQL
Great to follow this. I managed to do it/implement it into my report. Thanks and you got +1 new sub =)
Glad to hear it, thank you!
@@AnthonySmoak Ah one more question, for my confirmation, what about if I wanna apply the same logic on more than one page? Does it need to be created again with the same procedure/selections/bookmarks, or is there any kind of "copy-paste" behind it? Maybe in grouping and copying the selections, I saw it is possible to copy groups that you created before.
@@mirrrvelll5164 As far as I know you have to manually repeat the same process with new bookmarks. community.fabric.microsoft.com/t5/Desktop/Bookmarks-can-I-make-them-work-for-a-new-page-and-not-the/m-p/564714#M266488
Helped!
Hi Anthony - thank you for the demonstration. I am in the process of doing a salary and promotion request for my job. I understand the fundamentals of tableau but my question was how can I incorporate text only to show some community events, field and vendor events like that?
great videos !!!! Simple and Nice man !! tnx
Simple and nice is what I was aiming for, thank you!
Great explanation. Thanks
Thank you!
Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!
Fantastic, glad to hear that you learned something new!
We can use copy formatting from one worksheet to another worksheet for bar chart to save time😊
Another way would be to duplicate the bar chart sheet as Anthony did. However, instead of drag and drop new dimensions to Rows you can double click the dimension you want to change out and write the name of the dimension to replace with. This will keep the formatting already applied to the previous dimension for the new one.
Really Thank you for your explanation 😍😍 a New Like and subscription From Egypt 🤙
Thank you for supporting the channel!
Saved my day. Thank you. Trying to handle csv via oythpn script and always getting all values in one column, separated by the comma. Now I fixed it. Very unconvinient option in windows :/
Glad to hear it!
Thank you man, you are a lifesaver!
Thanks for the comment, much appreciated!
how is this in anyway better than MSQuery where i could just do {Call MyStoredProcedure(?,?,?)}. Not a bit of VBA or a macro, i could just assign the 3 parameters to cells on the sheet.
I know MSQuery is listed as an older legacy option and you have to manually enable it in the latest version of Office 365 Excel (will it continue to be supported like VBA)? However, you have given me an option to test, I'll let you know how it goes.
@@AnthonySmoak My complaint is really with Microsoft. They took something simple and replaced it with a nightmare. I'm a programmer so other than disliking VBA, i have no problem with this approach other than it used to be very simple with MSQuery.
@@jdwyer4851 I made a video exploring the MS Query approach. Thanks for the comment. czcams.com/video/2oT-PhgcKa8/video.htmlfeature=shared
@@AnthonySmoak Thank you for doing that. Microsoft has buried MSQuery on the current Excel version and you have to add it to the menu yourself. I hope that it doesn't go away completely, or at least if it does Microsoft could replace it something that its as equally simple. I'm a programmer, but for fast ad-hoc solutions I can turnout an Excel doc calling a stored procedure in minutes. Perhaps the more people who know about and use MSQuery the less likely it gets killed by Microsoft.
Thanks! Can't wait to see Part 2!
🎓
Thanks for this session.. Extremely helpful. Just one question, on category bar, can we change the color of the percentage like red for negative value and green for positive value and also add up and down arrow. I'm trying similar thing but I don't know if thats possible.