Microsoft Excel · Power Pivot

Excel Power Pivot

?????? ????????? ?????? Excel. ?????? ?????? ?? ?????????? ??????, DAX-??????? ??? ??????? ????????, ?????? ???????, KPI ? ????????????? ????????. ??? ???, ???? ???????????? ??????? ??????? ??????.

8–16

??. ?????

DAX

????
??????

80%

????????
?? ???????? ???????

???????? ????????? ?????MAX

????????????? · 5 500+ ?????

??????? ??????? · Excel-??????

5 500+????? ????????????

86?????? Excel

50+????????????? ????????

15 ???????????????

??? ????

???? ???????? ???? ????

????????? ? ??????????

?????? ?????? ?? ?????????? ?????? ? ????? ?????????? ?? ? ???? ?????? ??? VLOOKUP ???????.

????????? BI

???????? ? Excel, ?? ???????????? ?????? ?????? ? DAX. Power Pivot — ??? ????? Power BI.

???????????? ? ?????????

????? ???????? ? KPI, ????????? ????/???? ? ???????? ?? ????????.

?????????

??? ??????? ?? ?????

Excel Power Pivot — ??????? (8 ??. ?.)

8 ?

??????? ????? ???????? ? Power Pivot???????? ?????? ? ??????????? ????? ????????????????? DAX-????: SUM, COUNT, CALCULATE??????????? ???? ? KPI??????? ?? ?????? ???????

Excel Power Pivot — ??????????? (16 ??. ?.)

16 ?

??? ?? ??????????????? DAX: FILTER, ALL, RELATED, RANKX?????? ???????: DATESYTD, SAMEPERIODLASTYEAR??????????? ?????? ???????????????? ? Power Query

????? ????????? ??? ???? ???????? ????????? ?????????? ??? ??????.

Telegram ? ?????MAX

?????????

??? ????????? ?????? ????? ?????

??????? ?????? ?????? ?? ?????????? ??????

?????? DAX-???? ??? ??????? ????????

????????? ?????? ??????? ??? ????????? ????????

??????????? KPI ? ????????????? ????????

?????????? ?????? ??? VLOOKUP-???????

??????? ?? Power BI — ?? ?? ????????, ????? ??????????

???????

??? ???????? ????????

???? ?? ????????

??????? ? ??? ? ?????. ?????? ?? 20 ???????.

??????

Zoom, Teams ??? ???? ?????????. ?????? ???????.

??????

????? ?????? ????, ????? ????????.

?????????????

??? ?????

??????? ???????

????????????? ?????? · Excel, ??, ?????????????

???????? Excel ? 2010 ????. ?? Excel — 86 ??????, 3 500+ ?????. ???? Power Pivot, DAX, ????????????? ??????. ?????????? MOS Excel Expert (1000/1000 ??????).

5 500+?????

86?????? Excel

60+????????

????X5 Retail??????. ??????????????? ???????Synergy????????? ??

???????

???? ??? ???????? ????????

??????????????? ??????

8 ???????????

??????????? ???? ??, ??????????????? ???? ??, ???????????? ???????? ??, ????????????????? ??????, ???? ????, ???? ?????? ? ??, ???? / ??????, ??? ????????????? ???????

???????????? ? ???????????

9 ???????????

?????????? ???????? ??? ????????????? ??, ?????????? ??????????? ??? ????????????? ??, ???? ?????????????????, ??????????? ????????, ???? ???????, ???????? ?????????, ????? ????????? ????????, ?????????, ??? ??? ????? ??????????? (???)

?????, ???, ??????????

5 ???????????

??? ??????? ?????????? ??????, ??????-??????????, ??-???? (????????), ????????????, ????? ???????

?????????????? ? ???????????

6 ???????????

?????-??????, ?????????? ??, ????????, ??? ?????, ??? ???, ?????-????

IT, ???????, ???????

6 ???????????

????????-????, IBS, ??????? ??????????, ??????????, ???? ???????????? ????????, ??????? ????? (????)

?????????????, ??????, ??????

3 ???????????

??? ??????????? ????????, ?????-??? ???, ??? ? ?????