SQL Server Tabular Model

Recently we worked on a project which uses most of the features of Tabular Model.  While implementing there were lot of online link which helped to solve the problems.  This blog post is to consolidate all of them.  Tabular Model, DAX keyword were not Search Engine friendly, getting these out was not that easy, if you are just starting Tabular this post sure will help.

• TechEd Demo: Provides high level overview
• Very very basic demo using PowerPivot which is client version of Tabular Model.
• Getting Started with PowerPivot and DAX
• DAX Functions
• DAX Resource Center
• Understanding Relations
• Dynamic Relations
• Currency Conversion: Supporting the Currency conversion is challenging in Tabular Model. There are few blog highlighting different options, but none works for large scale tabular model!!  If you are data is limited you try this Considering Target Currency as Filter
• Security and Permission
• Basic Sample
• Dynamic Security
• Table based security
• Effective User Name Setting issue
• · Time Intelligent
• Concept and Best Practice
• Time DAX Functions
• Partition Processing Automation:SSAS Command
• Role Playing Dimension are not supported in Tabular Model, there is a connect ticket for the same also on name

DAX Query

• Basics Part 1, Part 2
• Channel 9
• Dynamic Filters

Update 7/15

• DAX Basics for Power BI
• PluralSight Training, They have lot of training sessions for DAX.
• Recommendation from SQL BI 
• Power BI Recommendation 
• Best practice from field
• Stairway to DAX and PowerBI

Data Tools, DACPAC & BACPAC

Database development is no more just scripts, there are lot of improvement in Database Project development, maintenance and deployment.  in this blog post let me summarize the recent developments.

• Database Project (Install DataTools from here)
• Database Project creation
• Database Reference
• Compilation and integration errors
• Warnings and Errors
• Database Deployment (Part of SQL 2012)
• DACPAC – Only Schema
• BACPAC – Schema and Data (JSON format)

• Export Import (Available from SQL Server 2005)
  • Script Generation (from SQL 2008 R2, include data in script), Even you can target to SQL Azure.

  

Visual Studio 2012 Update

Make sure you are updated with latest update of Visual Studio 2012, the UI navigation for VS 2012 is diff from the traditional update!!

Open Visual Studio 2012 click on Tools Menu and select Extension and Updates..

 

Get the latest updates… Enjoy!!

Click here to see the list of updates covered in Visual Studio 2012 Update 2

Wireframe

Prototyping is important to visualize the product ahead in SDLC, this helps to validate scenarios and receive early user feedbacks.  There are whole lot of tools to do the same.  Try

• Microsoft Sketchflow
• Balsamiq Mockups
• Pencil Project
• Windows 8 Metro Apps - http://www.telerik.com/products/windows-8/appmock.aspx (download)
• Consolidation of all tools