Easy Excel Sentiment Analysis
7:22
How to Make a Histogram in Excel
6:05
Build Better Sparklines in Tableau
20:18
Пікірлер
@Nikopup
@Nikopup 3 күн бұрын
lol not the Drake cameo. Thanks for the video!
@ferdinandusruruk2000
@ferdinandusruruk2000 6 күн бұрын
Hi anthony, can I get twbx of this dashboard? Thanks.
@AnthonySmoak
@AnthonySmoak 4 күн бұрын
Check the description of this video.
@politico3556
@politico3556 7 күн бұрын
Still new to my BI job, this helped!
@AnthonySmoak
@AnthonySmoak 7 күн бұрын
Glad to hear it, thanks for sharing!
@VIRUSINGH338
@VIRUSINGH338 11 күн бұрын
Thank you very much, it's really helpful
@AnthonySmoak
@AnthonySmoak 10 күн бұрын
@@VIRUSINGH338 Glad to hear it!
@XiZhang-j3i
@XiZhang-j3i 11 күн бұрын
have run time error 438 and the bug sits with Active.Workbook.Queries("LimitBalance").Refresh, could you please help?
@aravindsaraswatula2561
@aravindsaraswatula2561 11 күн бұрын
Thank you.
@AnthonySmoak
@AnthonySmoak 11 күн бұрын
You're welcome!
@artfotinich2276
@artfotinich2276 13 күн бұрын
This is a great video. Relied on it heavily while building several reports. Thank you very much.
@AnthonySmoak
@AnthonySmoak 11 күн бұрын
I appreciate you sharing this feedback, thank you!
@shirley957
@shirley957 14 күн бұрын
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) 😊
@AnthonySmoak
@AnthonySmoak 11 күн бұрын
Much appreciated Shirley. We definitely need that all lines off button!
@DarkArcticDay
@DarkArcticDay 15 күн бұрын
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!
@Child_of_the_most_High_God
@Child_of_the_most_High_God 15 күн бұрын
I just stumbled across your videos, and I can definitely say great stuff
@AnthonySmoak
@AnthonySmoak 15 күн бұрын
Thank you; make sure to tell a friend!
@mihirachandrasiri9307
@mihirachandrasiri9307 20 күн бұрын
Thank you vey much!
@AnthonySmoak
@AnthonySmoak 20 күн бұрын
Thanks for the comment!
@ParvanaGasimova
@ParvanaGasimova 22 күн бұрын
excellent amazing thanks
@AnthonySmoak
@AnthonySmoak 11 күн бұрын
You're too kind!
@brothertoughlove
@brothertoughlove 22 күн бұрын
Good work 👍🏿
@AnthonySmoak
@AnthonySmoak 22 күн бұрын
@@brothertoughlove Thank you!
@razor5352
@razor5352 23 күн бұрын
Now I understand the difference. Great video lesson 👍👍👍
@mnvsaikiran
@mnvsaikiran 25 күн бұрын
Very nice but the video is fast. Please see if you can make it go slow.
@AnthonySmoak
@AnthonySmoak 25 күн бұрын
Adjust your playback speed in the settings.
@oizysss
@oizysss 25 күн бұрын
Hey, why my SUM(Sales Selected Year) is null?
@jaygibbs7218
@jaygibbs7218 27 күн бұрын
I cant get my button to execute I click it and nothing I tried this 3 times and I dont see anything wrong
@AnthonySmoak
@AnthonySmoak 26 күн бұрын
@@jaygibbs7218 I assume you have design mode turned off and your code is placed in the on click action?
@yoseppramudito8890
@yoseppramudito8890 28 күн бұрын
I still use this method. Are there any other methods, or is it still the same?
@AnthonySmoak
@AnthonySmoak 10 күн бұрын
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.
@RIVASCOSTA
@RIVASCOSTA Ай бұрын
Hi, thank you, I dont have the option "MAKEDATE", do you know if is it normal? If yes, is there any other formula?
@AnthonySmoak
@AnthonySmoak Ай бұрын
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
@TheBinary0101
@TheBinary0101 Ай бұрын
Super !! thx lots .. subscribed
@AnthonySmoak
@AnthonySmoak Ай бұрын
Much appreciated!
@USA_to_Asia_in_2024
@USA_to_Asia_in_2024 Ай бұрын
Thank you Brother Smoak.
@AnthonySmoak
@AnthonySmoak Ай бұрын
@@USA_to_Asia_in_2024 Thank you!
@DayJones-wb7ig
@DayJones-wb7ig Ай бұрын
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!
@lizcameron3299
@lizcameron3299 Ай бұрын
Curious: what would I do if the duration would be over 20 years? Would I still have to enter the # of days?
@jackiehay2914
@jackiehay2914 Ай бұрын
Hello! Where can I find the dataset to follow along? Could you please post it ?
@AnthonySmoak
@AnthonySmoak Ай бұрын
@@jackiehay2914 Just do a Google search for "Tableau Superstore dataset". Some version of the file should be in multiple places.
@jackiehay2914
@jackiehay2914 28 күн бұрын
@@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.
@williambeasley838
@williambeasley838 Ай бұрын
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.
@paulpostma6520
@paulpostma6520 Ай бұрын
Would better without the music - too distracting
@KennelRottweiler-Haus
@KennelRottweiler-Haus Ай бұрын
Waiting for Part 2
@calebbrady11
@calebbrady11 Ай бұрын
Thank you, Anthony. Very helpful!
@AnthonySmoak
@AnthonySmoak Ай бұрын
Thank you for the comment!
@YashadaKul
@YashadaKul Ай бұрын
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!
@AnthonySmoak
@AnthonySmoak Ай бұрын
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!
@Cavalier70
@Cavalier70 Ай бұрын
Way to hard to follow and disjointed
@AnthonySmoak
@AnthonySmoak Ай бұрын
Nothing worth having comes easy.
@thehunter11
@thehunter11 2 ай бұрын
We're having a serious PARTITIONING case here. You the truth man, thanks.
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
You're the real MVP, thanks for the comment!
@kailashsathia3080
@kailashsathia3080 2 ай бұрын
LOVE YOUR CONTENT. HELPED ME A TON AT WORK.
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
I'm very glad to hear that, thanks for sharing!
@Ivy_1057
@Ivy_1057 2 ай бұрын
Thank you for the lesson! 👏
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Thanks for leaving a comment!
@AllisonRosenbaum
@AllisonRosenbaum 2 ай бұрын
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?
@anuskasarkar2183
@anuskasarkar2183 2 ай бұрын
This is helpful but when I am downloading the extract from tableau server, I am getting duplicate values
@kennisrogers2585
@kennisrogers2585 2 ай бұрын
Hey, this was awesome :) i look forward to more guides
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Thank you!
@tejeswarreddy6260
@tejeswarreddy6260 2 ай бұрын
How to create a connection when other user opens the Excel file , the data will refresh automatically, without prompting to authenticate to SQL
@mirrrvelll5164
@mirrrvelll5164 2 ай бұрын
Great to follow this. I managed to do it/implement it into my report. Thanks and you got +1 new sub =)
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Glad to hear it, thank you!
@mirrrvelll5164
@mirrrvelll5164 19 күн бұрын
@@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.
@AnthonySmoak
@AnthonySmoak 18 күн бұрын
@@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
@anthonylozito691
@anthonylozito691 2 ай бұрын
Helped!
@noelfrias2361
@noelfrias2361 2 ай бұрын
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?
@El_prof86
@El_prof86 2 ай бұрын
great videos !!!! Simple and Nice man !! tnx
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Simple and nice is what I was aiming for, thank you!
@yassera.rahman4100
@yassera.rahman4100 2 ай бұрын
Great explanation. Thanks
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Thank you!
@fidi7400
@fidi7400 2 ай бұрын
Thanks so much, you really helped me understanding grouping by and partition by. My lines of code now work as intended!
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Fantastic, glad to hear that you learned something new!
@RamMukesh86
@RamMukesh86 2 ай бұрын
We can use copy formatting from one worksheet to another worksheet for bar chart to save time😊
@filiporg5799
@filiporg5799 Ай бұрын
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.
@aspirationalaudio4025
@aspirationalaudio4025 2 ай бұрын
Really Thank you for your explanation 😍😍 a New Like and subscription From Egypt 🤙
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Thank you for supporting the channel!
@hameheroj4030
@hameheroj4030 2 ай бұрын
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 :/
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Glad to hear it!
@coreypea6225
@coreypea6225 2 ай бұрын
Thank you man, you are a lifesaver!
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
Thanks for the comment, much appreciated!
@jdwyer4851
@jdwyer4851 2 ай бұрын
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.
@AnthonySmoak
@AnthonySmoak 2 ай бұрын
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.
@jdwyer4851
@jdwyer4851 2 ай бұрын
@@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.
@AnthonySmoak
@AnthonySmoak Ай бұрын
@@jdwyer4851 I made a video exploring the MS Query approach. Thanks for the comment. kzfaq.info/get/bejne/aNWEYLOZzMmvkWw.htmlfeature=shared
@jdwyer4851
@jdwyer4851 Ай бұрын
@@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.
@timpanister73
@timpanister73 2 ай бұрын
Thanks! Can't wait to see Part 2!
@jasonbehrens3992
@jasonbehrens3992 2 ай бұрын
🎓