Is BI dead? – On dismantling data's ship of Theseus

Re:Is BI dead? – On dismantling data's ship of Theseus by SilverRed on Tuesday September 21, 2021 @07:28PM (#28611312)

We provide power bi access to the data our app runs on and it has been a mixed bag. The customers absolutely love it. But they build dashboards where hitting the refresh button can bring a super expensive db to its knees for half an hour.

So then we have to get our db people in to rewrite all of their reports so they don't do this which eliminated the benefit of having the customers do it.

In the end there is just no avoiding having experts build the dashboards.

[ Parent | on HN ]

Re:Is BI dead? – On dismantling data's ship of Theseus by monkeydust on Wednesday September 22, 2021 @04:42AM (#28614231)

OP here.

Interesting as we're looking at going long with PowerBI embedded for a client facing app and ditching our home grown effort which is always playing catch-up and costs a fortune.

[ Parent | on HN ]

Re:Is BI dead? – On dismantling data's ship of Theseus by Scalestein on Wednesday September 22, 2021 @09:50AM (#28616314)

I did the same thing last year for a client. So far it has worked pretty well. Client analysts create the reports and then deploy them for end users to view through a browser. End users can't do toooo much regarding playing with the data. It is slightly better than static data but the real value has been the client analysts being able to modify it without needing dev help (no JS chart libraries to mess with!)

[ Parent | on HN ]

Re:Is BI dead? – On dismantling data's ship of Theseus by KptMarchewa on Tuesday September 21, 2021 @07:51PM (#28611498)

Are you running analytics on an transactional database?

[ Parent | on HN ]

Re:Is BI dead? – On dismantling data's ship of Theseus by SilverRed on Tuesday September 21, 2021 @08:21PM (#28611722)

Yes, Power BI connects up to a read only mirror of the app sql db.

[ Parent | on HN ]

Re:Is BI dead? – On dismantling data's ship of Theseus by krauses on Wednesday September 22, 2021 @04:24AM (#28614155)

Is the relational source db a denormalized star schema? Are you doing direct query or import in Power BI?

[ Parent | on HN ]