Introduction to Excel and Web Queries¶

Microsoft Excel in combination with Web Queries is an excellent tool for data analysis: it has a good feature covering statistics, crosstabs (Pivot Tables) and graphing and charting; is familiar to most users; works both online and offline; and can be extended with formulae and macros to meet additional requirements.

This document explains how to connect Microsoft Excel to the Data Warehouse using Web Queries so that the spreadsheet and any linked Pivot Tables and charts can be refreshed and updated automatically with new data.