Data Warehouse Suggestions

%3CLINGO-SUB%20id%3D%22lingo-sub-2483131%22%20slang%3D%22en-US%22%3EData%20Warehouse%20Suggestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2483131%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EHi%20Everyone%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3EI%20am%20working%20for%20a%20company%20in%20the%20sales%20and%20marketing%20department.%20They%20generate%20data%20using%20several%20different%20data%20providers.%20These%20include%20Salesforce%2C%20Google%20Analytics%2C%20LinkedIn%2C%20Microsoft%20Teams%2C%20Bing%20ads%2C%20Google%20ads%2C%20etc.%20How%20would%20you%20suggest%20storing%20this%20data%2C%20and%20what%20product%20would%20you%20suggest%20using%3F%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22public-DraftStyleDefault-block%20public-DraftStyleDefault-ltr%22%3E%3CSPAN%3ETIA%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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
1 Reply

@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: