Abstract
With the release of Excel 2007 and SQL Server 2008, Microsoft has provided actuaries with a powerful and easy to use predictive modeling platform. This paper provides a brief overview of the SQL Server system. It then discusses the “Data Mining Client for Excel 2007” and explains how actuaries can use Excel to build predictive models, with little or no knowledge of the underlying SQL Server system.
Keywords: predictive modeling, data mining, exploratory data analysis, neural networks, regression modeling
Volume
Spring
Page
1-17
Year
2010
Keywords
predictive analytics
Categories
Actuarial Applications and Methodologies
Data Management and Information
Actuarial Systems
Financial and Statistical Methods
Statistical Models and Methods
Data Mining
Financial and Statistical Methods
Statistical Models and Methods
Exploratory Data Analysis
Financial and Statistical Methods
Statistical Models and Methods
Neural Networks
Financial and Statistical Methods
Statistical Models and Methods
Predictive Modeling
Financial and Statistical Methods
Statistical Models and Methods
Time Series
Publications
Casualty Actuarial Society E-Forum