Leverage MSFT BI Stack for models built in SAS and R - Predixion Software - Predixion Support and Training - General

My Account | Login

You are here : > General > Installation and Activation > Leverage MSFT BI Stack for models built in SAS and R

Forums

For any issues using Predixion products, please ask on our forums and a Predixion team member will respond promptly.

Unanswered Active Topics

Forums Search

Reply To Topic

Topic: Leverage MSFT BI Stack for models built in SAS and R

Posted By Jamie MacLennan on 06 Sep 2011 03:00 PM
The short answer is yes! PMML models created with SAS and R (or other products) can be operationalized into the MS BI stack through SSIS, or by integrating results directly into PowerPivot workbooks. Integrating into SSIS is as easy as importing the model, designing a query using Predixion Insight, and pasting the query into the Predixion Query transform in the SSIS environment. Using Predixion Insight you can * Import SAS, R and other PMML models * Evaluate PMML models using a variety of accuracy charts (and compare with Predixion models) * Query PMML models using the same interfaces as Predixion models * Integrate PMML models into Excel and PowerPivot * Automate PMML interactions using Visual Macros and VBA * Integrate PMML models into the MSFT stack reading from any source and putting results in any destination using through our native SQL Server Integration Services components

Username:

Security Code:

Enter the code shown above in the box below

Subject:

RE: Leverage MSFT BI Stack for models built in SAS and R

Message:

Submit

Cancel

Preview

Topic Review

Jeff Willis

New Member
Posts:11
Avatar

08 Sep 2011 11:12 AM
Marc, We have a great webinar on SSIS at this link. You can locate more information about PMML on our PMML Connexion™ datasheet. Here is a pointer to that. There is documentation about importing PMML at the following Help page. Go to Insight Analytics / Manage / My Stuff. Scroll all the way to the bottom of the page. Hope this helps! Thank you very much, Jeff Willis

Marc Alexander

New Member
Posts:2
Avatar

06 Sep 2011 10:23 PM
Is there a particular video you can point me to demonstrate this? Or, preferably, can we schedule a web session for a live demo of the product? We are interested in the intergration capabilities of the Insight product. Thanks for your help, Marc Director of Data Analytics Bridgepoint Education

Jamie MacLennan

New Member
Posts:2
Avatar

06 Sep 2011 03:00 PM
The short answer is yes! PMML models created with SAS and R (or other products) can be operationalized into the MS BI stack through SSIS, or by integrating results directly into PowerPivot workbooks. Integrating into SSIS is as easy as importing the model, designing a query using Predixion Insight, and pasting the query into the Predixion Query transform in the SSIS environment. Using Predixion Insight you can * Import SAS, R and other PMML models * Evaluate PMML models using a variety of accuracy charts (and compare with Predixion models) * Query PMML models using the same interfaces as Predixion models * Integrate PMML models into Excel and PowerPivot * Automate PMML interactions using Visual Macros and VBA * Integrate PMML models into the MSFT stack reading from any source and putting results in any destination using through our native SQL Server Integration Services components

----------------------------------- Jamie MacLennan CTO Predixion Software

Marc Alexander

New Member
Posts:2
Avatar

06 Sep 2011 02:24 PM
Is this product a feasible alternative for taking the PMML generated from other modeling software (SAS and R) and integrating them into our MSFT stack. For example, I've got a model that I want to use to score some data. Can I use the Predixion software to call that PMML with SSIS? Thanks, Marc

Active Forums 4.2

HELP

Predixion Insight Help includes a description of each tool, tips on how to use the tool and how to work with the results. You can also access Predixion Insight Help from the Predixion menu on the Insight ribbons.

Videos & Tutorials

Visit our growing library of tutorials and training videos to guide you through the multitude of features available Predixion Insight™. New videos are in production so please check back often.

Predixion provides support and warranties for all products and services. Please email support@predixionsoftware.com for information.