karunakaran karthikeyan

I am trying to build a data lake by pulling data from multiple data sources ( custom-built tools, excel files, CSV files, etc) and use the data lake to generate dashboards.

My question is which is the best tool to do the following:

1. Create pipelines to ingest the data from multiple sources into the data lake
2. Help me in aggregating and filtering data available in the data lake.
3. Create new reports by combining different data elements from the data lake.

I need to use only open-source tools for this activity.

I appreciate your valuable inputs and suggestions. Thanks in Advance.