Presented by John E. Dorman, CPA, COO, Texas Medical Association and Grant McInnes, Director, Business Intelligence & Software Development, Texas Medical Association

DigitalNow 2009 Powerpoint Download

Overview

Are you aware of the powerful predictive marketing tools that are free add-in options for Excel? Coupled with SQL server, these tools can provide an analysis of those attributes which are the best predictors of joining, purchasing or attending.

Learning Outcomes:

• Gain an understanding of basic predictive modeling concepts.
• See new Excel data mining tool add-in options demonstrated.
• Identify key attributes contributing toward joining, purchasing or attending decisions by your members.
• Apply those key attributes to your target markets.

History of Business Intelligence at TMA

• Initial engagement with Consulting Company, built a snapshot cube for Analysis
• Used Proclarity to drilldown and drillthrough to detail in the snapshot cube
• Discovered Excel Pivot Charts that can connect to a cube
• Last year, learnt about Excel Data Mining Add-In
• Beginning implementation of OBIEE platform for Analysis and Reporting

Resources

Tutorial/Walkthrough from Hands On Lab