BI Solutions

V.2.1

BI demo options

➤  BI DEMO I ➤  BI DEMO II ➤  BI DEMO III

BI solution with standard functions

Structure
Subject
  • Invoiced project revenue (EUR).
Reports
  • Total.
  • Department.
  • Individual.
Resources
  • SQL Database.
  • FoxPro Database.
Total
Subject
  • Invoiced project revenue (EUR).
Intake
  • Password.
  • Fiscal Year End Date.
  • Optional group:
    • Accounts.
  • Details: Y / N.
Week Nos.
  • The week starts on Monday.
  • Week No.1 contains 4 or more days of the new year.
  • The week number calculation is based on the invoice dates.
  • If necessary, placeholders are generated.
Main part
  • 27 formulas (*).
Sub part
  • 18 formulas (*).
Charts
Rankings
  • Among others [Segments + Accounts] vs. [B. D. Managers].
(*)
Formulas facilitate sophisticated needs and comprise all kinds of smart components (If-Then-Else, Loop, Concatenate, Data Exchange, etc). A simplified formula to illustrate If-Then-Else:
IF {@TotalUnits} >= 5000 THEN
FORMULA = {@ProjectRevenue} * 0.88
ELSEIF {@TotalUnits} < 5000 and >= 2500 THEN
FORMULA = {@ProjectRevenue} * 0.94
ELSE FORMULA = {@ProjectRevenue}
END IF
IF {@TotalUnits} >= 5000 THEN
FORMULA = {@ProjectRevenue} * 0.88
ELSEIF {@TotalUnits} < 5000 and >= 2500 THEN
FORMULA = {@ProjectRevenue} * 0.94
ELSE FORMULA = {@ProjectRevenue}
END IF
IF {@TotalUnits} >= 5000 THEN
FORMULA = {@ProjectRevenue} * 0.88
ELSEIF {@TotalUnits} < 5000 and >= 2500 THEN
FORMULA = {@ProjectRevenue} * 0.94
ELSE FORMULA = {@ProjectRevenue}
END IF
Department
Subject
  • Invoiced project revenue (EUR).
Intake
  • Password.
  • Dept-1, -2 or -3.
  • Fiscal Year End Date.
  • Optional groups:
    • Accounts.
    • B. D. Managers.
    • Project Managers.
  • Details: Y / N.
Supplement
  • Partly based on Total.
Individual
Subject
  • Invoiced project revenue (EUR).
Intake
  • Password.
  • Fiscal Year End Date.
  • Options:
    • (Part of) a last name.
    • (Part of) an HR-No.
  • Details: Y / N.
Supplement
Example: Revenue Development | Fiscal Year.
Click on the image to enlarge it.
Example: Revenue Development | FY.
If the device width exceeds 1050, you can click on the image to take a look at an exact enlargement.