Keep It Simple? Don’t be Daft!

Keep It Simple? Don’t Be Daft! I was recently working on a project where we were using SSRS to create XML reports which are then imported into Excel to facilitate further analysis. Unfortunately, I could not see any option in PowerPivot to connect to an XML source. There is the option for text and RSS, but no XML that I can see. I know I could create an RDL and connect to that, but XML is far more than just SSRS. I raised this with some colleagues, and one of them pointed me to this Microsoft article, Data Feed XML … Continue reading Keep It Simple? Don’t be Daft!

Pride Dispensed, Pride Promised, And Pride To Go

Normal 0 false false false MicrosoftInternetExplorer4 Just got back from London yesterday after the UK Excel Conference. A successful couple of days I think, we had a large audience, few no-shows, and a general good time. As this was organised mainly to avoid disappointing the many wait-listed people from the previous, April, conference, the agenda was largely the same as before. We had one new session on ‘Excel as a BI Tool’, which I think that many delegates found enlightening; to see Excel being used as an Enterprise reporting tool, querying huge amounts of data very quickly was an eye-opener. … Continue reading Pride Dispensed, Pride Promised, And Pride To Go