Excel - An Excellent Data Mining Tool

Microsoft have an add-in to Excel 2007 that allows you to interrogate mining models in both SQL Server 2008 and SQL Server 2005.  They have also included some very powerful visualisations that make it very easy for you to go from zero to hero when looking at mining models.  In this fun session I will show you some of those features and show you just how funky it can be.
Presented by Allan Mitchell at SQLBits V
  • Downloads
    Slide deck available Slide Deck 238 KB
    Video available WMV Video 136 MB
  • SpeakerBIO
    allan_mitchell.jpg
    elastIO focusses on search and data integration. Text data is increasing at an incredible rate.  Being able to derive meaning and intelligence from free text is hard but necessary if businesses are to get any ROI from things such as weblogs.  Search can offer your users a much better experience over your websites enabling them to find the things they need quicker. We have extensive experience in elasticSearch, SolR and Azure Search. Data will always need to flow from one place to another.  This could be the overnight batch job which takes data from an OLTP system and puts it into a Data Warehouse having first done some cleansing and conforming or it could be the sensors on your machinery in the warehouse which are constantly emitting data and you need to reason over those events and perhaps take action. We are experts in SSIS, Azure Streaming Analytics, Storm, Azure Machine Learning and Azure Data Factory   
  • Video