Forum Discussion
joshcorti11
Jun 24, 2021Copper Contributor
Data Warehouse Suggestions
Hi Everyone, I am working for a company in the sales and marketing department. They generate data using several different data providers. These include Salesforce, Google Analytics, LinkedIn, Mi...
olafhelper
Jun 25, 2021Bronze Contributor
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: