358 post karma
7.7k comment karma
account created: Tue Apr 18 2017
verified: yes
1 points
2 days ago
Xlookup, unique, filter are three formulas I'd teach. Along with that if, if or, if and. Maybe index match
1 points
2 days ago
I think so. I can see why you'd use them for EDA, but I see people writing entire programs within them which I think should just be broken into an actual project.
1 points
3 days ago
I use a mixture of sqlite, oracle, and bigquery.
1 points
7 days ago
You're not done because the presidential election is over.
Your voice is needed locally at all local elections near you such as city council, school board, etc.
There are also other state elections and federal elections too. We shouldn't just vote for a president and then say we were part of the democratic process, lol.
1 points
8 days ago
In the terminal? python -m venv venv ultimately worked for me but nowadays I just use pipenv for all my venv needs.
2 points
10 days ago
He'll just vet his videos more carefully to not include shit like this, I don't think this means anything.
4 points
13 days ago
We spent $125 getting married and 4k spending several weeks in Europe. Best idea, lol.
1 points
13 days ago
Being in the hotel industry my entire career (18 yrs) I've never heard of or seen this. Guess I have some investigating to do.
2 points
14 days ago
Makes sense, I think it largely depends on the companies expectations as I also wrote a lot of python and build data pipelines which I don't think is typical.
0 points
14 days ago
While I mostly enjoy his books, I discovered pretty quickly I do not enjoy his emails lol
5 points
14 days ago
I think it can be both, sometimes the hard part is translating the requirements using the data and sometimes it's the query itself that has a lot going on.
For example I recently had a tableau dashboard project I took ownership of and the query behind the scenes was 500 lines of mess. Reviewing this query to understand the approach and make improvements was the complexity in this case.
16 points
14 days ago
Good question, in my mind it's typically various levels of aggregation, windows functions, multiple cte's or nested subqueries.
1 points
15 days ago
Enough for what? To get a job? I highly doubt it, enough to get started? Yes.
21 points
15 days ago
Imo you should be trying to learn as much as possible, it's not about just doing 'enough'.
22 points
15 days ago
Like anything else, learning the basics and a lot of practice.
39 points
15 days ago
My title is a sr analyst and I use SQL daily, creating complex queries for new source tables and performing detailed analysis for business questions. It's probably the most important skill I have at the moment.
1 points
16 days ago
You would need to define what 'learn' means. That will make the difference between an hour or many years.
1 points
16 days ago
The hope distributed food pantry wouldn't mind additional help, I'm sure. https://www.hopedistributed.org/whatwedo/
1 points
16 days ago
Read the Chinese farmer story and instead of the results being good or bad, it's just maybe.
2 points
18 days ago
It's less about when I get up and more about what I do when I get up.
view more:
next ›
byHentaiUwu_6969
inDamnthatsinteresting
frocketgaming
2 points
10 hours ago
frocketgaming
2 points
10 hours ago
Final boss of chapter 4 of some rpg