Forum Discussion
Big Data Warehouse?
Hello Everyone,
I am looking for a tool (platform?) that will allow me to store huge amounts of data. The data will be coming either from ERP systems or from various excel files (same structure of the data, just different values every month).
For instance, something that will be able to handle more than 100k "excel rows" (+40 columns) each month. I was reading about "Hadoop". Is this a good solution? I saw that I can import data to PowerBI from Hadoop, so that would be cool.
If anyone can help to find a good comparison of various "data warehouse" (because I think that this is the correct naming) tools + your personal experience and preference, I would be very grateful.
thanks!
Hi Anonymous ,
You are in luck , from the recent Microsoft Ignite 2019 , micorosft announced a great tool called Azure Synapse Analytics
Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale.
Moreover it has a inbuild capability of PowerBI iteself 😊
Reference: https://docs.microsoft.com/en-in/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is
5 Replies
Hi Anonymous ,
You are in luck , from the recent Microsoft Ignite 2019 , micorosft announced a great tool called Azure Synapse Analytics
Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources—at scale.
Moreover it has a inbuild capability of PowerBI iteself 😊
Reference: https://docs.microsoft.com/en-in/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is