Hey Karthik, very informative post. Thanks ! With regard to automating the data pull and processing within Excel, do check out Power Query ("Get Data"). It is immensely powerful, and it does away with the need for all that shady ADO code. And I loved the (challenge of the) chart you included too :) a simple clustered bar chart or even panel bar chart would've been much more informative than the waffles they've currently used.
Understanding data science from the perspective of experimentation & measurement makes sense.
Hey Karthik, very informative post. Thanks ! With regard to automating the data pull and processing within Excel, do check out Power Query ("Get Data"). It is immensely powerful, and it does away with the need for all that shady ADO code. And I loved the (challenge of the) chart you included too :) a simple clustered bar chart or even panel bar chart would've been much more informative than the waffles they've currently used.