Business Intelligence and Data Warehouse | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Business Intelligence and Data Warehouse

Hi,
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..
Thanks

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 http://msmvps.com/blogs/ssqa/archive/tags/tutorial/default.aspx for tutorials in thsi case and don’t forget to upgrade your local Books online for SQL 2005 with latest update – http://sqlserver-qa.net/blogs/tools…able-for-download-update-your-local-copy.aspx

Hi,
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,
http://www.microsoft.com/bi/
http://www.microsoft.com/sql/solutions/bi/default.mspx

Appreciate all your help!!!
Thanks!!!

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

Here’s a new book on BI by Lynn Langit: http://blogs.msdn.com/microsoft_pre…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 |