Excel

SQL Server Data Mining with Microsoft Office Excel

• by Additional Articles

• SQL Server Performance

• Excel

• Article

This article demonstrates using SQL Server's data mining capabilities with the Excel.

2011-02-11

5,472 reads

Database defintion from an Excel Spec?

• by Ian Hadlington

• SQLServerCentral.com

• Excel

• Article

Have you ever been required to create a database with nothing but a specification in Excel?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3.41 (17)

Log in or register to rate

2009-11-12

7,367 reads

• Discuss

Utilize SSAS for data predictions and classification using Excel

• by Additional Articles

• SearchSQLServer

• Excel

• Article

Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.

2009-01-09

2,868 reads

Simple Column Chart for Analysis Services Data

• by Additional Articles

• Database Journal

• Excel

• Article

This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.

2008-12-19

2,293 reads

Script to build a SQL Server Data Dictionary and report with Microsoft Excel

• by Additional Articles

• MSSQLTips.com

• Excel

• Article

There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?

2008-12-09

4,930 reads

Automating Excel from SQL Server

• by Wayne Sheffield

• SQLServerCentral.com

• Excel

• Article

How to have SQL Server drive Excel spreadsheets

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.68 (117)

Log in or register to rate

2010-02-19 (first published: 2008-12-05)

36,528 reads

• Discuss

Build Great Looking Excel Spreadsheets

• by David Ziffer

• SQLServerCentral.com

• Excel

• Article

Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.42 (52)

Log in or register to rate

2008-11-05

18,020 reads

• Discuss

Let the Excel Play

• by Shashank Bhide

• SQLServerCentral.com

• Excel

• Article

This article describes how you can use excel to pull the data from the SQL Server and use it for report generating.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.44 (27)

Log in or register to rate

2008-10-03

13,027 reads

• Discuss

How to Export Data to Microsoft Office Excel 2007 Using SQL Server 2005

• by Additional Articles

• SQL Server Performance

• Excel

• Article

This article provides a step by step guide on how to export data to Microsoft Office Excel 2007

2008-07-04

8,937 reads