APPENDIX Initiative #7- BI Functions Repository

This repository will contain the BI and PM functions, which are used by various tools. The functions and their application will be explained in non-programming language, with emphasis on the application and not on coding. Please contact authoring@bipminstitute.com for being the co-author of this initiatiive OR/AND if you have suggestions on our content scope & structure. The purpose is not to provide the bookish definition of the functions (which you can get from Excel help-file for most of the cases), but on application. Even most simple functions can be grossly mis/under-utilized or can be very creatively applied depending upon our knowledge on their business & application perspective.

Each function will have a page, which will include in business language:

• Defintion of the function
• The input data for the function
• The output data of the function
• The formulae behind the function
• The application of the function
• Linked functions

List of Business intelligence functions

Basic functions

• Average  
• Count  
• First  
• Geometric mean  
• Greatest  
• Last  
• Least  
• Maximum
• Median  
• Minimum
• Mode
• Product  
• Standard deviation of a population
• Standard deviation of a sample
• Sum  
• Variance of a population  
• Variance of a sample

 Date Functions & Time Functions

• Add Days  
• Add Months
• Day of Month  
• Day of Week  
• Day of Year
• Days Between
• Month
• Month End Date
• Month Start Date
• Months Between  
• Quarter
• Second
• Week
• Year  
• Year End Date  
• Year Start Date  

OLAP functions

• Exponential weighted moving average
• Exponential weighted running average
• First in Range  
• Last In Range  
• Moving Average  
• Moving Count
• Moving Difference
• Moving maximum
• Moving minimum
• Moving standard deviation of a population
• Moving standard deviation of a sample
• Moving Sum
• Running average  
• Running Count
• Running maximum
• Running minimum
• Running standard deviation of a population
• Running standard deviation of a sample  
• Running um  
• Rank and NTile functions
• N Tile  
• N Tile Size  
• N Tile Value  
• N Tile Value Size  
• Percentile
• Rank  

Financial functions  

• Accrued interest  
• Accrued interest at maturity  
• Coupon period, beginning to settlement
• Coupon period, number of days with settlement
• Coupon period, settlement to next coupon
• Coupon date, next after settlement
• Coupon, number payable between settlement and maturity  
• Coupon date, previous
• Cumulative interest paid  
• Cumulative principal paid
• Fixed-declining balance (asset depreciation)
• Double-declining balance (asset depreciation)
• Discount rate for a security
• Dollar price, converted from fraction to decimal  
• Dollar price, converted from decimal to fraction  
• Duration  
• Effective annual interest rate
• Future value
• Future value schedule
• Interest rate
• Interest payment  
• Internal rate of return  
• Modified duration
• Modified internal rate of return  
• Nominal annual interest rate  
• Number of investment periods
• Net present value of an investment
• Odd-first-period price  
• Odd-first-period yield
• Odd-last-period price
• Odd-last-period yield  
• Payment  
• Principle payment  
• Price per $ face value  
• Price, discounted
• Price at maturity
• Present value
• Interest rate per period
• Amount received at maturity  
• Straight-line depreciation  
• Sum of year’s digits depreciation  
• T-bill equity
• T-bill price
• T-bill yield  
• Variable declining balance
• Yield
• Yield on a discounted security  
• Yield at maturity  

Mathematical functions  

• Absolute value  
• Arc cosine  
• Arc cosine, hyperbolic
• Arc sine
• Arc sine, hyperbolic
• Arc tangent
• Arc tangent
• Arc Tangent, hyperbolic  
• Ceiling value
• Combination
• Cosine
• Cosine, hyperbolic
• Conversion to
• Exponent
• Factorial  
• Floor value
• Integer  
• Logarithm, natural
• Logarithm
• Logarithm, base
• Modulus
• Power
• Quotient  
• Conversion to radians  
• Random number between two values  
• Round  
• Sine
• Sine, hyperbolic
• Tangent
• Tangent, hyperbolic  
• Truncate

Statistical functions

• Average deviation
• Beta distribution
• Binomial distribution
• Chi-square distribution
• Chi-square test for independence
• Confidence interval
• Correlation  
• Covariance
• Criterion binomial
• Exponential distribution  
• Fisher transformation
• F-probability distribution
• F Test
• Gamma Distribution  
• Hetro-scedastic T Test and HomoscedasticT Test  
• Hypergeometric distribution
• Intercept
• Inverse of the beta distribution
• Inverse of chi-squared distribution
• Inverse of the fisher transformation
• Inverse of F-probability distribution
• Inverse of gamma distribution
• Inverse of lognormal distribution
• Inverse of normal cumulative  distribution  
• Inverse of standard normal cumulative distribution  
• Inverse of T-distribution  
• Kurtosis
• Lognormal distribution
• Mean T-test  
• Negative binomial distribution
• Normal cumulative distribution  
• Paired T-test, two-sample for means
• Pearson product moment correlation coefficient
• Permutation
• Poisson distribution
• Square of pearson product moment correlation coefficient
• Skew  
• Slope of a linear regression
• Standardize
• Standard normal cumulative distribution  
• Standard error of estimates
• T Distribution
• Variance test
• Weibull Distribution