Forum Discussion
Database best practice
Hey Anonymous
your question is not an easy one, and does not suit this forum well, as Power BI benefits from a good data model in it's underlying data source.
For this reason an ideal solution might look like to completely redesign your ERP system, and this is beyond this forum. A redesign of an ERP system does not just affect the underlying data, but also the frontend.
From my experience these two books are a great start into data modeling:
- Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models Take It with You Guides: Amazon.de: Hoberman, Steve, Burbank, Donna, Bradley, Chris, Pomraning, Mona: Fremdsprachige Bücher
- The Data Model Resource Book: Volume 3: Universal Patterns for Data Modeling (English Edition) eBook: Silverston, Len, Agnew, Paul: Amazon.de: Kindle Store
As you will notice these books are already "old", but the insights are still valid.
Hopefully, this helps to close the box of the Pandora once again.
Regards,
Tom
Hey Anonymous
your question is not an easy one, and does not suit this forum well, as Power BI benefits from a good data model in it's underlying data source.
For this reason an ideal solution might look like to completely redesign your ERP system, and this is beyond this forum. A redesign of an ERP system does not just affect the underlying data, but also the frontend.
From my experience these two books are a great start into data modeling:
- Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models Take It with You Guides: Amazon.de: Hoberman, Steve, Burbank, Donna, Bradley, Chris, Pomraning, Mona: Fremdsprachige Bücher
- The Data Model Resource Book: Volume 3: Universal Patterns for Data Modeling (English Edition) eBook: Silverston, Len, Agnew, Paul: Amazon.de: Kindle Store
As you will notice these books are already "old", but the insights are still valid.
Hopefully, this helps to close the box of the Pandora once again.
Regards,
Tom
Thanks TomMartens Yes, I appreciate this is a very big subject and agree this is not the best area to discuss it, but there are few forums out there on this topic, much less with this amount of talent and expertise. Thank for the reference material links!