Forum Discussion
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, Microsoft Teams, Bing ads, Google ads, etc. How would you suggest storing this data, and what product would you suggest using?
TIA
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:
