In this book, two of Microsoft's leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management. Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the bookconstructing solutions. Each chapter-length case study begins with the customer's business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation. Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project. • Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services • Build data warehouses and extend them to support very large databases • Design effective Analysis Services databases • Ensure the superior data quality your BI system needs • Construct advanced enterprise scorecard applications • Use data mining to segment customers, cross-sell, and increase the value of each transaction • Design real-time BI applications • Get hands-on practice with SQL Server 2005's BI toolset
Jamie MacLennan, ZhaoHui Tang, and Bogdan Crivat, Wiley, 2009
Understand how to use the new features of Microsoft SQL Server 2008 for data mining by using the tools in Data Mining with Microsoft SQL Server 2008, which will show you how to use the SQL Server Data Mining Toolset with Office 2007 to mine and analyze data. Explore each of the major data mining algorithms, including naive bayes, decision trees, ti…
* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases * The authors then describe the development processes for building dimensions and cubes from various data sources * Demonstrating a variety …
Just as every business needs to effectively employ Business Intelligence (BI) to stay competitive, every IT professional needs to master BI to stay employed in this fastest-growing segment of Information Technology. Foundations of SQL Server 2005 Business Intelligence is the quickest path to understanding BI, and it is essential reading for all who…
Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsofts customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentialshow to create a cube, as well as how to deploy, customize, and extend the basic calculationsis…
Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008 Analysis Ser…
