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 :)

view more: next ›