I had hard time in performing these steps in the absence of Screen Shots, so thought of adding this post with Screen Shots. A BI semantic model connection is created in SharePoint and provides redirection to business intelligence semantic model...

Can get great performance during Excel Operations by enabling Multi Thread in Excel. How to Set Number of Threads - Office Button=> Excel Options=>Advanced=>Formulas ' Enable multi = threaded

  The following example adds roll-up rows to the Group-By columns of the SUMMARIZE function call. EVALUATE SUMMARIZE( 'Internet Sales', ROLLUP ('Date'[Calendar Year],Product[Product Category Name]), "Sales", ([Internet Total Sales]), "Tax"...

SUMMARIZE function returns a summary table for the requested totals over a set of groups. Readers familiar with T-SQL SELECT statement, this is the equivalent of writing a query using the GROUP BY clause. Syntax - SUMMARIZE(<table>, <groupBy_columnName>...

Windows Azure Boot Camp is a two day deep dive class to get you up to speed on developing for Windows Azure. The class includes a trainer with deep real world experience with Azure, as well as a series of labs so you can practice what you just learned...

One place where you can learn all new features of SQL 12 without even installing single component on your machine. Virtual Labs enable you to quickly evaluate and test Microsoft's newest products and technologies through a series of guided, hands-on labs...

Few of my friends have been blogging on WordPress and I heard good feedback about it. So, here I am… starting my new blog on http://karanspeaks.com My this blog http://blogs.msdn.com/karang   is still alive and will do cross posting there.