PowerPivot BlogRoll – 6th January 2013

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 6th January 2013.   Time To Name This Year’s Book! – bit.ly/TyZ5nX Database Pros in Demand – bit.ly/UXN78m [Commercial Webinar] Deep Dive into Business Intelligence in Excel 2013’s PowerPivot and Power View – bit.ly/115ls8J Creating Linked Tables in PowerPivot for Excel – bit.ly/TyZ5nX Excel 2013, Power View, Top 10 “long tail” and how DAX helpsbit.ly/YJTMkd

PowerPivot BlogRoll – 30th December 2012

Microsoft sneaked a couple of ne PowerPivot activity announced on Twitter for the week ending 30th December 2012.   Templated Excel workbooks with PowerPivot and Macro’s – bit.ly/12VdWwP Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel – bit.ly/UAX22u PowerPivot – Importing Data from Different Data Sources into PowerPivot for Excel – bit.ly/131Qi0v End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI – bit.ly/VpwWxI Refreshing PowerPivot Data in SharePoint 2013 – bit.ly/131Q3Ti [Video] Using PowerPivot with DataMarket Section of Windows Azure Marketplace – bit.ly/12Vd23e

PowerPivot BlogRoll – 23rd December 2012

PowerPivot activity announced on Twitter for the week ending 23rd December 2012.   Using HASONEVALUE in a DAX IF statement – bit.ly/TVMwA7 Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in – bit.ly/ZfaRsf Introduction to MDX for PowerPivot Users, Part 5: MDX Queries – bit.ly/12wLGQI [Update] What is using all that memory on my Analysis server instance? – bit.ly/T51Hsc Running Product in DAX: Calculating Portfolio Returns – bit.ly/XOobxz The CALCULATE Function—New DAX Video Tutoria – bit.ly/XTTirq. Note that this is a subscription site. Dynamic CUBE Formulae In Excel – bit.ly/R6Fnjs The Ballad of Ken Puls, DAX Convert … Continue reading PowerPivot BlogRoll – 23rd December 2012

Cooking With CUBEs

Microsoft sneaked a couple of ne As we should all know by now, PowerPivot provides Excel with a powerful way to harness data from one or more sources, and to do further analysis on that data within familiar pivot tables. Furthermore, because PowerPivot is creating an in-memory cube of the data, it is possible to build an analysis using CUBE formulae. I have blogged a couple of times about CUBE formulae, in Cycling Through The Fog and in Cracking The Code. In Excel, as with any development, you want your solution to be as flexible and dynamic as possible. This … Continue reading Cooking With CUBEs

PowerPivot BlogRoll – 16th December 2012

PowerPivot in Excel 2013 – bit.ly/V1jN01 How PowerPivot can help financial reporting –bit.ly/T0o1Dj Importing your SalesForce data directly into PowerPivot – bit.ly/T0nRMi Set Up a VM Test Server for PowerView and PowerPivot – bit.ly/R0QY3s Hide Calculated Items With Zero Totals In PowerPivot PivotTables – bit.ly/12tBW8W Book Review: DAX Formulas For PowerPivot – bit.ly/12hDDXR Creating a Spacer Column in a PowerPivot PivotTable – bit.ly/T2bMHu

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!

Power To The Ashes

Power To The Ashes   So the excitement is all over, and England have deservedly beaten the Australians at the latest Ashes series. Many late evenings have been spent listening to the coverage on Radio 5, catching the usual humour and generally irrelevant things that get covered in a cricket test match, things that help to make cricket the wonderful event that it is, more than just a game, a life affirming experience. Even David Cameron trying to climb aboard the ‘feel-good’ bandwagon can detract from the fun. @theashes This series we have seen the phenomenon of Ashley Kerekes, the … Continue reading Power To The Ashes

Self Service Is Cheap?

As I am sure that you are all aware, PowerPivot is the best thing to hit Excel since PED. Although I am not a big data cruncher, I have been playing with PowerPivot; to keep abreast of an important technology; it plays into one of my primary interests of Business Intelligence; and partly to seek out further opportunities. Although I have been scouring the blogs and dedicated websites, I do like to have a book as a reference point, and so I was very pleased to get a review copy of PowerPivot for the Data Analyst: Microsoft Excel 2010, by … Continue reading Self Service Is Cheap?