Microsoft Excel · Power Query
Excel Power Query
????????????? ?????????? ?????? ??? ??????. ?????? ?? ????? ??????????, ???????, ????????????? ? ??????????? ?????? ? ????????? ??????. ????????? ?????????? ?????? — ???? ??????.
8–16
??. ?????
80%
????????
?? ???????? ???????
?? ???????? ???????
M
????
???????
???????
????????????? · 5 500+ ?????
??????? ??????? · Excel-??????
??? ????
???? ???????? ???? ????
????????? ? ??????????
?????? ????? ???????? ?????? ???????. ????? ????? ??? ?????? ???? ??????.
????????????? ? ?????????
???????? ?????? ?? ?????? ??????, ?????? ? ?????? ?? ????. Power Query ??????? ???? ??????.
???????????? ? HR
??????? ?????????? ? ????????. ????? ?????? ??????? ????? ??????.
?????????
??? ??????? ?? ?????
01
Excel Power Query — ??????? (8 ??. ?.)
8 ?
?????? ?? Excel, CSV, ????? ??????, ??????????: ???? ??????, ?????????, ?????????????????????????: ?????, ?????, ?????????????????????? ?????? (append / merge)?????????? ?????? ????? ???????
02
Excel Power Query — ??????????? (16 ??. ?.)
16 ?
??? ?? ???????? + ???? M???????????????? ??????? ?? M??????? ??????????????: ?????????????, ??????????????????? ? ??????? ?????? Power Pivot??????????? ????????
?????????
??? ????????? ?????? ????? ?????
?????????? ????? ????????? ?????? ??? ???????????
????????????? ???????, ??????????????? ? ?????????? ???????
????????? ????? ????? ??????? ??? ??????????? ????? ??????
?????? ???????????????? ??????? ?? ????? M (??????????? ????)
??????????? ?????? ??? ?????? Power Pivot
????????? ????? ?????????? ?????? ? ??????? ???
???????
??? ???????? ????????
???? ?? ????????
??????? ? ??? ? ?????. ?????? ?? 20 ???????.
??????
Zoom, Teams ??? ???? ?????????. ?????? ???????.
??????
????? ?????? ????, ????? ????????.
?????????????
??? ?????
??????? ???????
????????????? ?????? · Excel, ??, ????????????????????? Excel ? 2010 ????. ?? Excel — 86 ??????, 3 500+ ?????. Power Query ???? ? 2014 ????. ?????????? MOS Excel Expert (1000/1000 ??????).
5 500+?????
86?????? Excel
60+????????
????X5 Retail??????. ??????????????? ???????Synergy????????? ??
???????
???? ??? ???????? ????????
??????????? ???? ??, ??????????????? ???? ??, ???????????? ???????? ??, ????????????????? ??????, ???? ????, ???? ?????? ? ??, ???? / ??????, ??? ????????????? ???????
?????????? ???????? ??? ????????????? ??, ?????????? ??????????? ??? ????????????? ??, ???? ?????????????????, ??????????? ????????, ???? ???????, ???????? ?????????, ????? ????????? ????????, ?????????, ??? ??? ????? ??????????? (???)
??? ??????? ?????????? ??????, ??????-??????????, ??-???? (????????), ????????????, ????? ???????
?????-??????, ?????????? ??, ????????, ??? ?????, ??? ???, ?????-????
????????-????, IBS, ??????? ??????????, ??????????, ???? ???????????? ????????, ??????? ????? (????)
??? ??????????? ????????, ?????-??? ???, ??? ? ?????
????????? ????? ? ??????? ???????????????????, ????????? ?????????? ?????????, ????? ?????? ??????, ????? ??? ?????? ???????? ???????
60+
???????????
7
????????
10+
???????
? 2010
????
??? ??????? Power Pivot — ?????? ?????? ? DAX-?????????.
??????????
???? ????? ??????
???????
?????? ???????
????? ?????? Excel ??????
Excel 2016 ? ?????, ??????? 365. Power Query ??????? ?? ??? ?????????? ??????.
????? ?? ???? ?????????????????
???. ??????? ???? ???????? ????? ?????????? ????????? ??? ????. ???? M — ?????? ? ???????????.
????? ?? ????????
??? ?????? ??????? — ??. ??? ?????? — ????????? ? ???-???????.
????? ?? ???????????? ??????????
??, ??? ?????? ????? ???????. ??????? ????? ???????.
??? ???????? ???????
?? ????????, ???, ??????????? ?????????. ??????? ??? ??.