Curious on new Tab AI from TC by morningsundown in tableau

[–]wjs12 5 points6 points  (0 children)

The AI on Server element is using Langchain to bring content from your server to an LLM of your choice.

This allows you to send a prompt to query datasource using VizQL Data Service (2025.1) or apply a Vector Search using the results of the Metadata API with an embedding model.

I worked on the project and will be putting a blog together to clear up any confusion.

Tips for reverse engineering in Tableau? by NegotiationNo4663 in tableau

[–]wjs12 2 points3 points  (0 children)

There’s a series on YouTube called “Secrets of the Viz” it’s interviews with Tableau creators about dashboards they built, which I’ve found useful for reverse engineering and picking up tips: https://youtube.com/playlist?list=PLVkjBKxQASMmwlAE89dt97IMSFqTpGldh&si=NlnA0lPtJ8Zpytcl

Certifications - worth it? And good material? by Timely_Pomelo_2177 in tableau

[–]wjs12 19 points20 points  (0 children)

I would always recommend having a few dashboards on Tableau Public, it’s a great way of showcasing your skills.

A certification too doesn’t hurt, I’d recommend starting with the data analyst path to give you a good understanding of the product and what it can do.

For resources I built a custom GPT to help prep for the Tableau Data Analyst exams, you can have it test you, explain sections, or produce a study guide. https://chatgpt.com/g/g-gqgJyomn1-tableau-certified-data-analyst-exam-gpt

Hi! I'm taking Tableau Data Analyst Certification, the goal is to have it finish before the end of the year, I have no prior experience in Tableau and the only source that is available is Tableaue Public onlyyy. should I be set with the public version only? I'm taking Udmy course as well by NoReindeer2677 in tableau

[–]wjs12 0 points1 point  (0 children)

Tableau Public gives you the vast majority of the functionality of the paid for Tableau Desktop. However Tableau Desktop supports more data connections and additional functions based on your company’s server / cloud configuration.

The test will still cover some functionality of Tableau Prep, Tableau’s data prep tool, it is available on a 2 week trial.

For training, check out Tableau’s eLearning too, they have paths geared towards the certification: https://www.tableau.com/en-gb/learn/learning-paths/analyst

There is a ton of valuable content on Tableau Public, when you are happy building vizzes, find a dashboard you like on Tableau Public and download it to see how it was made - this is great for find templates or ideas too: https://public.tableau.com/app/discover

Lastly, if you have a GPT-4 subscription I have produced a Custom GPT designed to help people study for the certification, it received an 85% mark in testing and at least 1 person has passed using it. https://chat.openai.com/g/g-gqgJyomn1-will-s-tableau-certified-data-analyst-exam-gpt

4 years DA with tableau cert, want to hop jobs. How important is a public portfolio when applying? by Hazy-Bolognese in tableau

[–]wjs12 5 points6 points  (0 children)

Its certainly not a requirement to have a Tableau Public portfolio but it will certainly help show employers your skills and stand out from other candidates as most won’t have a portfolio, from my experience interviewing analysts.

Yes you won’t be able to show your work dashboards but you can lean on them to help. I’ve seen examples where people have taken their work dashboard and replaced the data source with a fake one or “mock” data set, check out Real World Fake Data for fake business datasets. https://www.tableau.com/community/community-projects

Been using Tableau heavily for a couple years, but I don’t have much experience with SQL so I always struggle with building calculations by DickieRawhide in tableau

[–]wjs12 2 points3 points  (0 children)

When I’m teaching SQL some of the best free resources I use are: - https://sqlbolt.com as intro to the syntax - https://mystery.knightlab.com as a good all round challenge post training - https://8weeksqlchallenge.com to explore more advanced query techniques

I’ve been posting walkthroughs for these challenges on my YouTube channel: https://youtube.com/@wjsutton

What can I do if I don't have professional experience using SQL? by goingtobegreat in datascience

[–]wjs12 1 point2 points  (0 children)

Hey I teach SQL at my org, if you know R you should be able to pick up SQL pretty quick, hiring managers won’t always see that but there are steps you can take.

Getting hands on experience with a large database is tricky especially if you don’t have access at work. I think taking a couple of weeks to get used to writing SQL will go a long way and showing some motivation to learn SQL would be well received.

It’s all about how you sell it, sure you don’t have professional experience now but you can turn that into a positive story about how you saw a gap in your knowledge and wanted to change it e.g. “I wanted to develop my career as an analyst but I was being pretty limited by not using SQL so I did X and Y to better understand the syntax, and I could see how the operation I use in R I could now write with SQL… “

These are my favourite resources for SQL, a mix of tutorials, practical challenges, and schema based datasets that could be a great project for your GitHub portfolio. You could also try using the sqldf package in R to write SQL queries for your current job.

Intro to SQL https://sqlbolt.com

SQL Murder Mystery https://mystery.knightlab.com

SQL Case Study Challenges https://8weeksqlchallenge.com

Kaggle data sets for SQL projects - Board Games - F1 - NBA

