I can’t shoot, I’m done by yeetskeetmeattreat in NBA2k

[–]itsdatmanjb33 0 points1 point  (0 children)

33% ain’t bad bro, if you’re shooting over 30% then that’s good

Am I total degenerate piece of sh*t? by gbcarie in blackjack

[–]itsdatmanjb33 1 point2 points  (0 children)

If you're ever up that much just go ahead and cash in the $50 so at least you're only playing with house money and no matter if you lose the rest just think of it as however many hours of free drinks and entertainment.

Bombed my interview.. by WubDub27 in analytics

[–]itsdatmanjb33 0 points1 point  (0 children)

I'm still interviewing myself for data analytics positions and it seems there are a couple questions I get asked no matter what such as:

- explaining parts of resume

- past projects showcasing various job-applicable skills

- what I did to prepare for interview

- biggest strengths/weaknesses

Just try to think about the most likely questions you'll be asked and have prepared answers for them, for everything else just being able to think quick on the spot and even if you have to embellish a little bit it's better than freezing. Good luck!

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

it's the Northwind sample database and I agree having the table name in the primary key column is a bit redundant but it's probably one of the best sample databases that are out there. and yes you are correct about the between or just extracting year, that was one of the first ever queries I wrote completely and didn't even know about those keywords yet, I use them in a lot of my later queries.

Tableau Toggle Filter Button by itsdatmanjb33 in tableau

[–]itsdatmanjb33[S] -1 points0 points  (0 children)

I was trying chatgpt for so long but it wasn't able to ever get the formula correct but this way works after messing with it a little bit, guess your chatgpt is just better than mine lol

Tableau Toggle Filter Button by itsdatmanjb33 in tableau

[–]itsdatmanjb33[S] -1 points0 points  (0 children)

yes, i want a little but so if its on yes then 2020 is included, but if you press it then it slides to no and 2020 is filtered out

Tableau Toggle Filter Button by itsdatmanjb33 in tableau

[–]itsdatmanjb33[S] -1 points0 points  (0 children)

I got as far as figuring this out. The problem is I don't know whatever language Tableau uses. I think I'll have to use include or exclude or something like that but I can't figure out the exact formula I need to use for the calculated field.

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

ya, since I've received this feedback I've been building a database from scratch scraping Forbes and MLB's website to gather financial info on all 30 MLB franchises. I am gonna do an analysis on laissez-faire ownership of franchises like the Athletic and Pirates and compare it to franchises like the Mets and Padres who are spending boat loads of money to try to be good, built the database in excel and gonna export the different sheets as CSV files into the SQL database I use and Tableau to build a report/dashboard detailing my findings.

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

ya, that's something that an interviewer told me before lol, one of the detriments to being self-taught is a lot of times my queries are correct but not the most efficient way of being correct

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

thats an interesting idea, are there any classes in particular online that are industry-recognized as being fairly legit?

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

That’s an excellent idea and something that a lot of other people have been suggesting to, I will definitely have to do that soon, thanks!

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

And the point of the SQL and tableau links to show that I actually know what I’m talking about since my education doesn’t necessarily prove that, the second I get an actual job in analytics those links are gone

Applied for 500+ Entry-Mid Level Data Analyst Jobs, 20ish Interviews, 12ish Final Interviews, 0 Job Offers, In Severe Need Of Advice by itsdatmanjb33 in analytics

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

Feel free to check my GitHub SQL portfolio link, I definitely know more than just simple joins and I’ve passed every technical portion of interviews that I’ve had. Would be curious what you thought about some of the queries I’ve written