Excel Services Data Refresh Flowchart
I found a great flowchart for troubleshooting data refresh in excel services for SharePoint 2010. I also ended up using the Secure Store instead of kerberos. I had a few issues connecting to OLAP, but this diagram helped. View PDF: Excel Services Troubleshooting