May 6, 2021 at 9:18 am
Dear Forum,
I would like to ask the following question:
We have 50 excel tables. Each table has about 30 attributes. All tables together comprise around 1,2 Million rows.
--> Is there a ready-to-use solution which would allow us to analyze this data?
Thanks
May 6, 2021 at 3:59 pm
What are you looking to do? If you want to visualize this data, PowerBI can help. If you need to join data from 30 spreadsheet tables because they are all the same structure, you likely want to import them into some model and then start to perform analysis. Tableau can also likely help here.
A lot depends on what you mean by analysis. 1.2mm rows isnt' a lot for a database or PowerBI.
May 6, 2021 at 6:34 pm
Following on from what Steve suggested, if all the Excel files have the same structure, you can use a folder source in PowerBI (or Excel) and it will append all the Excel tables together and you can analyze there (using DAX, for example).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply