One of the more interesting technology battles this year (and probably 2008) will pit Microsoft's Office 2007 coupled with SQL Server 2005 against established business intelligence players. That fact ...

Teradata Aster has launched a new tool which allows business analysts to work with Hadoop data through SQL query structures. Its Aster SQL-H provides a bridge between widely used business intelligence ...

Using the External Data Connection feature in Excel, you can acquire information from external sources, such as Access and SQL Server. The data remains stored at its original source, but the data ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...