THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » excel   (RSS)
Showing page 2 of 5 (50 total posts)
  • Exploring earnings data for the UK [Open Data]

    I have a burgeoning interest in the world of Open Data which wikipedia describes as: Open data is the idea that certain data should be freely available to everyone to use and republish as they wish, without restrictions from copyright, patents or other mechanisms of control. The goals of the open data movement are similar to those of other ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 11, 2013
  • New PowerPivot Workshop for Excel 2013 available! #powerpivot #excel2013 #excel

    The Microsoft has launched the new Office 2013, we are proud to announce the availability of the new PowerPivot Workshop for Excel 2013! We have a fresh new website that offers all the training options: online and classroom courses. The target of this training are Excel Advanced Users and there are two versions of the workshop: the BASIC version ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 4, 2013
  • Execute a #DAX Query on #SSAS #Tabular in #Excel

    Apparently Excel does not offer a way to import data in Excel by using a DAX query on Analysis Services. The Data Connection Wizard seems to offers only the ability to create a PivotTable when you connect to Tabular, but not a Table (see the Table option disabled in the next picture). However, the workaround is to create a connection file and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2013
  • Linked Table, Reverse Linked Table and Linkback Table in Excel 2013 #powerpivot

    Kasper de Jonge wrote a blog post last year introducing an interesting new feature in Excel 2013: you can write a DAX query that extracts data from the PowerPivot model and returns a table in Excel. Such a table can be used as a Linked table for the same PowerPivot model, creating an interesting opportunity to inject data in a data model mixing ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 21, 2013
  • PowerPivot Compatibility across versions

    There are several versions of PowerPivot available and starting with Excel 2013 there are also several versions of Excel. It is useful to look at the compatibility between the different versions of Excel and PowerPivot available now. As a general rule when you have a PowerPivot workbook saved with a specific version of PowerPivot: You can ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 14, 2013
  • Olympics data available for all on Windows Azure SQL Database and Power View

    Are you looking around for some decent test data for your BI demos? Well, if so, Microsoft have provided some data about all medals won at the Olympics Games (1900 to 2008) at OlympicsData workbook - Excel, SSIS, Azure sample; it provides analysis over athletes, countries, medal type, sport, discipline and various other dimensions. The data has ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 29, 2012
  • DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

    The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that can be represented in a Date data type in Data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 5, 2012
  • Conditional formatting of duplicate values in Excel

    One of the infrequent pleasures of being a data geek like me is that one does occasionally stumble across little-known yet incredibly useful features in a tool that you use day-in, day-out. Today this happened to me and the feature is Excel’s ability to highlight dupicate rows in a worksheet. Check this out: Notice that I have got some data ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 2, 2012
  • CUBEMEMBER and CUBEVALUE stop working after #PowerPivot upgrade to #Excel 2013

    I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no longer reference the PowerPivot Data name, replacing it with ThisWorkbookDataModel instead. I wrote an article describing ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 31, 2012
  • Community Events in Köln (October) and Copenhagen November #ssas #tabular #powerpivot

    Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln - all details in the PASS local chapter here: I will be speaking at a community event in Copenhagen on November 21, 2012. The session will be Excel 2013 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 12, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement