Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

About The BookYour guide to building solutions across the entire Microsoft BI stack Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it. Discover how to: Manage the development life cycle and build a BI team Dig into SQL Server Analysis Services, Integration Services, and Reporting Services Navigate the Business Intelligence Development Studio (BIDS) Write queries that rank, sort, and drill down on sales data Develop extract, transform, and load (ETL) solutions Add a source code control system Help secure packages for deployment via encryption and credentials Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models Create and implement custom objects using .NET code View reports in Microsoft Office Excel® and Office SharePoint® Serverook

About Lynn Langit, Kevin S. Goff, Davide Mauri, Sahil Malik, and John WelchLynn Langit is a developer evangelist for the Microsoft MSDN® team. Prior to working at Microsoft, she founded and served as lead architect of a development firm that created BI solutions. She holds a number of Microsoft certifications, including MCITP, MCSD, MCDBA, and MCT. Kevin S. Goff is a Microsoft MVP and a trainer and BI practice lead for a Microsoft Gold Certified Partner. Davide Mauri, MCP, MCAD, MCDBA, MCT, is a Microsoft MVP who has worked with SQL Server since version 6.5. Sahil Malik is a consultant and trainer who has been a Microsoft MVP and an INETA speaker for many years. John Welch is a Microsoft MVP and the chief architect at a consulting firm specializing in BI solutions.