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 » PowerPivot » Excel 2013   (RSS)
Showing page 1 of 2 (11 total posts)
  • Connecting to #powerpivot from an external program (such as #Tableau)

    Many people requested me how to connect to Power Pivot from an external program, without publishing the workbook on SharePoint or on Analysis Services Tabular. I always said it is not possible (for both technical and licensing reasons), but someone observed that Tableau is able to extract data from a Power Pivot data model connecting directly to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 26, 2014
  • Using Added Columns in #DAX Queries

    I had an issue in a query that reminded me a few details naming columns created by ADDCOLUMNS. When you specify a simple name in ADDCOLUMNS, you can use it later, for example in a SUMMARIZE or in a FILTER expression, such as in the following example (see the Value column): EVALUATE CALCULATETABLE (     ADDCOLUMNS ( ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 21, 2014
  • Power Query now imports relationships #powerquery #powerpivot

    The December release of Power Query preview (version 2.9.3502.261) introduced an interesting feature: when you import multiple tables in the data model, relationships existing between tables in the data source are automatically detected and added to the data model as well. This is similar to the behavior you have in Power Pivot, but there is an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 17, 2013
  • Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular

    I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that in certain business is huge and expensive, especially if you have to load it in memory. I also ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 27, 2013
  • Excel 2013 stand-alone now includes #powerpivot

    This time Microsoft listened to the many complaints received since Excel 2013 release and the stand-alone version of Excel now includes Power Pivot and Power View! This is a very important news because there were customer who didn’t upgrade from Excel 2010 to Excel 2013 just because they would have lost the Power Pivot add-in! This news ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 19, 2013
  • DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

    I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog, this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this new release, but unfortunately it will require some weeks because I'm traveling a lot in these ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 4, 2013
  • PowerPivot Workbook Size Optimizer #powerpivot #tabular

    Microsoft released the Workbook Size Optimizer for Excel, the first version of an Excel add-in for Excel 2013 that inspects the data model and suggest possible optimizations. Fundamentally, it tries to apply the best practices descripted in a white paper I mentioned a few weeks ago, removing useless columns and changing granularity to those that ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 30, 2013
  • New PowerPivot 2013 book available! #excel #powerpivot

    Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010. In the previous book we had a target audience that included advanced Excel users and BI developers, because at ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 2, 2013
  • Update to the PowerPivot for Excel 2013 licensing #powerpivot #excel

    UPDATE Aug 16, 2013: Excel 2013 stand-alone now includes Power Pivot and Power View! Rob Collie Ken Puls (thanks Bob!) wrote a very interesting post about the PowerPivot for Excel 2013 licensing. Short recap: PowerPivot for Excel 2013 is only available in a few editions of Excel/Office (more details here) If you want to buy a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 27, 2013
  • The Right Version of Excel 2013 for using PowerPivot #powerpivot #excel

    UPDATE Aug 16, 2013: Excel 2013 stand-alone now includes Power Pivot (now the name has a space and it is no longer a single word!). This post was originally published on Feb 18, 2013 and is now outdated. If you already have Excel 2013 stand-alone, you should see PowerPivot enabled in an upcoming update. Many people started using PowerPivot with ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 18, 2013
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement