{"id":1755,"date":"2020-02-20T14:24:53","date_gmt":"2020-02-20T11:24:53","guid":{"rendered":"http:\/\/bymmb.com\/?p=1755"},"modified":"2020-02-20T14:25:43","modified_gmt":"2020-02-20T11:25:43","slug":"power-querypower-pivotpower-bidaxveri-analizi2020","status":"publish","type":"post","link":"https:\/\/bymmb.com\/power-querypower-pivotpower-bidaxveri-analizi2020\/","title":{"rendered":"Power Query|Power Pivot|Power BI|DAX|Veri Analizi|2020"},"content":{"rendered":"<p><a href=\"http:\/\/bymmb.com\/wp-content\/uploads\/2020\/02\/2775682_62fe.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1756\" src=\"http:\/\/bymmb.com\/wp-content\/uploads\/2020\/02\/2775682_62fe-300x169.jpg\" alt=\"\" width=\"300\" height=\"169\"><\/a><\/p>\n<p><a href=\"http:\/\/bymmb.com\/online-egitimlerim\/\" target=\"_blank\" rel=\"noopener noreferrer\">E\u011fitime kat\u0131lmak i\u00e7in t\u0131klay\u0131n.<\/a><\/p>\n<ul class=\"udlite-block-list\">\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Veri analizine s\u0131f\u0131rdan ba\u015flay\u0131p, ileri noktalara ta\u015f\u0131yacaks\u0131n\u0131z.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Pivot Tablolar ile h\u0131zl\u0131 ve interaktif raporlama yapmay\u0131 \u00f6\u011freneceksiniz.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Veri Modeli olu\u015fturmay\u0131 ve B\u00fcy\u00fck Verilerle \u00e7al\u0131\u015fmay\u0131 g\u00f6receksiniz.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Kendi \u0130\u015f Zekas\u0131 ara\u00e7lar\u0131n\u0131z\u0131 olu\u015fturabileceksiniz.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Karma\u015f\u0131k DAX form\u00fcllerini kullanabileceksiniz.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">BI ara\u00e7lar\u0131 ile Veri G\u00f6rselle\u015ftirme konusunda uzmanla\u015facaks\u0131n\u0131z.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">\u0130nteraktif Dashboard raporlar tasarlayabileceksiniz.<\/span><\/div>\n<\/li>\n<li>\n<div class=\"udlite-text-md udlite-block-list-item udlite-block-list-item-large udlite-text-md udlite-block-list-item-tight udlite-block-list-item-neutral\" data-purpose=\"objective\"><span class=\"udlite-block-list-item-content\">Tablo ili\u015fkileri ve Sorgular konusunda ileri d\u00fczey bilgiler edineceksiniz.<\/span><\/div>\n<\/li>\n<\/ul>\n<p>Ders 1:Power Nedir, Ne \u0130\u015fe Yarar?<br \/>\nDers 2:Kurs Metodolojisi<br \/>\nDers 3:Bilgilendirme<br \/>\nDers 4:Hangi Excel S\u00fcr\u00fcmlerini Kullanmal\u0131s\u0131n\u0131z?<br \/>\nB\u00f6l\u00fcm 2:Power Query<br \/>\nDers 5:E\u011fitim Dosyalar\u0131<br \/>\nDers 6:Aray\u00fcz<br \/>\nDers 7:Giri\u015f Sekmesi<br \/>\nDers 8:D\u00f6n\u00fc\u015ft\u00fcr Sekmesi<br \/>\nDers 9:S\u00fctun Ekle Sekmesi<br \/>\nDers 10:Sorgular\u0131 Birle\u015ftirmek<br \/>\nDers 11:Sorgular\u0131 Eklemek<br \/>\nDers 12:Tablosal Veriyi S\u00fctunsal Hale Getirmek<br \/>\nDers 13:Yinelenen De\u011ferler Hari\u00e7 Veri Do\u011frulama Olu\u015fturmak<br \/>\nDers 14:Tarihsel Filtreye G\u00f6re Veri Ay\u0131rmak<br \/>\nDers 15:Gruplanan Verilerle \u0130\u015flem Yapmak<br \/>\nB\u00f6l\u00fcm 3:Power Pivot<br \/>\nDers 16:Power Pivot Giri\u015f<br \/>\nDers 17:Veri Modeli Olu\u015fturmak<br \/>\nDers 18:Farkl\u0131 Kaynaklardan Gelen Datalar\u0131 \u0130\u00e7eri Aktarmak<br \/>\nDers 19:Related Fonksiyonu ile \u0130\u015flem Yapmak<br \/>\nDers 20:Year-Month-Format Fonksiyonlar\u0131n\u0131n Kullan\u0131m\u0131<br \/>\nDers 21:\u00d6l\u00e7\u00fc Olu\u015fturmak<br \/>\nDers 22:Hiyerar\u015fi Olu\u015fturmak<br \/>\nB\u00f6l\u00fcm 4:DAX(S\u0131k Kullan\u0131lan Fonksiyonlar)<br \/>\nDers 23:Dax Operat\u00f6rleri<br \/>\nDers 24:Sum-Average-Max-Min Fonksiyonlar\u0131<br \/>\nDers 25:Countrows-Count-Counta-Distinctcount Fonksyionlar\u0131<br \/>\nDers 26:IF-AND-OR Fonksiyonlar\u0131<br \/>\nDers 27:Switch-LEN-CONCETENATE-LEFT-MID-RIGHT-UPPER-LOWER Fonksiyonlar\u0131<br \/>\nDers 28:Sumx-Filter-Countx-Calculate Fonksyionlar\u0131<br \/>\nDers 29:Day-Month-Year-Now-Today-Weekday-Dateiff Fonksyionlar\u0131<br \/>\nB\u00f6l\u00fcm 5:Power BI<br \/>\nDers 30:Power BI Kurulumu<br \/>\nDers 31:Power BI Kaynak Dosyalar\u0131<br \/>\nDers 32:Aray\u00fcz &#8211; Veri Aktarma &#8211; Sorgu Ekran\u0131 ve Tablo \u0130li\u015fkileri-H\u0131zl\u0131 Bir Bak\u0131\u015f<br \/>\nDers 33:Harita \u2013 Ara\u00e7 \u0130p U\u00e7lar\u0131 \u2013 Grafik \u0130li\u015fkileri \u2013 Dilimleyici &#8211; Kartlar<br \/>\nDers 34:Klas\u00f6rden Y\u00fckleme Yapmak &#8211; Tarih Dilimleyicisi<br \/>\nDers 35:Online Ortamdan G\u00f6rsel \u00d6zellik Eklemek \u2013 Manuel Veri Giri\u015fi<br \/>\nDers 36:Dilimleyici Senkronizasyonu<br \/>\nDers 37:Web&#8217;den Veri Alarak Rapor Olu\u015fturmak<br \/>\nDers 38:\u00d6l\u00e7\u00fcler &#8211; \u00d6l\u00e7\u00fc Katmanlama &#8211; Gaugh Chart<br \/>\nDers 39:Rankx ve Ko\u015fullu Bi\u00e7imlendirme<br \/>\nDers 40:Calculate ve All<br \/>\nDers 41:K\u00fcm\u00fclatif Toplam Olu\u015fturmak<br \/>\nDers 42:Zamansal Zeka Fonksiyonlar\u0131(Time Intelligence)<br \/>\nDers 43:Gizlenebilir Filtre Alan\u0131 (Bookmark)<br \/>\nDers 44:#Proje 1 (1. B\u00f6l\u00fcm)<br \/>\nDers 45:#Proje 1 (2. B\u00f6l\u00fcm)<br \/>\nDers 46:#Proje 1 (3. B\u00f6l\u00fcm)<br \/>\nDers 47:#Proje 1 (4. B\u00f6l\u00fcm)<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>E\u011fitime kat\u0131lmak i\u00e7in t\u0131klay\u0131n. Veri analizine s\u0131f\u0131rdan ba\u015flay\u0131p, ileri noktalara ta\u015f\u0131yacaks\u0131n\u0131z. Pivot Tablolar ile h\u0131zl\u0131 ve interaktif raporlama yapmay\u0131 \u00f6\u011freneceksiniz. Veri Modeli olu\u015fturmay\u0131 ve B\u00fcy\u00fck Verilerle \u00e7al\u0131\u015fmay\u0131 g\u00f6receksiniz. Kendi \u0130\u015f&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1756,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_joinchat":[],"footnotes":""},"categories":[690,689],"tags":[1028,1026,1029,1023,1024,1025,1027,1030,1031],"acf":[],"views":736,"taxonomy_info":{"category":[{"value":690,"label":"Dashboard \u00d6rnekleri"},{"value":689,"label":"Online E\u011fitimler"}],"post_tag":[{"value":1028,"label":"dashboard"},{"value":1026,"label":"dax"},{"value":1029,"label":"online raporlama"},{"value":1023,"label":"power bi"},{"value":1024,"label":"power pivot"},{"value":1025,"label":"power query"},{"value":1027,"label":"sorgu e\u011fitimi"},{"value":1030,"label":"veri analizi"},{"value":1031,"label":"veri bilimi"}]},"featured_image_src_large":["https:\/\/bymmb.com\/wp-content\/uploads\/2020\/02\/2775682_62fe-1024x576-1582197840.jpg",1024,576,true],"author_info":{"display_name":"bymmb","author_link":"https:\/\/bymmb.com\/author\/bymmb\/"},"comment_info":0,"category_info":[{"term_id":690,"name":"Dashboard \u00d6rnekleri","slug":"dashboard-ornekleri","term_group":0,"term_taxonomy_id":690,"taxonomy":"category","description":"","parent":0,"count":18,"filter":"raw","cat_ID":690,"category_count":18,"category_description":"","cat_name":"Dashboard \u00d6rnekleri","category_nicename":"dashboard-ornekleri","category_parent":0},{"term_id":689,"name":"Online E\u011fitimler","slug":"online-egitimler","term_group":0,"term_taxonomy_id":689,"taxonomy":"category","description":"","parent":0,"count":10,"filter":"raw","cat_ID":689,"category_count":10,"category_description":"","cat_name":"Online E\u011fitimler","category_nicename":"online-egitimler","category_parent":0}],"tag_info":[{"term_id":1028,"name":"dashboard","slug":"dashboard","term_group":0,"term_taxonomy_id":1028,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1026,"name":"dax","slug":"dax","term_group":0,"term_taxonomy_id":1026,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1029,"name":"online raporlama","slug":"online-raporlama","term_group":0,"term_taxonomy_id":1029,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1023,"name":"power bi","slug":"power-bi","term_group":0,"term_taxonomy_id":1023,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"},{"term_id":1024,"name":"power pivot","slug":"power-pivot","term_group":0,"term_taxonomy_id":1024,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1025,"name":"power query","slug":"power-query","term_group":0,"term_taxonomy_id":1025,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1027,"name":"sorgu e\u011fitimi","slug":"sorgu-egitimi","term_group":0,"term_taxonomy_id":1027,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1030,"name":"veri analizi","slug":"veri-analizi","term_group":0,"term_taxonomy_id":1030,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":1031,"name":"veri bilimi","slug":"veri-bilimi","term_group":0,"term_taxonomy_id":1031,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/1755"}],"collection":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/comments?post=1755"}],"version-history":[{"count":0,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/posts\/1755\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media\/1756"}],"wp:attachment":[{"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/media?parent=1755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/categories?post=1755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bymmb.com\/wp-json\/wp\/v2\/tags?post=1755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}