You need to “see” your business at a glance, in real time to make informed decisions from throughout the organization. You have taken the first step in answering solving this business issue and purchased a BI tool such as Birst. Your team is excited and the request for dashboards and charts from every department are pouring in. Great! Now you quickly realize that:
- Your ERP is transaction based and not conducive for BI Analytics.
- Your ERP has the “data” but BI needs that data summarized in a star schema format to feed “dashboards”.
- Your BI platform may have the ability to read ERP databases, but ERP databases are not pre-built into the BI platform.
Think about when you purchase Excel, it does not come with “standard” spreadsheets, users create them. Business Intelligence (BI) software such as Birst is similar to Excel, here's how:
- BI (Birst) comes with the ability to read databases, but ERP databases are not “pre-built” into the program (just as spreadsheets are not built into Excel).
- Integration results are based on the knowledge of your ERP database, how you link it to BI (Birst), and the development skills of the user.
- You either need a technically skilled user to create the necessary data schemas to correctly convert data from ERP to BI software or you need toolkit, enter ATx.