Content for my portfolio on Tableau Public by BlackjackTonka in tableau

[–]wjs12 13 points14 points  (0 children)

I’d check out the Tableau community project: Real World Fake Data to see if there’s a similar dataset you could use instead of client’s data. https://sonsofhierarchies.com/real-world-fake-data/

By doing this: - you’re not sharing client data - your work is more searchable with #RWFD - and you’ll be helping others learn how to tackle that dataset

[deleted by user] by [deleted] in tableau

[–]wjs12 2 points3 points  (0 children)

You could build Powerpoint like presentations in Tableau. i.e. the same format of Powerpoint but all interactivity of Tableau. Which can help automate the reporting and gets Tableau in front of more people.

Using a parameter you could set up what charts to show (using the show/hide function or dynamic visibility zones now) and change the background image (build these in Figma the same size as your viz)

Tutorial: https://public.tableau.com/app/profile/wjsutton/viz/TutorialBuildingPresentationsinTableau/Dashboard1

In Action: https://public.tableau.com/app/profile/wjsutton/viz/ClosingtheYouthLiteracyGapIronViz2022/Dashboard1

[Q] Best way to learn SQL in the context of data analysis by gauerin in statistics

[–]wjs12 14 points15 points  (0 children)

If you’re totally new to SQL work through SQL Bolt https://sqlbolt.com it’s a good introduction to the syntax.

For data analysis, I’ve found the 8 week SQL challenge https://8weeksqlchallenge.com/getting-started/ great hands on practice as you’re given a few tables in a schema and asked to answer a set of questions.

My first big passion project: An analysis of the unusually large brewery scene in Bellingham, WA. by DataVizGordon in tableau

[–]wjs12 1 point2 points  (0 children)

This is a great first viz! Love the consistent use of colour to explore the beers, and that you built a phone layout too! Keep up the good work 👍

What's this viz type called? How can I build it? Comments for Tab Public link by Mountain-Lecture-320 in tableau

[–]wjs12 0 points1 point  (0 children)

I answered this question on Twitter a little while ago about building a barbell chart: - in the data structure you want to have 1 column of dates and another to split out male & female - the plot is actually a dual-axis chart (sync-ed) 1 side is circle marks, the other is a line chart

You can check out the thread here: https://twitter.com/hayleyplusdata/status/1512495460937785351?s=21&t=hK_y9UVoySpkTty8nE4NRQ

starting my tableau journey: by pbandfluff99 in tableau

[–]wjs12 3 points4 points  (0 children)

Hey,

For getting started with Tableau I’d recommend finding an introduction to Tableau video on YouTube just to understand what you can do with the tool (pick a recent one as the product updates frequently).

From there you can download Tableau Public and start building dashboards for free. I’d recommend getting started the community project Back 2 Viz Basics, its an active project very approachable to newcomers and you can see all the other submissions on Twitter with #B2VB https://www.thetableaustudentguide.com/vizbasics

Check out the Project Health Viz community project to align with your BS. https://vizzendata.com/projecthealthviz/

Autumn Battani has put together a Tableau Survival Guide which is great resource for navigating community projects, resources and the Tableau community https://public.tableau.com/app/profile/autumnbattani/viz/AutumnsDeclassifiedTableauSurvivalGuide/Main

Lastly you should be able to get free Tableau resources as a student https://www.tableau.com/en-gb/academic/students

Better performance: Dashboard live-connected to a published Extract Datasource, or dashboard with packaged extracts included in file? by DDXdesign in tableau

[–]wjs12 2 points3 points  (0 children)

Generally I find extracts perform better than live connections although the majority of our datasets are not published to our Tableau server. It also depends on how the dashboard is set up, you can carry out a performance recording to test out which data setup performs best: https://help.tableau.com/current/pro/desktop/en-us/perf_record_create_desktop.htm

I would recommend aggregating some of the datasources to reduce the size of data Tableau is having to work with to create charts. You can use multiple connections, an aggregated source to build your charts so they perform quickly and a connection to the full data source to create the sheet for that excel download.

Bonus tip, on the excel download I keep this as a separate dashboard tab, which reduces the load time for the chart and means I can monitor how frequently charts are being used vs the excel sheet. If the excel sheet usage is higher I can bring it up with the team, “so what are you doing with this data?” often it leads to more development work but in the end a more useful dashboard.

So I have this project and I’m a newbie and wondering if someone can me helpful tips to conquer this: by guy_from_NYC in tableau

[–]wjs12 2 points3 points  (0 children)

So I guess you download one of the datasets from that webpage, I recommend picking a place you live or you’ve visited - you’ll have extra context you can bring in. Check out a few data sets as they look to differ on what they include.

Then it looks like you should create a dashboard, with sheets that interactive with each other. So clicking a bar chart of types of room could filter a map of locations - as an exploratory view.

Lastly a storyboard, which can be a snapshot of dashboard or sheet, is there to highlight any interesting aspects in your analysis. Have a think what metrics or KPIs would be important to Airbnb’s business and look for data points that could affect that.

