Why not just export from Odoo into a spreadsheet each week?
You can, but it is slow, manual, and out of date the moment it is finished. Connecting Odoo directly to a BI tool means the dashboard refreshes itself on a schedule, so leadership always sees current numbers without anyone rebuilding a report by hand.