Quick Learn | FAQ's | Technical Solutions

Find percentage difference between two numbers: Percentage difference formula: Percentage difference equals the absolute value of the change in value, divided by the average of the 2 numbers, all multiplied by 100.   Finally use percent sign, %. Percent difference = ( | ΔV |/ ( ∑V/2) ) * 100 = ( | (V1 - V2) | / ((V1 + V2)/2) ) * 100 For example one, to calculate the percentage difference: What is the percentage difference between 6 & 8? Assume  V1 = 6  V2 = 8  Enter numbers into our formula ( | (V1 - V2) | / ((V1 + V2)/2) ) * 100 Answer: Calculate percentage difference  between V1 = 6  &   V2 = 8  ( | V1 - V2 | / ((V1 + V2)/2) ) * 100  = ( | 6 - 8 | / ((6 + 8)/2) ) * 100  = ( | -2 | / (14/2) ) * 100  = ( 2 / 7 ) * 100  = 0.285714 * 100  = 28.5714% difference

Common Understanding between Datawarehouse & DataMining Data warehousing is a process that must occur before any data mining can take place. In other words, data warehousing is the process of compiling and organizing data into one common database, and  Data mining is the process of extracting meaningful data from that database.  The data mining process relies on the data compiled in the data warehousing phase in order to detect meaningful patterns. The data mining will typically be done by business users who are not engineers, but who will most likely receive assistance from engineers when they are trying to manipulate their data.  The data warehousing phase is a strictly engineering phase, where no business users are involved and this gives us another way of defining the 2 terms: data mining is typically done by business users with the assistance of engineers, and data warehousing is typically a process done exclusively by engineers.

EMP & DEPT tables in Oracle Database DDL 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 create table dept(    deptno number(2,0),    dname  varchar2(14),    loc    varchar2(13),    constraint pk_dept primary key (deptno) ); create table emp(    empno    number(4,0),    ename    varchar2(10),    job      varchar2(9),    mgr      number(4,0),    hiredate date ,    sal      number(7,2),    comm     number(7,2),    deptno   number(2,0),    constraint pk_emp primary key (empno),    constraint fk_deptno foreign key (deptno) references dept (deptno) ); /* create table bonus(    ename varchar2(10),    job   ...