Hello @Anjlika Sahu Thank you for contacting us on Microsoft Q&A platform. Happy to help!
I understand that you want to capture azure resource utilization and create a weekly trend of the same. Usage report from the Azure portal/APIs/Cost Analysis is the best way to achieve your goal.
From Azure portal download usage report - https://learn.microsoft.com/en-us/azure/cost-management-billing/understand/download-azure-daily-usage
Using APIs - https://learn.microsoft.com/en-us/rest/api/cost-management/
Automation:
https://learn.microsoft.com/en-us/azure/cost-management-billing/automate/automation-overview
https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/manage-automation
Hope this helps. Let me know if you need anything else!
If the response helped, do "Accept Answer" and up-vote it