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 » PowePivot   (RSS)
Showing page 2 of 3 (30 total posts)
  • 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
  • A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

    One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d like to provide a few link to sessions, documents, bits and courses that are available now or ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 14, 2012
  • String Comparison in #DAX

    In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending) match of a string. I just wrote an article about string comparison in DAX. During my exploration of LIKE replacement functions in DAX, I have ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 30, 2011
  • #PowerPivot Workshop Online for America’s Time Zones #ppws

    After so many request we have finally arranged a PowerPivot Workshop online edition dedicated to America’s time zones! It is scheduled for December 19-20, 2012, with this schedule: US Eastern Time (EST): 10:00am-1:00pm / 2:00pm-5:00pm US Central Time (CST): 9:00am-12:00pm / 1:00pm-4:00pm US Pacific Time (PST): 7:00am-10:00am / ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 29, 2011
  • Solving security issue in PowerPivot for SharePoint and Power View

    I just installed a brand new server (well, a virtual machine) with SharePoint 2010 SP1 and SQL Server 2012 RC0, including PowerPivot and Reporting Services / Power View. The server is joined to the domain I use in our development environment. I published a workbook in the PowerPivot Gallery and my user was immediately able to connect, browse and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 18, 2011
  • #BISM, Measures and a new blog from a #ssas development team member

    In the PowerPivot book and in the PowerPivot Workshop I mentioned the difference between implicit and explicit measures. The use of implicit measures might be confusing because at the end they are automatically created and maintained by the user interface of PowerPivot, but in reality the “real engine” doesn’t know the difference between ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 16, 2011
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement