Home » Databases » Analysis Services Tabular Model tutorial video

 
 

Analysis Services Tabular Model tutorial video

 

SQL Server Analysis Services (SSAS) today is a mature and extremely successful product that is used and trusted in thousands of enterprise-level deployments. From Analysis Services 2012 the most important point is that it is really two products in one:

  • known version of Analysis Servces – now called Multidimensional Model
  • new version of Analysis Services that closely resembles PowerPivot – is called the Tabular Model.

The Analysis Services Tabular Model is the subject of this video tutorials.
Watch this video tutorial and find out how to use a Data Analysis Expressions (DAX) language and how to build, deploy, and query a BISM (BI Semantic Model) tabular model with step-by-step guides, examples, and best practices. Learn how to analyze tabular data using the BISM in SQL Server.
9 lessons, total length 122 minutes.

  1. Getting started with the Analysis Services Tabular Model (06:31)
    Introduction the Tabular Model, Installation Process
    buy single lesson
  2. Analysis Services - The BISM Tabular Model - Introduction (25:43)
    Creating a database, Insert a data, Creating an Analysis Services Project, Building a Simple Tabular Model, Working in the Diagram View, Creating Hierarchies and Creating Measures, Browsing a Workspace Database, Querying a Tabular Model in Excel - Connecting to a Deployed Database
    buy single lesson
  3. DAX Basisc (21:17)
    Calculated Columns and Measures, Downloading DAX Editor, Installing DAX Editor, Using the DAX Editor, Empty Values, IF and IFERROR, Aggregate Functions, Logical Functions, Information Functions, Mathematical Functions, Text Functions, Conversion Functions, Date and Time Functions
    buy single lesson
  4. DAX (Data Analysis Expressions) - Querying Tabular (15:00)
    DAX Data Types and DAX Operators, DAX Query Syntax, EVALUATE and ORDER BY clause, Using CALCULATETABLE and FILTER, Using ADDCOLUMNS and SUMMARIZE, Using CROSSJOIN, GENERATE, and GENERATEALL, Using ROW, Using CONTAINS, Using LOOKUPVALUE
    buy single lesson
  5. Defining Measures and Understanding CALCULATE and CALCULATETABLE Functions (05:50)
    Defining Measures in DAX, CALCULATE and CALCULATETABLE Functions
    buy single lesson
  6. Building Hierarchies (16:05)
    Building Hierarchies, Hierarchies Spanning Multiple Tables, Parent/Child Hierarchies, Handling Empty Items
    buy single lesson
  7. The Tabular Presetation Layer (11:13)
    Naming Objects, Hiding Columns, Sorting Column Data, Formatting
    buy single lesson
  8. KPIs (02:31)
    Creating KPIs
    buy single lesson
  9. Security (17:40)
    Creating Database Roles in SSDT, Creating Database Roles in SSMS, Advanced Row Filter Expressions, Filtering on Multiple Columns, Using a Permissions Table, Dynamic Security,
    buy single lesson

Price 39.00 USD


Frequently Asked Questions

Watch sample lesson and see how fast and easy discovering new knowledge can be:

Tags: , , , ,