Using ElasticSearch and Kibana for Business Intelligence

Question

We use ElasticSearch to search our product. It works great.

Now we want to provide self-service with business intelligence for our customers. Operating database reporting sucks due to performance impact. At run time, calculating the average “order clearance time” for 10 million records would not produce results on time. The traditional way is to create a data array by loading live data using ETLs and summing them. Then use any reporting mechanism to offer customers metrics and reports. This approach works, but increases the total cost of ownership for our customers.

I am wondering if ElasticSearch used as an intermediate data surface for reporting. Can Kibana cater for data mining, the need for visualization?

Answer 1

We have the same needs. For tools such as Qlik, PowerBI, Tableau, you need to increase the overall insfrastructure stack and where you plan to go abroad without the ability to share it, this may not be the best option in terms of cost and complexity.

Answer 2

devextreme devexpress. . mysql mssql db , , , 10 devextreme.