Every BI product today is claiming to support self service BI. What does it mean indeed? Is it possible to map complex BI operations and data models to a self service BI user interface? Self service BI claims that IT support would not be required to run these applications. Can someone build complex SQL query without knowing SQL language? . To build the data required for a simple insights, analysts have to run lot of analysis on the data. How self service can help them out? May be it could be possible to map simple BI operations to some user interface for quick access on analysis but again it will require training from the technical staff. I am not sure how IT could be exempted from self service BI support. For example lets say we create a simple query builder drag drop interface to build the SQL query. Do you think an analyst who do not know simple SQL constructs can use that interface to build his data query.
Tableau claims to be the very first self service BI product. I am not sure if a non technical staff can use tableau to build an insight from any complex data. It seems that IT support is mandatory in any case. I have been using tableau for a while now and i had to build an analysis from multiple data sources by using their data merging technique. it was hard time even for me (a technical guy) to merge the data and to build an analysis on top of it. How self service can replace IT, its not understandable.
To me, self service BI can only be possible if an application provide end to end easy to use user interface for non technical user. may be a manager would like to explore the data but he do not know SQL Queries. I am not sure if such a user interface is available at the moment or it could be provided.
Do any big data analysis product supports such an intuitive user interface? . I will keep this question open for the community to answer.