Has any of you implemented a Business Intelligence solution with ERPNext?

[logicbala]

Hello Users,

We have started recently to engage with the ERPNext community and would like to hear from the group whether any one has implemented a Business Intelligence solution utilizing the ERPNext transactional data. We are talking about the generic business intelligence solution which provides you (the business users) with basic dashboarding and adhoc reporting capabilities using a simple drag and drop user interface. More here: http://en.wikipedia.org/wiki/Business_Intelligence .

If you have implemented or tried to implement one, please share your experience in doing the same. If you are planning to implement one then please do share what is the end goal you are trying to achieve by implementing a BI/Analytical solution.

Regards,

Bala

With more power, comes more responsibility !

With less power, comes more creativity !!

–

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/83775531-eb77-408f-a9ea-8a31610f4d58%40googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

[djkazi]

@logicbala
Did you get any feedback/progress on this?

[Pawan]

We had integrated ERPNext database with Zepelin, there are many other open source BI tools also available that you can use to connect to ERPNext database

[felix]

Microsoft Power BI Tutorial - How to generate great reports with ERPNext

Hello, I was recently looking for options to generate beautiful reports with ERPNext and found out about Microsoft Power BI Desktop which is free for personal use and very easy to use. The trickyest part was to be able to gather live data from ERPNext. Here is how I was able to do it (using a bunch of tutorials on the Internet) even though it’s not perfect (I will update this post one I find a better way to do it). 1 - Download Microsoft Power BI Desktop: 2 - Use ERPNext Rest API to load yo…

Metabase with ERPNext

For those who are interested in an installed software and a familiar office product feel. Install Microsoft Power BI desktop edition. Data Visualization | Microsoft Power BI

[adam26d]

Hello Pawan

How did you connect Zeppelin to Mariadb?

[Not_a_countant]

Here are a couple of more links for metabase with ERPNext

How I created this Sales KPI Dashboard

Here I am sharing my knowledge how I created a Sales KPI Dashboard with Metabase [image] Start an AWS Instance and install Docker - Link Install Metabase by docker run -d -p 80:3000 --name metabase metabase/metabase (I installed on port 80 (http://example.com) and you have to make sure port 80 is opened on your AWS EC2 Management Console → Security Groups) [port 80] Now we have to enable MariaDB to accept remote connections. SSH to your server sudo nano /etc/mysql/my.cnf and comment …

Visualizing ERPNext data using Metabase: Step-by-Step Guide

This is my humble attempt at providing a step-by-step to using Metabase with ERPNext I am running Metabase v0.27.2 on Windows 8. [metabase00] Unzip the Metabase jar file into a folder. Navigate into the folder and run this command java -jar metabase.jar [metabase01] Make sure JRE installed. After running the command, wait for Metabase to be ready. Open your browser and access through your URL at port 3000 Example: http://localhost:3000 [metabase02] You are presented with a login pag…

[Pawan]

You can bind mysql interpreter to your notebook, you can check the link here

[adam26d]

These are such excellent guides. Thank you so much @Not_a_countant !