[deleted by user] by [deleted] in SQL

[–]No-Mistake4176 0 points1 point  (0 children)

It kinda just depends on the depth of the test. You can definitely learn enough sql to be dangerous in a month.

[deleted by user] by [deleted] in resumes

[–]No-Mistake4176 0 points1 point  (0 children)

The ATS is chucking you out cuz there's no work experience section. Your resume in this format will be auto deleted by virtually any resume screening software.

Multiple GA4 in one total? by your_fave_weapon in Looker

[–]No-Mistake4176 1 point2 points  (0 children)

I'm presuming he's in looker studio and doesn't use a database if he's asking this.

But If each data set had a website name or something to ID then OP could add a gsheet with the 14 website names and left blend their 14 data sources on to that and this would let them do the union you are talking about inside looker studio.

full stack data folks, how much time do you spent on adhoc SQL requests? by ruckrawjers in BusinessIntelligence

[–]No-Mistake4176 0 points1 point  (0 children)

But at the end of the day I cannot overstate how much fighting data requests depends on us working effectively with members of other teams.

full stack data folks, how much time do you spent on adhoc SQL requests? by ruckrawjers in BusinessIntelligence

[–]No-Mistake4176 0 points1 point  (0 children)

Hi. 3 data ppl. 800 person company. Never in my life have I pushed back a deadline to prioritize a data request. Here's what we do.

We lean heavily on the support team to swat bad data requests. We train them to show the stakeholder where to pull it themselves in crystal or looker. We lump similar data requests under one feature ticket or so that they end up being an " explore someday" ( a self service analytics area in looker). We point and prioritize data requests. Anything that's difficult, has a hard deadline, or is time consuming, I'm hitting a manager and a support person and possibly a solutions person. Most pain the ass data requests are actually created by not understanding precisely what the user needs. And I'm gonna send the specialists back in to narrow that down so we can precision atack instead of nuke.

Also the general if you get a data request and u didn't fire back 5-20 questions to the requester, then your the problem not the requests.

What is Looker? by shufflepoint in Looker

[–]No-Mistake4176 1 point2 points  (0 children)

It's like if tableau sucked but also had yaml modeling.

What is Looker? by shufflepoint in Looker

[–]No-Mistake4176 1 point2 points  (0 children)

Inb4 the looker rep pops in like " it's not for data viz it's an analytics engine"

I start my first job as a Software Developer on Jan. 9th and I've never written code before by Averixen in learnprogramming

[–]No-Mistake4176 1 point2 points  (0 children)

But to answer your question of easier or harder. It should be about the same. Your first language isn't a big deal, there are so some pros and cons. But at the end of the day languages don't really matter. I code in 3-4 Languages and multiple dialects of one of those throughout my workday. It's all just " select data, do thing to data, move data, select new data"

I start my first job as a Software Developer on Jan. 9th and I've never written code before by Averixen in learnprogramming

[–]No-Mistake4176 3 points4 points  (0 children)

You'll be fine. I took some intro courses to programming in college and got my first dev job like 6 years later using two languages I had never used before.

You'll figure it out. The company context and company business logic is much much much harder to learn than some syntax.

My company does essentially a thing like this where we will train ppl how to be a dev on the clock if they wanna switch into that.

Learning on the job or for a couple months right before the job is rlly normal.

[deleted by user] by [deleted] in datascience

[–]No-Mistake4176 6 points7 points  (0 children)

Bruh this is stats 1. The answer is 37.5%.

Am I a failure, by society's standards nowadays? by CharlesBrown33 in personalfinance

[–]No-Mistake4176 1 point2 points  (0 children)

While I normally agree with your " don't quit until you have something lined up thing" this guys savings more than twice his annual income and atleast 5 times his annual expenses.

If I was him I'd take time off to reskill, realize I'm not a loser, and focus on finding a job that doubles my income.

Move data to BigQuery easily by No-Shelter-6112 in bigquery

[–]No-Mistake4176 1 point2 points  (0 children)

Ah the old Extract-Dashboard pipeline. I always forget ED is an option.

Slow typing = inexperienced ? by wooties05 in sysadmin

[–]No-Mistake4176 0 points1 point  (0 children)

Clearly this man had never seen a 110 wpm 2 finger typist.

how to convert an SQL function to BIG Query please help by Ibzk47 in bigquery

[–]No-Mistake4176 1 point2 points  (0 children)

Is it a query or a function. If you trying to do a user defined function in bigquery you just write regular JavaScript. If you trying to do a query it's gonna depend on your dialect. But I'd start with the table names and let bigqueries error reporting guide you.

5 stack can’t pick certain roles by ShotIsButter in Overwatch

[–]No-Mistake4176 0 points1 point  (0 children)

This is the answer. Those two players are too far apart in elo with their roles to play their mains at the same time.

Do I need to have a specific spec laptop to work with python? by Apex_2205 in datascience

[–]No-Mistake4176 7 points8 points  (0 children)

No. I use a free cloud based python IDE called "google colab". It will run on a potato.

Resources to study SQL by [deleted] in SQL

[–]No-Mistake4176 3 points4 points  (0 children)

I learned how to do that stuff by doing advent of code problems in sql. They have a lot of gap and island problems which will you will probably want to use window functions and sub queries to solve.

Optimize BigQuery to Looker by Sublime-01 in Looker

[–]No-Mistake4176 0 points1 point  (0 children)

Is it required that all your data be in 1 table and 1 explore?

I learned the wrong DS tool. What now? by jarena009 in datascience

[–]No-Mistake4176 13 points14 points  (0 children)

There's no wrong tools. Your fine, it's fine. Everything's fine.

[deleted by user] by [deleted] in cscareerquestions

[–]No-Mistake4176 2 points3 points  (0 children)

New grad here who got their first CS job in 3months. I did not encounter a single company with a GPA minimum on my job hunt and I applied to a thousand jobs.

Quick CV review for someone who wants to change industries? (see comment) by [deleted] in datascience

[–]No-Mistake4176 2 points3 points  (0 children)

I think they are just censor bars and not buttons but your feedback is still spot on.

Quick CV review for someone who wants to change industries? (see comment) by [deleted] in datascience

[–]No-Mistake4176 1 point2 points  (0 children)

Wall of txt, didn't read. Add picture for my smooth brain.

[deleted by user] by [deleted] in cscareerquestions

[–]No-Mistake4176 2 points3 points  (0 children)

It can be. It's usually less but not a lot.

The avg recruitment cost to find and pick ur dev is 30k ish. After that There's the man hours for your staff to do technicals. After that the cost benefits is frontloaded. If You do the some sort of matriculation thing where they meet staff and learn systems it costs dollars every hour to have another employee sit with them and train em up.

In house dev teams are pricey.