Business Intelligence and Data Warehouse | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Business Intelligence and Data Warehouse

I’m interested in working in this arena and was wondering if there are good books/articles for beginners??
I’m inclining towards building a data mart with BI interface. Appreciate any help/advice..

Lot of options availble for you in fact web resources on Microsoft site and as well as forums/tips/blogs etc. BI means not only analysis services it tends to be for SSIS & SSRS too refer to for tutorials in thsi case and don’t forget to upgrade your local Books online for SQL 2005 with latest update –…able-for-download-update-your-local-copy.aspx

I would definitely encourage you to buy Dr Ralph Kimball’s books on dimensional modelling, as well as his Toolkit books. One of the most important aspects of a datawarehouse is the modelling of the data, and when you come from a relational background it is quite a change in mindset.

yes it us vast area.
for starter,

Appreciate all your help!!!

"The Data Warehouse Toolkit" by Ralph Kimball and Margy Ross is the book.

Here’s a new book on BI by Lynn Langit:…solutions-with-microsoft-sql-server-2008.aspx


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |