I just had a chance to view some very cool demos on the topic of using PowerPivot and data mining together to solve some interesting business problems.
Go see Mark Tabladillo’s YouTube home page: http://www.youtube.com/user/MarkTabNet# or his web site at: http://www.marktab.net/ (which also has a download of the workbooks he is using in his demo.
And the three demos are here:
- http://www.youtube.com/user/MarkTabNet#p/a/u/0/oy7RCLJRuGg (Categorization)
- http://www.youtube.com/user/MarkTabNet#p/a/u/1/7oNr71Qrox4 (Promotion analysis)
- http://www.youtube.com/user/MarkTabNet#p/a/u/2/MgXzU_WSVUo (Marriage scoring)
(Just one geek’ie comment – you will notice that he is using the 32-bit PowerPivot add-in and Excel 32-bit. This is because the data mining add-in is only available in 32-bit so you will hit various memory limits sooner than you would with 64-bit. Forewarned is forearmed.)
And while we are on the subject, here are two interesting blog postings from Kasper de Jonge:
http://www.powerpivotblog.nl/convert-a-excel-pivot-table-to-a-excel-table-use-ssas-data-to-do-data-mining-in-excel
http://www.powerpivotblog.nl/screencast-using-datamining-with-powerpivot-in-excel
Enjoy!
Unfortunatelly all YouTube videos where removed…
i can’t see the video on youtube, it says it is removed by the user !!
Thanks. I am going to contact the Marketing group and see if I can get a copy of them.
Hi Everyone — the videos are all there — the links here are not all correct, but the main video site is http://www.youtube.com/marktabnet
[...] This post was mentioned on Twitter by Jelle-Jeroen Lamkamp. Jelle-Jeroen Lamkamp said: Interested in PowerPivot and data mining? http://powerpivotgeek.com/2010/05/13/interested-in-powerpivot-and-data-mining/ [...]