Delivering Business Intelligence with Microsoft SQL Server 2012 3/E

Master the business intelligence tools in the latest release of Microsoft SQL Server Fully updated for the new version of SQL Server, Delivering Business Intelligence with Microsoft SQL Server XXXX, Third Editionis a complete BI course in a book. It begins with a discussion of BI, defining what it is and why it is important in today's business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering the BI. Several analysis databases are built and used for examples throughout the book. The examples give a complete description of each process, so you will able to complete similar tasks on your own data using all the BI tools available in SQL Server. Delivering Business Intelligence with Microsoft SQL Server XXXX, Third Edition Provides a complete understanding of the BI lifecycle and the Microsoft tools designed to handle each step in that lifecycle Features step-by-step, start-to-finish instructions that lead you through the creation of complete processes and solutions Includes example scenarios that place the BI concepts and Microsoft tools in a real-world context and assist you in applying this knowledge to particular business situations Offers free downloadable code

Part I: Business Intelligence
Chapter 1. Equipping the Organization for Effective Decision Making
Chapter 2. Making the Most of What You've Got--Using Business Intelligence
Chapter 3. Seeking the Source--The Source of Business Intelligence
Chapter 4. Two, Two, Two Models in One--The BI Semantic Model
Chapter 5. First Steps--Beginning the Development of Business Intelligence
Part II: Defining Business Intelligence Structures
Chapter 6. Building Foundations--Creating Data Marts
Chapter 7. Transformers--Integration Service Structure and Components
Chapter 8. Fill 'er Up--Using Integration Services for Populating Data Marts
Part III: Working with a Multidimensional BI Semantic Model
Chapter 9. Cubism--Measures and Dimensions
Chapter 10. Bells and Whistles--Special Features of OLAP Cubes
Chapter 11. Writing a New Script--MDX Scripting
Chapter 12. Pulling It Out and Building It Up--MDX Queries
Part IV: Working with a Tabular BI Semantic Model
Chapter 13. Setting the Table--Creating a Tabular BI Semantic Model
Chapter 14. A Fancy Table--Tabular BI Semantic Model Advanced Features
Part V: Mining
Chapter 15. Panning for Gold--Introduction to Data Mining
Chapter 16. Building the Mine--Working with the Data Mining Model
Chapter 17. Spelunking--Exploration Using Data Mining
Part VI: Delivering
Chapter 18. Special Delivery--Microsoft Business Intelligence Client Tools
Chapter 19. Let's Get Together--Integrating Business Intelligence with Your Applications
Index