{"id":365,"date":"2020-10-06T23:52:35","date_gmt":"2020-10-06T23:52:35","guid":{"rendered":"https:\/\/kindsonthegenius.com\/mssql\/?p=365"},"modified":"2020-10-07T11:39:54","modified_gmt":"2020-10-07T11:39:54","slug":"sql-server-2019-analytics-services-ssas-tutorial-for-beginners-part-1","status":"publish","type":"post","link":"https:\/\/www.kindsonthegenius.com\/mssql\/sql-server-2019-analytics-services-ssas-tutorial-for-beginners-part-1\/","title":{"rendered":"SQL Server 2019 Analytics Services (SSAS) Tutorial for Beginners – Part 1"},"content":{"rendered":"

In this tutorial, you will learn the basics of SQL Server 2019 Analytics Services. We would cover setting up SSAS on our local computer and create a Tabular Model.<\/p>\n

The step by step video for this tutorial will be updated in The Tech Pro Channel.<\/a><\/p>\n

Video Link here<\/a><\/p>\n

In this tutorial we’ll cover the following;<\/p>\n

    \n
  1. What is SSAS?<\/a><\/li>\n
  2. Some Prerequisites<\/a><\/li>\n
  3. SSAS Setup<\/a><\/li>\n
  4. Install SQL Server Data Tools (VS)<\/a><\/li>\n
  5. Setup Analysis Services Tabular Project<\/a><\/li>\n
  6. Create a New Tabular Project<\/a><\/li>\n<\/ol>\n

     <\/p>\n

    1. What is SSAS?<\/strong><\/h4>\n

    SSAS stands for SQL Server Analytics Services and is simply a data analysis tool by Microsoft. Using SSAS, you can analyze data coming from various sources and produce some summaries of useful information.<\/p>\n

    Using SSAS you can create two types of models;<\/p>\n

    Tabular Model<\/strong> – this is just a kind of database. Or say a database that is a bit more advanced that normal relational database. A tabular model are in-memory databases that uses table and other relational components such as relationships, joins, rows and column etc<\/p>\n

    Multidimensional Model<\/strong> – this is a data model that support very large amount of data. Similar to but not exactly big data. Multimensional data model in addition to tabular data supports other things like dimensions, measures perspectives, data sources and perspectives. We’ll cover these in subsequent tutorials.<\/p>\n

    Now let’s get into the practical!<\/p>\n

     <\/p>\n

    2. Some Prerequisites<\/strong><\/h4>\n

    SQL Server installed as well as SQL Server Management Studio.<\/p>\n

    Add the AdventureWorks2019 database to the server. You can get it from here.<\/a><\/p>\n

    We’ll do further setups as we go. So simply follow the procedure below.<\/p>\n

     <\/p>\n

    3. Setup SSAS<\/strong><\/h4>\n

    We would follow the steps below to setup SSAS<\/p>\n

    Step 1<\/strong> – Run the SQL Server setup. You will come to the screen below:<\/p>\n

    \"\"<\/a>
    Installing SSAS<\/figcaption><\/figure>\n

    Step 2<\/strong> – Click on the first link ‘New SQL Server stand-alone installation or add features to an existing installation’.<\/p>\n

    Step 3<\/strong> – Follow the Wizard steps. And when it comes to the Feature Selection page, select Analysis Services as shown below:<\/p>\n

    \"\"<\/a>
    Choose Analysis services<\/figcaption><\/figure>\n

    Step 4<\/strong> – When you get to the Analysis Services Configuration, choose Tabular Mode as shown below<\/p>\n

    \"\"<\/a>
    Choose Tabular Mode<\/figcaption><\/figure>\n

    Step 5<\/strong> – Follow the steps and complete the installation.<\/p>\n

     <\/p>\n

    4. Install SQL Server Data Tools<\/strong><\/h4>\n

    You need to install SQL Server Data Tools (SSDT). According to Microsoft, this tool has been integrated into Visual Studio. So following the steps below, you’ll be taken to where you’ll download and install Visual Studio 2019.<\/p>\n

    Step 1<\/strong> – Follow the same process but select SQL Server Data Tools. See figure below:<\/p>\n

    \"Installing<\/a>
    Installing SQL Server Data Tools<\/figcaption><\/figure>\n

    Step 2<\/strong> – Click on Install SQL Server Data Tools. You’ll be taken to the download page for Visual Studio. Install it.<\/p>\n

     <\/p>\n

    5. Setup Analysis Services Tabular Project<\/strong><\/h4>\n

    To be able to complete the project we, would need some data. And this data would come from the AdventureWorks Data Warehouse file<\/a>. So follow the steps below:<\/p>\n

    Step 1<\/strong> – Download the AdventureWorksDW file from the above link<\/p>\n

    Step 2<\/strong> – Open Management Studio and restore the Adventureworks database.<\/p>\n

    Step 3<\/strong> – Open Visual Studio. For the first time, you will choose Continue Without Code as shown below<\/p>\n

    \"\"<\/a>
    Starting Visual Studio without code<\/figcaption><\/figure>\n

    Step 4<\/strong> – Click on Extensions on the menu on the Extensions Manager. Enter Tabular in the search box and find Microsoft Analysis Services Projects as shown below. Click on Download to download it<\/p>\n

    \"\"<\/a>
    Adding Microsoft Analysis Services Projects<\/figcaption><\/figure>\n

     <\/p>\n

    6. Create a Tabular Model Project in Visual Studio<\/strong><\/h4>\n

    Now we would would create an SSAS project in Visual Studio.<\/p>\n

    Step 1<\/strong> – Start a new Project in Visual Studio. In the list of Project Types, select Analysis Services Tabular Projects as shown below<\/p>\n

    \"\"<\/a>
    Select Analysis Services Tabular Project<\/figcaption><\/figure>\n

    Step 2<\/strong> – In the next window as shown below, give the project a name and click Create<\/p>\n

    \"New<\/a>
    New Tabular Project configuration<\/figcaption><\/figure>\n

    Step 3<\/strong> – In the tabular model designer, select Integrated Workspace as shown below:<\/p>\n

    \"\"<\/a>
    Choose Integrated Workspace<\/figcaption><\/figure>\n

    At this point, we have successfully completed the setup. The final window for the new project is as shown below:<\/p>\n

    \"\"<\/a>
    SSAS Tabular Model Project<\/figcaption><\/figure>\n

     <\/p>\n

    In the next part, we would try to understand the various types of models available in SSAS.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this tutorial, you will learn the basics of SQL Server 2019 Analytics Services. We would cover setting up SSAS on our local computer and … <\/p>\n","protected":false},"author":1,"featured_media":381,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[23,29],"tags":[30,31,32],"class_list":["post-365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ms-sql-server","category-sql-server-analysis-services","tag-analysis-services","tag-ssas","tag-tabular-model"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.kindsonthegenius.com\/mssql\/wp-content\/uploads\/sites\/11\/2020\/10\/SQL-Server-Analysis-Services-Tabular-Model-1.jpg?fit=1518%2C577&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":6,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":383,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/365\/revisions\/383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/media\/381"}],"wp:attachment":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}