SSAS - Tabular Model (online)
Course
Online
Description
-
Type
Workshop
-
Level
Beginner
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
-
Virtual classes
Yes
As of SQL Server 2012, you can now create tabular models in Analysis Services, rather than building cubes in legacy multidimensional models. For anyone who is familiar with relational databases, tabular models are easier to create and use than cube models; plus they use DAX as a language, rather than the harder-to-understand MDX. Tabular models are a natural extension of PowerPivot within Excel.
This course will show you how to create tabular models by combining tables from SQL Server, Access, Excel and other data sources, and how to extract data from these models using Excel pivot tables, PowerView, Reporting Services reports and above all the DAX query language.
Important information
Documents
- SSAS (Tabular Model).pdf
Facilities
Location
Start date
Start date
Reviews
Subjects
- Visual Studio basics
- Connecting to SQL Server
- Creating a data model
- Relationships
- Excel pivot tables
- Other data sources
- Calculated columns
- Measures
- Changing query context
- Prototyping using PowerPivot
- Accessing DAX queries
- Calendars
- Date calculations
- Hierarchies
- KPIs
- Perspectives
Teachers and trainers (1)
David Wakefield
Director / Programmer / Trainer
Course programme
- Multidimensional vs tabular
- Separate named instances
- Visual Studio windows
- Setting startup options
- Creating a project
- Creating and using connections
- Filtering rows and columns
- Hiding from client tools
- Renaming tables/columns
- How column storage works
- How processing works
- Diagram view
- Creating relationships
- Analysing data in Excel
- Connecting from Excel
- Using Excel pivot tables
If time
Power BI Desktop overview- Importing from SSAS
- Basic visualisations
- How publishing works
- Linking to Excel
- Pasting in data
- Using IF and SWITCH
- BLANK arithmetic
- Linking tables using RELATED
- Creating measures
- SUMX, AVERAGEX, etc.
- The CALCULATE function
- Using FILTER
- Using PowerPivot
- Importing PowerPivot models into SSAS
- Constraints
- From within Excel
- From Reporting Services
- Creating a calendar table
- Using multiple calendars
- Working days
- Period to date
- Prior and parallel periods
- Semi-additive measures
- Creating a hierarchy
- Viewing hierarchies
- The parts of a KPI
- Absolute and relative measures
- Creating and viewing KPIs
- Creating perspectives
- Using in Excel
If time
Security- How security works
- Creating roles
- Filtering rows by role
Additional information
SSAS - Tabular Model (online)