End to end BI solution for not complex scenarios
Overall Satisfaction with Birst
We adopted BIRST to be used as the enterprise BI solution so all departments with enterprise BI needs would use BIRST.
We use BIRST Cloud solution.
- Being a cloud solution the platform upgrades are not a pain point anymore.
- Once the data model is ready, building basic reports/dashboards are really straightforward.
- One single tool may cover all your business intelligence needs, from data ingestion to reporting so it can be cost-saving in terms of licensing.
- Building an analytical ready model does not require highly skilled developers.
- Lack of access to underlying database and use of non standard languages (propietary code) BQL and BIRST scripting.
- Very poor and not user-friendly administrative area. Big dependency on command line tasks (a few drag and drop) and lack of out of the box administrative views (reports and dashboards showing platform's response).
- Small community. Really difficult to find skilled resources in the market and few technical blog articles or videos available.
- Data ingestion capabilities do not scale. Being capable of ingesting data is an added value however, the solution is mainly based on SQL plus scripting (no out of the box monitoring capabilities, difficult to reverse-engineer...).
Depending on the complexity of your company's data and business needs it may or may not be a good fit. I would say it can be a good BI ecosystem for small and mid-size companies with low complexity so they can have data ingestion and reporting capabilities with one single tool.
If you need to integrate data from many different data source;, your environment does change quite frequently, you have many different business areas, the data volume you have is quite big... then it is less appropriate.
Infor Birst Feature Ratings
Additional Questions on Birst Capabilities
From the admin/developer point of view we do not find it user friendly, a lot of commands for administrative tasks (few drag and drop), a lot custom code required for data ingestion purposes including Python, batch command line, BQL (BIRST SQL language, it is difficult to reverse engineer, there is a lack of a super-administrator role which could have access to everything.
Personally I would say it could be a good fit for mid-size companies with low complexity (few data sources, few STAR-schemas and few conformed dimensions).
Current usage of BIRST in our company is not focused on a specific business area or function but all areas with enterprise BI needs.
The support team we have is basically granting access to users, and supporting the different applications including: monitor the execution of ETLs, building new reports/dashbords, troubleshooting issues...
- Enterprise wide reporting with big target audience having a common semantic layer in order to ensure KPI definitions are consistent
- Depending on BIRST new capabilities. Currently we're trying to adopt Pronto for self service data preparation purposes
In many cases we are provided with workarounds but not real solutions.
Multiple times we are given the answer "code change" requested so we have to wait for the next release (every 3 months) and in some cases we have to wait for more than one release.
Problems left unsolved
There are other cases where a minor release has been provided (not having to wait for 3 months) but this is not the usual case.
Requires technical support
Not well integrated
Slow to learn
Feel nervous using
Lots to learn
- Self service BI to build simple reports with Visualizer is easy
- Interacting with existing reports and dashboards is really easy
- Data ingestion process is quite complex
- Data modelling and making changes to the existing model can be really tricky. It is hard to reverse engineer and apply changes on a model built by another developer/team and it is hard to change something if you do not regularly apply changes (i.e. add a dimension to a model you built 5 months ago).
- The administration parts are not user friendly. It is Flash based and a lot of things are done via commands. There is no super administrator role so not possible to have a look at everything which has been built.
Evaluating Birst and Competitors
the BI Industry in 2015 and we were looking for a SaaS cloud solution what we did not consider is the high complexity of our data-ingestion/integration needs neither the low re-usability of the data ingested by BIRST.
During the selection process make sure the tool does fully cover the capabilities needed and clearly position it within your toolkit so each tool is used for the purpose it was selected.