THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Analysis Servic... » PowePivot   (RSS)
Showing page 1 of 2 (11 total posts)
  • Advanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot

    One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number of companies, with and without a previous experience on former versions of Analysis ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 22, 2013
  • Interviewed in SQL Down Under podcast #sqlserver #ssas #powerpivot

    I’ve been interviewed by Greg Low in SQL Down Under show 58, and this is *not* an April fool! We talked for one hour about Tabular, Multidimensional, Data Warehouse and just a little bit about music (you can discover which music genre I’m used to listen…). You can hear this interview from the SQL Down Under Show 58 page (it is an MP3 format) and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 1, 2013
  • End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

    This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early 2013 but many early adopters are already using it daily (myself included) PowerPivot and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 27, 2012
  • Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

    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 considered in the group that the SUMMARIZE uses ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 4, 2012
  • New videos available #dax #ssas #powerpivot

    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 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2012
  • DAX Studio 1.0 beta available #dax #tabular #powerpivot

    Are you waiting for a usable and interactive DAX editor? Are you tired of using the MDX editor provided by SSMS as a temporary solution to write and execute a DAX query? The wait is over! DAX Studio is a free Excel add-in that enables you to write a DAX query in a small dialog box that offer a productive environment, with a tabular object browser ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 30, 2012
  • Analysis Services Tabular books #ssas #tabular

    Many people are looking for books about Analysis Services Tabular. Today there are two books available and they complement each other: Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari and Chris Webb Applied Microsoft SQL Server 2012 Analysis Services: Tabular Modeling by Teo Lachev The ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 9, 2012
  • Optimize Many-to-Many with SUMMARIZE and Other Techniques

    We are still in the early days of DAX and even if I have been using it since 2 years ago, there is still a lot to learn on that. One of the topics that historically interests me (and many of the readers here, probably) is the many-to-many relationships between dimensions in a dimensional data model. When I and Alberto wrote the The Many to Many ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 1, 2012
  • Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

    If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, you cannot import the attribute key value. Only the attribute name is included in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2011
  • #BISM Introduction and #PowerPivot Advanced Data Modeling #sqlbits video available

    As Chris announced in his blog, some of the sessions from the SQLBits 8 in Brighton are already available (for free!). Yesterday I watched more than half of my BISM Introduction session just to check that no NDA was broken. And, believe it or not, the session had to be really “balanced” in order to not disclose anything of the news announced at ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 28, 2011
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement