Buy SQL Server Analysis Services 2012 Cube Development Cookbook
close menu
Bookswagon
search
My Account
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology Books > Computer programming / software engineering > Programming and scripting languages: general > SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-
SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-

SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast. Key Features Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions Book DescriptionMicrosoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence. This practical guide teaches you how to build business intelligence solutions using Microsoft’s core product – SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012. Starting with comparing MultiDimensional and tabular models – discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users. The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages. This book provides you with data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services.What you will learn Design commonly encountered dimensions Extend your cubes to include advanced features such as actions, translations, and key performance indicators Maintain cubes by adding/removing data using partitions Administer Analysis Services instance Scale out your solution by synchronizing cube data Build tabular model solutions Who this book is forIf you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

Table of Contents:
Table of Contents

  1. Introduction to Relational Data Mart Design
  2. Understanding Cubes
  3. Creating cubes
  4. Extending & customizing cubes
  5. Optimizing the processing of dimensions and cubes
  6. MDX
  7. Analysis Services security
  8. Administering and Monitoring SSAS instance
  9. Using Tabular Models
  10. DAX Query Language Basics
  11. Monitoring and Optimizing Tabular Model Performance
  12. Appendix


About the Author :
Baya Dewald has been working with Microsoft SQL Server for over 15 years and with Analysis Services since its debut in 1999. He has architected, developed, and administered databases with millions of users and cubes measured in terabytes. Throughout his career, he has held various certifications, including Microsoft Certified Solution Developer, Microsoft Certified Systems Engineer, and Microsoft Certified Database Administrator. He has managed DBA teams and published over 100 technical articles in SQL Server Magazine, SQL Professional, Tech Target, and InformIT. He has also contributed to several technical books as a co-author and technical reviewer. He can be reached at baya.dewald@gmail.com.


Best Sellers


Product Details
  • ISBN-13: 9781849689816
  • Publisher: Packt Publishing Limited
  • Publisher Imprint: Packt Publishing Limited
  • Language: English
  • Sub Title: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-
  • ISBN-10: 1849689814
  • Publisher Date: 26 Dec 2013
  • Binding: Digital (delivered electronically)
  • No of Pages: 340


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-
Packt Publishing Limited -
SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

SQL Server Analysis Services 2012 Cube Development Cookbook: If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!