joshcorti11 , im common one collects frequently all data together in a "single-point-of-truth", a data warehouse.
The DW can be a database in any RDBMS or more dedicated warehouse system. To get all data from different source system we use ETL tool = "Extraction, transformation, loading"
Next point for decision is: On-premise or in the Cloud?
For analytics/reporting you can use OLAP = Online Analytic Process
If it should be a Microsoft product:
RDBMS: SQL Server 2019 | Microsoft
ETL: SQL Server Integration Services - SQL Server Integration Services (SSIS) | Microsoft Docs
OLAP: SQL Server Analysis Services overview | Microsoft Docs
Reporting: What is SQL Server Reporting Services - SQL Server Reporting Services (SSRS) | Microsoft Docs
Data Warehouse: Data warehousing in Microsoft Azure - Azure Architecture Center | Microsoft Docs
Olaf
OLAP:
