1 / 29

Introducing XLeratorDB

Introducing XLeratorDB. XLeratorDB is a unique, In-Database Analytics package that provides…. Advanced Analytics – over 650 functions. Greater Performance – up to 100 x faster than Excel. Risk Reduction – eliminate spreadsheet risk. Improved Security – calculations saved on DB.

teresapatterson
Download Presentation

Introducing XLeratorDB

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing XLeratorDB

  2. XLeratorDB is a unique, In-Database Analytics package that provides… Advanced Analytics – over 650 functions Greater Performance – up to100x faster than Excel Risk Reduction – eliminate spreadsheet risk Improved Security – calculations saved on DB Faster Development – lower development costs Unsurpassed Quality – over 1.6 billion test cases Optimize SQL Server – enhance customer value FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  3. The History of XLeratorDB 2008 Charles Flock and Joe Stampf found WestClinTech and introduce XLeratorDB with over 350 Finance, Statistics, Math and Engineering functions. 2010 - 2011 More than 250 new functions added to XLeratorDB. 2008 2009 2010 2011 2012 2008 First commercial sale of XLeratorDB. 2012 - Present XLeratorDB releases new Financial-Options, CAPM and Windowing functions. Client list grows to over 400 and function list grows to more than 650. FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  4. XLeratorDB Featured Clients FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  5. XLeratorDB Global Reach Global Coverage of Financial Markets FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com FUNCTION LIBRARIES FOR SQL SERVER

  6. XLeratorDB Packages

  7. XLeratorDB Packages High-Level list of Functions Finance Statistics Math • Descriptive Statistics • Continuous data • Dispersion • Shape • Statistical Inference • Chi Square • T-Test • Correlation and Regression • Correlation • Probability • Linear • Slope • Trend • Data collection • Standard error • Probabilities • Beta cumulative probability density • Inverse of BetaDist • Binomial distribution • Fisher transformation • Arithmetic/Algebraic • Euclidean • Factorials • Mround • Product • Trigonometry • Hyperbolic Cosine • Secant • Inverse Hyperbolic • Interpolations • Linear • Polynomial • Cubic Spline • Number/Series Generators • Random / Random Normal • Monte Carlo • Matrix • Matrix Inverse • Matrix Multiplication • Transpose • Rates of Return • Internal Rate of Return • IRR with non-periodic cash flows • Net Present Value • Modified Dietz • Capital Asset Pricing Model • Alpha and Beta • Sharpe, Sortino, Treynor and Information ratios • Bond Figurations • Accrued Interest • Bond Price and Yield • Odd First, Last coupons • Loans • Principal and Interest payments • Amortization schedules • Depreciation • Declining Balance • Straight Line • Other • Business Days, • Interest Basis • Yield Curves FUNCTION LIBRARIES FOR SQL SERVER 7 7 WestClinTech.com

  8. XLeratorDB Packages High-Level list of Functions Financial-Options Engineering Strings & Windowing • Engineering • Bessel function • Error • Delta • Base Conversions • Binary number • Decimal • Hexadecimal • Octal • Complex Numbers • Coefficients • Absolute value • Quotient • Sine • Square root • Unit Conversions • Acres / Hectares • Length • Speed • Temperature • Volume • Weight • Option Models • -European • Black Scholes Merton • Binomial • Implied Volatility • -American • Binomial • Bjerksund-Stensland • Implied Volatility • Option Greeks • Delta • Gamma • Vega • Theta • Rho • Lambda • Risk Matrix • Option Matrix • Option P/L Matrix • Binomial Tree visualization • Text Formatting • Concatenate • Decimal to fraction • Date Format • Parsing • Inspection • String count • Character position • Calendar • Working days • Logic • Windowing • Lag • Running Count, Sum, Avg, STDEV, VAR, etc. • Moving Count, Sum, Avg, STDEV, VAR, etc. • Running Slope, Intercept, Forecast, etc. • Moving Slope, Intercept, Forecast, etc. • Moving Averages FUNCTION LIBRARIES FOR SQL SERVER 8 8 WestClinTech.com

  9. Performance Information

  10. XLeratorDB Performance Examples Performance increase from Excel 2010 to XLeratorDB FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  11. Deployment / Installation Solution

  12. XLeratorDB Deployment Models Desktop Single Server Server Cluster XLeratorDB in the Cloud FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  13. XLeratorDB Installed XLeratorDB installed on the database as a native component The installed functions look and behave like a native SQL Server component. FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  14. XLeratorDB Installed Example of XLeratorDB XIRR function in SQL Server Management Studio As the example below shows, XLeratorDB functions are easy to deploy and use. FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  15. XLeratorDB used as a Development Solution Example of XLeratorDB CAPM functions in the QlikView BI solution XLeratorDB not only includes sophisticated functionality but is also “integration friendly” FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  16. XLeratorDB used as a Development Solution Example of XLeratorDB’s Option Matrix functions in the QlikView BI solution FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  17. XLeratorDB used as a Development Solution Example of XLeratorDB in Healthcare FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  18. Documentation and Blog

  19. XLeratorDB Documentation • XLeratorDB includes full documentation that is available on the web site • All functions include examples that can be implemented right out of the box • XLeratorDB blog includes over 75 informative articles that provide real-world examples that can be cut, pasted and executed right from the page FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  20. XLeratorDB Documentation Example FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  21. XLeratorDB Blog Article Examples Calculating a time-weighted rate of return using modified Dietz in SQL Server By cflock on 10/24/2012 1:24 PM The modified Dietz calculation produces a result which measures the performance of an investment portfolio based on time-weighted cash flows. Today, we will look at two XLeratorDB aggregate functions, EMDIETZ and FVSCHEDULE, which calculate the modified Dietz value for each period and then link the results together to come up with a time-weighted rate of return value. Read More » Creating a Bond Amortization Schedule in SQL Server By cflock on 4/5/2012 8:55 PM A look at different techniques for generating schedules to account for the premium or discount associated with the issuance or purchase of a bond using the XLeratorDB functions COUPDAYSNC, COUPNUM, DAYS360, EDATE, IRR, PRICE, PV, RATE, SeriesDate, SeriesInt, XIRR, and YIELD. Read More » Calculating the Time-Weighted Rate of Return in SQL Server By cflock on 11/25/2011 1:51 PM With the release of the TWRR multi-input aggregate function, XLeratorDB users can now calculate the time-weighted rate of return directly in a T-SQL statement. Read More » 11 financial calculations that you can’t do in EXCEL By cflock on 10/18/2011 8:16 PM Here is a list of 11 very simple financial calculations that you can’t do in EXCEL, either because the EXCEL design of a function doesn’t support the input data, or because EXCEL produces a result that is wrong or unreliable. Of course, we used EXCEL 2010 and, of course, you can do them in SQL Server using XLeratorDB. Part 1 of 11 - Enter a negative yield to calculate the price of a bond Read More » FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  22. Product Quality and Testing

  23. 1.6 Billion Test Cases XLeratorDB Product Quality and Testing • XLeratorDB ‘s product quality meets the highest standard • XLeratorDB quality is assured with over1.6 billiontest cases • XLeratorDB employs a “test harness” for every function, each containing an average of 2.4 million test cases • The quality of XLeratorDB gives you the confidence to focus on your business, not your software Statistics Finance Windowing Math XLeratorDB Utilities Financial-Options Engineering Strings FUNCTION LIBRARIES FOR SQL SERVER 23 WestClinTech.com

  24. Compatibility

  25. XLeratorDB Technical Compatibility Development languages Applications Databases • SQL Server • SQL Server 2005 • SQL Server 2008 • SQL Server 2012 • also Oracle, MySQL, DB2, etc. • via ODBC/Linked Servers .Net Java Perl C++ Python Powershell and many others… MS Excel MS Access MS SSRS QlikTech’s QlikView Misys Eagle Eye R and many others… XLeratorDB functions are accessible to any programming language or application that can connect to a database FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  26. Summary

  27. XLeratorDB Summary • XLeratorDB includes over 650 sophisticated functions covering Finance, Statistics, Financial Options, Math, Engineering, Windowing and Strings • XLeratorDB dramatically increases performance and security, reduces risk and has impeccable quality • XLeratorDB greatly enhances the overall value of SQL Server FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  28. XLeratorDB Summary • XLeratorDB Licensing Model is very flexible with surprisingly low cost of ownership • XLeratorDB Product Updates and Email and Phone Support provided at no additional charge • XLeratorDB New Functionality driven by client input • Consulting Services are also available FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

  29. E-v-O-L-V-E to the next step in computational power… FUNCTION LIBRARIES FOR SQL SERVER WestClinTech.com

More Related