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   (RSS)
Showing page 2 of 3 (25 total posts)
  • Running Excel 2013 in a separate instance #excel #powerpivot

    The new Excel 2013 preview is publicly available and it introduces many new features, like an integrated version of PowerPivot and Power View. These two add-ins are automatically installed but not enabled by default. You just have to go in Excel Options / Add-Ins and choose COM Add-ins from the Manage combo box, then press the Go… button; at this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 24, 2012
  • Workaround for lack of PowerPivot API in Excel

    A few days ago a post about VSTO-based PowerPivot Workbook in the PowerPivot Team Blog shown a workaround for the lack of PowerPivot API in Excel. In reality, I don’t like this workaround at all, because it relies on displaying message boxes to the end user in order to click “Update” button in the PowerPivot Ribbon. I understand the reasons why ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 8, 2011
  • Parameterize Charts using Excel Slicers in PowerPivot

    One new nice feature of Excel 2010 is the Slicer. Usually, slicers are used to filter data in a PivotTable. But they might be also useful to parameterize an algorithm or a chart! We discussed this technique in our book, but Alberto Ferrari wrote a post that shows how to use this technique to allow the user to select two stocks that should be ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 2, 2011
  • Stock Analysis and Moving Average with PowerPivot

    One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot. You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement calculations that might be useful when you want to implement some stock analysis using ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 27, 2011
  • The Microsoft BI Roadmap: BISM, UDM and Beyond

    Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 15, 2010
  • PowerPivot book sample chapters available in PDF

    You can download these two sample chapters of the PowerPivot for Excel 2010: Give Your Data Meaning book: Chapter 2 - PowerPivot at Work This is introductive and suggested to read to anyone who is new to PowerPivot Chapter 7 – Date Calculations in DAX Do you want to make date calculation in DAX? This is the chapter for ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 19, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Dimensionality Lost

    This topic is general and not related to a specific feature of PowerPivot. In the way it is designed today, when data are imported from a SSAS cube into PowerPivot, the dimensionality of the original cube is lost and a flat table is imported as the result of a single MDX query. This approach should work in PowerPivot considering the way data are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Measures Are Imported as Text Columns

    Every measure imported from a SSAS cube is imported as a Text column instead of as a Numeric column. This is very annoying because users are used to use SSAS data with rich metadata, and a measure is usually numeric. Moreover, the standard aggregation used by PowerPivot for a Text column is Count - whenever the measure is a real count (thus, an ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 30, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX

    If you write direct MDX queries using SSAS 2005/2008 as a PowerPivot data source, it is better if you prepare your MDX query by using another editor. For example, write and test your MDX query by using SQL Server Management Studio and then copy & paste your query into the user interface provided by the Table Import Wizard. The remaining part ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 26, 2010
  • Using SSAS 2005/2008 as PowerPivot Data Source: Query Designer

    The query designer in PowerPivot has a few limitations that require the manual modification of the MDX query to get data that are often needed to create a PowerPivot model that compares data from cube with data from other sources (like Excel workbooks or external databases). For example, it is not possible to import the attribute key (the MDX ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement