Before looking at building Business Intelligence (BI) solutions with SQL Server 2005, it's important to get an understanding of the underlying concepts. This chapter covers the basics of what makes BI systems different from transaction systems and looks at some modeling techniques and technologies for providing the performance and flexibility that users need. We end the chapter by providing some practical project advice and point out some of the pitfalls of BI projects. |