Главная KPI Дашборд

KPI Дашборд

KPI Дашборд обычно показывает значения и динамику основных KPI. Такой дашборд создается для руководящих сотрудников, чтобы они могли сразу увидеть как идут дела в компании или в каком-то конкретном направлении. Такой дашборд не подходит для глубокого анализа данных.

Sales KPI

Sales Selected Year:=
if year([Order Date]) = [Year Selected]
then [Sales]
end

Sales Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then [Sales]
end

Sales Change YoY:=
(sum([Sales Selected Year]) - sum([Sales Previous Year])) /
 sum([Sales Previous Year])

Sales Change Sign:=
if [Sales Change YoY] > 0 then 1
else -1
end
Profit KPI

Profit Selected Year:=
if year([Order Date]) = [Year Selected]
then [Profit]
end

Profit Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then [Profit]
end

Profit Change YoY:=
(sum([Profit Selected Year]) - sum([Profit Previous Year])) /
 sum([Profit Previous Year])

Profit Change Sign:=
if [Profit Change YoY] > 0 then 1
else -1
end
Orders KPI

Orders Selected Year:=
if year([Order Date]) = [Year Selected]
then [Order ID]
end

Orders Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then [Order ID]
end

Orders Change YoY:=
(countd([Orders Selected Year]) - countd([Orders Previous Year])) / countd([Orders Previous Year])

Orders Change Sign:=
if [Orders Change YoY] > 0 then 1
else -1
end
Costs KPI
Costs Selected Year:=
if year([Order Date]) = [Year Selected]
then [Costs]
end

Costs Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then [Costs]
end

Costs Change YoY:=
(sum([Costs Selected Year]) - sum([Costs Previous Year])) /
 sum([Costs Previous Year])

Costs Change Sign:=
if [Costs Change YoY] > 0 then 1
else -1
end
Days to Ship KPI
Days to Ship Selected Year:=
if year([Order Date]) = [Year Selected]
then [Days to Ship]
end

Days to Ship Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then [Days to Ship]
end

Days to Ship Change YoY:=
(avg([Days to Ship Selected Year]) - avg([Days to Ship Previous Year])) / avg([Days to Ship Previous Year])

Days to Ship Change Sign:=
if [Days to Ship Change YoY] > 0 then 1
else -1
end
Order Amount KPI
Order Amount Selected Year:=
if year([Order Date]) = [Year Selected]
then {include year([Order Date]): sum([Sales]) / countd([Order ID])}
end

Order Amount Previous Year:=
if year([Order Date]) = [Year Selected] - 1
then {include year([Order Date]): sum([Sales]) / countd([Order ID])}
end

Order Amount Change YoY:=
(avg([Order Amount Selected Year]) - avg([Order Amount Previous Year])) / avg([Order Amount Previous Year])

Order Amount Change Sign:=
if [Order Amount Change YoY] > 0 then 1
else -1
end