the 20 minute tabular model
Download
Skip this Video
Download Presentation
The 20-Minute Tabular Model

Loading in 2 Seconds...

play fullscreen
1 / 11

The 20-Minute Tabular Model - PowerPoint PPT Presentation


  • 146 Views
  • Uploaded on

The 20-Minute Tabular Model. Bill Anton Prime Data Intelligence. Agenda . What is Tabular (and why do I care) Tabular vs. Multidimensional DEMO - build a basic tabular model. What is Tabular. Reporting Layer (ex. SSRS, Power View, Excel). Reporting Layer. Tabular.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' The 20-Minute Tabular Model' - kineta


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the 20 minute tabular model

The 20-Minute Tabular Model

Bill Anton

Prime Data Intelligence

agenda
Agenda 
  • What is Tabular (and why do I care)
  • Tabular vs. Multidimensional
  • DEMO - build a basic tabular model
what is tabular
What is Tabular

Reporting Layer (ex. SSRS, Power View, Excel)

Reporting Layer

Tabular

Multidimensional

Model

Business

Intelligence

Semantic

Model

DAX

MDX

Business Logic

xVelocity

Direct Query

MOLAP

ROLAP

Data Access

DW*

Data Warehouse

Source Systems (ex. SAP, LOB Applications)

Source Systems

summary of tabular limitations
Summary of Tabular Limitations
  • Parent-Child Hierarchies
  • Complex Calculations
    • Named Sets
    • Scoped Assignments
    • Custom Rollups
    • Cell Calculations
  • Many 2 Many
  • Actions
  • Writeback
  • Translations
  • Data Mining
  • Aggregations (not necessary)
  • Cell Security
  • Linked Objects
tabular vs multidimensional1
Tabular vs. Multidimensional

Tabular

Either 

Multidimensional

slide7

What’s the take away?

Use the right tool for the job!

slide8
DEMO

Requirements:

SQL Server Data Tools (SSDT)

SQL Server Analysis Services - Tabular Instance

references
References

http://byobi.com/blog/20-minute-tabular-model/

ad