Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Hands-On SQL Server 2019 Analysis Services

You're reading from   Hands-On SQL Server 2019 Analysis Services Design and query tabular and multi-dimensional models using Microsoft's SQL Server Analysis Services

Arrow left icon
Product type Paperback
Published in Oct 2020
Publisher Packt
ISBN-13 9781800204768
Length 474 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Steven Hughes Steven Hughes
Author Profile Icon Steven Hughes
Steven Hughes
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Preface 1. Section 1: Choosing Your Model
2. Chapter 1: Analysis Services in SQL Server 2019 FREE CHAPTER 3. Chapter 2: Choosing the SQL Server 2019 Analytic Model for Your BI Needs 4. Section 2: Building and Deploying a Multidimensional Model
5. Chapter 3: Preparing Your Data for Multidimensional Models 6. Chapter 4: Building a Multidimensional Cube in SSAS 2019 7. Chapter 5: Adding Measures and Calculations with MDX 8. Section 3: Building and Deploying Tabular Models
9. Chapter 6: Preparing Your Data for Tabular Models 10. Chapter 7: Building a Tabular Model in SSAS 2019 11. Chapter 8: Adding Measures and Calculations with DAX 12. Section 4: Exposing Insights while Visualizing Data from Your Models
13. Chapter 9: Exploring and Visualizing Your Data with Excel 14. Chapter 10: Creating Interactive Reports and Enhancing Your Models in Power BI 15. Section 5: Security, Administration, and Managing Your Models
16. Chapter 11: Securing Your SSAS Models 17. Chapter 12: Common Administration and Maintenance Tasks 18. Other Books You May Enjoy

Creating the solution and first tabular model

We will be creating four tabular models in this chapter. The first and second models will be built on the data warehouse and the third one will be built on the transactional database. We will then wrap up with the imported model. Each of these will be created as projects in a single Visual Studio solution. This will allow us to manage the shared settings effectively. Let's get started:

  1. Open Visual Studio and create a new project. Choose the Analysis Services Tabular Project as shown in the following screenshot. If you don't see it in your list, search for Tabular to find the correct template:

    Figure 7.1 – Creating a new Analysis Services tabular project

  2. Configure your new project. Give the project and the solution a name. We are naming our first project WideWorldImportersTAB as this will be the primary model we will work with in the following chapters:

    Figure 7.2 – Configuring your Analysis Services tabular...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image