Hi Kim Vinson,
I dont know about the Retail Pro 9 . But you are talking about creating some views or dashboards which will get the valued information.
You can have a look at this video . how tableau can be used in Retail Analytics:Leveraging Tableau for Retail Analytics - YouTube
I have integrated Retail Pro version 9 and Retail Pro version 8 with different BI and reporting solutions fell free to mail me if you need any support related to Retail Pro.
Mobile: +91 7373092020