Update analytic solver platform
The Correlation Matrix dialog allows entry of coefficients, but does not yet draw histograms or scatterplots in cells.
UPDATE ANALYTIC SOLVER PLATFORM CODE
Users with student licenses (who entered a Textbook Code and Course Code) will have access to Frontline's SQL Azure database when Get Data - Database is chose, and to Frontline's Apache Spark Big Data cluster when Get Data - Big Data is chosen, without having to enter login credentials. The XLMiner Get Data button options (Worksheet, Database, File Folder, Big Data) are all available.
XLMiner Platform Tab OptionsĪll of the Ribbon options for forecasting, data mining, and text mining functionality of XLMiner Platform in Excel are also available in, and the dialog boxes that appear for each menu function are virtually identical. The built-in Grant Decision Analysis workbook ("Exploring Decision Risk" worksheet) is an illustration of this. However, with a little care, you can perform Monte Carlo simulations on decision tree models. Clicking the Close button hides the window, clicking the Decision Tree button on the Ribbon displays it again.īecause array formulas are not yet supported in the spreadsheet grid, you cannot use the (array-entered) TABLE function to perform sensitivity analysis on decision trees in, as you can in Excel. If you are on a different worksheet and you click the tab for a worksheet that contains a decision tree (created and saved in either or Analytic Solver Platform in Excel), the window will pop up to display the tree. Since the node-worksheet cell relationships are maintained, you can create a decision tree in desktop Excel, save and upload the workbook to, and immediately see and work with that decision tree in the pop-up window. But in Excel the graphic nodes are visually "next to" the related worksheet cells in, the nodes are in the pop-up window. In both cases, rollback calculations are performed via worksheet cell formulas. In, decision trees are created in a separate window that "pops up" in front of the spreadsheet grid - with some extra interactive features. In Analytic Solver Platform, decision trees are created on the Excel spreadsheet (which has a "graphics layer"). But they are visually somewhat different. Below is a summary, ordered by buttons on the Ribbon: Creating and Using Decision TreesĪnalytic Solver Platform and offer the same basic functionality for creating and evaluating decision trees, using Expected Value or Certainty Equivalent calculations, and the dialog boxes for creating, deleting or editing tree nodes are very similar in both cases. Partner with the FICO® Scoring solutions team and leverage our scoring and analytic expertise to help industries reduce risk, improve experiences, and support growth.Nearly all optimization and simulated related functions available in Analytic Solver Platform are also available in.
UPDATE ANALYTIC SOLVER PLATFORM HOW TO
Learn how to gain better industry risk insights using data-driven analytic solutions with FICO® Scoring Solutions for Industry Risk. FICO delivers a range of products and services globally that empower the development of enhanced credit risk strategies.