THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

Watch #TechEd sessions online for free #powerpivot #dax

The sessions recorded at TechEd 2013 are online. I and Alberto Ferrari delivered the same sessions and the recording are available for both TechEd North America and TechEd Europe.

It’s nice for me being able to compare two deliveries of the same session. In theory, the second delivery (Europe) should have been improved based on feedback of previous conference. If anyone watched the two recordings, I will be very happy to get any further feedback!

Here is the two sessions available with the links to the recordings:

  • Microsoft PowerPivot Excel 2013 in Action by Alberto Ferrari
    Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions. In this session, see how to create a business solution from scratch, loading tables inside PowerPivot, enriching them with new data, building complex formulas using the DAX language, leveraging the materialization of DAX queries in Excel and finally building dashboards and reports using the new PivotTable features and Power View. The goal of the session is to provide a clear understanding of the power of BI in Excel 2013 and raise your curiosity about the DAX language and the Tabular architecture.
    Recording at TechEd North America
    Recording at TechEd Europe


  • Querying in DAX by Marco Russo
    DAX is not only an expression language but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. This session introduces DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations. Many practical examples based on common patterns and an analysis of the query plans show how to get the best out of DAX.
    Recording at TechEd North America
    Recording at TechEd Europe

And if someone is interested in attending the SSAS Tabular Workshop online on July 22-23, hurry up! Early bird is expiring soon!

Published Monday, July 8, 2013 3:53 PM by Marco Russo (SQLBI)


No Comments
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement