Dashboards now appear in the lineage view of the Tableau catalog.
Be sure to check out out my professional home, @The Information Lab for more great Tableau, Alteryx and AWS content.
Visit my blog https://tableautim.com
Say hi on twitter: https://twitter.com/tableautim?l ---
Files used in my videos for 2020.2 videos: https://j.mp/2YvaEot ----
Join my Discord Server. https://discord.gg/shBuxXr it's a little sparse at the moment but hang in there.
...
https://www.youtube.com/watch?v=rYAxsgIcFLw
In this video, we will see if we can use the power of ChatGPT to solve a regex challenge in Tableau. Specifically, we will try to extract emails from a paragraph of text text using ChatGPT's advanced natural language processing capabilities. We will walk you through the process step-by-step. We will also provide tips and tricks for optimising your question in Chat GPT to improve the accuracy of its response and troubleshoot where necessary to make the calculation work. Whether you're new to using ChatGPT or a seasoned pro, this video will give you the knowledge and skills you need to confidently tackle any regex challenge in Tableau.
Rregex101: build, test, and debug regex https://regex101.com/r/0v0M6o/1
Additional Functions - Tableau https://help.tableau.com/current/pro/desktop/en-us/functions_functions_additional.htm
Data from mocker Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel https://www.mockaroo.com/bdcc6ce0
Timestamps
0:00 Intro
0:16 The challenge
2:49 Asking Chat GPT
4:53 testing the formula it gave us
6:31 Verdict on the response
7:11 Asking a better question
10:09 Can chat GPT explain the formula?
11:59 Using regex 101 to validate the formula
Join this channel to get access to perks:
https://www.youtube.com/channel/UC7HYxRWmaNlJux-X7rNLZyw/join
#tableau #salesforce #analytics #data
Follow me on Twitter: https://twitter.com/TableauTim
My recording gear & what's on my desk. https://kit.co/TableauTim/desk-setup
My website: https://www.tableautim.com/
My Screen Annotation Tool: https://j.mp/3HWc4Mj
My technology Channel: https://j.mp/3F0d28f
Share feedback and Suggestions: https://tableautim.canny.io/suggestions
...
https://www.youtube.com/watch?v=G6VQHs4QSAk
Tableau blog on this feature: https://www.tableau.com/about/blog/2020/4/get-ask-data-your-dashboard-smart-simple-self-service-analysis
"Now it’s possible to integrate Ask Data right into your dashboard, enabling easy and powerful, in-context natural language analysis in just a few short steps. All you need is a show/hide dashboard object with Tableau Desktop and Tableau Server or Online 2019.3+"
...
https://www.youtube.com/watch?v=fVBSodjoUUA
You can connect to a named range or an Excel table (also known as an Excel list) in the same way as you connect to a worksheet. Both the named range and Excel table function as a table in Tableau.
You create named ranges in Excel by selecting a range of cells and then selecting Define Name on the Formulas tab. Similar to named ranges, you can create an Excel table in Excel by selecting a range of cells, and then selecting Insert - Table. When you connect to a named range or Excel table in Tableau, an icon appears next to the sheet in the Data Source page, as shown below.
00:00 - Intro
00:16 - When to use this trick
01:31 - Named ranges in Excel and how they work
04:03 - How to connect to named ranges in Tableau Desktop
06:34 - Working with the connections
08:53 - Connecting to named range sin Tableau Prep
Follow me on Twitter: https://twitter.com/TableauTim
My recording gear & what's on my desk. https://kit.co/TableauTim/desk-setup
My website: https://www.tableautim.com/
My Screen Annotation Tool: https://j.mp/3HWc4Mj
My technology Channel: https://j.mp/3F0d28f
...
https://www.youtube.com/watch?v=j5VUqMIcr2I
00:00 - Intro
00:35 - PARAMETER INTERFACE
02:46 - USE THE PARAMETER IN THE FLOW
Follow me on Twitter: https://twitter.com/TableauTim
My recording gear & what's on my desk. https://kit.co/TableauTim/desk-setup
My website: https://www.tableautim.com/
My place of work: https://www.theinformationlab.co.uk/
...
https://www.youtube.com/watch?v=1unEg5skU3E
With this update, Site admins can now control who has the ability to create PATs (Personal access tokens) in Tableau, and they can now control how long PATs are valid, ranging from 1 to 365 days.
A Personal Access Token (PAT) is a type of authentication token that acts as an alternative to a traditional username and password for accessing specific services, especially web-based APIs.
...
https://www.youtube.com/watch?v=C265A5fSATU
Diego Parker's Post: http://j.mp/3aWVooa
In this last video of the series, I walk you through how unions and joins work in Tableau Prep builder. In excel this would typically be a manual operation leaving you to human error if you incorrectly configure a V lookup or incorrectly union two data sets. Tableau prep gives you a fast easy and safe way to make sure the relationships in your data make sense and it makes it easy to spot scenarios where your matches don't work the way they should. -----
Join my Discord Server. https://discord.gg/shBuxXr it's a little sparse at the moment but hang in there.
...
https://www.youtube.com/watch?v=f7tTlG2mfxc
Following on from the last video, we get stuck into the Snowflake guide on getting started with Snowflake.
Find the guide here: https://j.mp/3nYHYPo
Intro 0:00
The overview of the interface 2:52
The snowflake web UI toolbar & Databases 4:29
Snowflake Shares 7:37
Snowflake data marketplace 8:32
Snowflake warehouses 9:42
Snowflake worksheets 15:22
Snowflake History 16:09
Snowflake admin tab 18:55
Preparing to load data into Snowflake 21:06
Setting up the database in Snowflake 22:37
Set Context for the worksheet in Snowflake 25:24
Run a query in the Snowflake web interface 27:49
Viewing a table and creating a stage in Snowflake 31:28
List files in an S3 bucket in Snowflake 36:29
Create a file format in Snowflake 38:02
Loading Data and debugging the file format 41:10
Main Timeline 52:25
...
https://www.youtube.com/watch?v=M6tqms7PhN8
We’ve been away for even more time, but we're back to close off the season with one final episode to round off our thoughts on the Tableau Conference 2020 aka Tableau conference'ish
Feedback welcome on Twitter to Ravi at @scribblr_42 or Tim at @tableautim - or e-mail us, at datumpodcast@gmail.com (mailto:datumpodcast@gmail.com)
...
https://www.youtube.com/watch?v=2GZjwA8n5dg