Webcast Update - Data Mining Add-Ins for the 2007 Office System

  • Article

MICROSOFT ON-DEMAND WEBCAST:

Technet Webcast: Data Mining Add-Ins for the 2007 Office System (Level 200)

 

Recorded: November 27, 2006

Jamie MacLennan, Development Manager, Microsoft

 

Length: 59 minutes

 

Agenda:

Overview: Data Mining for the masses

Product Demo: SQL Server 2005 Data Mining

- Table Analysis tools for Excel 2007

- Data Mining Client for Excel 2007

- Data Mining templates for Visio 2007

 

Content:

00:00 - 04:12 Opening Slides

Make Data Mining accessible to all business professionals

What is Data Mining?

- "Machine learning algorithms which look for patterns inside your data"

 

04:13 - 21:40 Table Analysis Tools for Excel 2007

- Analyze Key Influences (6:35)

- Detect Categories: target to find common groupings (08:25)

- Highlight Exceptions: which rows stand out? (12:00)

- Fill from Example: detect implied patterns and extend to data (17:35)

- Forecast: build model, perform forecast, show results in Excel chart (20:15)

- Scenario Analysis: Goal Seek, What-If (21:00)

- Table Analysis Tools Architecture slide (21:40)

23:31 - 53:14 Data Mining Client for Excel 2007

- Trace: show all commands sent from Excel to Analysis Services (25:00)

- Explore Data: view counts of discrete values in data (25:55)

- Clean Data: look for outliers, specify thresholds, re-label (26:45)

- Partition Data: select sampling type: split data into training & testing set (29:30)

- Classify: classification wizard for creating model (30:40)

- Advanced Editor: Create Mining Model, select algortihm (34:15)

- Accuracy Chart (35:00)

- Profit Chart (36:20)

- Query (37:50)

- Manage Models: rename, delete, process, export models (40:00)

- Data Mining Client Architecture slide (40:50)

 

43:10 - 53:14 Data Mining Templates for Office Visio 2007

Format in Visio, Publish to Web, Annote, Import Custom Shapes

- Decision Trees (44:30)

- Dependency Networks (50:15)

 

53:15 - 58:45 Concluding Slides

- Requirements

- Additional Resources

 

 

My esteemed colleague, Eugene Asahara, recently posted a blog titled Data Mining in the PerformancePoint "MAP" Framework . It was not too long after discussing this post with Eugene that I was compelled to learn more about SQL Server Data Mining in preparation for an upcoming Microsoft BI engagement.

 

Please share your comments re: ways PerformancePoint and Data Mining can and should be integrated.

If you have specific examples or case studies, I'd love to showcase them here.