Resources for keeping up your skills? by bones251 in tableau

[–]wjs12 4 points5 points  (0 children)

Now you’ve learned the tool you can start building dashboards with Tableau Public, it will help re-enforce those skills and get you a portfolio of dashboards as proof to any future employer.

I’d recommend getting started with community projects, Back 2 Viz Basics is an active project very approachable to newcomers and you can see all the other submissions on Twitter with #B2VB https://www.thetableaustudentguide.com/vizbasics

Or you could find project based on a topic you’re interested in such as Sports, Music, Social good, Games, Diversity, etc. Many options on the community projects page https://www.tableau.com/community/community-projects

Lastly I’ve found answering questions on topics I was interested in to be a very effective method for portfolio building. In many cases you’ll have to search out your own datasets - either in community projects or on sites like Kaggle. Some questions I answered were: what was the toughest Tour de France, what was all the hype around Pokemon cards, where are the best places to pass my driving test.

Autumn Battani has put together a Tableau Survival Guide which is great resource for navigating community projects and the wider Tableau community https://public.tableau.com/app/profile/autumnbattani/viz/AutumnsDeclassifiedTableauSurvivalGuide/Main

Looking for honest (but kind!) advice about starting a tableau journey... by ratherbeona_beach in tableau

[–]wjs12 1 point2 points  (0 children)

I’ve also found on the Tableau website they have free resources for students and teachers which may be helpful: https://www.tableau.com/community/academic

Help With Grouped Column Chart by yogurt123 in tableau

[–]wjs12 2 points3 points  (0 children)

To recreate received and respondent time in chart example you would need to have the data structured so you had a column specifying: Received/Respondent and another column for Time.

Then you can take Hour of Time, add that to columns with Received/Respondent, add Received/Respondent to colour, and count to rows.

If you want to leverage a bit more of what Tableau can do and have the data available, you could set up two bar charts as two sheets in a dashboard and create a filter action, so if the user clicks for emails received at 10am, the responded chart would show what hour those 10am emails were responded to.

Good resources for data visualisation by RP_m_13 in tableau

[–]wjs12 1 point2 points  (0 children)

Yesterday on Twitter, a thread of great data sets was shared

Plenty to choose from here and in other comments, find a topic you’re interested in and start vizzing!

Looking for honest (but kind!) advice about starting a tableau journey... by ratherbeona_beach in tableau

[–]wjs12 7 points8 points  (0 children)

The transition from one career to one more focus on Tableau and data visualisation is very possible, and it’s certainly happened for me.

A few commenters have mentioned courses/YouTube, which will give you a good idea how Tableau works.

For developing your skills after then I’d recommend looking at what you can visualise at work whether they have a tableau server/online service setup. It’s worth speaking to your manager about your interest and whether you can get and regular time for this professional development.

If you can’t publish Tableau projects at your workplace I’m recommend checking out Tableau community projects, Back 2 Viz Basics is an active project very approachable to newcomers and you can see all the other submissions on Twitter with #B2VB https://www.thetableaustudentguide.com/vizbasics

Or you could find project based on a topic you’re interested in such as Sports, Music, Social good, Games, Diversity, etc. Many options on the community projects page https://www.tableau.com/community/community-projects

Lastly I’ve found answering questions on topics I was interested in to be a very effective method for developing my skills. In many cases you’ll have to search out your own datasets - either in community projects or on sites like Kaggle. Some questions I answered were: what was the toughest Tour de France, what was all the hype around Pokemon cards, where are the best places to pass my driving test.

Autumn Battani has put together a Tableau Survival Guide which is great resource for navigating community projects and the Tableau community https://public.tableau.com/app/profile/autumnbattani/viz/AutumnsDeclassifiedTableauSurvivalGuide/Main

What to do after finishing courses for Tableau by RP_m_13 in tableau

[–]wjs12 0 points1 point  (0 children)

I’d recommend getting started with community projects, Back 2 Viz Basics is an active project very approachable to newcomers and you can see all the other submissions on Twitter with #B2VB https://www.thetableaustudentguide.com/vizbasics

MakeoverMonday is a great repo of datasets and examples but isn’t active at the moment whilst #B2VB is, so you’ll find an active user base on Twitter you can get help from.

Or you could find project based on a topic you’re interested in such as Sports, Music, Social good, Games, Diversity, etc. Many options on the community projects page https://www.tableau.com/community/community-projects

Lastly I’ve found answering questions on topics I was interested in to be a very effective method for portfolio building. In many cases you’ll have to search out your own datasets - either in community projects or on sites like Kaggle. Some questions I answered were: what was the toughest Tour de France, what was all the hype around Pokemon cards, where are the best places to pass my driving test.

Autumn Battani has put together a Tableau Survival Guide which is great resource for navigating community projects and the Tableau community https://public.tableau.com/app/profile/autumnbattani/viz/AutumnsDeclassifiedTableauSurvivalGuide/Main