Jump to content

b_m_b_m_b_m

Members
  • Posts

    25,928
  • Joined

  • Last visited

  • Days Won

    175

Posts posted by b_m_b_m_b_m

  1. 2 minutes ago, Joe said:

     

    I've been using the SQL tutorial at mode.com, but this looks great too, thanks! Also trying to complete the UC Davis Coursera SQL course by Monday.

    Nice. Yeah try a lot of different stuff but just make sure you get to write sql to get a feel for it. Set theory is good to have but that's a whole semester math class if you really want to dig into it after a while (but may be helpful in the long run)

  2. You're probably going to be tasked with understanding the databases/data/business before you're trusted to pull and analyze data in any meaningful way. This is similar to what I gave newer analysts at my last job and should get you started. The specifics of the db used (oracle, postgresql, mssql, etc) will be useful later but right now you'll just need to know the basics that would apply to virtually any of them: basic query setup, how to select, how to do various joins, and maybe some other useful things (group by, having, order by, etc)

     

    Find a random data set and save it in a sqlite database and play around with it.

    • Thanks 1
  3. 42 minutes ago, CitizenVectron said:

    I don't understand—what is SALT? So you can write off your local/state taxes on your federal taxes? Why would that even be a thing?

    Basically, yeah. The deduction reduces the income used to calculate your federal taxes. Same as charitable giving and home mortgage interest (lol)

     

    But these itemized deductions are weighed against the ~24000$ standard deduction. So the two biggest things are the SALT deduction and home mortgage interest deduction. Even with the SALT cap and the cap for mortgage interest between the two of these you can easily blow past the 24k standard deduction in an area with a high cost of housing and taxes...but only if you're already relatively well off because the bar is so high. You have to own a home and be paying interest and taxes on this in addition to other state and local taxes. (Which non homeowners/non mortgage payers also pay but don't get the benefit of the mortgage interest deduction or the deduction for paying their landlords property taxes)

     

    So even outside of the data (which points to the wealthy getting the majority of the benefit of the removal of the SALT cap) it makes intuitive sense that this cap in addition to the MI deduction massively favors the well to do. They both should be removed, and even the GOP couldn't eliminate them! 

×
×
  • Create New...