{"id":15543,"date":"2020-11-27T12:23:58","date_gmt":"2020-11-27T12:23:58","guid":{"rendered":"https:\/\/www.yuksekbilgili.com\/wordpress\/?p=15543"},"modified":"2024-03-23T10:15:36","modified_gmt":"2024-03-23T07:15:36","slug":"microsoft-power-bi-egitimi","status":"publish","type":"post","link":"https:\/\/www.yuksekbilgili.com\/wordpress\/microsoft-power-bi-egitimi\/","title":{"rendered":"Microsoft Power BI E\u011fitimi"},"content":{"rendered":"
\n\t

Online<\/p>

Microsoft Power BI E\u011fitimi<\/h1>\t\t\t\t\t
\n\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div><\/div><\/div><\/div>
\"\"<\/div>
\t\t\t

E\u011e\u0130T\u0130M\u0130N AMACI<\/strong><\/p>\n

Bu e\u011fitim program\u0131 ile kat\u0131l\u0131mc\u0131lar\u0131n, farkl\u0131 kaynaklardaki verilere ba\u011flanma, verileri alma, \u015fekillendirme ve d\u00f6n\u00fc\u015ft\u00fcrebilme, Hesaplama ve DAX fonksiyonlar\u0131n\u0131 kullanarak, verileri g\u00f6rselle\u015ftirecek ve rapora d\u00f6n\u00fc\u015ft\u00fcrebilecek, dashboard\u2019lar olu\u015fturabilecek, olu\u015fturulan bu dashboard ve raporlar\u0131 yay\u0131nlay\u0131p, payla\u015fabilecek bilgi ve deneyime sahip olmalar\u0131 hedeflenmektedir.<\/p>\n<\/div>\n\t\t<\/div><\/div>

\t\t\t

E\u011e\u0130T\u0130M\u0130N \u0130\u00c7ER\u0130\u011e\u0130<\/strong><\/p>\n

MOD\u00dcL 1<\/u><\/p>\n

POWER BI G\u0130R\u0130\u015e<\/p>\n

    \n
  • Power BI Desktop<\/li>\n
  • Power BI Desktop se\u00e7eneklerini \u00f6zelle\u015ftirme<\/li>\n
  • Power BI Servis<\/li>\n
  • Power BI Mobil<\/li>\n<\/ul>\n

    VER\u0130 ALMA<\/p>\n

      \n
    • Power BI Desktop ile veri kaynaklar\u0131na ba\u011flanma<\/li>\n
    • Text ve CSV dosyalar\u0131na ba\u011flanma<\/li>\n
    • Excel ve Access dosyalar\u0131na ba\u011flanma<\/li>\n
    • Web kaynaklar\u0131na ba\u011flanma<\/li>\n
    • SQL ba\u011flant\u0131 olu\u015fturma ve i\u00e7eri aktarma<\/li>\n
    • Power Query Edit\u00f6r\u00fcn\u00fc tan\u0131ma<\/li>\n
    • Power Query ile verileri temizleme ve d\u00f6n\u00fc\u015ft\u00fcrme<\/li>\n
    • Veri tiplerini d\u00fczenlemek<\/li>\n
    • Tarihsel s\u00fctunlarla \u00e7al\u0131\u015fmak ve tarihsel d\u00f6n\u00fc\u015f\u00fcmler<\/li>\n
    • S\u00fctun ba\u015fl\u0131klar\u0131 ve s\u00fct\u00fcn yerle\u015fimlerini d\u00fczenlemek<\/li>\n
    • Mevcut s\u00fctunlardan yeni s\u00fctunlar olu\u015fturmak<\/li>\n
    • D\u00fczensiz bi\u00e7imdeki verileri temizleme<\/li>\n
    • Pivot ve Unpivot ile sorguyu d\u00fczenlemek<\/li>\n
    • Sorgular\u0131 devrik d\u00f6n\u00fc\u015ft\u00fcrme<\/li>\n
    • \u00d6rneklerden S\u00fctun ekleme (Column From Example)<\/li>\n
    • \u00d6zel s\u00fctun ekleme (Custum Columns)<\/li>\n
    • Sorgular\u0131 Birle\u015ftirme (Merge, Append)<\/li>\n
    • Parametre Kullan\u0131m\u0131<\/li>\n<\/ul>\n

      VER\u0130 MODELLEME<\/p>\n

        \n
      • Veri modellemeye giri\u015f<\/li>\n
      • Tablolar aras\u0131 ili\u015fki olu\u015fturmak ve ili\u015fki y\u00f6netimi<\/li>\n
      • Otomatik ili\u015fki alg\u0131lama ve bu \u00f6zelli\u011fin devre d\u0131\u015f\u0131 b\u0131rak\u0131lmas\u0131<\/li>\n
      • \u0130li\u015fkilerde kardinalite (bire-bir, bire- \u00e7ok, \u00e7oka -\u00e7ok)<\/li>\n
      • \u0130li\u015fkide filtre y\u00f6n\u00fc<\/li>\n
      • \u0130ki tablo aras\u0131nda birden fazla ili\u015fki y\u00f6netimi<\/li>\n
      • Hesaplanm\u0131\u015f tablolar olu\u015fturmak<\/li>\n<\/ul>\n

        MOD\u00dcL 2<\/u><\/p>\n

        HESAPLAMALAR VE DAX KULLANIMI<\/p>\n

          \n
        • Hesaplanm\u0131\u015f s\u00fctun olu\u015fturmak<\/li>\n
        • Hesaplanm\u0131\u015f \u00f6l\u00e7\u00fc olu\u015fturmak<\/li>\n
        • Hesaplanm\u0131\u015f s\u00fctun ve \u00f6l\u00e7\u00fc fark\u0131<\/li>\n
        • Hesaplanm\u0131\u015f tablo olu\u015fturmak<\/li>\n
        • Tarih tablosu olu\u015fturma<\/li>\n
        • CALENDER<\/li>\n
        • CALENDERAUTO<\/li>\n
        • Temel Fonksiyonlar<\/li>\n
        • Aggregation (SUM, AVERAGE, MAX, MIN)<\/li>\n
        • Iteration (SUMX, AVERAGEX, MINX, MAXX)<\/li>\n
        • Aggregation ve Iteration kar\u015f\u0131la\u015ft\u0131rma<\/li>\n
        • Tarih ve ak\u0131ll\u0131 zaman fonksiyonlar\u0131<\/li>\n
        • DATE, YEAR, MONT, DAY, WEEKDAY<\/li>\n
        • EOMONTH<\/li>\n
        • DATEDIFF<\/li>\n
        • DATEADD<\/li>\n
        • MTD, QTD, YTD<\/li>\n
        • TOTALMTD, TOTALQTD, TOTALYTD<\/li>\n
        • SAMEPERIODLASTYEAR<\/li>\n
        • Sayma Fonksiyonlar\u0131\n
            \n
          • COUNT<\/li>\n
          • COUNTA<\/li>\n
          • COUNTBLANK<\/li>\n
          • COUNTROWS<\/li>\n
          • DISTINCTCOUNT<\/li>\n<\/ul>\n<\/li>\n
          • Mant\u0131ksal Fonksiyonlar\n
              \n
            • AND, OR, NOT<\/li>\n
            • IF, IFERROR<\/li>\n<\/ul>\n<\/li>\n
            • Bilgi Fonksiyonlar\u0131\n
                \n
              • ISBANK, ISERROR<\/li>\n
              • ISTEXT, ISNONTEXT, ISNUMBER<\/li>\n<\/ul>\n<\/li>\n
              • Metin Fonksiyonlar\u0131\n
                  \n
                • CONCATENATE, CONCATENATEX<\/li>\n
                • REPLACE, SEARCH<\/li>\n
                • UPPER, LOWER, FIXED<\/li>\n<\/ul>\n<\/li>\n
                • Filtre Fonksiyonlar\u0131\n
                    \n
                  • FILTER<\/li>\n
                  • ALL, ALLSELECTED, ALLEXCEPTED<\/li>\n
                  • VALUE, HASONVALUE, SELECTEDVALUE<\/li>\n<\/ul>\n<\/li>\n
                  • Di\u011fer Geli\u015fmi\u015f Fonksiyonlar<\/li>\n
                  • CALCULATE Fonksiyonu<\/li>\n
                  • CALCULATE ve FILTER birlikte kullan\u0131m\u0131<\/li>\n
                  • REALTED, REALTEDTABLE ve USERELATION kullan\u0131m\u0131<\/li>\n
                  • LOOKUPVALUE<\/li>\n
                  • DIVIDE, POWER<\/li>\n
                  • GENERATESERIES<\/li>\n
                  • CHOOSE, SWITCH<\/li>\n<\/ul>\n

                    MOD\u00dcL 3<\/u><\/p>\n

                    VER\u0130LER\u0130 G\u00d6RSELLE\u015eT\u0130RME<\/p>\n

                      \n
                    • Power BI\u2019daki G\u00f6rsellere Giri\u015f<\/li>\n
                    • G\u00f6rsel bi\u00e7imlerini d\u00fczenleme<\/li>\n
                    • Tema kullan\u0131m\u0131<\/li>\n
                    • Karma Grafikler<\/li>\n
                    • Dilimleyiciler ve \u00f6zellikleri<\/li>\n
                    • Harita g\u00f6rselle\u015ftirmeleri<\/li>\n
                    • Matrisler ve tablolar<\/li>\n
                    • Da\u011f\u0131l\u0131m \u00c7izelgeleri<\/li>\n
                    • \u015eelale ve huni \u00e7izelgeleri<\/li>\n
                    • Gauges ve tek say\u0131 kartlar<\/li>\n
                    • \u00c7izelgeler ve g\u00f6rsellerdeki renkleri de\u011fi\u015ftirme<\/li>\n
                    • \u015eekiller, metin kutular\u0131 ve resimler<\/li>\n
                    • Sayfa d\u00fczeni ve bi\u00e7im ayarlar\u0131<\/li>\n
                    • Bir Rapor Sayfas\u0131n\u0131 Kopyalama<\/li>\n
                    • Veri olmayan kay\u0131tlar\u0131 g\u00f6sterme<\/li>\n
                    • Ba\u015fka alana g\u00f6re s\u0131ralama<\/li>\n
                    • \u0130pucu \u00f6zelli\u011fini kullanmak<\/li>\n
                    • Ba\u015fka bir ipucu sayfas\u0131 olu\u015fturma<\/li>\n
                    • G\u00f6rsel hiyerar\u015filer ve drill-down<\/li>\n
                    • G\u00f6rsellerde etkile\u015fimleri d\u00fczenlemek<\/li>\n
                    • Filtreleme<\/li>\n
                    • Sayfaya filtre uygulamak<\/li>\n
                    • Rapora filtre uygulamak<\/li>\n
                    • Top N, Bottom N filtreler<\/li>\n
                    • Drill-through \u00f6zelli\u011fi ile ba\u015fka sayfaya filtreli ge\u00e7i\u015f<\/li>\n
                    • Bookmark ve se\u00e7im panel kullan\u0131m\u0131<\/li>\n
                    • Sat\u0131r d\u00fczeyi g\u00fcvenlik<\/li>\n
                    • Tarihe g\u00f6re dinamik filtrelerle \u00e7al\u0131\u015fmak<\/li>\n<\/ul>\n

                      DASHBOARD VE RAPORLARI YAYIMLAMA VE PAYLA\u015eMA<\/p>\n

                        \n
                      • Power BI Service\u2019i tan\u0131ma<\/li>\n
                      • Power BI Desktop raporlar\u0131n\u0131 yay\u0131nlamak<\/li>\n
                      • Mobil g\u00f6r\u00fcn\u00fcmleri ayarlamak<\/li>\n
                      • Raporlar\u0131 yazd\u0131rma ve d\u0131\u015far\u0131ya aktarma<\/li>\n
                      • Dashboard Olu\u015fturma ve Yap\u0131land\u0131rma<\/li>\n
                      • Kurum i\u00e7i Dashboardlar\u2019\u0131 Payla\u015fma<\/li>\n
                      • Gateway Kullan\u0131m\u0131 ve veri g\u00fcncelleme<\/li>\n
                      • Analyze In Excel<\/li>\n<\/ul>\n<\/div>\n\t\t<\/div><\/div>

                        Detayl\u0131 Bilgiler<\/h3>\t\t\t
                        <\/div>\n\t\t<\/div><\/div><\/div>
                        \n
                        \n\t\t\t<\/span>\t<\/div>\n<\/div><\/div><\/div>
                        \t\t\t

                        2 g\u00fcn | 14 Saat<\/p>\n<\/div>\n\t\t<\/div><\/div>

                        <\/div><\/div>
                        \n
                        \n\t\t\t<\/span>\t<\/div>\n<\/div><\/div><\/div>
                        \t\t\t

                        S\u0131n\u0131f E\u011fitimi veya \u00c7evrimi\u00e7i (Online)<\/p>\n<\/div>\n\t\t<\/div><\/div>

                        <\/div><\/div>
                        \n
                        \n\t\t\t<\/span>\t<\/div>\n<\/div><\/div><\/div>
                        \t\t\t

                        Maksimum 20 Ki\u015fi<\/p>\n<\/div>\n\t\t<\/div><\/div>

                        <\/div><\/div><\/div><\/div><\/div>

                        E\u011fitim Teklifi Al\u0131n<\/h3>\t\t\t