Power Query: The formation of professional competencies of a business analyst
https://doi.org/10.32517/0234-0453-2020-35-2-30-40
Abstract
About the Authors
D. M. NazarovRussian Federation
DmitryM. Nazarov, Doctor of Sciences (Economics), Docent, Head of the Department of Business Informatics
A. D. Nazarov
Russian Federation
Anton D. Nazarov, Assistant at the Department of Business Informatics
References
1. Sazonov B. A. Klassifikatsiya professional’nykh obrazovatel’nykh programm v Rossijskoj Federatsii: problemy i vozmozhnye resheniya [Classification of professional educational programs in the Russian Federaition: problems and possible decisions]. Vysshee obrazovanie v Rossii— Higher Education in Russia, 2017, no. 11, p. 20–30. (In Russian.) Available at: https://vovr.elpub.ru/jour/article/view/1202
2. Senashenko V. S. Urovni sopryazheniya sistemy vysshego obrazovaniya i sfery truda [Conjugation levels between higher education and labour sphere]. Vysshee obrazovanie v Rossii — Higher Education in Russia, 2018, vol. 27, no. 3, p. 38–47. (In Russian.) Available at: https://vovr.elpub.ru/jour/article/view/1312
3. Sobolev A. B. O modernizatsii obrazovatel’nykh standartov [On the modernization of educational standards]. (In Russian.) Available at: http://fgosvo.ru/uploadfiles/presentations/20.09.2016/Sobolev20.09.2016.pdf
4. Tantsura N. P., Valdaytseva E. A. Opyt sozdaniya proektov FGOS novogo pokoleniya i priblizitel’noj osnovnoj obrazovatel’noj programmy (POOP) spetsialitetov na osnove professional’nykh standartov [Experience in the creation of Federal State Educational Standards of new generation and an Approximate Basic Educational Program (ABEP) of specialties based on professional standards]. Sovremennaya psikhologiya i pedagogika: problemy i resheniya. Sbornik statej po materialam VII mezhdunarodnoj nauchno-prakticheskoj konferentsii [Modern psychology and pedagogy: problems and solutions. Collection of articles on the materials of the 7th international scientific-practical conference]. Novosibirsk, Sibac, 2018, p. 46–57. (In Russian.) Available at: https://sibac.info/conf/pedagogy/vii/99141
5. Uvarov M. Power Query: steroidy dlya MS Excel i Power BI [Power Query: Steroids for MS Excel and Power BI]. (In Russian.) Available at: https://habr.com/ru/post/271019/
6. Prikaz Ministerstva obrazovaniya i nauki Rossijskoj Federatsii ot 11 avgusta 2016 g. № 1002 “Ob utverzhdenii federal’nogo gosudarstvennogo obrazovatel’nogo standarta vysshego obrazovaniya po napravleniyu podgotovki 38.03.05 Biznes-informatika (uroven’ bakalavriata)” [Order of the Ministry of Education and Science of Russian Federation dated August 11, 2016 No. 1002 “On the approval of the Federal State Educational Standard of Higher Education in the field of preparation 38.03.05 Business Informatics (undergraduate level)”]. (In Russian.) Available at: http:// www.consultant.ru/document/cons_doc_LAW_204048/
7. Prikaz Ministerstva obrazovaniya i nauki Rossijskoj Federatsii ot 8 aprelya 2015 g. № 370 “Ob utverzhdenii federal’nogo gosudarstvennogo obrazovatel’nogo standarta vysshego obrazovaniya po napravleniyu podgotovki 38.04.05 Biznes-informatika (uroven’ magistratury)” [Order of the Ministry of Education and Science of Russian Federation dated April 8, 2016 No. 370 “On the approval of the Federal State Educational Standard of Higher Education in the field of preparation 38.04.05 Business Informatics (master’s level)”]. (In Russian.) Available at: http://fgosvo.ru/uploadfiles/fgosvom/380405.pdf
8. Prikaz Ministerstva truda i sotsial’noj zashhity Rossijskoj Federatsii ot 25 sentyabrya 2018 goda № 592n “Ob utverzhdenii professional’nogo standarta “Biznes-analitik”” [Order of the Ministry of Labor and Social Protection of the Russian Federation dated September 25, 2018 No. 592n “On approval of the professional standard “Business Analyst””]. (In Russian.) Available at: https://minjust.consultant.ru/documents/40700
9. Moore M. Mastering Excel: Power Query. 2016. 68 p.
10. Puls K., Escobar M. M is for (data) monkey. The Excel’s pro’s definitive guide to power query. Holy Macro! Books, 2015. 308 p.
11. Interaktivnoe obuchenie rabote s Microsoft Power BI [Microsoft Power BI interactive learning]. (In Russian.) Available at: https://docs.microsoft.com/ru-ru/power-bi/ guided-learning 12. Moore J., Wonderford L., Eppen G., Gould F., Schmidt C. Ehkonomicheskoe modelirovanie v Microsoft Excel (+ CD-ROM) [Decision Modeling with Microsoft Excel]. Moscow, Vil’yams, 2014. 1024 p. (In Russian.)
12. Neofitsial’noe otkrytoe metodicheskoe posobie k programme Power BI i nadstrojkam nad Excel Power Query i Power Pivot [Unofficial open tutorial for Power BI and Excel Power Query and Power Pivot add-ins]. (In Russian.) Available at: https://github.com/power-bi/PowerBI-book-ru
13. Pavlov N. Skul’ptor dannykh v Excel s Power Query (+primery) [Data sculptor in Excel with Power Query (+ examples)]. Moscow, De`Libri, 2019. 334 p. (In Russian.)
14. Walkenbach D. Microsoft Excel 2016. Bibliya pol’zovatelya [Microsoft Excel 2016. User Bible]. Moscow; Saint Petersburg, Dialektika, 2019. 1032 p. (In Russian.)
15. Chessman T. Znakomimsya s Microsoft Power Query [Meet Microsoft Power Query]. Windows IT Pro/RE, 2014, no. 1, p. 43. (In Russian.) Available at: https://www.osp.ru/winitpro/2014/01/13039194
Review
For citations:
Nazarov D.M., Nazarov A.D. Power Query: The formation of professional competencies of a business analyst. Informatics and education. 2020;(2):30-40. (In Russ.) https://doi.org/10.32517/0234-0453-2020-35-2-30-40