When gathering data for our clients we typically get this data in a variety of ways from 3rd party sources. Sometimes it comes to us in a scheduled export through an email attachment, an Excel file can be dropped into a cloud storage folder, or we pull data directly from a database.
In most of these cases, the data is not a good format in its raw form. We need to do a lot of data manipulation first before importing it into our own application’s database. Currently this is done by using a combination of Microsoft Power Automate (gets triggered by different events) and Power Query inside of Excel.
I’m curious what tools others are using to prepare their data in similar scenarios. For example, Tableau has a tool called Tableau Prep. Are there other tools out there that people like?