{"id":1898,"date":"2022-05-19T04:48:43","date_gmt":"2022-05-19T04:48:43","guid":{"rendered":"https:\/\/new.liedm.lt\/?p=1898"},"modified":"2022-05-19T12:30:43","modified_gmt":"2022-05-19T12:30:43","slug":"nuotoliniai-mokymai-ms-excel-pazengusiems-duomenu-analize-su-power-query-ir-power-pivot","status":"publish","type":"post","link":"https:\/\/www.liedm.lt\/index.php\/nuotoliniai-mokymai-ms-excel-pazengusiems-duomenu-analize-su-power-query-ir-power-pivot\/","title":{"rendered":"Nuotoliniai mokymai &#8222;MS\u00a0Excel\u00a0pa\u017eengusiems. Duomen\u0173 analiz\u0117 su Power Query ir Power Pivot&#8221;"},"content":{"rendered":"\n<p>2022 m. gegu\u017e\u0117s 19 d. vyko mokymai, skirti tiems, kas savo darbe naudoja MS OFFICE 365 paketo program\u0105 MS EXCEL.<br>Per mokymus lektorius i\u0161samiai pristat\u0117 ir pademonstravo MS Excel Power \u012frankius Power Query ir Power Pivot, duomen\u0173 importavimo i\u0161 \u012fvairi\u0173 \u0161altini\u0173 (CSV, MS Excel lenteli\u0173 ir kt.) galimybes ir ypatumus, duomen\u0173 sutvarkymo ir i\u0161valymo proces\u0105, duomen\u0173 modelio parengim\u0105, taip pat \u012fvad\u0105 \u012f programavimo kalb\u0105 DAX (Data Analysis Expressions).<\/p>\n\n\n\n<p>Mokymus ved\u0117 dr. Saulius Preidys (Vilniaus universitetas).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>2022 m. gegu\u017e\u0117s 19 d. vyko mokymai, skirti tiems, kas savo darbe naudoja MS OFFICE 365 paketo program\u0105 MS EXCEL.Per mokymus lektorius i\u0161samiai pristat\u0117 ir pademonstravo MS Excel Power \u012frankius Power Query ir Power Pivot, duomen\u0173 importavimo i\u0161 \u012fvairi\u0173 \u0161altini\u0173 (CSV, MS Excel lenteli\u0173 ir kt.) galimybes ir ypatumus, duomen\u0173 sutvarkymo ir i\u0161valymo proces\u0105, duomen\u0173 modelio parengim\u0105, taip pat \u012fvad\u0105 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1923,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1898","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-naujienos"],"gutentor_comment":0,"_links":{"self":[{"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/posts\/1898","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/comments?post=1898"}],"version-history":[{"count":0,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/posts\/1898\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/media\/1923"}],"wp:attachment":[{"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/media?parent=1898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/categories?post=1898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.liedm.lt\/index.php\/wp-json\/wp\/v2\/tags?post=1898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}