L'édition de cet ISBN n'est malheureusement plus disponible.
Afficher les exemplaires de cette édition ISBNIf 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
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 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 from this book
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.
Baya Dewald
Baya Dewald has been working with Microsoft SQL Server for over 15 years and with Analysis Services since its debut in 1999. Baya has architected, developed and administered databases with millions of users and cubes measured in Terabytes. Throughout his career Mr. Dewald has held various certifications including Microsoft Certified Solution Developer, Microsoft Certified Systems'; Engineer and Microsoft Certified Database Administrator. Mr. Dewald has managed DBA teams and published over 100 technical articles in SQL Server Magazine, SQL Professional, Tech Target and InformIT. He also contributed to several technical titles as a co-author and technical reviewer. Baya can be reached at baya.dewald@gmail.com
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.
Frais de port :
EUR 3,70
Vers Etats-Unis
Description du livre Etat : New. N° de réf. du vendeur ABLIING23Mar2912160253751
Description du livre PAP. Etat : New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. N° de réf. du vendeur L0-9781849689809
Description du livre Etat : New. PRINT ON DEMAND Book; New; Fast Shipping from the UK. No. book. N° de réf. du vendeur ria9781849689809_lsuk
Description du livre PF. Etat : New. N° de réf. du vendeur 6666-IUK-9781849689809
Description du livre Etat : New. pp. 340. N° de réf. du vendeur 2697773001
Description du livre Etat : New. Print on Demand pp. 340 3:B&W 7.5 x 9.25 in or 235 x 191 mm Perfect Bound on White w/Gloss Lam. N° de réf. du vendeur 94657046
Description du livre PAP. Etat : New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. N° de réf. du vendeur L0-9781849689809
Description du livre Paperback / softback. Etat : New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. N° de réf. du vendeur C9781849689809
Description du livre Etat : New. Dieser Artikel ist ein Print on Demand Artikel und wird nach Ihrer Bestellung fuer Sie gedruckt. KlappentextThis title includes more than 100 recipes to develop business intelligence solutions using Analysis Services. N° de réf. du vendeur 4287890
Description du livre Taschenbuch. Etat : Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - This title includes more than 100 recipes to develop business intelligence solutions using Analysis Services. N° de réf. du vendeur 9781849689809