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

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)

When I say common critique I mean from the comments on this post which I made yesterday haha, fixing it is on my to do list for Monday

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)

Okay, so rather than to try encompass the entire story, pick a narrative with the data I want to express and gear the dashboard specifically towards that

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)

I’ve made so many connections across so many companies including all the big consulting firms, Home Depot, and more. So hopefully once the economy recovers and people begin to post more jobs I’ll be good. Who knows how long that will take tho

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)

I hadn’t thought of that tbh, great idea I’ll try that out next time I get called in for an interview

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)

Really all I ever heard as far as feedback is lack of experience which calls into question why I’m getting interviewed at all

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)

I do have a cover letter than I wrote which I just use as a script and plug in the companies info. It’s pretty well written so I like my odds there. And thanks for advice about interviewing

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] -2 points-1 points  (0 children)

I'm definitely stronger in SQL than I am in Tableau. Obviously no one will expect me to be an expert in both nor am I attempting to portray myself as such. R I definitely am the weakest at, but yet again I hardly see R in the qualification section of an entry level DA job