November 16, 2013
Hi everybody! Microsoft is migrating our platform to Wordpress and so the blog will have a new address!
This means that you'll be visiting me and the blog at:
Ella Maschiach's BI Blog
Unfortunately enough, this also means that your feedburner account will no longer work.The new RSS account is:
Please stay in touch with us!
November 12, 2013
A colleague in the IT department wanted to send his clients a report in Excel which was actually a pivot table on data from their DWH. He created the file easily enough. He defined on the Data tab in Excel a connection from SQL Server. He chose to connect to a specific table in the relevant DB. He could then edit the connection he created through the Data tab > connections > choosing the relevant connection and then properties and then edit the query on the Definition tab, through the Command Text box. ...