Video Tutorials for Business Intelligence with Excel 2007
MyVBProf.com hosts a set of great video tutorials for performing business intelligence tasks with Excel 2007. Bill Burrows starts with the installation of pre-requisites. He even shows how to make sure that Excel .Net Programmability Support is available! Wow!!
Bill then follows up with a set of tutorials on pivot tables and wraps up with videos on using the Table Analysis Tools from the SQL Server Data Mining add-ins for Excel. His approach is accessible, his style is captivating, his examples are meaningful and very well explained.
Therefore:
1. If you have SQL Server 2005 or 2008 CTP these tutorials give you a great start for BI using Excel and Analysis Service.
2. If you do not have SQL Server, get a free evaluation from http://www.microsoft.com/sql/downloads/trial-software.mspx, then go back to the previous point
3. You don’t have SQL Server, don’t want to try it out, don’t care about the data mining part — fine, just watch some of the tutorials to see what you miss!
[…] Original post by bogdan […]
[…] Administrator wrote an interesting post today onHere’s a quick excerptMyVBProf.com hosts a set of great video tutorials for performing business intelligence tasks with Excel 2007. Bill Burrows starts with the installation of pre-requisites. He even shows how to make sure that Excel . … […]
Do you know the book
Data Analysis using SQL and Excel, by Gordon Linoff?
Visit:
http://www.data-miners.com/dataminingsqlserver
Thanks for the link. I was aware of the book but not of the website.
The following website presents easy and friendly tutorial videos for Excel 2007:
http://www.microsoft-office-excel.com