Advice for Business Intelligence(BI) Architecture

[nicolewells]

Hello All, 

Hope all doing great, 

I would like to get some advice on our BI architecture, which is pretty complex to maintain.

I work in an e-shopping company, our prod works on a LAMP system (Linux Apache MySQL PHP).

Every night:

data from our prod DB (MySQL) are extracted with Talend then inserted in another MySQL database named DWH for data warehouse
data from this DWH are then extracted by Jedox/Palo to load OLAP cubes, which are used by Excel with a plugin for restitution
data from this DWH are also accessed by Access/Excel one-shot reports, but this is not working very fine
Each time we need to modify an existing workflow or create a new report, there is a lot of steps and different Talend technologies to use, which leads us to a pretty complicated platform.

What can I do to simplify this process?

Thanks

Nicolewells

[v-yulgu-msft]

Hi @nicolewells,

Thanks for your question. However, this is a Power BI forum, you'd better post this thread on a more related forum to get professional advice.

Regards,

Yuliana Gu