The book SAP Analysis for Office - The Comprehensive Guide covers everything Analysis for Office has to offer, from setup, through customizing to reporting with the VBA API. Take a look at the table of contents to convince yourself that it is the right book for you.
Here you find several ABAP tools to make your life easier. For example the Transport Dependency Check allows you to check transports dependencies or the Query Link Components which allows you to repair decoupled by mistake link components in BW/4HANA.
You can get the full SAP Analysis for Office Video Course as download.