Hello,

I have a niche business and I am willing to build my own BI system that will be analyze my business performances this way.

The architecture of this is following –

1. Desktop software tool what will build the campaigns by this hierarchy

Name of the customer + ID --> name of the product + ID

(the bottom line of this is to create for each one of these above they own serial ID with name that I could analyze in excel BI after that)

What do I need use to build this tool? What I need to learn to build this tool? ermp?


2. Daily CSV report will uploaded to some ermp database

3. This daily database (2) together with data of (1)
Name of the customer + ID --> name of the product + ID will connect with excel BI for that I could to see and analyze in excel by olap cube.

What do I need to learn and know to build all these 3 parts.

Thanks.
John.