LEADER 00000cam a2200589 i 4500 
001    on1202461828 
003    OCoLC 
005    20240126125653.0 
006    m     o  d         
007    cr cnu---unuuu 
008    201031s2020    enk     o     000 0 eng d 
015    GBC0G8268|2bnb 
016 7  019991754|2Uk 
019    1202052352 
020    180020163X 
020    9781800201637|q(electronic bk.) 
020    |z9781800204768|q(pbk.) 
035    (OCoLC)1202461828|z(OCoLC)1202052352 
037    9781800201637|bPackt Publishing 
040    EBLCP|beng|epn|cEBLCP|dUKMGB|dOCLCO|dYDX|dOCLCF|dN$T
       |dEBLCP|dUKAHL|dOCLCQ|dOCLCO|dKSU|dOCLCQ|dOCLCO 
049    RIDW 
050  4 QA76.73.S67 
082 04 005.7585|223 
082 04 005.756|223 
090    QA76.73.S67 
100 1  Hughes, Steven. 
245 10 Hands-On SQL Server 2019 Analysis Services :|bDesign and 
       Query Tabular and Multi-Dimensional Models Using 
       Microsoft's SQL Server Analysis Services. 
260    Birmingham :|bPackt Publishing, Limited,|c2020. 
300    1 online resource (475 pages) 
336    text|btxt|2rdacontent 
337    computer|bc|2rdamedia 
338    online resource|bcr|2rdacarrier 
505 0  Cover -- Title Page -- Copyright and Credits -- Dedication
       -- About Packt -- Foreword -- Contributors -- Table of 
       Contents -- Preface -- Section 1: Choosing Your Model -- 
       Chapter 01: Analysis Services in SQL Server 2019 -- What 
       is SQL Server Analysis Services anyway? -- SQL Server 
       Analysis Services is not SQL Server -- SQL Server Analysis
       Services through the years -- Why use SQL Server Analysis 
       Services? -- Optimized for reporting and analytics -- 
       Works great with Excel -- Organized with end users in mind
       -- What's new in SQL Server Analysis Services 2019? 
505 8  Multidimensional models in 2019 -- Tabular models in 2019 
       -- What are the tools used with SQL Server Analysis 
       Services? -- SQL Server 2019 Developer edition -- SQL 
       Server Management Studio (SSMS) -- Visual Studio with SQL 
       Server Data Tools (SSDT) -- One last thing -- our sample 
       data -- Restoring the data warehouse backup -- Summary -- 
       Chapter 02: Choosing the SQL Server 2019 Analytic Model 
       for Your BI Needs -- Technical requirements -- 
       Understanding how we got here -- two modes -- Discovering 
       multidimensional model strengths and challenges -- 
       Strengths of the multidimensional model 
505 8  Multidimensional model challenges -- Discovering tabular 
       model strengths and challenges -- Strengths of tabular 
       models -- Challenges with tabular models -- Understanding 
       other differences that matter -- Partitioning -- Role-
       playing dimensions -- OLAP versus relational concepts -- 
       Hardware requirements -- Choosing the model type for 
       business-specific reasons -- Rapid development and change 
       -- Cloud readiness -- Complex analysis -- Client tools -- 
       Summary -- Further reading -- Section 2: Building and 
       Deploying a Multidimensional Model -- Chapter 03: 
       Preparing Your Data for Multidimensional Models 
505 8  Technical requirements -- A short primer on dimensional 
       modeling -- Understanding the origin of dimensional 
       modeling -- Defining dimensional modeling terms -- Key 
       dimensional modeling concepts -- Common issues in 
       relational dimensional models -- Planning dimensions and 
       facts -- Designing and building dimensions and facts -- 
       Column names -- business-friendly or designer-friendly? --
       Dimension tables -- Fact tables -- Indexing strategies -- 
       Loading data into your star schema -- Staging your data --
       SQL Server data loading methods and tools -- Using 
       database views and data source views 
505 8  Data source views -- pros and cons -- Database views as an
       interface layer -- Prepping our database for the 
       multidimensional model -- Wide World Importers Sales -- 
       Creating the views for the multidimensional model -- 
       Summary -- Chapter 04: Building a Multidimensional Cube in
       SSAS 2019 -- Technical requirements -- Creating the 
       Analysis Services project in Visual Studio -- Adding the 
       SQL Server database connection to the project -- Adding 
       the DSVs to the project -- Adding dimensions, attributes, 
       and hierarchies -- Creating dimensions with the Dimension 
       Wizard -- Adding hierarchies to your dimensions 
520    This book will expand your ability to deliver meaningful, 
       performant solutions to your organization. You'll learn 
       how to use an analytical engine for decision making and 
       business analytics. With the help of this practical guide,
       you'll also be able to work confidently with data and 
       analytics. 
588 0  Print version record. 
590    eBooks on EBSCOhost|bEBSCO eBook Subscription Academic 
       Collection - North America 
630 00 SQL server. 
630 07 SQL server|2fast 
650  0 Business intelligence. 
650  0 Database management. 
650  7 Business intelligence|2fast 
650  7 Database management|2fast 
700 1  Jorgensen, Adam. 
776 08 |iPrint version:|aHughes, Steven.|tHands-On SQL Server 
       2019 Analysis Services : Design and Query Tabular and 
       Multi-Dimensional Models Using Microsoft's SQL Server 
       Analysis Services.|dBirmingham : Packt Publishing, Limited,
       ©2020 
856 40 |uhttps://rider.idm.oclc.org/login?url=https://
       search.ebscohost.com/login.aspx?direct=true&scope=site&
       db=nlebk&AN=2658853|zOnline ebook via EBSCO. Access 
       restricted to current Rider University students, faculty, 
       and staff. 
856 42 |3Instructions for reading/downloading the EBSCO version 
       of this ebook|uhttp://guides.rider.edu/ebooks/ebsco 
948    |d20240319|cEBSCO|tEBSCOebooksacademic NEW 1-26-24 6521
       |lridw 
994    92|bRID