Skip to main content

Decision Table


Logical Modelling and decision tables

Logical modelling involves modelling internal structure and functionality of a process. Decision tables are useful in logical modelling. Decision tables show logic inside a process, action(s) that needs to be taken when a condition or a set of conditions are satisfied.

Use of decision tables

  • used by developers to identify any discrepancies in business rules (Tarlinder 2016).  
  • used for customer support in telecom industry to provide an optimal plan based on the customer's usage (Singh 2015).
  • used in SAP HANA to specify business rules (Singh 2015)
  • Used in Model based testing as inputs (Kramer, Legeard, Bazzana, & Binder, 2016). Business rules in decision table can be converted into arguments for parameterized testing (Tarlinder 2016). 

A Decision tables can be created using the following steps:
  1. Identify conditions 
  2. Identify actions that needs to be carried out when certain conditions are met. 
  3. Create rules - A rule specifies action(s) that needs to be taken when certain condition(s) are met. Consider all possible rules when decision making. Each rules should be independent of the other and should be unique. 
  4. Simplify the decision table

Example: In a specific college, the students are assessed using coursework, Midterm and Final exam. If the students score an average of 50% or more for the exam then their coursework marks is added to the final grade. But if, the average exam marks is less than 50 then the coursework marks is not added to their final grade. If the student has completed at least 75% of the course work and has scored an average of exam that is greater than or equal to 45 and less than 50 then the student is passed with an overall grade of 50%. 


The above table can be simplified as shown below:



Reference

Labels:

Comments

Post a Comment

Popular posts from this blog

CUMIPMT and CUMPRINC function

CUMIPMT Cumulative interest payment function allows you to calculate the interest paid for a loan or from an investment from period A to period B. When getting a loan, CUMIPMT function can be used to calculate the total amount of interest paid in the first five months or from period 12 to period 20. A period can be a month, a week or two week. Loan Amount : 350,000.00 APR: 4.5% Down payment: 0.00 Years: 25 Payment per year: 12 From the above data, we can calculate the following: No of Period: 25 × 12 = 300 Periodic Rate: 4.5/12 = 0.375% Here is how you will substitute these values into the function. = CUMIPMT (periodic rate, No of period, vehicle price, start period, end period,  ) = CUMIPMT (0.375, 300, 350000, 1, 5, 0) In an excel worksheet, we use cell address instead of actual values as shown below: Here is the formula view of the worksheet: CUMPRINC Another related function is CUMPRINC. CUMPRINC function is used to calculate cumul
Post a Comment
Read more

Excel PMT Function

PMT function is very useful for calculating monthly payment required to payback a loan or mortgage at a fixed rate. This function require a minimum of three inputs, periodic rate, number of periods, present value or the loan amount. Here is a simple example. Home Loan: 350,000.00 Interest rate: 4.5% Number of years to repay the loan: 25 Note: To calculate monthly payment, we need to find the monthly rate and number of months as shown above. Then it is simply a matter of substituting the values into the payment function, as shown in the formula view below.
Post a Comment
Read more

BCG's Brand Advocacy Index

The Boston Consulting Group's (BCG) Brand Advocacy Index (BAI) is a metric developed to help companies measure the degree of customer advocacy for their brands. BAI focuses on the likelihood of customers to recommend a brand to others, which is a powerful indicator of brand strength and customer loyalty. Unlike other customer satisfaction or loyalty metrics, BAI emphasizes the importance of customer referrals and word-of-mouth marketing. BAI is calculated based on a survey where customers are asked about their willingness to recommend a brand to their friends, family, or colleagues. The responses are then used to compute a score, which ranges from -100 to 100. A higher BAI score indicates that a brand has more advocates who are likely to recommend the brand to others, while a lower score suggests that the brand has fewer advocates or even a higher number of detractors. BCG's research has shown that companies with higher BAI scores tend to experience higher growth rates and bett
Post a Comment
Read more