There are many third-party reporting tool such as Power BI that run against data warehouse so that it does impact OLTP database. 

 

Some of the benefits of data warehouse are:

• that data from multiple systems can be combined to provide a consistent view of information for the company
• that it allows storage of data in one database by transforming data into meaningful information that are collected from various sources

 

What are some of the challenges in implementing data warehouse?