This is my personal site where I give my opinions, advice & code for free. For paid assignments contact me here.
- Testing a DAX measure using Excel functionality – XIRR example
- DISCOVER_COMMANDS DMV – Improve Drillthrough & Learn DAX Query
- A frown, or two – Data Explorer to PowerPivot gotchas.
- M’s back – Create a PowerPivot Time Dimension using Excel’s PowerQuery
- The Model of a very modern PowerPivot – without the add-in
- DAX’s back – Create DAX Measures in Excel 2013 without PowerPivot Add-in
- Look’s like Star Schema is back on the menu!
- Níl aon Analytics mar d’Analytics féin.
- Building an Excel 2013 Percentile dashboard without PowerPivot or a PivotTable
- Playing DAX Percentiles on the mean (or is that median) Streets of Ireland
- There are Klingons off the Star-Schema bow, Jim.
- Why use a dimensional data model for PowerPivot?
- Cross Join Three Tables via DAX Query to seed a Date Dimension.
- PowerPivot for Excel as an XML/A Server
- Excel as a Google Visualization API Data Source
- MapReduce Redux or MapReduce and Flow-based Programming (reprised)
- R in two miniute video lessons - twotorials by anthony damico
- 10 R packages I wish I knew about earlier
- Microsoft and Nokia: Who’s buying whom? – Quartz
- cdecl: C gibberish ↔ English
- Power BI Learning Resources - TechNet Articles - United States (English) - TechNet Wiki
- 6 Ways to Get Me to Email You Back | LinkedIn
- Enhancing Dashboard Interfaces with Shape Layering Tricks » Bacon Bits
- Top 10 Excel Sins
- History of Excel - YouTube