Data Mining with ace on-demand and Microsoft(R) Excel
Your Enterprise ABC/M model can provide tremendous insight into the current financial health of your organization and profitability of existing customers and products. What if you wanted to look into the future or gain greater understanding of the relationships between customers and products purchased. This is where Predictive Modeling and Data Mining come into play.
With the power of SQL Server 2005 Analysis Service and Microsoft Excel you can dig deep into your data from your ABC model. The types of analysis you can perform are:
- Market Basket Analysis
- Churn Analysis
- Market Analysis
- Forecasting
- Data Exploration
Please click here for more information on the Data Mining capabilities of SQL Server 2005.
It is also very easy to access this advanced functionality, Microsoft provide a free plug-in to Microsoft Excel, you can access your pre-built ace cubes using Excel over the internet using XML and analyze the data using the power of SQL Server 2005 Analysis Service, you also don't have to worry about transferring large amounts of data over the internet because all the heavy processing is done on the server and Microsoft Excel is used to display the results.
