ml-specialty video for an electronics company will start to receive excel files containing unstructured data with sales, revenue, and expenses on a daily basis
An electronics company will start to receive excel files containing unstructured data with sales, revenue, and expenses on a daily basis from all its global branches. The main purpose is to perform SQL queries on the data as well as using business intelligence tools to gain insights. Also, a machine learning specialist will train on this data to produce a forecasting model which forecasts revenues with a time span of 1 day. The company wants to receive the unstructured data in an appropriate data lake and automate the process of extracting, loading, and transforming this data to a parquet format, using a fully managed service, to be loaded to a suitable data warehouse and visualized later using business intelligence tools. Which combination of services should be used?