Tools and best practice for reporting/presentation database
It seems you are referring to a concept called a data warehouse.  Data Warehousing is a huge topic, with a few main types of architecture: star schema, snowflake, and data vault. Googling these might give you some ideas on how to proceed.