Tabular modeling with SQL server 2016 analysis services cookbook expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions
Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions About This Book Build and deploy Tabular Model projects from relational data sources Leverage DAX and create high-performing calculated fields and measures Create ad-hoc reports based o...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt
2017.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630148706719 |
Tabla de Contenidos:
- Cover
- Copyright
- Credits
- About the Author
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Table of Contents
- Preface
- Chapter 1: Introduction to Microsoft Analysis Services Tabular Mode
- Introduction
- Learning about Microsoft Business Intelligence and SQL Server 2016
- Understanding tabular mode
- Learning what's new in SQL Server 2016 tabular mode
- Modeling
- Instance management
- Scripting
- DAX
- Importing sample datasets
- Getting ready
- How to do it…
- How it works…
- Understanding basic concepts
- Tables
- Columns
- Measures
- Relationships
- Hierarchies
- Chapter 2: Setting up a Tabular Mode Environment
- Introduction
- Installing and configuring a development environment
- Getting ready
- How to do it…
- How it works…
- Installing Visual Studio 2015
- Getting ready
- How to do it…
- How it works…
- Installing SQL Server Data Tools (SSDT)
- Getting ready
- How to do it…
- How it works…
- Interacting with SQL Server Data Tools
- Getting ready
- How to do it…
- How it works…
- Configuring a workspace server
- Getting ready
- How to do it…
- How it works…
- There's more…
- Configuring SSAS project properties
- Getting ready
- How to do it…
- How it works…
- Chapter 3: Tabular Model Building
- Introduction
- Adding new data to a tabular model
- Getting ready
- How to do it…
- How it works…
- Adding a calculated column
- Getting ready
- How to do it…
- How it works…
- Adding a measure to a tabular model
- How to do it…
- How it works…
- Changing model views
- How to do it…
- How it works…
- There's more…
- Renaming columns
- How to do it…
- How it works…
- Defining a date table
- Getting ready
- How to do it…
- How it works…
- Creating hierarchies
- How to do it…
- How it works…
- Understanding and building relationships
- Getting ready.
- How to do it…
- How it works…
- Creating and organizing display folders
- Getting ready
- How to do it…
- How it works…
- Deploying your first model
- Getting ready
- How to do it…
- How it works…
- Browsing your model with SQL Server Management Studio
- How to do it…
- How it works…
- Browsing your model with Microsoft Excel
- How to do it…
- How it works…
- Chapter 4: Working in Tabular Models
- Introduction
- Opening an existing model
- How to do it…
- How it works…
- Importing data
- Getting ready
- How to do it…
- How it works…
- Modifying model relationships
- How to do it…
- How it works…
- Modifying model measures
- How to do it…
- How it works…
- Modifying model columns
- How to do it…
- How it works…
- Modifying model hierarchies
- How to do it…
- How it works…
- There's more…
- Creating a calculated table
- How to do it…
- How it works…
- There's more…
- Creating key performance indicators (KPIs)
- How to do it…
- How it works…
- Modifying key performance indicators (KPIs)
- How to do it…
- How it works…
- Deploying a modified model
- How to do it…
- How it works…
- There's more…
- Chapter 5: Administration of Tabular Models
- Introduction
- Managing tabular model properties
- [Changing data backup locations]
- Changing data backup locations
- Changing DirectQuery mode
- Changing workspace retention
- Changing workspace server
- Managing perspectives
- Getting ready
- How to do it…
- Adding a new perspective
- Editing a perspective
- Renaming a perspective
- Deleting a perspective
- Copying a perspective
- Managing partitions
- How to do it…
- Creating a Partition
- Editing a partition
- Processing partitions
- How it works…
- Managing roles
- Getting ready
- How to do it…
- Creating Admin role
- Creating a Read role
- Creating a read and process role.
- Creating a process role
- Editing roles
- There's more…
- Managing server properties
- How to do it…
- Managing Analysis Services memory
- How to do it…
- How it works…
- Chapter 6: In-Memory Versus DirectQuery Mode
- Introduction
- Understanding query modes
- Understanding in-memory mode
- Advantages of in-memory
- Limitations of in-memory
- Understanding DirectQuery mode
- Advantages of DirectQuery
- Limitations of DirectQuery mode
- Creating a new DirectQuery project
- How to do it…
- How it works…
- Configuring DirectQuery table partitions
- How to do it…
- How it works…
- Testing DirectQuery mode
- How it works…
- Chapter 7: Securing Tabular Models
- Introduction
- Configuring static row-level security
- Getting ready
- How to do it…
- How it works…
- Configuring dynamic filter security
- Getting ready
- How to do it…
- How it works…
- Chapter 8: Combining Tabular Models with Excel
- Introduction
- Using Analyze in Excel from SSMS
- How to do it…
- How it works…
- Connecting to Excel from SQL Server Data Tools
- How to do it…
- How it works…
- Using PivotTables with tabular data
- Using Slice, Sort, and Filter
- How to do it…
- How it works…
- Using the timeline filter with pivot tables
- How to do it…
- How it works…
- Analyzing data with Power View
- How to do it…
- How it works…
- There's more…
- Importing data with Power Pivot
- Getting ready
- How it works…
- Modeling data with Power Pivot
- Getting ready
- How to do it…
- How it works…
- Adding data to Power Pivot
- Getting ready
- How to do it…
- How it works…
- Moving Power Pivot models to the enterprise
- Moving Power Pivot to SSAS via Management Studio
- How to do it…
- How it works…
- Moving Power Pivot to SSAS via SQL Server Data Tools
- How to do it…
- How it works…
- Chapter 9: DAX Syntax and Calculations.
- Introduction
- Understanding DAX formulas
- Getting ready
- How to do it…
- How it works…
- There's more…
- Using the AutoSum measure in Visual Studio
- How to do it…
- How it works…
- Creating calculated measures
- Getting ready
- How to do it…
- How it works…
- Creating calculated columns
- How to do it…
- How it works…
- There's more…
- Using the IF function
- Getting ready
- How to do it…
- How it works…
- Using the AND function
- How to do it…
- Using the SWITCH function
- How to do it…
- How it works…
- There's more…
- Using the CONCATENATE function
- How to do it…
- How it works…
- There's more…
- Using the LEFT Function
- How to do it…
- How it works…
- There's more…
- Using the RELATED function
- How to do it…
- How it works…
- There's more…
- Using the RELATEDTABLE function
- How to do it…
- How it works…
- Using EVALUATE in DAX queries
- How to do it…
- Filtering based on a value
- Getting ready
- How to do it…
- How it works…
- Filtering a related table
- How to do it…
- How it works…
- Using ALL to remove filters
- How to do it…
- How it works…
- Using ALL to calculate a percentage
- Getting ready
- How to do it…
- How it works…
- Using the SUMMARIZE function
- How to do it…
- How it works…
- Adding columns to the SUMMARIZE function
- Getting ready
- How to do it…
- How it works…
- Using ROLLUP with the SUMMARIZE function
- How to do it…
- How it works…
- Chapter 10: Working with Dates and Time Intelligence
- Introduction
- Creating a date table in Visual Studio
- Getting ready
- How to do it…
- How it works…
- Using the CALENDAR function
- How to do it…
- How it works…
- Modifying the date table with the YEAR function
- Getting ready
- How to do it…
- How it works…
- Modifying the date table to include month data
- How to do it…
- How it works….
- There's more…
- Using the NOW and TODAY functions
- How to do it…
- How it works…
- Using the DATEDIFF function
- Getting ready
- How to do it…
- How it works…
- There's more…
- Using the WEEKDAY function
- How to do it…
- How it works…
- There's more…
- See also…
- Using the FIRSTDATE function
- How to do it…
- How it works…
- There's more…
- Using the PARALLELPERIOD function
- How to do it…
- How it works…
- There's more…
- Calculating Year over Year Growth
- How to do it…
- How it works…
- Using the OPENINGBALANCEMONTH function
- How to do it…
- How it works…
- Using the OPENINGBALANCEYEAR function
- How to do it…
- How it works…
- Using the CLOSINGBALANCEMONTH function
- How to do it…
- How it works…
- Using the CLOSINGBALANCEYEAR function
- How to do it…
- How it works…
- Using the TOTALYTD function
- How to do it…
- How it works…
- Chapter 11: Using Power BI for Analysis
- Introduction
- Getting started with Power BI desktop
- How to do it…
- How it works…
- Adding data to Power BI reports
- How to do it…
- How it works…
- There's more…
- Visualizing the crash data with Power BI
- Getting ready
- How to do it…
- How it works…
- Editing visualization properties in Power BI
- Getting ready
- How to do it…
- How it works…
- Adding additional visualizations to Power BI
- Getting ready
- How it to do it…
- How it works…
- Adding a slicer to Power BI
- Getting ready
- How to do it…
- How it works…
- Using analytics in Power BI
- Getting ready
- How to do it…
- How it works…
- Index.
