Power BI Dashboard Build

I need to build a dashboard for a client that will show key metrics for a client. I would also like the client to be able to interrogate/search the dashboard/metrics.
The dataset is added to weekly from a manual import and I would like to streamline/automate that process if possible.
The dataset may need to be manipulated/adjusted.
This project may lead to further work in the future.