| Description |
1 online resource (475 pages) |
| Summary |
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. |
| Contents |
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? |
|
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 |
|
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 |
|
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 |
|
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 |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
SQL server.
|
|
SQL server |
|
Business intelligence.
|
|
Database management.
|
|
Business intelligence |
|
Database management |
| Added Author |
Jorgensen, Adam.
|
| Other Form: |
Print version: Hughes, Steven. Hands-On SQL Server 2019 Analysis Services : Design and Query Tabular and Multi-Dimensional Models Using Microsoft's SQL Server Analysis Services. Birmingham : Packt Publishing, Limited, ©2020 |
| ISBN |
180020163X |
|
9781800201637 (electronic bk.) |
|
9781800204768 (pbk.) |
|
