Hacker News new | past | comments | ask | show | jobs | submit login

That workflow sounds so painful. Why not get a BI tool that can integrate directly into your data warehouse and do reporting through that?



Because in large companies BI and data are managed by external people, and without a budget at 5, if not 6 digits, nothing happens.

If there are some self service BI, most likel self service is only by name.

Add some variants related to security, max number of licenses allowed (hilarity ensures if IT bears the cost on behalf of the business without being able to charge back), etc


It's really not, I've used python in the past but prefer R for this.

As it stands excel is a better presentation layer than almost all BI tools once you're past the modelling and analysis stages.


With this, you get:

- Reproducibility (the official, bundled Excel numerical routines have/had errors greater than floating-point precision) which avoids the unprofessional look of, say, least squares numbers that differ from a check by hand.

- Version and environment control. This is the fastest way I can answer the question, "what would these new routines produce if run against last October's pool of databases?"

- A presentation format where client customizations for style, dimensional units and currencies, human language, etc. can all be owned outside of your project.

I try to sell this approach when I can. Is there a particular BI that strikes a better balance?


Sometimes you have to do your thing and then enforce change (if you can). Large orgs can be just as odd as individuals but on a far grander scale.

I've worked for other firms and then my own for the last 24 years. My job title is Managing Director but I am under no illusion that my word is final. It is really final but only when I say so and I never do.

Oh a BI thingie. Yes that will fix everything. No it wont.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: