3 ms·
First step is providing simple self-service access to data with minimal time/money efforts. Typical approach is: * data sources (database tables & columns) are
by seektable 7y ago
First step is providing simple self-service access to data with minimal time/money efforts. Typical approach is:
* data sources (database tables & columns) are isolated from end users with some kind of 'model'; end-users operate in terms of this model. This model is created & maintained by 'publishers' - this is user(s) with some technical background that know database structure & SQL good enough. In large organizations this is IT specialists, in small businesses this role is covered by founders/managers with tech skills. If organization database(s) cannot handle OLAP queries directly some kind of data lake is organized to deal with slow queries.
* end users use BI tool to perform ad-hoc analysis, save & share their reports.
Also it is good idea to start from something very simple that can be configured very fast; in this way you can collect feedback from end-users (BI consumers) as early as possible, and then decide if you need to invest more in more complex / enterprise oriented BI solutions.
In this context, I may recommend to check our BI tool: https://www.seektable.com https://www.seektable.com (both cloud service and on-premise installations are possible).