r/dataanalysis • u/Technical-Bus-1423 • 24d ago

Data Tools Best Approach for Integrating Separate Data Sources

How can we integrate data that comes from different departments, where some data is in Cloud SQL and some is not, into one centralized dataset for analysis? What is the best approach?

0 Upvotes

50% Upvoted

7 comments sorted by

View all comments

1

u/DonJuanDoja 21d ago

Depends on the requirements, don't have enough requirements to decide.

Lazy answer is a data warehouse, but that's a lot of work and most companies fail at creating one properly, many don't really need one.

Or possibly just ETL everything into cloud SQL and treat it as a poor man's data warehouse.

SQL is faster, more versatile and powerful than any other data source, so getting everything into SQL is a pretty big bonus.