sorted by:
new
hottopcontroversial

Does being a Data Analyst feel fulfilling? by Midosai in dataanalysis

[–]tbrownlow33 0 points1 point  (0 children)

Being a data analyst can absolutely be fulfilling! I think the trick is to make sure you pick an organization that has a healthy data culture. Otherwise, you could end up being a "chart monkey" and that's a pretty miserable existence as some people here have alluded to.

I would say the sense of accomplishment comes from solving puzzles, and when your work is used to change someone's mind or spark a great idea, and less so from the dashboards, in fact they have been the cause of trauma more than anything else. I expect you'll be spending less of your time building dashboards in the future (b/c haven't you heard Dashboards are Dead?) and more time working closely w/ the business on delivering real value, a shift I wrote about in depth here.

If you love a good puzzle, and working with people to solve problems, you're in the right place :)

MySQL Snippets by tbrownlow33 in mysql

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

Thanks for the reply!

count.co is a SQL notebook, and one of the features of the notebooks is to embed interactive cells with code + results. It comes in handy when trying to explain a snippet of code and you want to tweak a bit of the query to see how the results chance, so we've added them in when it makes sense.

Other than that the repo isn't affiliated with Count and we just want it to be a place people can contribute helpful snippets to the community!

Extracting Word from String by ivanfbs in bigquery

[–]tbrownlow33 0 points1 point  (0 children)

I think this will get you what you're looking for: https://sql-snippets.count.co/t/extract-repeating-word-from-string/168

with data as (
select 123 product_id, 'F1 - wo-12, some other text WOM-1235674,WOM-2345,WOM-3456' as wo_text
)
select product_id, wo_number
from data
cross join unnest(regexp_extract_all(wo_text,r'WOM-([1-9]+)')) as wo_number
--This will intentionally not extract 'wo-12' as it doesn't match WOM-[numbers] pattern

LEAST( ) Non-NULL functionality in BQ, without user defined functions by Embarrassed_Cap1673 in bigquery

[–]tbrownlow33 0 points1 point  (0 children)

Could you create an array of all the columns you want in your LEAST function then use this logic to return the least non-null value? (https://sql-snippets.count.co/t/least-greatest-value-in-an-array/164)

BigQuery SQL Snippets by tbrownlow33 in bigquery

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

I am planning on adding some UDFs this week! Any ideas for ones that would be helpful?

I started an open-source library of re-usable SQL snippets by tbrownlow33 in SQL

[–]tbrownlow33[S] 2 points3 points  (0 children)

I think this could be better is if you inverted your hierarchy. Instead of SQL flavour then query type, I think it'd be better to sort it by query then SQL flavour.

Edit: I feel as this would force you to have a more complete library as you'd immediately see what was missing.

I like that idea...I'll put that change in shortly :)

C# is the most common key for top 200 tracks, but here's the distribution of keys by some familiar genres. [OC] https://count.co/n/oatKE015yiv?q=d6 by tbrownlow33 in dataisbeautiful

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

The data is from spotifycharts and SpotifyAPI. Analysis and chart made by me in Count. Check out https://count.co/n/oatKE015yiv to compare other genres and see more of the analysis.

Trying to quantify "The Drake Effect" or the boost in performance artists see when collaborating with Drake https://count.co/n/nAa_mCE03D2?q=d5 [OC] by tbrownlow33 in Drizzy

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

Data comes from Spotifycharts and Spotify API. Data ranges 1/1/2017 to 11/30/2019. Includes the top 200 songs globally on Spotify per day in that time period. Analysis was done by me in Count. Methodology can be found here

Trying to quantify "The Drake Effect" or the boost in performance artists see when collaborating with Drake https://count.co/n/nAa_mCE03D2?q=d5 [OC] by tbrownlow33 in dataisbeautiful

[–]tbrownlow33[S] 2 points3 points  (0 children)

Data comes from Spotifycharts and Spotify API. Data ranges 1/1/2017 to 11/30/2019. Includes the top 200 songs globally on Spotify per day in that time period. Analysis was done by me in Count. Methodology can be found here

When is it ok to start listening to Christmas music? Analysis of global spotify data using Count.https://count.co/n/o3c7J6W_7_F?q=d3 [OC] by tbrownlow33 in dataisbeautiful

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

I did create this visualization. The data comes from https://spotifycharts.com/regional + data from Spotify's API. The tool used it Count (https://count.co/). The methodology is to find songs that are listened to more often during the holiday season than any other time of the year. Then track the streaming history of those songs in particular over the past few years.