Microsoft SQL Server 2008 Analysis Services
Book Details:
Pages: | 448 |
Published: | Apr 15 2009 |
Posted: | Nov 19 2014 |
Language: | English |
Book format: | PDF |
Book size: | 16.18 MB |
Book Description:
Teach yourself to use SQL Server 2008 Analysis Services for business intelligenceone step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniquesdirect from the companion Web site.
Design and implement fast, scalable and maintainable cubes A real-world guide to designing cubes with Analysis Services 2008Model dimensions and measure groups in BI Development StudioImplement security, drill-through, and MDX calculationsLearn how to deploy, monitor, and performance-tune your cubeFilled with best practices and useful hints and tips In Detail Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will h...
Every business has 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 Services will show you how to pull that data together and present it for reporting and analysis in a way that makes the data accessible to business users, instead of needing to rely on the IT department every time someone needs a different report. AccessibleWith a single author's voice, this book conducts a guided tour through the technology that makes it easy to dive into. SolutionorientedWhile technically d...
Problem, Design, Solution
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration ServicesSQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations. After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them. Shows you how to design SSIS solutions for data cleansing, ETL and file managementDemonstrates how to integrate data from a variety of data sources, Shows how to monitor SSIS performance,Demonstrates how to avoid common pitfalls involved with SSIS deploymentExplains how to ensure performance of the deployed solution ...
2007 - 2021 © eBooks-IT.org