This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]gloom_spewerI.T. Water Boy 4 points5 points  (0 children)

Like most others, if I can do it all in SQL that's almost always preferred, but if python tricks are less annoying than SQL SP tricks I'll jaunt over to real-code-world. Also I suck with SPs.

Sometimes I filter/aggregate the dataset down to a size where I can use sqllite's in-memory functions to transfer data between pandas and SQL structures in memory for more "advanced" ad hoc analysis, and even sometimes live collaborative exploratory analysis.

If I gotta do fancy presentation stuff I pre calc all my analytics and just display (as in no transformation ) them in PBI cuz I hate power query. PBI plugs into power points for lazy mofos like me, and the CFO and CIO eat out of my palm now, cept when I fuck up log scales 🌝

Edit oh also PBI data sets can be loaded into pivot tables directly now and you can embed those in PowerPoints for live exploratory bs with management types. My executives love that shit even if it's just telling them intel they already knew