New videos available #dax #ssas #powerpivot

Posted by Marco Russo (SQLBI) on SQL Blog See other posts from SQL Blog or by Marco Russo (SQLBI)
Published on Fri, 24 Aug 2012 13:21:47 GMT Indexed on 2012/08/27 21:50 UTC
Read the original article Hit count: 278

Filed under:

Analysis Services

|

DAX

|

PowePivot

The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available:

DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other languages
DAX: Calculated Columns vs. Measures shows the difference between calculated columns and measures in DAX
Introduction to DAX has a content corresponding to the title!

The first two videos are freely available, the third one is longer and visible only to subscribers. The goal for this series of video is to reach advanced Excel users and BI developers that are new to DAX. If we should categorize this content, it’s a sort of level 200 session in a conference. I don’t expect readers of this blog to watch this video (if not for the sake of curiosity!) but if you have to explain this subject to anyone else and you have other priorities… well, you can add this post to the list of resources you provide for studying the subject!

© SQL Blog or respective owner

Related posts about Analysis Services

Azure Mobile Services: what files does it consist of?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Azure Mobile Services is a platform that provides a small set of functionality consisting of authentication, custom data tables, custom API’s, scheduling scripts and push notifications to be used as the back-end of a mobile application or if you want, any application or web site. As described in my… >>> More
Visual Studio 2013 Static Code Analysis in depth: What? When and How?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I'll illustrate in details the following points What is static code analysis? When to use? Supported platforms Supported Visual Studio versions How to use Run Code Analysis Manually Run Code Analysis Automatically Run Code Analysis while check-in source… >>> More
Using Analysis Services Processing Task & Analysis Services Execute DDL Task in SSIS

as seen on SQL Server Performance - Search for 'SQL Server Performance'
SQL Server Integration Services (SSIS) is a Business Intelligence tool which can be used by database developers or administrators to perform Extract, Transform & Load (ETL) operations. In my previous article Using WMI Data Reader and WMI Event Watcher ... [Read Full Article] >>> More
Testing your Web services using the Data Web Services Test Client

as seen on Internet.com - Search for 'Internet.com'
Paul Zikopoulos introduces you to the Data Web Services Test Client that's available in IBM Data Studio Version 1.2 or later >>> More
Silverlight 4 + RIA Services - Ready for Business: Exposing OData Services

as seen on Dot net Slackers - Search for 'Dot net Slackers'
OData is an emerging set of extensions for the ATOM protocol that makes it easier to share data over the web. To show off OData in RIA Services, lets continue our series. We think it is very interesting to expose OData from a DomainService to facilitate data sharing… >>> More

Related posts about DAX

Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

as seen on SQL Blog - Search for 'SQL Blog'
If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows… >>> More
DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

as seen on SQL Blog - Search for 'SQL Blog'
The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that… >>> More
Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions

as seen on SQL Server Central - Search for 'SQL Server Central'
Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series… >>> More
Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

as seen on SQL Server Central - Search for 'SQL Server Central'
Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot… >>> More
Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

as seen on SQL Server Central - Search for 'SQL Server Central'
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs. Save 45% on our top SQL Server database administration tools. Together… >>> More