1 / 13

SQL 2012 & The Ultimate BI Suite

SQL 2012 & The Ultimate BI Suite. Efi Goldman Solution Expert at Panorama Software. Training Plan. Agenda. Business Logic Creating and Managing a Tabular Model – Demo How should I build my model? Advanced Analytics with Necto – Demo . Last Session Summery.

huy
Download Presentation

SQL 2012 & The Ultimate BI Suite

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL 2012 & The Ultimate BI Suite Efi Goldman Solution Expert at Panorama Software

  2. Training Plan

  3. Agenda • Business Logic • Creating and Managing a Tabular Model – Demo • How should I build my model? • Advanced Analytics with Necto – Demo

  4. Last Session Summery • Three Main licensing Programs: • Standard (without Tabular Model) • BI Server (With Tabular Model and wide sharepoint integration) • Enterprise – Mission critical high performance • Two Visual Studio (BIDS) project types in Denali • Multidimensional project – with MDX and MOLAP/ROLAP • Tabular project – with DAX and VertiPaq/ DirectQuery • Two different Instances

  5. VertiPaq for high performance, MOLAP for mission critical scale DirectQuery and ROLAP for real-time access to data sources State-of-the-art compression algorithms Scales to largest enterprise servers BI Semantic Model • Rich data modeling capabilities • Sophisticated business logic using MDX and DAX • Fine-grained security – row/cell level • Enterprise capabilities – multi-language and perspectives • Multi-dimensional and tabular modeling experiences • MDX and DAX for business logic and queries • Cached and passthrough storage modes • Choice of end-user BI tools Flexibility Richness Scalability

  6. How Should I Build my Model? • Depends on the application needs for each layer • Data model • Business logic • Data access & storage

  7. Data Model Tabular • Familiar model, easier to build, faster time to solution • Advanced concepts (parent-child, many-to-many) not available natively in the model… need calculations to simulate these • Easy to wrap a model over a raw database or warehouse for reporting & analytics Multidimensional • Sophisticated model, higher learning curve • Advanced concepts baked into the model and optimized (parent-child, many-to-many, attribute relationships, key vs. name, etc.) • Ideally suited for OLAP type apps (e.g. planning, budgeting, forecasting) that need the power of the multidimensional model

  8. Business Logic DAX • Based on Excel formulas and relational concepts – easy to get started • Complex solutions require steeper learning curve – row/filter context, Calculate, etc. • Calculated columns enable new scenarios, however no named sets or calc members MDX • Based on understanding of multidimensional concepts – higher initial learning curve • Complex solutions require steeper learning curve – CurrentMember, overwrite semantics, etc. • Ideally suited for apps that need the power of multidimensional calculations – scopes, assignments, calc members

  9. Data Access and Storage VertiPaq • In-memory column store… typical 10x compression • Brute force memory scans… high performance without tuning… • Basic paging … data volume mostly fits in physical memory MOLAP • Disk based store… typical 3x compression • Disk scans with in-memory subcube caching… aggregation, tuning required • Extensive I/O support… scales to multiple TBs DirectQuery • Passes through DAX queries & calculations… fully exploits backend database capabilities • No support for MDX queries… no support for data sources other than SQL Server (in Denali) ROLAP • Passes through fact table requests… not recommended for large dimension tables • Supports most relational data sources…

  10. Denali demo

  11. Tabular Model – How to’s

  12. Working with multiple relationships between two tables

  13. Live Q & A info@panorama.com PanoramaSW Name: Business Intelligence News Panorama Software www.panorama.com/industry-news

More Related