Top Modern Data Warehouse questions

,

Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):

  1. Do I need a data lake? Data lake details
  2. Do I need a relational data warehouse? Is the traditional data warehouse dead?
  3. Do I need a cube? The need for having both a DW and cubes
  4. Where do I clean my data? Where should I clean my data?
  5. What is the Common Data Model (CDM)? Common Data Model
  6. How should I organize the data lake? For this question I defer to my favorite blogger, Melissa Coates (SQL Chick): Zones in a Data Lake, Data Lake Use Cases and Planning Considerations, FAQs About Organizing a Data Lake
  7. What is the future of Hadoop? The difficulty in answering this question relies in exactly what is “Hadoop” anymore (it used to consist of HDFS, YARN, MapReduce and tools built on top of these such as Hive and Spark). Products like Azure Data Lake Store Gen2 are HDFS compatible which I see being around for a real long time due to the rise of data lakes (I see HDFS as the primary source for a data lake). Meanwhile, SQL Server 2019 Big Data Clusters creates HDFS data nodes and includes Apache Spark. See Did Hadoop kill Data Warehousing or Save it?
  8. Should I put all our structured data into our data lake? Should I load structured data into my data lake?
  9. How does a NoSQL database like Cosmos DB compare to a relational database? Understanding Cosmos DB
  10. Can you explain the use cases for big data products? Use cases of various products for a big data cloud solution
  11. What are all the products I can use to clean my data? What product to use to transform my data?
  12. Is Azure Data Factory “SSIS in the cloud”? Azure Data Factory Data Flow
  13. Can the cloud save us money? Cost savings of the cloud
  14. What do you think of data virtualization? Data Virtualization vs Data Warehouse
  15. Do you know a good workshop to learn big data technologies? Big Data Workshop

I have also put these questions under a new FAQ page.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate