• Complain

Hughes Steve - SQL server analysis services 2012 cube development cookbook

Here you can read online Hughes Steve - SQL server analysis services 2012 cube development cookbook full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. City: Birmingham, UK, year: 2013, publisher: Packt Publishing, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Hughes Steve SQL server analysis services 2012 cube development cookbook

SQL server analysis services 2012 cube development cookbook: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "SQL server analysis services 2012 cube development cookbook" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

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.

Overview

  • 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

In Detail

Microsoft 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 Microsofts 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 from this book

  • 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

Approach

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.

Who this book is written for

If 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.

Hughes Steve: author's other books


Who wrote SQL server analysis services 2012 cube development cookbook? Find out the surname, the name of the author of the book and a list of all author's works by series.

SQL server analysis services 2012 cube development cookbook — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "SQL server analysis services 2012 cube development cookbook" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

Reset

Interval:

Bookmark:

Make
SQL Server Analysis Services 2012 Cube Development Cookbook

SQL Server Analysis Services 2012 Cube Development Cookbook

Copyright 2013 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: December 2013

Production Reference: 1181213

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-84968-980-9

www.packtpub.com

Cover Image by William Kewley (<>)

Credits

Authors

Baya Dewald

Paul Turley

Steve Hughes

Reviewers

Dan English

Stevo Smoilac

Acquisition Editors

Edward Gordon

Llewellyn Rozario

Lead Technical Editor

Anila Vincent

Technical Editors

Dipika Gaonkar

Kapil Hemnani

Edwin Moses

Mrunmayee Patil

Siddhi Rane

Tarunveer Shetty

Proofreaders

Cathy Cumberlidge

Bernadette Watkins

Copy Editors

Sarang Chari

Mradula Hegde

Dipti Kapadia

Gladson Monteiro

Karuna Narayanan

Lavina Pereira

Laxmi Subramanian

Project Coordinators

Rahul Dixit

Cheryl Botelho

Mary Alex

Indexer

Rekha Nair

Production Coordinator

Kyle Albuquerque

Cover Work

Kyle Albuquerque

About the Authors

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 <>.

First and foremost, I'd like to thank my family for allowing me to dedicate long hours to working on this book. I am also thankful to my friend Scot Reagin for his encouragement and support while writing this book and to my friend and mentor Kevin Kline who helped me find excellent co-authors. Thanks too to all reviewers, particularly to Dan English, for their useful and thought-provoking comments that helped to make this book more useful to the readers.

Paul Turley is a mentor with SolidQ and is a Microsoft SQL Server MVP. He consults, writes, speaks, teaches, and blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is the director of the Oregon SQL PASS chapter and user group, and the lead author of Professional SQL Server 2012 Reporting Services and 11 other books by Wrox and Microsoft Press . Paul blogs at SqlServerBiBlog.com.

Special thanks to my wife and daughters for their support and understanding. Thanks to all the mentors and staff at SolidQ, a truly world-class organization.

Steve Hughes is a Practice Lead at Magenic. In his current role, he develops strategy and helps guide data, business intelligence, collaboration, and data integration development using Microsoft technologies, including SQL Server, SharePoint, and BizTalk. He continues to deliver data and business intelligence solutions using these platforms. He has been working with technology for over 15 years with much of that time spent on creating business intelligence solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable. He also has experience working with a large software company as a service vendor and there received awards for customer satisfaction and engineering excellence.

In 2010, he received the Consultant of the Year honor at Magenic. He has delivered multiple presentations on SQL server, data architecture, and business intelligence over the years. Steve can often be found at Professional Association for SQL Server (PASS) events where he serves as a regional mentor and is active with the Minnesota SQL Server User Group (MNPASS). He shares his insights from the field on his blog at http://dataonwheels.wordpress.com.

I want to thank my wife, Sheila, and our four childrenKristyna, Alex, Andrew, and Mikaylafor their patience as I worked on this project. Their support has been awesome in this and my other endeavors. I also want to thank the team at Packt Publishing and the reviewers for their guidance throughout the writing of this book as it has allowed us to put together a better product for all of you. Finally, I dedicate all my efforts to my father-in-law, Ed Jankowski, without whom I would have never been involved in software at all. We all miss you, Ed.

About the Reviewers

Dan English is a Microsoft SQL Server MVP and the Business Intelligence Practice Manager at Superior Consulting Services in Minneapolis, MN. He has been developing with Microsoft technologies since 1996 and has focused on data warehousing and business intelligence since 2004. He has presented for the Minnesota SQL Server user group, the Microsoft Minnesota BI user group, and Minnesota TechFuse, along with SQL Server and SharePoint Saturday events. He is also an avid blogger and tweeter.

He holds a Bachelor of Science degree in Business Administration from the Minnesota State University, Mankato. He is an MCITP: Business Intelligence Developer 2005 and 2008 and a Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server Business IntelligenceImplementation and Maintenance and also for Microsoft Office SharePoint Server 2007Configuring.

He and his wife, Molly, live in Minnesota and have two children, Lily and Wyatt.

Stevo Smoilac is an Associate Principal Consultant at Magenic, a Microsoft Gold Certified Partner that specializes in business intelligence solutions.

He has over 12 years' experience working in software development, the last seven of which have focused on designing, implementing, managing, and administrating technical solutions developed using Microsoft SQL Server and the Microsoft Business Intelligence stack. He has been involved in all phases of the BI development lifecycle from envisioning through operational support and is passionate about the field of business intelligence.

He is currently a Virtual Technology Solutions Professional (V-TSP) for business intelligence, a Microsoft Certified IT Professional, and holds a B. Tech degree in Information Technology.

Next page
Light

Font size:

Reset

Interval:

Bookmark:

Make

Similar books «SQL server analysis services 2012 cube development cookbook»

Look at similar books to SQL server analysis services 2012 cube development cookbook. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.


Reviews about «SQL server analysis services 2012 cube development cookbook»

Discussion, reviews of the book SQL server analysis services 2012 cube development cookbook and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.