automation on excel, power bi, dashboard

I need help automating reports on Excel, Power BI, and a dashboard. The level of complexity is intermediate and I already have existing data that needs to be incorporated into the automation. Specifically, tasks such as data transformation, report generation and visualization, data analysis and forecasting are required. It's important to have the ability to quickly generate accurate and up to date datasets. I am looking to partner with a freelancer who has the experience and skill set necessary to develop a reliable automated reporting system.