Cargando…

SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services /

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. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is i...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Dewald, Baya
Otros Autores: Hughes, Steve, Turley, Paul, 1962-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Pub., 2013.
Colección:Quick answers to common problems.
Temas:
Acceso en línea:Texto completo
Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBOOKCENTRAL_ocn870467562
003 OCoLC
005 20240329122006.0
006 m o d
007 cr cnu---unuuu
008 140213s2013 enka o 001 0 eng d
040 |a UMI  |b eng  |e pn  |c UMI  |d COO  |d DEBBG  |d DEBSZ  |d N$T  |d EBLCP  |d IDEBK  |d E7B  |d YDXCP  |d CHVBK  |d OCLCF  |d OCLCO  |d OCLCQ  |d OCL  |d OCLCQ  |d AGLDB  |d ICA  |d ZCU  |d MERUC  |d OCLCQ  |d JBG  |d OCLCO  |d D6H  |d VNS  |d VTS  |d CEF  |d ICG  |d NLE  |d UKMGB  |d OCLCQ  |d OCLCO  |d STF  |d DKC  |d AU@  |d OCLCQ  |d UKAHL  |d OCLCQ  |d OCLCO  |d OCLCQ  |d K6U  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
015 |a GBB6J3221  |2 bnb 
016 7 |a 018014108  |2 Uk 
016 7 |a 018005515  |2 Uk 
019 |a 867317608 
020 |a 9781849689816  |q (electronic bk.) 
020 |a 1849689814  |q (electronic bk.) 
020 |a 9781782170662 
020 |a 1782170669 
020 |a 9781782170679 
020 |a 1782170677 
020 |z 9781849689809 
020 |z 1849689806 
029 1 |a CHNEW  |b 000643075 
029 1 |a CHNEW  |b 000899669 
029 1 |a CHVBK  |b 403395321 
029 1 |a DEBBG  |b BV041784034 
029 1 |a DEBBG  |b BV044065635 
029 1 |a DEBSZ  |b 404337503 
029 1 |a DEBSZ  |b 493139036 
029 1 |a GBVCP  |b 814512798 
029 1 |a NZ1  |b 15912149 
029 1 |a UKMGB  |b 018005515 
029 1 |a UKMGB  |b 018014108 
035 |a (OCoLC)870467562  |z (OCoLC)867317608 
037 |a 9781849689816  |b Packt Publishing Pvt. Ltd 
050 4 |a HD38.7  |b .D49 2013 
072 7 |a COM  |x 051170  |2 bisacsh 
072 7 |a COM  |x 021000  |2 bisacsh 
082 0 4 |a 005.7585  |2 23 
049 |a UAMI 
100 1 |a Dewald, Baya. 
245 1 0 |a SQL server analysis services 2012 cube development cookbook :  |b more than 100 recipes to develop business intelligence solutions using analysis services /  |c Baya Dewald, Steve Hughes, Paul Turley. 
260 |a Birmingham, UK :  |b Packt Pub.,  |c 2013. 
300 |a 1 online resource (1 volume) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Quick answers to common problems 
588 0 |a Online resource; title from cover (Safari, viewed February 10, 2014). 
505 0 |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views. 
505 8 |a Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures. 
505 8 |a Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options. 
505 8 |a Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality. 
505 8 |a Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session. 
520 |a 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. 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. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
630 0 0 |a SQL server. 
630 0 7 |a SQL server.  |2 blmlsh 
630 0 7 |a SQL server  |2 fast 
650 0 |a Business intelligence. 
650 0 |a Data mining. 
650 0 |a Database management. 
650 0 |a MDX (Computer program language) 
650 6 |a Exploration de données (Informatique) 
650 6 |a Bases de données  |x Gestion. 
650 6 |a MDX (Langage de programmation) 
650 7 |a COMPUTERS  |x Programming Languages  |x SQL.  |2 bisacsh 
650 7 |a COMPUTERS  |x Databases  |x General.  |2 bisacsh 
650 7 |a Business intelligence  |2 fast 
650 7 |a Data mining  |2 fast 
650 7 |a Database management  |2 fast 
650 7 |a MDX (Computer program language)  |2 fast 
700 1 |a Hughes, Steve. 
700 1 |a Turley, Paul,  |d 1962-  |1 https://id.oclc.org/worldcat/entity/E39PCjwqFmvM9yyTPYR6fVPjVK 
776 0 8 |i Print version:  |a Dewald, Baya.  |t SQL Server Analysis Services 2012 Cube Development Cookbook.  |d Birmingham : Packt Publishing, ©2013  |z 9781849689809 
830 0 |a Quick answers to common problems. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781849689809/?ar  |z Texto completo 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1581056  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH26849674 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL1581056 
938 |a ebrary  |b EBRY  |n ebr10825553 
938 |a EBSCOhost  |b EBSC  |n 680698 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis27260897 
938 |a YBP Library Services  |b YANK  |n 11468639 
994 |a 92  |b IZTAP