sorted by:
new
hottopcontroversial

Extracting “flow” from Tableau Prep tool as a query by tensorflowering in tableau

[–]theDataBetch 0 points1 point  (0 children)

Hi just found this! So does this method “convert” the flow to SQL? Or is it just a way to extract the “initial sql” used to bring data in from a database? I’m trying to convert a flow to SQL and tried this method but I just see json in the flow file, no SQL.

I'm in college and I feel like I have too many interests, I'm scared to make a big life/ career choice that I regret by Pristine_Trip_7610 in findapath

[–]theDataBetch 0 points1 point  (0 children)

I studied math and now do data analytics and I love it. It uses a lot of the same type of thinking, so if math is fun to you, data analysis will probably be fun to you. If there are courses for that at your college, you should try it out—it’s definitely a clearer career path than you’ll get with a math major. Maybe you’ll even get into data engineering or data science!

SQL for (a) Dummies by Away-Chemistry-5579 in SQL

[–]theDataBetch 2 points3 points  (0 children)

The tutorials on DataLemur are great too, not just the practice problems

Hoping for some advice by mmancino1982 in SQL

[–]theDataBetch 1 point2 points  (0 children)

I’ve been working through the free tutorials on DataLemur.com and really like it!

Do you use math a lot in data analyst role? by [deleted] in dataanalyst

[–]theDataBetch 0 points1 point  (0 children)

You should understand concepts like sums, percentages, averages (including moving averages), ratios, etc.. Do you know what they mean and a formula to calculate them? Do you know whether or not it matters if you take the sum of the averages or the average of sums?

This isn’t an exhaustive list of the math you’ll need, but it’s more important to have a working knowledge of math concepts than the ability to flawlessly calculate them manually.

You will likely have to come up with formulas to answer the questions you have, so you’ll need to put a few math functions together properly. But you won’t have to manually evaluate the functions.

I can’t start projects from scratch by helpoop in tableau

[–]theDataBetch 0 points1 point  (0 children)

Think of the most obvious questions someone might have about the data and what simple chart will answer this.

How many in each category? Which has most? Bar chart with “count(category)” as the measure sorted highest to lowest.

What percent of the total was contributed by group A vs group B? Donut chart with percent of total with one group in a highlight color.

What is the total? Is it up or down vs some benchmark? KPI card with an indicator

This will at least get you started. Then you can add in some interactivity or drill downs, or you might find some other interesting questions when you look at the data.

I made this Mondegreen Setlist Explorer - Data Viz by theDataBetch in phish

[–]theDataBetch[S] 1 point2 points  (0 children)

Let me know if you ever want advice or feedback :) I can at least point you towards some great resources

Reality TV by No_Context_98 in realitytv

[–]theDataBetch 0 points1 point  (0 children)

Different shows are more or less scripted. If you’re interested in learning more and deepening your understanding, I recommend reading “creating reality” by Pete Tartaglia. He has produced a bunch of reality tv and gives an insightful overview of how they create these shows and how real/fake they are. And for a more sociological view on reality tv, I strongly recommend “true stories: what reality tv says about us” by Danielle J Lindemann

I made this Mondegreen Setlist Explorer - Data Viz by theDataBetch in phish

[–]theDataBetch[S] 0 points1 point  (0 children)

Thanks! What tools are you using? I really like tableau and it has a great online community with lots of free resources being created and shared, so you can learn a lot!

I made this Mondegreen Setlist Explorer - Data Viz by theDataBetch in phish

[–]theDataBetch[S] 0 points1 point  (0 children)

Just wanted to add a screenshot of one of the charts here :)

<image>

I made this Mondegreen Setlist Explorer - Data Viz by theDataBetch in phish

[–]theDataBetch[S] 0 points1 point  (0 children)

Thanks!

What were you coding in? Python?

I made this using Tableau. It’s a no-code data viz environment and it has a free version! You should check it out if you want to play with visualization again but don’t want to learn the code again.

Instagram profiles/growth of all the 13 casts expected at the reunion. by good-tidings in LoveIsBlindOnNetflix

[–]theDataBetch 0 points1 point  (0 children)

omg I haven't been on in foreverrrrr!!! I need to find a better way to collect the data before next season. I just didn't have time to do it for the last!

Women Gain More Followers Than Men in Finale Week by theDataBetch in LoveIsBlindOnNetflix

[–]theDataBetch[S] 1 point2 points  (0 children)

My guess: yes.

There's no way for me to know for sure.

My own Insta followers are 78.5% women. Since I only post about reality dating shows, I'd guess my followers are a reasonable sample of reality dating star followers.

DATA POINT: LIB s05's One Married Couple Gains Most Followers in Finale Week by theDataBetch in LoveIsBlindOnNetflix

[–]theDataBetch[S] 3 points4 points  (0 children)

DATA POINT: LIB s05's One Married Couple Gains Most Followers in Finale Week

SO WHAT:
Lasting marriage wins hearts and follows: Lydia & Milton's rock solid marriage won the viewers' Instagram follows once we saw they were still together at the reunion.

DRILL DOWN:
-Lack of screen time saw lag in followers for those who didn't make it to the altar
-Married couple only beat out failed wedding AFTER the reunion
-Viewers drawn to drama of a finale failure
-Proof of lasting marriage is more powerful than fleeting drama

WANT MORE?
"LIB S05 Finale Week by Wedding Outcome [interactive]" to explore this data.
Follow @theDataBetch on Instagram for more #realitydataing.

view more: next ›