I work in an Advancement department, and was wondering if there are any users out there that are using Advance Web as their source of data? Our approach has been to duplicate Advance Web tables, make these available through an oracle connection, and then create and publish data sources to Tableau Server.
Some of our issues have been trying to anticipate the different types of scenarios that people want to report on, and guess at the various extracts. These extracts are typically joined using left joins to make them as general as possible. This approach has caused analysis to be too complicated in some cases, because we could have 6 or 7 different table joins.
Are there any Higher Ed users out there willing to share some tips on how they've prepared data sources for Tableau?