Database Reference
In-Depth Information
How to do it...
Perform the following steps:
1. Start Microsoft Excel.
2. On the
Data
ribbon, in the
Get External Data
area, click on
From Other Sources
and then choose
From SQL Server
.
3. In the
Server name
field, enter the name of the SQL Server that hosts the
DWDataMart
database, select
Use Windows Authentication
, and then click on
Next
.
4. Select the
DWDataMart
database, click on the
v_Custom_r_AllIncidents
view,
and then click on
Finish
.
5. In the
Import Data
dialog, click on
OK
.
Microsoft Excel connects to the data source and retrieves the data from the view created
earlier in this recipe. You can now use common Excel features, such as PivotTables or
PivotCharts, to analyze your data.
When you want Excel to load the latest data from the database, right-click anywhere inside
the data table and click on
Refresh
, as shown in the following screenshot: