New in Datawarehousing

I would highly appreciate if anyone provide me any website from where I can
get the quick idea to create cubes in SQL Server and add that cube in Excel
to do some analysis.

Thanks in advance.

Your reply would be highly appreciated.

Thanks

"Noor" wrote in message
news:%23sN7gc3wIHA.704-at-TK2MSFTNGP05.phx.gbl...
>I would highly appreciate if anyone provide me any website from where I can
>get the quick idea to create cubes in SQL Server and add that cube in Excel
>to do some analysis.
>
> Thanks in advance.
>
> Your reply would be highly appreciated.
>
> Thanks
>

A place to start would be:
http://www.microsoft.com/sql/solutions/bi/default.mspx

--
David Portas

A quick idea?
Cubes will make building your pivot tables easier, assuming the cubes are
already designed and loaded, and the data refresh will be faster when the
data source is an OLAP cube instead of transactional tables.
Hoever, if the end result you are looking for is analyzing SQL Server data
within Excel Pivot Tables, and you are dealing with a few hundred MB of data
or less, then building cubes in SQL Server Analysis Services is an additional
step that is not required. There are books and website dedicating solely to
building "Excel Pivot Tables", so just google it and see what speaks to you.

"Noor" wrote:

> I would highly appreciate if anyone provide me any website from where I can
> get the quick idea to create cubes in SQL Server and add that cube in Excel
> to do some analysis.
>
> Thanks in advance.
>
> Your reply would be highly appreciated.
>
> Thanks
>
>
>

On Sun, 1 Jun 2008 19:01:38 +0100, "David Portas"
wrote:

>"Noor" wrote in message
>news:%23sN7gc3wIHA.704-at-TK2MSFTNGP05.phx.gbl...
>>I would highly appreciate if anyone provide me any website from where I can
>>get the quick idea to create cubes in SQL Server and add that cube in Excel
>>to do some analysis.
>>
>> Thanks in advance.
>>
>> Your reply would be highly appreciated.
>>
>> Thanks
>>
>
>A place to start would be:
>http://www.microsoft.com/sql/solutions/bi/default.mspx


This reboots my XPsp2 system!
mms://wm.microsoft.com/ms/sql/tours/AS_1_Pervasive_BI.wmv

The media player comes up.
The system POWERS DOWN IMMEDIATELY and reboots.

After logging back in, little MS boxes come up saying "system
recovered from serious error", click for details and more info, and it
lists files in the temp directory mini070208.dmp and sysdata.xml.

WTF?

I did this a second time, just to confirm.

So far, no further harm seems to have occurred.

I am not aware of having any other problems of any kind with .wmv or
any other content.

J.