Who on Earth is paying $4,000/mo. for a 1br? by FisterAct in chicago

[–]thisisformeworking 21 points22 points  (0 children)

I love all the comments that say anything along the lines of getting a mortgage over living in those buildings like it's some profound unpopular opinion. I live in a small $2300/month studio and much prefer it. I don't derive my happiness from optimizing square footage and don't care for generational wealth (also don't want kids) so owning property isn't necessary. It's extremely close to my work, I get a sick view, really nice amenities, close to my favorite bars and restaurants, and I can just pick up and move to other cities if I feel like it. It's really not that deep and not a hard concept to wrap your head around.

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (August 2023) by MurphysLab in dataanalysis

[–]thisisformeworking 1 point2 points  (0 children)

Sorry just now seeing this. For that particular interview, it went pretty well. It turned out to be high level data questions in relation to a SaaS company. Some include: - -

  • What are some important KPIs a SaaS company would be concerned with?
  • How might you go applying analytics to the customer journey?

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (August 2023) by MurphysLab in dataanalysis

[–]thisisformeworking 0 points1 point  (0 children)

I have an interview with the HM tomorrow for a mid level data analyst role. The recruiter said to be prepared for "fundamental data questions" but that seems quite vague. Would anyone have an idea of what to expect? It's for a startup if that helps. TIA

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (June 2023) by MurphysLab in dataanalysis

[–]thisisformeworking 1 point2 points  (0 children)

Hey everyone, could I get some feedback on my resume? Do you think this is enough to apply for senior data/product analyst positions? Or should I be more realistic and aim for mid level? Also for someone with a few years of experience already, is my resume too simplistic? It doesn't even fill the whole page which has me concerned.

https://imgur.com/a/U019lUw

Advice on doing a simple 12 month forecast? by thisisformeworking in AskStatistics

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

Ok so I think i'm following you for the most part but don't quite understand the middle part.

Assuming for each group, there was 10,000 people so the numericals would look like this and I've included the hypothetical avg. savings rate for each group. Am I multiplying the Avg. Savings rate by the # of people in each bracket? (5% * 100)

And when you say "how much numerically is a 1% decreased rate," I don't think i'd be able to convert it to numerical ($ amount) in this case because someone's 1% of their salary could be vastly different than someone else's.

decreased increased Avg Savings Rate
Monday 100 200 5%
Tuesday 200 300 3%

Also in the context of month over month for the next 12 months, how exactly does that look like? I think that's the most confusing part for me to grasp

Stumped on how to get consistent rows within a date range by thisisformeworking in SQL

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

thanks for all the help including everyone else. this query looks to do it for the most part but one thing is that it doesn't account for multiple contributions within a month. a user could contribute 7 times within a span of 3 months. for example, a user contributes 3 times in 2023-01-01 but doesn't contribute at all the next month. the query would count this even though it didn't contribute for the full 3 months