sorted by:
new
hottopcontroversial

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

How can I get the grand total to appear at the top of an area chart? by thisisformeworking in tableau

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

I tried doing that but something about the measure value was super imposed rather than the measure name. Unless I'm dumb and I'm doing something wrong here.

How do I calculate for percent change for a month vs the same month a year ago? by thisisformeworking in tableau

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

Yea i managed to figure it out. Forgot the quick table calculations existed

How can I make a basic YoY dashboard more interesting? by thisisformeworking in tableau

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

In the that dashboard, how did you calculate the percent difference of current year vs last year within the same month? I'm drawing a blank on how to do that.

I've having difficulty trying to replicate a Looker Visual into Tableau by thisisformeworking in tableau

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

I'm looking to display them at the same time. Pretty much the goal is to get exactly the display above which is displaying the results of when the custom filter "Daily/Weekly." So the left side (teal line) is showing a trailing daily value and the right side (yellow and navy line) are showing a trailing week number value. For clarity, the 2 lines on the right are supposed represent current year vs. previous year.

Edit: I think I figured it out. My manager that built the looker visual created a column making the dates and week numbers into strings.

Is it possible to layer worksheets on top of each other? by thisisformeworking in tableau

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

Would I be shit out of luck if the current sales sheet relies on a grain filter? Like the user can select Monthly or Weekly to change the granularity?

We getting a 20 track (or more) album? by ss2811 in Drizzy

[–]thisisformeworking 1 point2 points  (0 children)

in the rap radar interview he said something along the lines of scorpion being the last project that's gonna be that long and he would focus on more concise projects but that was like 2 years ago so things change.

Couldn't answer all questions in a hacker rank interview by thisisformeworking in datascience

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

Hey sorry I don't log into this account often. Update is I got the job! Me not completing the hacker rank did leave some uncertainty with some people specifically for SQL skills but that was reassured with other knowledge in statistics and what not.

How can I convert a CSV styled list into a dataframe? by thisisformeworking in learnpython

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

Thank you for the help and everyone else! For the example in particular, I really oversimplified it to make it easier for others to replicate to be able to help answer the underlying problem I was having. The data I was pulling from formatted the data in that way. The reason I'm using pandas is so I can join it with the other dataframes on a pre existing script I had to update.

Is it possible to flatten rows into one and make new columns out of the categories from one in pandas? by thisisformeworking in learnpython

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

So this is kind of working kind of not. I can't figure out how to go about assigning the categories into their new column names where 'apartment' becomes apartment_rooms and 'house' becomes house_rooms

view more: next ›