5 ms·
Yeah, if you can understand vlookup, you can certainly pick up sql joins fairly easily. You can do quite a lot even with basic SQL skills. Reaching business pe
by anakic 10y ago
Yeah, if you can understand vlookup, you can certainly pick up sql joins fairly easily. You can do quite a lot even with basic SQL skills.
Reaching business people from a marketing perspective and talking to them about SQL is a whole different thing, though.
- cm2187 10y agoYeah but I found myself in that exact position. I provided data to a bunch of business users who don't understand SQL but understand pivot tables extensively. I have the choice between either spending a few days educating them on how to do SQL, or to give them data in a way that they can use the tools they are already familiar with. I was too busy to do the former. The other thing is that SQL sucks at creating pivot tables. It is good when you only want to aggregate in one direction. When you want to aggregat in multiple directions (column A by row, column B by row) the syntax becomes tedious to do by hand.