Business Analysis of Web Application Information

How to use an Excel spreadsheet to pull data from a web application's SQL server and then perform business analysis on it.