Power automate

I am looking for help creating a Power Automate workflow that can automate a specific process to generate reports. It should be able to run on a weekly basis and integrate with other software. I need help streamlining the process and automating all the relevant tasks so that I can get the report in the most efficient way.