Identify the relevant tables in SAP,
Develop RFC's in SAP for data extraction purposes,
Develop a workable dashboard in Excel (MAcro\VB6 ) to invoke the RFC's for data extraction,
Update SAP custom tables (if required) for future reporting from a SAP perspective