The 20 minute tabular model
Download
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


Tabular vs multidimensional
Tabular vs. Multidimensional


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


What’s the take away?

Use the right tool for the job!


DEMO

Requirements:

SQL Server Data Tools (SSDT)

SQL Server Analysis Services - Tabular Instance


Dax vs mdx
DAX vs MDX



References
References

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

  • Twitter: @SQLbyoBI

  • Blog: http://byobi.com

  • Email: [email protected]


ad