You should pick Entity Store if you want quick analytics and fast reporting. It works well with Power BI. Entity Store uses special data and indexes to make searches faster. If you need flexible reports or custom connections, BYOD is a good choice. BYOD lets you keep data entities in SQL format