Business Intelligence

Power Query: Excel's gateway to reproducible analysis

Intro In this blog post, I’ll try to highlight some of Excel’s functionality which have been around for a while, but remains largely unknown to the broad public. Now, I’ll be the first one to throw rocks at the Excel camp. I’ve got receipts: Please don't... — Taras Kaduk (@taraskaduk) February 10, 2018 My analysis is in Excel. #Loseyourjobin5words — Taras Kaduk (@taraskaduk) March 5, 2018 Reproducible analysis, case in point.
Read more

The 4 Stages of Data Analytics Maturity: Challenging the Gartner’s Model

*Cross-posted: LinkedIn, Medium * If you happen to work in analytics, data science or business intelligence, you’ve probably seen one of the iterations of this Gartner’s graph on stages of data analysis in a company: The figure above shows various stages of analytics maturity, from “descriptive” to “prescriptive”. I’ve seen it so many times, it became an eyesore to me. There is nothing wrong with it. This look nicely breaks down the evolution of analytics into understandable parts and pairs each stage with a question to be answered: what happened, why did it happen, what will happen, how can we make it happen.
Read more

On Importance of Minimalism in Retrospective Analytics

*Cross-posted: Medium, LinkedIn * Hey, analyst, how is life? Talk to me. Do you love what you do for life, do you like all things data? Yet, do you sometimes feel like you’re a Sisyphus rolling a giant rock of data up the hill every day, only to see it go down with a racket in the evening (and you know what you’re going to do tomorrow)? Or, do you imagine yourself being a plate spinner at a circus, only instead of plates and poles you’ve got five dozen reports to spin, and instead of an entertained crowd you’ve got your co-workers, managers and senior executives watching your “performance” and asking to add more plates, and God forbid any one plate falls?
Read more