Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber<\/title>\n\n \n <meta name=\"description\"\n content=\"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Stratejik yorumdan pratik implementasyona, \u00f6rnek veri seti olu\u015fturmadan sanity check'lere kadar kapsaml\u0131 rehber.\">\n <meta name=\"keywords\"\n content=\"Power BI, cohort analizi, LTV, retention analizi, payment processing, veri analizi, DAX, Power Query\">\n <meta name=\"author\" content=\"Verintra\">\n\n \n <meta property=\"og:title\" content=\"Payment Processing i\u00e7in Power BI Cohort Analizi \u2014 Kapsaml\u0131 Rehber\">\n <meta property=\"og:description\"\n content=\"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Python \u00f6rnek veri kodu ile birlikte.\">\n <meta property=\"og:type\" content=\"article\">\n <meta property=\"og:url\" content=\"https:\/\/verintra.com\/blog\/power-bi-cohort-analizi\">\n <meta property=\"og:image\" content=\"https:\/\/verintra.com\/images\/power-bi-cohort-og.jpg\">\n <meta property=\"og:site_name\" content=\"Verintra\">\n\n \n <meta name=\"twitter:card\" content=\"summary_large_image\">\n <meta name=\"twitter:title\" content=\"Payment Processing i\u00e7in Power BI Cohort Analizi\">\n <meta name=\"twitter:description\"\n content=\"Kapsaml\u0131 Power BI cohort analizi rehberi. Python kodu, DAX \u00f6rnekleri ve ger\u00e7ek d\u00fcnya uygulamalar\u0131.\">\n <meta name=\"twitter:image\" content=\"https:\/\/verintra.com\/images\/power-bi-cohort-twitter.jpg\">\n\n \n <script type=\"application\/ld+json\">\n {\n \"@context\": \"https:\/\/schema.org\",\n \"@type\": \"TechArticle\",\n \"headline\": \"Payment Processing i\u00e7in Power BI Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber\",\n \"description\": \"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Stratejik yorumdan pratik implementasyona, \u00f6rnek veri seti olu\u015fturmadan sanity check'lere kadar her \u015fey bu rehberde.\",\n \"image\": \"https:\/\/verintra.com\/images\/power-bi-cohort-featured.jpg\",\n \"author\": {\n \"@type\": \"Organization\",\n \"name\": \"Verintra\",\n \"url\": \"https:\/\/verintra.com\"\n },\n \"publisher\": {\n \"@type\": \"Organization\",\n \"name\": \"Verintra\",\n \"logo\": {\n \"@type\": \"ImageObject\",\n \"url\": \"https:\/\/verintra.com\/logo.png\"\n }\n },\n \"datePublished\": \"2025-08-23T10:00:00+03:00\",\n \"dateModified\": \"2025-08-23T10:00:00+03:00\",\n \"mainEntityOfPage\": {\n \"@type\": \"WebPage\",\n \"@id\": \"https:\/\/verintra.com\/blog\/power-bi-cohort-analizi\"\n },\n \"articleSection\": \"Veri Analizi\",\n \"keywords\": [\"Power BI\", \"cohort analizi\", \"LTV\", \"retention analizi\", \"payment processing\", \"veri analizi\", \"DAX\", \"Power Query\"],\n \"about\": [\n {\n \"@type\": \"Thing\",\n \"name\": \"Power BI\"\n },\n {\n \"@type\": \"Thing\", \n \"name\": \"Cohort Analizi\"\n },\n {\n \"@type\": \"Thing\",\n \"name\": \"LTV Analizi\"\n }\n ],\n \"teaches\": [\n \"Power BI ile cohort analizi kurulumu\",\n \"DAX measure'lar\u0131 yazma\",\n \"Python ile \u00f6rnek veri olu\u015fturma\",\n \"Retention analizi yapma\"\n ]\n }\n <\/script>\n\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n\n body {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, sans-serif;\n line-height: 1.6;\n color: #ffffff;\n background-color: #1e1d20;\n }\n\n .container {\n max-width: 1200px;\n margin: 0 auto;\n padding: 0 1.5rem;\n }\n\n .blog-header {\n background: linear-gradient(to bottom, #3eb3d1, #05767d);\n padding: 4rem 0;\n text-align: left;\n }\n\n .category-tags {\n font-size: 0.875rem;\n text-transform: uppercase;\n letter-spacing: 0.1em;\n color: rgba(255, 255, 255, 0.8);\n margin-bottom: 1rem;\n }\n\n .main-title {\n font-size: clamp(2rem, 4vw, 3rem);\n font-weight: 700;\n line-height: 1.2;\n margin-bottom: 1.5rem;\n }\n\n .title-subtitle {\n color: rgba(255, 255, 255, 0.9);\n }\n\n .lead-text {\n font-size: 1.125rem;\n color: rgba(255, 255, 255, 0.9);\n margin-bottom: 2rem;\n line-height: 1.6;\n }\n\n .meta-info {\n display: flex;\n flex-wrap: wrap;\n gap: 1rem;\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.8);\n }\n\n .blog-content {\n padding: 3rem 0;\n }\n\n .toc-box {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n margin-bottom: 3rem;\n border: 1px solid #374151;\n }\n\n .toc-title {\n font-size: 1.25rem;\n font-weight: 700;\n color: #3eb3d1;\n margin-bottom: 1rem;\n }\n\n .toc-list {\n list-style: none;\n padding: 0;\n }\n\n .toc-list li {\n margin-bottom: 0.5rem;\n }\n\n .toc-list a {\n color: rgba(255, 255, 255, 0.8);\n text-decoration: none;\n font-size: 0.875rem;\n transition: color 0.3s ease;\n }\n\n .toc-list a:hover {\n color: #3eb3d1;\n }\n\n .content-section {\n margin-bottom: 3rem;\n }\n\n .section-title {\n font-size: 1.5rem;\n font-weight: 700;\n color: #3eb3d1;\n margin-bottom: 1.5rem;\n }\n\n .content-text {\n font-size: 1.125rem;\n color: rgba(255, 255, 255, 0.9);\n margin-bottom: 1.5rem;\n line-height: 1.6;\n }\n\n .highlight-box {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border-left: 4px solid #3eb3d1;\n margin-bottom: 1.5rem;\n }\n\n .highlight-list {\n list-style: none;\n padding: 0;\n }\n\n .highlight-list li {\n display: flex;\n align-items: flex-start;\n gap: 0.75rem;\n margin-bottom: 0.75rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .list-bullet {\n color: #3eb3d1;\n font-weight: bold;\n margin-top: 0.25rem;\n }\n\n .data-table {\n width: 100%;\n background-color: #000000;\n border-radius: 0.5rem;\n border: 1px solid #374151;\n overflow-x: auto;\n margin-bottom: 1.5rem;\n }\n\n .data-table table {\n width: 100%;\n border-collapse: collapse;\n }\n\n .data-table th {\n padding: 1rem;\n text-align: left;\n font-weight: 600;\n background-color: rgba(62, 179, 209, 0.2);\n }\n\n .data-table td {\n padding: 1rem;\n border-top: 1px solid #374151;\n font-size: 0.875rem;\n }\n\n .field-name {\n font-family: 'Courier New', monospace;\n color: #3eb3d1;\n }\n\n .warning-box {\n background-color: rgba(249, 115, 22, 0.2);\n border: 1px solid rgba(249, 115, 22, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-bottom: 1.5rem;\n }\n\n .warning-text {\n color: #fed7aa;\n }\n\n .code-inline {\n background-color: rgba(0, 0, 0, 0.5);\n padding: 0.25rem 0.5rem;\n border-radius: 0.25rem;\n font-family: 'Courier New', monospace;\n font-size: 0.875rem;\n }\n\n .steps-list {\n list-style: none;\n padding: 0;\n }\n\n .steps-list li {\n display: flex;\n gap: 0.75rem;\n margin-bottom: 0.75rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .step-number {\n background-color: #3eb3d1;\n color: #000;\n font-weight: 700;\n padding: 0.25rem 0.5rem;\n border-radius: 0.25rem;\n font-size: 0.875rem;\n min-width: 2rem;\n text-align: center;\n }\n\n .code-block {\n background-color: #1e1e1e;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border: 1px solid #35C7D6;\n margin-bottom: 1.5rem;\n overflow-x: auto;\n}\n\n .code-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 1rem;\n }\n\n .code-title {\n font-weight: 600;\n color: #3eb3d1;\n }\n\n .copy-button {\n font-size: 0.75rem;\n background-color: #3eb3d1;\n color: #000;\n padding: 0.25rem 0.75rem;\n border-radius: 0.25rem;\n border: none;\n cursor: pointer;\n transition: background-color 0.3s ease;\n }\n\n .copy-button:hover {\n background-color: rgba(62, 179, 209, 0.8);\n }\n\n pre {\n font-family: 'Courier New', Consolas, Monaco, monospace;\n font-size: 0.875rem;\n color: #000000;\n overflow-x: auto;\n line-height: 1.6;\n \n margin: 0;\n}\n\n\/* DAX keyword'leri i\u00e7in *\/\npre .keyword {\n color: #569cd6;\n font-weight: 600;\n}\n\n\/* Fonksiyon isimleri i\u00e7in *\/\npre .function {\n color: #dcdcaa;\n}\n\n\/* String'ler i\u00e7in *\/\npre .string {\n color: #ce9178;\n}\n\n\/* Yorum sat\u0131rlar\u0131 i\u00e7in *\/\npre .comment {\n color: #6a9955;\n font-style: italic;\n}\n\n .info-box {\n background-color: rgb(0, 0, 0);\n border: 1px solid rgba(34, 197, 94, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-bottom: 1.5rem;\n }\n\n .info-text {\n color: #bbf7d0;\n }\n\n .tip-box {\n background-color: rgba(59, 130, 246, 0.2);\n border: 1px solid rgba(59, 130, 246, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-top: 1.5rem;\n }\n\n .tip-text {\n color: #bfdbfe;\n }\n\n .error-box {\n background-color: rgba(239, 68, 68, 0.2);\n border: 1px solid rgba(239, 68, 68, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n }\n\n .error-text {\n color: #fecaca;\n }\n\n .stats-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n gap: 1.5rem;\n margin-bottom: 2rem;\n }\n\n .stats-card {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border: 1px solid #374151;\n }\n\n .stats-title {\n font-weight: 600;\n color: #3eb3d1;\n margin-bottom: 1rem;\n }\n\n .stats-item {\n display: flex;\n justify-content: space-between;\n margin-bottom: 0.5rem;\n font-size: 0.875rem;\n }\n\n .stats-value {\n font-family: 'Courier New', monospace;\n }\n\n .action-section {\n background: linear-gradient(to right, #3eb3d1, #05767d);\n border-radius: 0.5rem;\n padding: 2rem;\n text-align: center;\n margin-top: 3rem;\n }\n\n .action-title {\n font-size: 1.5rem;\n font-weight: 700;\n margin-bottom: 1rem;\n }\n\n .action-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));\n gap: 1.5rem;\n margin-bottom: 1.5rem;\n }\n\n .action-card {\n background-color: rgba(0, 0, 0, 0.2);\n border-radius: 0.5rem;\n padding: 1rem;\n }\n\n .action-icon {\n font-size: 1.5rem;\n margin-bottom: 0.5rem;\n }\n\n .action-card-title {\n font-weight: 600;\n margin-bottom: 0.5rem;\n }\n\n .action-card-text {\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .cta-buttons {\n display: flex;\n flex-direction: column;\n gap: 0.75rem;\n align-items: center;\n }\n\n .cta-primary {\n display: inline-block;\n background-color: #ffffff;\n color: #3eb3d1;\n padding: 0.75rem 1.5rem;\n border-radius: 0.5rem;\n text-decoration: none;\n font-weight: 600;\n transition: background-color 0.3s ease;\n }\n\n .cta-primary:hover {\n background-color: rgba(255, 255, 255, 0.9);\n }\n\n .cta-secondary {\n display: inline-block;\n background-color: rgba(0, 0, 0, 0.3);\n color: #ffffff;\n padding: 0.75rem 1.5rem;\n border-radius: 0.5rem;\n text-decoration: none;\n font-weight: 600;\n transition: background-color 0.3s ease;\n }\n\n .cta-secondary:hover {\n background-color: rgba(0, 0, 0, 0.4);\n }\n\n .blog-footer {\n margin-top: 4rem;\n padding-top: 2rem;\n border-top: 1px solid #374151;\n }\n\n .footer-content {\n display: flex;\n flex-wrap: wrap;\n justify-content: space-between;\n align-items: center;\n gap: 1rem;\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.6);\n }\n\n .footer-links {\n display: flex;\n gap: 1rem;\n }\n\n .footer-links a {\n color: #3eb3d1;\n text-decoration: none;\n transition: color 0.3s ease;\n }\n\n .footer-links a:hover {\n color: #ffffff;\n }\n\n @media (max-width: 768px) {\n .container {\n padding: 0 1rem;\n }\n\n .blog-header {\n padding: 2rem 0;\n }\n\n .meta-info {\n flex-direction: column;\n gap: 0.5rem;\n }\n\n .stats-grid {\n grid-template-columns: 1fr;\n }\n\n .action-grid {\n grid-template-columns: 1fr;\n }\n\n .footer-content {\n flex-direction: column;\n text-align: center;\n }\n }\n <\/style>\n<\/head>\n\n<body>\n \n <header class=\"blog-header\">\n <div class=\"container\">\n <div class=\"category-tags\">\n Veri Analizi \u2022 Power BI \u2022 Cohort Analizi\n <\/div>\n <h1 class=\"main-title\">\n Power BI ile Cohort Analizi\n <span class=\"title-subtitle\"> \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber<\/span>\n <\/h1>\n <div class=\"lead-text\">\n Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini\n Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query + DAX + model\n tasar\u0131m\u0131) hem de stratejik yorumu i\u00e7erir. <br \/><br \/>Son k\u0131s\u0131mda test edebilmeniz i\u00e7in sentetik \u00f6rnek veri olu\u015fturma kodu da var.\n <\/div>\n <div class=\"meta-info\">\n <span>\ud83d\udcc5 Yay\u0131n Tarihi: 23 A\u011fustos 2025<\/span>\n <span>\u23f1\ufe0f Okuma S\u00fcresi: 15 dakika<\/span>\n <span>\ud83d\udcca Zorluk: Orta<\/span>\n <\/div>\n <\/div>\n <\/header>\n\n \n <main class=\"blog-content\">\n <div class=\"container\">\n\n \n <nav class=\"toc-box\" role=\"navigation\" aria-label=\"\u0130\u00e7indekiler\">\n <h2 class=\"toc-title\">\ud83d\udccb \u0130\u00e7erik<\/h2>\n <ul class=\"toc-list\">\n <li><a href=\"#neden-cohort\">\u2022 Neden Cohort Analizi?<\/a><\/li>\n <li><a href=\"#veri-modeli\">\u2022 Veri Modeli & \u015eema<\/a><\/li>\n <li><a href=\"#power-query\">\u2022 Power Query (ETL) – Temizleme & Normalize<\/a><\/li>\n <li><a href=\"#calculated-columns\">\u2022 Calculated Columns – Cohort Temelleri<\/a><\/li>\n <li><a href=\"#dax-measures\">\u2022 Temel DAX Measures<\/a><\/li>\n <li><a href=\"#ornek-veri\">\u2022 \u00d6rnek Veri Olu\u015fturma (Python)<\/a><\/li>\n <li><a href=\"#test-dogrulama\">\u2022 Test & Do\u011frulama<\/a><\/li>\n <li><a href=\"#gercek-ornekler\">\u2022 Ger\u00e7ek D\u00fcnya \u00d6rnekleri<\/a><\/li>\n <\/ul>\n <\/nav>\n\n \n <section id=\"neden-cohort\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfaf Neden Cohort Analizi? (K\u0131sa ve Net)<\/h2>\n <p class=\"content-text\">\n Cohort analizi, belirli bir zaman diliminde (genellikle ay) sisteme kat\u0131lan kullan\u0131c\u0131lar\u0131n (bu durumda sat\u0131c\u0131lar\u0131n)\n zaman i\u00e7indeki davran\u0131\u015flar\u0131n\u0131 izlemeye yarayan g\u00fc\u00e7l\u00fc bir analiz y\u00f6ntemidir. Payment processing sekt\u00f6r\u00fcnde bu analiz\n \u00f6zellikle de\u011ferlidir \u00e7\u00fcnk\u00fc:<\/p>\n\n \n\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131 edinim maliyeti (CAC)<\/strong> ile <strong>lifetime value (LTV)<\/strong> aras\u0131ndaki dengeyi g\u00f6sterir<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>\u0130\u015f b\u00fcy\u00fcmesinin s\u00fcrd\u00fcr\u00fclebilirli\u011fini de\u011ferlendirme f\u0131rsat\u0131 verir<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Hangi onboarding\/entegrasyonun<\/strong> i\u015fe yarad\u0131\u011f\u0131n\u0131 ortaya koyar<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Churn kritik d\u00f6nemini<\/strong> tahminlemesi ve \u00f6nleme stratejileri geli\u015ftirilmesine yard\u0131mc\u0131 olur<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Segment bazl\u0131 performans<\/strong> kar\u015f\u0131la\u015ft\u0131rmas\u0131 sa\u011flar<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <\/section>\n\n \n <section id=\"is-hedefleri\" class=\"content-section\">\n <h2 class=\"section-title\"> \ud83c\udfaf \u0130\u015f Hedefleri:<\/h2>\n <p class=\"content-text\">\n Bu cohort analizi sistemini kurduktan sonra a\u015fa\u011f\u0131daki stratejik sorulara cevap alabileceksiniz:<\/p>\n\n <h3 class=\"title-subtitle\">Retention & Churn Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Her ay edinilen sat\u0131c\u0131lar\u0131n 1., 3., 6., 12. ayda hayatta kalma (active) oran\u0131 nedir?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Retention d\u00fc\u015f\u00fc\u015f\u00fc hangi aya yo\u011funla\u015f\u0131yor? (kritik m\u00fcdahale zaman\u0131)<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi cohort’lar\u0131n retention performans\u0131 daha iyi?<\/span>\n <\/li>\n <\/ul><br\/>\n\n <h3 class=\"title-subtitle\">LTV & Revenue Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi cohort’lar\u0131n LTV’si h\u0131zl\u0131 y\u00fckseliyor, hangileri d\u00fc\u015f\u00fck kal\u0131yor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Ortalama k\u00fcm\u00fclatif gelir (LTV) nas\u0131l geli\u015fiyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>CAC geri \u00f6deme s\u00fcresi ka\u00e7 ay?<\/span>\n <\/li>\n <\/ul><br\/>\n\n <h3 class=\"title-subtitle\">Segmentasyon Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi \u00fcr\u00fcn tiplerinde (API vs iframe vs vPOS) retention farklar\u0131 var?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>\u0130\u015f kollar\u0131na g\u00f6re (MCC kodlar\u0131) sat\u0131c\u0131 davran\u0131\u015flar\u0131 nas\u0131l de\u011fi\u015fiyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>B\u00fcy\u00fck vs k\u00fc\u00e7\u00fck i\u015flem hacimli sat\u0131c\u0131lar aras\u0131nda fark var m\u0131?<\/span>\n <\/li>\n <\/ul><br\/> \n\n <h3 class=\"title-subtitle\">Operasyonel Kararlar<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>K\u0131sa d\u00f6nemde hangi metrikleri kullanarak churn riski tespit edebilirim?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi aylarda yeni sat\u0131c\u0131 edinimi daha ba\u015far\u0131l\u0131 oluyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Onboarding s\u00fcrecimde hangi iyile\u015ftirmeler en etkili olacak?<\/span>\n <\/li>\n <\/ul><br \/>\n <\/section>\n <section id=\"veri-modeli\" class=\"content-section\">\n <div>\n <h2 class=\"section-title\">\ud83d\uddc3\ufe0f Veri Modeli & \u015eema<\/h2>\n <p class=\"content-text\">\n Power BI modelinin sa\u011fl\u0131kl\u0131 \u00e7al\u0131\u015fmas\u0131 i\u00e7in \u00f6nerilen temel alanlar:\n <\/p>\n <\/div>\n\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Alan<\/th>\n <th>Tip<\/th>\n <th>A\u00e7\u0131klama<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">Ay_Periyodu<\/span><\/td>\n <td>date(ay\u0131n ilk g\u00fcn\u00fc)<\/td>\n <td>Ay bazl\u0131 cohort analiz referans\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Sat\u0131c\u0131_ID<\/span><\/td>\n <td>text\/int<\/td>\n <td>Benzersiz merchant ID<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u00dcr\u00fcn_Tipi<\/span><\/td>\n <td>text<\/td>\n <td>API \/ iframe \/ vPOS \/ POS<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Toplam_Gelir<\/span><\/td>\n <td>decimal<\/td>\n <td>Br\u00fct gelir<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Tum_Maliyetler<\/span><\/td>\n <td>decimal<\/td>\n <td>Banka\/i\u015flem maliyetleri<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Net_Kazan\u00e7<\/span><\/td>\n <td>decimal<\/td>\n <td>Toplam_Gelir – Tum_Maliyetler<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u0130\u015flem_Say\u0131s\u0131<\/span><\/td>\n <td>decimal<\/td>\n <td>Ger\u00e7ekle\u015fen \u0130\u015flem Adedi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u0130\u015flem_Hacmi<\/span><\/td>\n <td>decimal<\/td>\n <td>Ger\u00e7ekle\u015fen \u0130\u015flem Hacmi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Sektor_Kodu<\/span><\/td>\n <td>decimal<\/td>\n <td>Sekt\u00f6rel Gruplama<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <div class=\"warning-box\">\n <p class=\"warning-text\">\n <strong>\u26a0\ufe0f \u00d6nemli:<\/strong> <span class=\"code-inline\">Ay_Periyodu<\/span>\n mutlaka ay\u0131n ilk g\u00fcn\u00fc olmal\u0131 (<span class=\"code-inline\">YYYY-MM-01<\/span>).\n Bu Power BI time-intelligence ile uyumlu \u00e7al\u0131\u015fmay\u0131 sa\u011flar.\n <\/p>\n <p class=\"warning-text\">\n <span class=\"list-bullet\">\u2022<\/span>\n <span class=\"code-inline\">Net_Kazan\u00e7<\/span> hesaplamas\u0131n\u0131 ETL a\u015famas\u0131nda yaparsan\u0131z model performans\u0131 artar.\n <\/p>\n <p class=\"warning-text\">\n <span class=\"list-bullet\">\u2022<\/span>\n Sat\u0131c\u0131 ID’lerin benzersiz oldu\u011fundan emin olun; ayn\u0131 sat\u0131c\u0131n\u0131n birden fazla ID’si varsa \u00f6nce dedupe i\u015flemi yap\u0131n.\n <\/p>\n <\/div>\n <\/section>\n\n <section id=\"ornek-veri\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udc0d \u00d6rnek Veri Olu\u015fturma (Python)<\/h2>\n <p class=\"content-text\">\n A\u015fa\u011f\u0131daki Python kodu, Power BI ile deney yapman\u0131z i\u00e7in ger\u00e7ek\u00e7i davran\u0131\u015flar\u0131 taklit eden\n ~10,000 sat\u0131c\u0131 ayl\u0131k verisi \u00fcretir (2022-01 \u2192 2024-12):\n <\/p>\n \n <div class=\"code-block\" style=\"max-height: 400px; overflow-y: auto;\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">cohort_data_generator.py<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('python-code')\">Kopyala<\/button>\n <\/div>\n <pre id=\"python-code\">\n import pandas as pd\n import numpy as np\n import random\n from datetime import datetime, timedelta\n \n # Seed ayarlama (tekrarlanabilir sonu\u00e7lar i\u00e7in)\n np.random.seed(42)\n random.seed(42)\n \n # Parametreler\n n_merchants = 10000\n start_date = datetime(2022, 1, 1)\n end_date = datetime(2024, 12, 1)\n months = pd.date_range(start=start_date, end=end_date, freq='MS').to_pydatetime().tolist()\n \n # \u00dcr\u00fcn tipleri ve kategori kodlar\u0131\n product_types = ['API', 'iframe', 'vPOS', 'POS']\n mcc_codes = ['5411', '5812', '5651', '5999', '5611', '5311', '5732', '5691']\n \n rows = []\n \n # Her sat\u0131c\u0131 i\u00e7in temel \u00f6zellikler\n merchant_avg_tx_value = np.random.lognormal(mean=8.0, sigma=0.8, size=n_merchants)\n merchant_base_retention = np.random.choice([0.9, 0.7, 0.6, 0.5], size=n_merchants, p=[0.25, 0.25, 0.3, 0.2])\n \n for i in range(n_merchants):\n merchant_id = f\"M{100000 + i}\"\n cohort_month = random.choice(months)\n product = random.choice(product_types)\n mcc = random.choice(mcc_codes)\n avg_tx = merchant_avg_tx_value[i]\n base_ret = merchant_base_retention[i]\n \n # \u00dcr\u00fcn tipine g\u00f6re retention ayarlamas\u0131\n if product == 'API':\n base_ret *= 1.05\n elif product == 'iframe':\n base_ret *= 0.85\n elif product == 'vPOS':\n base_ret *= 0.9\n else:\n base_ret *= 0.95\n \n # Cohort'tan itibaren her ay i\u00e7in\n for month in months:\n if month < cohort_month: continue months_since=(month.year - cohort_month.year) * 12 + (month.month -\n cohort_month.month) # Retention olas\u0131l\u0131\u011f\u0131 zamanla azal\u0131r retention_prob=max(0.01, base_ret * np.exp(-0.25 *\n months_since)) active=np.random.rand() < retention_prob if not active: continue # \u0130\u015flem say\u0131s\u0131 (Poisson da\u011f\u0131l\u0131m\u0131)\n tx_count=max(1, np.random.poisson(lam=2 + 0.02 * months_since)) # Mevsimsellik etkisi seasonal=1.0 if month.month in\n [11, 12]: # Kas\u0131m-Aral\u0131k seasonal=1.2 elif month.month in [6, 7, 8]: # Yaz aylar\u0131 seasonal=1.05 # \u0130\u015flem hacmi\n hesaplama tx_volume=max(0.0, np.random.normal( loc=tx_count * avg_tx * seasonal, scale=0.1 * tx_count * avg_tx ))\n toplam_gelir=float(round(tx_volume, 2)) # Maliyet hesaplamalar\u0131 maliyet_orani=np.random.uniform(0.01, 0.035)\n tum_maliyet=round(toplam_gelir * maliyet_orani, 2) net_kazanc=round(toplam_gelir - tum_maliyet, 2)\n rows.append({ \"Ay_Periyodu\" : month.strftime(\"%Y-%m-01\"), \"Sat\u0131c\u0131_ID\" : merchant_id, \"\u00dcr\u00fcn_Tipi\" :\n product, \"Toplam_Gelir\" : toplam_gelir, \"Kategori_Kodu\" : mcc, \"T\u00fcm_Maliyetler\" : tum_maliyet, \"Net_Kazan\u00e7\" :\n net_kazanc, \"\u0130\u015flem_Hacmi\" : round(toplam_gelir, 2), \"\u0130\u015flem_Say\u0131s\u0131\" : int(tx_count) }) # DataFrame olu\u015fturma\n df=pd.DataFrame(rows) df['Ay_Periyodu']=pd.to_datetime(df['Ay_Periyodu']) # Rastgele s\u0131ralama df=df.sample(frac=1,\n random_state=42).reset_index(drop=True) # CSV olarak kaydetme df.to_csv(\"cohort_sample_10000_2022-2024.csv\",\n index=False) print(f\"Veri seti olu\u015fturuldu: {len(df)} sat\u0131r, {df['Sat\u0131c\u0131_ID'].nunique()} benzersiz sat\u0131c\u0131\")\n print(f\"Tarih aral\u0131\u011f\u0131: {df['Ay_Periyodu'].min()} - {df['Ay_Periyodu'].max()}\") print(f\"Ortalama ayl\u0131k gelir:\n \u20ba{df['Net_Kazan\u00e7'].mean():,.2f}\") # \u0130lk birka\u00e7 sat\u0131r\u0131 g\u00f6sterme print(\"\\n\u00d6rnek veriler:\")\n print(df.head().to_string()) <\/pre>\n <\/div>\n \n <div class=\"info-box\">\n <p class=\"content-text\">\n Bu kod yakla\u015f\u0131k 10.000 sat\u0131c\u0131 i\u00e7in 2022-01 ile 2024-12 tarihleri aras\u0131ndaki ayl\u0131k i\u015flem davran\u0131\u015f\u0131n\u0131 sim\u00fcle eder.\n Sim\u00fclasyonda:\n <\/p>\n <h4 class=\"info-text\"><strong>Kod \u00d6zellikleri:<\/strong><\/h4>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Her sat\u0131c\u0131n\u0131n ortalama i\u015flem de\u011feri log-normal da\u011f\u0131l\u0131mla belirlenir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Ayl\u0131k devam etme (retention) olas\u0131l\u0131\u011f\u0131 zamanla exponential decay g\u00f6sterir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Mevsimsellik fakt\u00f6rleri (Kas\u0131m-Aral\u0131k yo\u011funlu\u011fu) dahil edilir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> \u00dcr\u00fcn tiplerine g\u00f6re retention farkl\u0131l\u0131klar\u0131 modellenir\n <\/ul>\n <\/div>\n <h3 class=\"content-text\"><strong>Veri Seti \u00d6zellikleri:<\/strong><\/h3>\n <li>\n <span>CSV s\u00fctunlar\u0131: <span class=\"code-inline\">Ay_Periyodu<\/span>, <span class=\"code-inline\">Sat\u0131c\u0131_ID<\/span>, <span class=\"code-inline\">\u00dcr\u00fcn_Tipi<\/span>, <span class=\"code-inline\">Toplam_Gelir<\/span>, <span class=\"code-inline\">Kategori_Kodu<\/span>, <span class=\"code-inline\">T\u00fcm_Maliyetler<\/span>, <span class=\"code-inline\">Net_Kazan\u00e7<\/span>, <span class=\"code-inline\">\u0130\u015flem_Hacmi<\/span>,\n <span class=\"code-inline\">\u0130\u015flem_Say\u0131s\u0131<\/span><\/span>\n <\/li>\n <li>\n \n <span><span class=\"code-inline\">Ay_Periyodu<\/span> ay\u0131n ilk g\u00fcn\u00fc format\u0131nda (YYYY-MM-01) geldi\u011fi i\u00e7in do\u011frudan Power BI'da zaman-intelligence i\u015flemlerine\n uygundur\n <\/li>\n <li>\n \n <span>Veri sentetik oldu\u011fu i\u00e7in ger\u00e7ek m\u00fc\u015fteri bilgisi i\u00e7ermez; analiz ve modellerinizi geli\u015ftirmek i\u00e7in g\u00fcvenle\n kullan\u0131labilir<\/span>\n <\/li>\n <\/section>\n\n <section id=\"power-query\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udd04 Power Query (ETL) \u2014 Power Query ile Veri Haz\u0131rl\u0131\u011f\u0131<\/h2>\n <p class=\"content-text\">\n Burada CSV\/veri kayna\u011f\u0131ndan veriyi al\u0131p temizleyip Ay_Periyodu, Net_Kazan\u00e7 s\u00fctunlar\u0131yla \u00e7al\u0131\u015f\u0131r hale getiriyoruz.\n <\/p>\n <h3 class=\"content-text\"><strong>Tipik ETL Ad\u0131mlar\u0131:<\/strong><\/h3>\n <ol class=\"steps-list\">\n <li>\n <span class=\"step-number\">1<\/span>\n <span><strong>Veri oku<\/strong> (CSV \/ SQL \/ parquet)<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">2<\/span>\n <span><strong>Tarih normalizasyonu<\/strong> \u2014 Date.FromText ve Date.StartOfMonth ile Ay_Periyodu\n olu\u015ftur<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">3<\/span>\n <span><strong>Null\/NaN temizli\u011fi<\/strong> \u2014 Sat\u0131c\u0131_ID bo\u015fsa filtrele<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">4<\/span>\n <span><strong>Net_Kazan\u00e7 hesapla<\/strong> (ETL'de yapmak performans kazand\u0131r\u0131r)<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">5<\/span>\n <span><strong>Gereksiz s\u00fctunlar\u0131 kald\u0131r<\/strong> ve tipleri sabitle<\/span>\n <\/li>\n <\/ol><\/section>\n <section>\n <h3>\u00d6nemli A\u00e7\u0131klamalar<\/h3>\n <h3>Neden <span class=\"code-inline\">Date.StartOfMonth<\/span> Kullan\u0131yoruz?<\/h3>\n <li>\n <span>Kesin ay-bucket referans\u0131 olu\u015fturmak i\u00e7in<\/span>\n <\/li>\n <li>\n <span>Power BI'\u0131n time-intelligence fonksiyonlar\u0131 tutarl\u0131 \u00e7al\u0131\u015f\u0131r<\/span>\n <\/li>\n <li>\n <span>Cohort hesaplamalar\u0131nda tarih uyumsuzlu\u011fu \u00f6nlenir<\/span><\/li>\n\n <br \/>\n <h3>Veri Kalite Kontrolleri:<\/h3>\n <li>\n <span>Null\/bo\u015f <span class=\"code-inline\">Sat\u0131c\u0131_ID<\/span> de\u011ferler filtrelenir<\/span>\n <\/li>\n <li>\n <span>Negatif gelir de\u011ferleri temizlenir<\/span>\n <\/li>\n <li>\n <span>Text alanlar trim edilir<\/span>\n <\/li>\n \n <\/br>\n <h3>Performance \u0130pu\u00e7lar\u0131:<\/h3>\n <li>\n <span>Table.Buffer son ad\u0131mda kullan\u0131l\u0131r - d\u00f6n\u00fc\u015f\u00fcmleri sabitleme<\/span>\n <\/li>\n <li>\n <span>ETL a\u015famas\u0131nda Net_Kazan\u00e7 hesaplan\u0131rsa model hafifler<\/span>\n <\/li><\/br>\n <\/section>\n\n <section id=\"dax-measures\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcbb Modelleme: DateTable & \u0130li\u015fkiler<\/h2>\n <p class=\"content-text\">\n <strong>DateTable Olu\u015fturma:<\/strong> <\/br>Her modelde bir DateTable olmal\u0131\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">\u00d6rnek DAX Kodu:<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('m-code')\">Kopyala<\/button>\n <\/div>\n <pre id=\"m-code\">DateTable =\n ADDCOLUMNS(\n CALENDAR(DATE(2021,1,1), DATE(2026,12,31)),\n \"Y\u0131l\", YEAR([Date]),\n \"Ay\", FORMAT([Date], \"MMMM\"),\n \"AyNumaras\u0131\", MONTH([Date]),\n \"Y\u0131lAy\", FORMAT([Date], \"yyyy-MM\"),\n \"Ay_Start\", DATE(YEAR([Date]),MONTH([Date]),1),\n \"\u00c7eyrek\", \"Q\" & QUARTER([Date])\n )<\/pre><\/div>\n\n <h2>Model \u0130li\u015fkileri<\/h2><\/br>\n <li>\n <span><strong>DateTable[Date]<\/strong> \u2192 1-* <strong>Transaction[Ay_Periyodu]<\/strong><\/span>\n <\/li>\n <br><h3> Neden Bu \u0130li\u015fki \u00d6nemli:<\/h3>\n <li>Bu ili\u015fki, zaman serisi analizleri ve raporlamalar\u0131 i\u00e7in kritik \u00f6neme sahiptir. \n DateTable, tarihsel verilerin do\u011fru bir \u015fekilde analiz edilmesini sa\u011flar.<\/li>\n <li>(DATEADD, SAMEPERIODLASTYEAR) gibi fonksiyonlar d\u00fczg\u00fcn \u00e7al\u0131\u015f\u0131r<\/li>\n <li>Tarih aral\u0131\u011f\u0131 y\u00f6netimi tek yerden yap\u0131l\u0131r<\/li>\n<\/section>\n\n <section id=\"calculated-columns\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcca Calculated Columns: Cohort Temellerini Olu\u015fturma<\/h2>\n <p class=\"content-text\">\n Bu s\u00fctunlar sat\u0131c\u0131 ba\u015f\u0131na sabit oldu\u011fundan <strong>calculated column<\/strong> veya ETL'de\n hesaplanmal\u0131 \u00e7\u00fcnk\u00fc:<br>\n 1- Sat\u0131c\u0131 ba\u015f\u0131na bir kez hesaplanan sabit de\u011ferlerdir.<br>\n 2- Her rapor sorgusu s\u0131ras\u0131nda yeniden hesaplanmas\u0131na gerek yoktur.<br>\n 3- Performans a\u00e7\u0131s\u0131ndan avantaj sa\u011flar.\n <\/p>\n\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Date (sat\u0131c\u0131n\u0131n ilk i\u015flem ay\u0131)<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-date')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-date\">Cohort_Date =\nCALCULATE(\n MIN('Transaction'[Ay_Periyodu]),\n ALLEXCEPT('Transaction','Transaction'[Sat\u0131c\u0131_ID])\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n <strong>Ne yapar:<\/strong> Her sat\u0131c\u0131n\u0131n ilk i\u015flem yapt\u0131\u011f\u0131 ay\u0131 (edinim ay\u0131n\u0131) hesaplar. T\u00fcm cohort analizinin temelini olu\u015fturur.\n\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Months_Since_Cohort - Cohort \u0130ndeksi<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('months-since')\">Kopyala<\/button>\n <\/div>\n <pre id=\"months-since\">Months_Since_Cohort =\nIF(\n ISBLANK('Transaction'[Cohort_Date]) || ISBLANK('Transaction'[Ay_Periyodu]),\n BLANK(),\n DATEDIFF('Transaction'[Cohort_Date], 'Transaction'[Ay_Periyodu], MONTH)\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n <strong>Ne yapar:<\/strong> Sat\u0131c\u0131n\u0131n edinim ay\u0131ndan itibaren ka\u00e7 ay ge\u00e7ti\u011fini g\u00f6sterir (0, 1, 2, 3...). Heatmap g\u00f6rsellerinde kullan\u0131lacak temel indekstir.\n <\/p>\n <p class=\"content-text\">\n <strong>Veri Tipi:<\/strong> Whole Number olarak ayarlay\u0131n - g\u00f6rsellerde do\u011fru s\u0131ralama i\u00e7in \u00f6nemli.\n <\/p>\n <div class=\"info-box\">\n <p class=\"info-text\">\n <strong>\u2705 Sanity Check:<\/strong> Her cohort i\u00e7in <span class=\"code-inline\">Months_Since_Cohort =\n 0<\/span>\n sat\u0131rlar\u0131nda <span class=\"code-inline\">Cohort_Active_Count == Cohort_Size<\/span> olmal\u0131.\n <\/p>\n <\/div>\n <\/section>\n\n <section id=\"dax-measures\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a1 Temel DAX Measures<\/h2>\n <p class=\"content-text\">\n A\u015fa\u011f\u0131da, cohort matrisleri ve temel KPI'lar i\u00e7in gerekli t\u00fcm measure'lar yer al\u0131yor:\n <\/p>\n <h3 class=\"title\">Cohort_Size - Cohort Ba\u015flang\u0131\u00e7 B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h3>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Size<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-size')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-size\">Cohort_Size =\n VAR CohortPeriod = SELECTEDVALUE('Transaction'[Cohort_Date])\n RETURN\n CALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n FILTER(ALL('Transaction'), 'Transaction'[Cohort_Date] = CohortPeriod)\n )\n<\/pre>\n <\/div>\n <h3 class=\"title\">Cohort_Active_Count - Aktif Sat\u0131c\u0131 Say\u0131s\u0131<\/h3>\n <p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong> Belirli bir cohort'un t+N ay\u0131nda ka\u00e7 sat\u0131c\u0131n\u0131n aktif oldu\u011funu sayar.\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Active_Count<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-active-count')\">Kopyala<\/button>\n <\/div>\n <pre\n id=\"cohort-active-count\">Cohort_Active_Count =\n VAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\n VAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\n VAR CohortMonthDate = EDATE(SelectedCohort, CohortMonthIndex)\n RETURN\n CALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n 'Transaction'[Ay_Periyodu] = CohortMonthDate)\n )\n<\/pre>\n <\/div>\n <h3 class=\"title\">Cohort_Retention_Rate – Retention Oran\u0131<\/h3>\n <p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong>Ana KPI metri\u011fi. G\u00f6rsellerde y\u00fczde format\u0131nda g\u00f6sterin.\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Retention_Rate<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-retention-rate')\">Kopyala<\/button>\n <\/div>\n <pre\n id=\"cohort-retention-rate\">Cohort_Retention_Rate =\nDIVIDE([Cohort_Active_Count], [Cohort_Size], 0)<\/pre>\n <\/div>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Performans \u0130pucu:<\/strong> <span class=\"code-inline\">Cohort_Date<\/span> ve\n <span class=\"code-inline\">Months_Since_Cohort<\/span> ETL veya calculated column olarak\n saklanmal\u0131.\n B\u00fcy\u00fck transaction tablolar\u0131n\u0131 <span class=\"code-inline\">Merchant_Month_Summary<\/span> tablosuna\n indirgeme.\n <\/p>\n <\/div>\n <\/section>\n<h3 class=\"title\">Cohort_Revenue_Period – D\u00f6nemsel Gelir<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Revenue_Period<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-revenue-period')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-revenue-period\">Cohort_Revenue_Period =\nVAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\nVAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\nVAR CohortMonthDate = EDATE(SelectedCohort, CohortMonthIndex)\nRETURN\nCALCULATE(\n SUM('Transaction'[Net_Kazan\u00e7]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n 'Transaction'[Ay_Periyodu] = CohortMonthDate\n )\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Cohort_Cumulative_Revenue – K\u00fcm\u00fclatif Gelir<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Cumulative_Revenue<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-cumulative-revenue')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-cumulative-revenue\">Cohort_Cumulative_Revenue =\nVAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\nVAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\nRETURN\nCALCULATE(\n SUM('Transaction'[Net_Kazan\u00e7]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n DATEDIFF('Transaction'[Cohort_Date], 'Transaction'[Ay_Periyodu], MONTH) <= CohortMonthIndex\n )\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Cohort_Average_LTV - Ortalama Lifetime Value<\/h3>\n<p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong> CAC ile kar\u015f\u0131la\u015ft\u0131rma yaparak ROI hesaplar\u0131 i\u00e7in kritik metrik.\n<\/p>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Average_LTV<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-average-ltv')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-average-ltv\">Cohort_Average_LTV =\nDIVIDE(\n [Cohort_Cumulative_Revenue],\n [Cohort_Size],\n 0\n)<\/pre>\n<\/div>\n\n<h2 class=\"section-title\">\ud83d\udcca Ek KPI'lar: Genel Sat\u0131c\u0131 Sa\u011fl\u0131\u011f\u0131<\/h2>\n\n<h3 class=\"title\">Aktif Sat\u0131c\u0131lar<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Aktif_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('aktif-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"aktif-saticilar\">Aktif_Sat\u0131c\u0131lar =\nCALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] = MAX('Transaction'[Ay_Periyodu])\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Yeni Sat\u0131c\u0131lar<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Yeni_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('yeni-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"yeni-saticilar\">Yeni_Sat\u0131c\u0131lar =\nVAR CurrentMonth = MAX('Transaction'[Ay_Periyodu])\nVAR CurrentActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] = CurrentMonth\n )\nVAR PreviouslyActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] < CurrentMonth\n )\nRETURN\nCOUNTROWS(EXCEPT(CurrentActive, PreviouslyActive))<\/pre>\n<\/div>\n\n<h3 class=\"title\">Churn Oran\u0131<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Churned_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('churned-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"churned-saticilar\">Churned_Sat\u0131c\u0131lar =\nVAR PreviousMonthActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n DATEADD('Transaction'[Ay_Periyodu], -1, MONTH),\n 'Transaction'[\u0130\u015flem_Say\u0131s\u0131] > 0\n )\nVAR CurrentActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[\u0130\u015flem_Say\u0131s\u0131] > 0\n )\nRETURN\nCOUNTROWS(EXCEPT(PreviousMonthActive, CurrentActive))<\/pre>\n<\/div>\n<\/section>\n\n<section id=\"dashboard-tasarimi\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcca Dashboard Tasar\u0131m\u0131 ve G\u00f6rselle\u015ftirme<\/h2>\n\n <h3 class=\"content-text\"><strong>Executive Summary Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">KPI Kartlar\u0131:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Aktif Sat\u0131c\u0131lar<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Yeni Sat\u0131c\u0131lar<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Churn Oran\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Toplam Gelir<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Ortalama \u0130\u015flem Hacmi<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Trend Grafikleri:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Ayl\u0131k gelir trendi (line chart)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Yeni sat\u0131c\u0131 edinim trendi<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Churn oran\u0131 trendi<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Cohort Analizi Ana Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">Matrix (Heatmap) Ayarlar\u0131:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Rows:<\/strong> Cohort_Date (Y\u0131lAy format\u0131nda)<\/span>\n <\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Columns:<\/strong> Months_Since_Cohort (0, 1, 2,\n 3...)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Values:<\/strong> Cohort_Retention_Rate (%\n format\u0131nda)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Conditional Formatting:<\/strong> Koyu renk = y\u00fcksek\n retention<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Alternatif Matrix:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Values:<\/strong> Cohort_Average_LTV (LTV \u0131s\u0131 haritas\u0131\n i\u00e7in)<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Segment Analizi Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">Slicers:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>\u00dcr\u00fcn_Tipi<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Kategori_Kodu (MCC)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>\u0130\u015f_Orta\u011f\u0131<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Grafikler:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Cohort b\u00fcy\u00fckl\u00fc\u011f\u00fc bar chart<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Segment bazl\u0131 LTV kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Top 20 sat\u0131c\u0131 tablosu<\/span><\/li>\n <\/ul>\n <\/div>\n<\/section>\n\n<section id=\"gercek-dunya-ornegi\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfe2 Ger\u00e7ek D\u00fcnya \u00d6rne\u011fi: 50,000+ Sat\u0131c\u0131 ile Cohort Analizi<\/h2>\n <p class=\"content-text\">\n T\u00fcrkiye'nin \u00f6nde gelen payment processing \u015firketlerinden birinde yapt\u0131\u011f\u0131m\u0131z ger\u00e7ek bir cohort analizi \u00f6rne\u011fini\n payla\u015f\u0131yorum.\n 2.3 milyon i\u015flem sat\u0131r\u0131 ve 52,000+ sat\u0131c\u0131 verisi \u00fczerinde \u00e7al\u0131\u015farak elde etti\u011fimiz bulgular:\n <\/p>\n\n <h3 class=\"title-subtitle\">Veri Seti \u00d6zellikleri<\/h3>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca Proje B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h4>\n <div class=\"stats-item\">\n <span>Zaman Aral\u0131\u011f\u0131:<\/span>\n <span class=\"stats-value\">Ocak 2022 - Aral\u0131k 2024 (36 ay)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Sat\u0131c\u0131 Say\u0131s\u0131:<\/span>\n <span class=\"stats-value\">52,847 benzersiz sat\u0131c\u0131<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem Sat\u0131r\u0131:<\/span>\n <span class=\"stats-value\">2,347,892 transaction<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem Hacmi:<\/span>\n <span class=\"stats-value\">\u20ba18.4 milyar<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Ayl\u0131k Yeni Sat\u0131c\u0131:<\/span>\n <span class=\"stats-value\">~1,500<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Veri Boyutu:<\/span>\n <span class=\"stats-value\">450 MB (Excel) \/ 180 MB (Power BI)<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <h3 class=\"title-subtitle\">En B\u00fcy\u00fck 10 Cohort (Sat\u0131c\u0131 Say\u0131s\u0131na G\u00f6re)<\/h3>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Cohort Ay\u0131<\/th>\n <th>Sat\u0131c\u0131 Say\u0131s\u0131<\/th>\n <th>\u00d6zel Not<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">2023-01<\/span><\/td>\n <td>2,847<\/td>\n <td>En b\u00fcy\u00fck onboarding ay\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-09<\/span><\/td>\n <td>2,534<\/td>\n <td>Sonbahar kampanyas\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-03<\/span><\/td>\n <td>2,431<\/td>\n <td>Pandemi sonras\u0131 toparlanma<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-06<\/span><\/td>\n <td>2,289<\/td>\n <td>Yaz sezonu<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-07<\/span><\/td>\n <td>2,156<\/td>\n <td>Tatil \u00f6ncesi yo\u011funluk<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2024-02<\/span><\/td>\n <td>2,098<\/td>\n <td>Yeni \u00fcr\u00fcn lansman\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-11<\/span><\/td>\n <td>1,987<\/td>\n <td>Black Friday etkisi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-04<\/span><\/td>\n <td>1,876<\/td>\n <td>Bahar d\u00f6nemi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-05<\/span><\/td>\n <td>1,743<\/td>\n <td>Normalle\u015fme s\u00fcreci<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-10<\/span><\/td>\n <td>1,692<\/td>\n <td>Okul \u00f6ncesi al\u0131\u015fveri\u015f<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <h3 class=\"title-subtitle\">Retention Analizi - Sekt\u00f6r Benchmarklar\u0131<\/h3>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcc8 Genel Retention Trendi<\/h4>\n <div class=\"stats-item\">\n <span>Month 0:<\/span>\n <span class=\"stats-value\">100.0%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 1:<\/span>\n <span class=\"stats-value\">67.3%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 2:<\/span>\n <span class=\"stats-value\">54.1%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 3:<\/span>\n <span class=\"stats-value\">48.7%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 6:<\/span>\n <span class=\"stats-value\">38.2%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 12:<\/span>\n <span class=\"stats-value\">28.4%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 24:<\/span>\n <span class=\"stats-value\">19.7%<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">\u00d6ne \u00c7\u0131kan Bulgular:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>\"3 Ayl\u0131k Kritik E\u015fik\":<\/strong> \u0130lk 3 ayda %51.3 churn -\n bu d\u00f6nemde yap\u0131lan m\u00fcdahalelerin ROI'\u0131 \u00e7ok y\u00fcksek<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Seasonality Etkisi:<\/strong> Sonbahar aylar\u0131nda edinilen\n cohort'lar %15-20 daha iyi retention g\u00f6steriyor<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Product Mix Impact:<\/strong> API entegrasyonu yapan\n sat\u0131c\u0131lar, iframe kullanlara g\u00f6re 2.3x daha uzun s\u00fcre kal\u0131yor<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"title-subtitle\">Lifetime Value (LTV) Bulgular\u0131<\/h3>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Cohort<\/th>\n <th>Ortalama LTV (24 Ay)<\/th>\n <th>Not<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">2022-01<\/span><\/td>\n <td>\u20ba47,350<\/td>\n <td>Matured cohort<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-06<\/span><\/td>\n <td>\u20ba52,100<\/td>\n <td>Yaz etkisi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-09<\/span><\/td>\n <td>\u20ba61,200<\/td>\n <td>En performant<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-01<\/span><\/td>\n <td>\u20ba34,600<\/td>\n <td>Hen\u00fcz geli\u015fmekte<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-06<\/span><\/td>\n <td>\u20ba31,900<\/td>\n <td>Gen\u00e7 cohort<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2024-01<\/span><\/td>\n <td>\u20ba8,750<\/td>\n <td>Sadece 12 ay<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcb0 LTV Distribution (24 Ayl\u0131k)<\/h4>\n <div class=\"stats-item\">\n <span>Top %5:<\/span>\n <span class=\"stats-value\">\u20ba340,000+ (whale merchants)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Top %10:<\/span>\n <span class=\"stats-value\">\u20ba185,000<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Top %25:<\/span>\n <span class=\"stats-value\">\u20ba85,000<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Median:<\/span>\n <span class=\"stats-value\">\u20ba23,400<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Bottom %25:<\/span>\n <span class=\"stats-value\">\u20ba4,200 alt\u0131<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n<h3 class=\"title-subtitle\">Segmentasyon Insights<\/h3>\n<div class=\"highlight-box\">\n <h4 class=\"stats-title\">MCC (Kategori) Bazl\u0131 Performance:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Marketler\/S\u00fcpermarketler (MCC 5411):<\/strong> En y\u00fcksek\n retention (%41 @ 12ay)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Restoranlar (MCC 5812):<\/strong> Orta retention ama y\u00fcksek\n volume<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Giyim (MCC 5651):<\/strong> Mevsimsel dalgalanma, d\u00fc\u015f\u00fck\n retention<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>E-ticaret Genel (MCC 5999):<\/strong> \u00c7ok de\u011fi\u015fken, segment\n analizi gerekli<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Partner Channel Analizi:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Direct Sales:<\/strong> %35.2 (12ay retention) - Premium\n segment<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Bank Referral:<\/strong> %28.7 - Stable ama d\u00fc\u015f\u00fck LTV<\/span>\n <\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Digital Marketing:<\/strong> %22.1 - Y\u00fcksek volume, d\u00fc\u015f\u00fck\n quality<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Reseller Network:<\/strong> %31.4 - B\u00f6lgesel farkl\u0131l\u0131k\n y\u00fcksek<\/span><\/li>\n <\/ul>\n<\/div>\n\n<h3 class=\"title-subtitle\">Model Performance ve Optimizasyon<\/h3>\n<div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\u26a1 Power BI Model Specs<\/h4>\n <div class=\"stats-item\">\n <span>Y\u00fckleme S\u00fcresi:<\/span>\n <span class=\"stats-value\">~12s (initial) \/ ~3s (refresh)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Model Boyutu:<\/span>\n <span class=\"stats-value\">178 MB (compressed)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>DAX Hesaplama:<\/span>\n <span class=\"stats-value\"><200ms (cohort matrix)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Concurrent User:<\/span>\n <span class=\"stats-value\">15+ kullan\u0131c\u0131 sorunsuz<\/span>\n <\/div>\n <\/div>\n\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udd27 Performance Optimizasyonlar\u0131<\/h4>\n <div class=\"stats-item\">\n <span>Summary Table:<\/span>\n <span class=\"stats-value\">628,000 sat\u0131r (pre-aggregated)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Partitioning:<\/span>\n <span class=\"stats-value\">Y\u0131l bazl\u0131 (2022, 2023, 2024)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Calculated Columns:<\/span>\n <span class=\"stats-value\">2 adet<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Indexing:<\/span>\n <span class=\"stats-value\">Composite index<\/span>\n <\/div>\n <\/div>\n<\/div>\n\n<h3 class=\"title-subtitle\">\u0130\u015f Etkisi ve Eylem Plan\u0131<\/h3>\n<p class=\"content-text\">Bu cohort analizi sonucunda al\u0131nan somut aksiyonlar:<\/p>\n\n<div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Onboarding UX \u0130yile\u015ftirmesi:<\/strong> \u0130lk 30 g\u00fcn i\u00e7inde %15\n daha fazla sat\u0131c\u0131 aktif kald\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Risk-Based Outreach:<\/strong> Churn riski y\u00fcksek segmente\n \u00f6zel destek program\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Product Roadmap:<\/strong> API-first yakla\u015f\u0131m, iframe deste\u011fi\n kademeli azaltma<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Pricing Strategy:<\/strong> LTV segmentlerine g\u00f6re komisyon\n yap\u0131s\u0131 revize edildi<\/span><\/li>\n <\/ul>\n<\/div>\n\n<div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udc8e ROI Hesaplamas\u0131<\/h4>\n <div class=\"stats-item\">\n <span>Analiz Maliyeti:<\/span>\n <span class=\"stats-value\">~80 saat + tool costs<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130yile\u015ftirme ROAS:<\/span>\n <span class=\"stats-value\">%340 (6 ay i\u00e7inde)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Churn Azalmas\u0131:<\/span>\n <span class=\"stats-value\">-%23 (y\u0131ll\u0131k basis)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Net Gelir Etkisi:<\/span>\n <span class=\"stats-value\">+\u20ba12.8M (12 ay projeksiyon)<\/span>\n <\/div>\n <\/div>\n<\/div>\n\n<div class=\"info-box\">\n <p class=\"info-text\">\n Bu ger\u00e7ek d\u00fcnya \u00f6rne\u011fi, cohort analizinin sadece bir reporting tool de\u011fil, stratejik karar alma arac\u0131 oldu\u011funu\n g\u00f6steriyor.\n <\/p>\n<\/div>\n<\/section>\n\n<section id=\"yaygin-hatalar\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a0\ufe0f Yayg\u0131n Hatalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">1. Tarih Saat Uyumsuzluklar\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Farkl\u0131 timezone'lar nedeniyle cohort tarihleri yanl\u0131\u015f\n hesaplan\u0131yor.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> ETL a\u015famas\u0131nda t\u00fcm tarihleri UTC'ye \u00e7evirin ve Ay_Periyodu'nu\n ay\u0131n ilk g\u00fcn\u00fc olarak normalize edin.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">2. Duplicate Sat\u0131c\u0131 ID'ler<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Ayn\u0131 sat\u0131c\u0131n\u0131n birden fazla ID'si olmas\u0131.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> M\u00fc\u015fteri matching tablosu kullanarak e-posta veya vergi numaras\u0131\n bazl\u0131 dedupe yap\u0131n.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">3. Performance Sorunlar\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> B\u00fcy\u00fck veri setlerinde yava\u015fl\u0131k.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> Import mode kullan\u0131n, pre-aggregated tablolar olu\u015fturun,\n calculated column'lar\u0131 tercih edin.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">4. Cohort 0'\u0131n %100 Olmamas\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Genellikle Cohort_Date veya Months_Since_Cohort hatal\u0131\n hesaplanmas\u0131.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> Her cohort'un Month 0'\u0131nda retention'\u0131n %100 oldu\u011funu kontrol\n edin.<\/p>\n <\/div>\n<\/section>\n\n<section id=\"performans-optimizasyon\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a1 Performans Optimizasyonu \u0130pu\u00e7lar\u0131<\/h2>\n\n <h3 class=\"content-text\"><strong>1. Calculated Column vs Measure Karar\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Calculated Columns:<\/strong> Cohort_Date, Months_Since_Cohort gibi sabit hesaplamalar -\n veri yenilendi\u011finde bir kez hesaplan\u0131r<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Measures:<\/strong> Dinamik KPI'lar ve filtrelenebilir metrikler - her sorgu i\u00e7in\n hesaplan\u0131r ama daha esnektir<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <p class=\"content-text\">\n <strong>Karar Kriterleri:<\/strong> E\u011fer de\u011fer sat\u0131c\u0131\/i\u015flem baz\u0131nda sabitse ve filtreleme gerektirmiyorsa\n calculated column kullan\u0131n. Dinamik hesaplama ve filtreleme gerektiren her \u015fey i\u00e7in measure kullan\u0131n.\n <\/p>\n\n <h3 class=\"content-text\"><strong>2. Summary Tablolar<\/strong><\/h3>\n <p class=\"content-text\">\n B\u00fcy\u00fck veri setlerinde (1M+ sat\u0131r) pre-aggregated tablo kullan\u0131n. Bu yakla\u015f\u0131m sorgu performans\u0131n\u0131 10-20x\n h\u0131zland\u0131rabilir:\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Sat\u0131c\u0131_Ay_Summary Tablosu<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('summary-table')\">Kopyala<\/button>\n <\/div>\n <pre id=\"summary-table\">-- Power Query M ile Summary Tablo Olu\u015fturma\nlet\n Source = Transaction,\n Grouped = Table.Group(\n Source, \n {\"Sat\u0131c\u0131_ID\", \"Ay_Periyodu\", \"\u00dcr\u00fcn_Tipi\", \"Kategori_Kodu\"},\n {\n {\"\u0130\u015flem_Say\u0131s\u0131\", each List.Sum([\u0130\u015flem_Say\u0131s\u0131]), type number},\n {\"Net_Kazan\u00e7\", each List.Sum([Net_Kazan\u00e7]), type number},\n {\"Toplam_Gelir\", each List.Sum([Toplam_Gelir]), type number}\n }\n )\nin\n Grouped\n\n-- Alternatif: DAX ile Summary Tablo\nSat\u0131c\u0131_Ay_Summary = \nSUMMARIZE(\n 'Transaction',\n 'Transaction'[Sat\u0131c\u0131_ID],\n 'Transaction'[Ay_Periyodu],\n 'Transaction'[\u00dcr\u00fcn_Tipi],\n \"\u0130\u015flem_Say\u0131s\u0131\", SUM('Transaction'[\u0130\u015flem_Say\u0131s\u0131]),\n \"Net_Kazan\u00e7\", SUM('Transaction'[Net_Kazan\u00e7])\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n Bu summary tablo \u00fczerinden measure'lar\u0131 \u00e7al\u0131\u015ft\u0131rarak milyonlarca sat\u0131rl\u0131k transaction tablosunu y\u00fcz binlere\n indirgemi\u015f olursunuz.\n <\/p>\n\n <h3 class=\"content-text\"><strong>3. Indexing Stratejisi<\/strong><\/h3>\n <p class=\"content-text\">\n SQL veri kayna\u011f\u0131n\u0131z varsa, a\u015fa\u011f\u0131daki kolonlar \u00fczerinde index olu\u015fturun:\n <\/p>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131_ID:<\/strong> Tek ba\u015f\u0131na index - merchant bazl\u0131 sorgular\u0131 h\u0131zland\u0131r\u0131r<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Ay_Periyodu:<\/strong> Tek ba\u015f\u0131na index - zaman serisi sorgular\u0131 i\u00e7in<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131_ID + Ay_Periyodu (composite):<\/strong> En kritik index - cohort hesaplamalar\u0131\n i\u00e7in<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">SQL Index Olu\u015fturma Komutlar\u0131<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('sql-index')\">Kopyala<\/button>\n <\/div>\n <pre id=\"sql-index\">-- Tek kolon indexler\nCREATE INDEX idx_merchant_id ON Transaction(Sat\u0131c\u0131_ID);\nCREATE INDEX idx_period ON Transaction(Ay_Periyodu);\n\n-- Composite index (en \u00f6nemli)\nCREATE INDEX idx_merchant_period ON Transaction(Sat\u0131c\u0131_ID, Ay_Periyodu);\n\n-- \u00dcr\u00fcn tipi segmentasyonu i\u00e7in\nCREATE INDEX idx_product_type ON Transaction(\u00dcr\u00fcn_Tipi);\n\n-- Performance check\nSELECT \n tablename, \n indexname, \n indexdef \nFROM pg_indexes \nWHERE tablename = 'transaction';<\/pre>\n <\/div>\n<\/section>\n\n<section id=\"gelismis-teknikler\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\ude80 Geli\u015fmi\u015f Analiz Teknikleri<\/h2>\n\n <h3 class=\"content-text\"><strong>1. Segmented Cohort Analizi<\/strong><\/h3>\n <p class=\"content-text\">\n Farkl\u0131 sat\u0131c\u0131 segmentleri i\u00e7in ayr\u0131 cohort analizleri yaparak daha derinlemesine i\u00e7g\u00f6r\u00fcler elde edebilirsiniz:\n <\/p>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca MCC Koduna G\u00f6re<\/h4>\n <p class=\"content-text\">\n Her sekt\u00f6r\u00fcn farkl\u0131 retention paterni vard\u0131r. Marketler genelde y\u00fcksek retention g\u00f6sterirken, giyim\n sekt\u00f6r\u00fc mevsimsel dalgalanmalar g\u00f6sterir.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udd27 \u00dcr\u00fcn Tipine G\u00f6re<\/h4>\n <p class=\"content-text\">\n API entegrasyonu yapan sat\u0131c\u0131lar iframe kullananlara g\u00f6re 2-3x daha uzun s\u00fcre kal\u0131yor. Bu insight \u00fcr\u00fcn\n stratejinizi \u015fekillendirebilir.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udce2 Onboarding Kanal\u0131na G\u00f6re<\/h4>\n <p class=\"content-text\">\n Direct sales vs digital marketing vs partner referral - her kanal farkl\u0131 kalite sat\u0131c\u0131 getirir. CAC ve\n LTV dengesini kanal baz\u0131nda optimize edin.\n <\/p>\n <\/div>\n <\/div>\n\n <h3 class=\"content-text\"><strong>2. Predictive Churn Modeling<\/strong><\/h3>\n <p class=\"content-text\">\n Cohort verilerini kullanarak gelecekteki churn'\u00fc tahminleyebilir ve proaktif aksiyonlar alabilirsiniz:\n <\/p>\n <div class=\"info-box\">\n <p class=\"info-text\"><strong>Erken Uyar\u0131 Sinyalleri:<\/strong><\/p>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>\u0130lk 3 ayda d\u00fc\u015f\u00fck i\u015flem hacmi:<\/strong> Ayl\u0131k i\u015flem hacmi cohort ortalamas\u0131n\u0131n %50'sinin\n alt\u0131ndaysa y\u00fcksek churn riski<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Azalan trend:<\/strong> Ard\u0131\u015f\u0131k 2 ayda i\u015flem hacmi d\u00fc\u015f\u00fc\u015f\u00fc g\u00f6steriyorsa m\u00fcdahale\n gerekli<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>\u0130\u015flem s\u0131kl\u0131\u011f\u0131 d\u00fc\u015f\u00fc\u015f\u00fc:<\/strong> Ayl\u0131k i\u015flem say\u0131s\u0131 3'\u00fcn alt\u0131na d\u00fc\u015ferse kritik seviye<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Churn Risk Score Hesaplama<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('churn-risk')\">Kopyala<\/button>\n <\/div>\n <pre id=\"churn-risk\">Churn_Risk_Score = \nVAR CurrentMonthTx = [\u0130\u015flem_Say\u0131s\u0131]\nVAR PrevMonthTx = CALCULATE([\u0130\u015flem_Say\u0131s\u0131], DATEADD('Transaction'[Ay_Periyodu], -1, MONTH))\nVAR CohortAvgTx = CALCULATE(\n AVERAGE('Transaction'[\u0130\u015flem_Say\u0131s\u0131]),\n FILTER(ALL('Transaction'), 'Transaction'[Cohort_Date] = SELECTEDVALUE('Transaction'[Cohort_Date]))\n)\nVAR MonthsSinceCohort = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\n\n\/\/ Risk fakt\u00f6rleri\nVAR LowVolumeRisk = IF(CurrentMonthTx < CohortAvgTx * 0.5, 30, 0)\nVAR DeclineRisk = IF(CurrentMonthTx < PrevMonthTx, 25, 0)\nVAR EarlyStageRisk = IF(MonthsSinceCohort <= 3 && CurrentMonthTx < 5, 20, 0)\nVAR InactivityRisk = IF(CurrentMonthTx = 0, 50, 0)\n\nRETURN\n LowVolumeRisk + DeclineRisk + EarlyStageRisk + InactivityRisk<\/pre>\n <\/div>\n\n <h3 class=\"content-text\"><strong>3. LTV Segmentasyonu<\/strong><\/h3>\n <p class=\"content-text\">\n Sat\u0131c\u0131lar\u0131 LTV'ye g\u00f6re kategorize ederek farkl\u0131la\u015ft\u0131r\u0131lm\u0131\u015f hizmet stratejileri uygulayabilirsiniz:\n <\/p>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Segment<\/th>\n <th>LTV Aral\u0131\u011f\u0131<\/th>\n <th>Strateji<\/th>\n <th>Kaynak Tahsisi<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><strong>Platinum<\/strong><\/td>\n <td>\u20ba100,000+<\/td>\n <td>Dedicated account manager, \u00f6zel fiyatland\u0131rma<\/td>\n <td>Y\u00fcksek<\/td>\n <\/tr>\n <tr>\n <td><strong>Gold<\/strong><\/td>\n <td>\u20ba50,000-\u20ba100,000<\/td>\n <td>Priority support, quarterly reviews<\/td>\n <td>Orta-Y\u00fcksek<\/td>\n <\/tr>\n <tr>\n <td><strong>Silver<\/strong><\/td>\n <td>\u20ba10,000-\u20ba50,000<\/td>\n <td>Standard support, self-service tools<\/td>\n <td>Orta<\/td>\n <\/tr>\n <tr>\n <td><strong>Bronze<\/strong><\/td>\n <td>\n <\u20ba10,000< \/td>\n <td>Automated onboarding, growth programs<\/td>\n <td>D\u00fc\u015f\u00fck<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">LTV Segment Hesaplama<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('ltv-segment')\">Kopyala<\/button>\n <\/div>\n <pre id=\"ltv-segment\">LTV_Segment = \nVAR LTV = [Cohort_Average_LTV]\nRETURN\n SWITCH(\n TRUE(),\n LTV >= 100000, \"Platinum\",\n LTV >= 50000, \"Gold\",\n LTV >= 10000, \"Silver\",\n \"Bronze\"\n )<\/pre>\n <\/div>\n<\/section>\n\n\n<section id=\"test-dogrulama\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udd0d Test & Do\u011frulama (Sanity Checks)<\/h2>\n <div class=\"error-box\">\n <h4 class=\"error-text\"><strong>\u26a0\ufe0f Mutlaka Yap\u0131lmas\u0131 Gerekenler:<\/strong><\/h4>\n <ol class=\"steps-list\">\n <li><span class=\"step-number\">1<\/span><strong>Cohort 0 kontrol\u00fc:<\/strong> <span\n class=\"code-inline\">Months_Since_Cohort = 0<\/span> sat\u0131rlar\u0131nda <span\n class=\"code-inline\">Cohort_Active_Count == Cohort_Size<\/span> olmal\u0131<\/li>\n <li><span class=\"step-number\">2<\/span><strong>Rastgele merchant kontrol\u00fc:<\/strong> Ham veride\n <span class=\"code-inline\">MIN(Ay_Periyodu)<\/span> ile modeldeki <span\n class=\"code-inline\">Cohort_Date<\/span> e\u015fle\u015fmeli\n <\/li>\n <li><span class=\"step-number\">3<\/span><strong>Unique counts:<\/strong> <span\n class=\"code-inline\">DISTINCTCOUNT(Sat\u0131c\u0131_ID)<\/span> ile d\u0131\u015f kaynak sonu\u00e7lar\u0131n\u0131\n kar\u015f\u0131la\u015ft\u0131r<\/li>\n <li><span class=\"step-number\">4<\/span><strong>Tarih\/timezone sorunlar\u0131:<\/strong> ETL'de t\u00fcm\n tarihleri UTC'ye \u00e7evir<\/li>\n <li><span class=\"step-number\">5<\/span><strong>Null\/0 gelir sat\u0131rlar\u0131:<\/strong> LTV hesaplan\u0131rken\n outlier trimming stratejisi belirle<\/li>\n <\/ol>\n <\/div>\n<\/section>\n\n<section id=\"gercek-ornekler\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcc8 Ger\u00e7ek D\u00fcnya \u00d6rnekleri & Benchmark<\/h2>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca Tipik Retention E\u011frisi<\/h4>\n <div class=\"stats-item\">\n <span>Month 0:<\/span>\n <span class=\"stats-value\">100%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 1:<\/span>\n <span class=\"stats-value\">~67%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 3:<\/span>\n <span class=\"stats-value\">~48-50%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 6:<\/span>\n <span class=\"stats-value\">~38%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 12:<\/span>\n <span class=\"stats-value\">~28%<\/span>\n <\/div>\n <\/div>\n\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83c\udfe2 \u00d6rnek Proje B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h4>\n <div class=\"stats-item\">\n <span>Zaman aral\u0131\u011f\u0131:<\/span>\n <span class=\"stats-value\">36 ay<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Sat\u0131c\u0131 say\u0131s\u0131:<\/span>\n <span class=\"stats-value\">52,847<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem sat\u0131r\u0131:<\/span>\n <span class=\"stats-value\">~2.35M<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Ortalama yeni sat\u0131c\u0131\/ay:<\/span>\n <span class=\"stats-value\">~1,500<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Kritik \u0130pucu:<\/strong> \u0130lk 3 ay kritik \u00f6neme sahiptir. Bu d\u00f6neme y\u00f6nelik onboarding\n yat\u0131r\u0131m\u0131n\u0131n ROI'si genelde en y\u00fcksektir.\n <\/p>\n <\/div>\n<\/section>\n\n\n<section id=\"sonuc\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfaf Sonu\u00e7 ve Eylem Plan\u0131<\/h2>\n <p class=\"content-text\">\n Cohort analizi, payment processing \u015firketleri i\u00e7in sadece bir raporlama arac\u0131 de\u011fil, stratejik karar alma ve\n b\u00fcy\u00fcme optimizasyonunun temelidir. Bu rehberi takip ederek:\n <\/p>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">1\ufe0f\u20e3 Hemen Ba\u015flay\u0131n<\/h4>\n <p class=\"content-text\">\n Verilerinizi yukar\u0131daki \u015femaya g\u00f6re organize edin. Ay_Periyodu kolonunu mutlaka ay\u0131n ilk g\u00fcn\u00fc format\u0131nda\n tutun.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">2\ufe0f\u20e3 DAX Kodlar\u0131n\u0131 Kopyalay\u0131n<\/h4>\n <p class=\"content-text\">\n Haz\u0131r measure'lar\u0131 ve calculated column'lar\u0131 modelinize aktar\u0131n. Test edin ve kendi i\u015f kurallar\u0131n\u0131za\n g\u00f6re uyarlay\u0131n.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">3\ufe0f\u20e3 Dashboard'unuzu Kurun<\/h4>\n <p class=\"content-text\">\n Executive summary, cohort heatmap ve segment analizi sayfalar\u0131n\u0131 olu\u015fturun. Conditional formatting ile\n g\u00f6rsel etki yarat\u0131n.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">4\ufe0f\u20e3 \u0130yile\u015ftirme Yap\u0131n<\/h4>\n <p class=\"content-text\">\n \u0130lk sonu\u00e7lara g\u00f6re segmentasyon, filtreleme ve ek KPI'lar ekleyin. Kullan\u0131c\u0131 feedback'i al\u0131n ve\n iterative geli\u015ftirin.\n <\/p>\n <\/div>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Kritik Ba\u015far\u0131 Metrikleri:<\/strong><\/h3>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>Ayl\u0131k retention oran\u0131 >80%<\/strong> (ilk ay i\u00e7in) - Bu alt\u0131na d\u00fc\u015f\u00fcyorsa onboarding\n s\u00fcrecinizi g\u00f6zden ge\u00e7irin<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>12 ayl\u0131k LTV\/CAC oran\u0131 >3<\/strong> - S\u00fcrd\u00fcr\u00fclebilir b\u00fcy\u00fcme i\u00e7in minimum hedef<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>Churn oran\u0131 <%15< \/strong> (ayl\u0131k) - Sa\u011fl\u0131kl\u0131 bir retention program\u0131 i\u00e7in \u00fcst limit<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>3. ay retention >45%<\/strong> - Kritik milestone, bu alt\u0131na d\u00fc\u015fenler i\u00e7in m\u00fcdahale\n program\u0131<\/span>\n <\/li>\n <\/ul>\n <\/div>\n\n <div class=\"warning-box\">\n <p class=\"warning-text\">\n <strong>\u26a0\ufe0f \u00d6nemli Hat\u0131rlatma:<\/strong> Bu analiz sistemini kurduktan sonra, ayl\u0131k bazda cohort\n performans\u0131n\u0131z\u0131 takip ederek onboarding s\u00fcre\u00e7lerinizi optimize edebilir, sat\u0131c\u0131 memnuniyetini art\u0131rabilir ve\n s\u00fcrd\u00fcr\u00fclebilir b\u00fcy\u00fcme sa\u011flayabilirsiniz. Unutmay\u0131n: Cohort analizi bir kerelik de\u011fil, s\u00fcrekli izlenmesi\n gereken bir s\u00fcre\u00e7tir.\n <\/p>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Sonraki Ad\u0131mlar:<\/strong><\/h3>\n <p class=\"content-text\">\n Bu rehberi uygulad\u0131ktan sonra a\u015fa\u011f\u0131daki geli\u015fmi\u015f teknikleri de\u011ferlendirin:\n <\/p>\n <ol class=\"steps-list\">\n <li>\n <span class=\"step-number\">1<\/span>\n <span><strong>A\/B Testleri:<\/strong> Farkl\u0131 onboarding s\u00fcre\u00e7lerinin cohort performans\u0131na etkisini \u00f6l\u00e7\u00fcn.\n \u00d6rne\u011fin: K\u0131sa vs uzun onboarding formu, self-service vs assisted setup<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">2<\/span>\n <span><strong>Machine Learning Modelleri:<\/strong> Churn prediction i\u00e7in logistic regression veya random\n forest modelleri geli\u015ftirin<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">3<\/span>\n <span><strong>Real-time Alerting:<\/strong> Power Automate kullanarak kritik metrikler i\u00e7in otomatik uyar\u0131\n sistemleri kurun<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">4<\/span>\n <span><strong>Competitive Benchmarking:<\/strong> Sekt\u00f6r standartlar\u0131yla kendi performans\u0131n\u0131z\u0131\n kar\u015f\u0131la\u015ft\u0131r\u0131n<\/span>\n <\/li>\n <\/ol>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Pro Tip:<\/strong> \u0130lk 90 g\u00fcn boyunca haftal\u0131k cohort toplant\u0131lar\u0131 yap\u0131n. Erken d\u00f6nem patternleri\n tespit etmek ve h\u0131zl\u0131 iterasyon yapmak i\u00e7in bu kritik. Sonras\u0131nda ayl\u0131k rutine ge\u00e7ebilirsiniz.\n <\/p>\n <\/div>\n<\/section>\n\n \n <section class=\"action-section\">\n <h3 class=\"action-title\">\ud83d\ude80 H\u0131zl\u0131 Eylem Plan\u0131<\/h3>\n <div class=\"action-grid\">\n <div class=\"action-card\">\n <div class=\"action-icon\">1\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">ETL'i Haz\u0131rla<\/h4>\n <p class=\"action-card-text\">CSV\/DB \u2192 Power Query ile Ay_Periyodu normalize et, Net_Kazan\u00e7\n hesapla<\/p>\n <\/div>\n <div class=\"action-card\">\n <div class=\"action-icon\">2\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">Model Kur<\/h4>\n <p class=\"action-card-text\">DateTable, Cohort_Date & Months_Since_Cohort calculated columns,\n measures ekle<\/p>\n <\/div>\n <div class=\"action-card\">\n <div class=\"action-icon\">3\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">Dashboard Olu\u015ftur & Test et<\/h4>\n <p class=\"action-card-text\">Heatmap + Executive + Segment sayfalar\u0131 kur, sanity checks \u00e7al\u0131\u015ft\u0131r\n <\/p>\n <\/div>\n <\/div>\n <div class=\"cta-buttons\">\n <a href=\"#\" class=\"cta-primary\">\n \ud83d\udcca Power BI Template \u0130ndir\n <\/a>\n <a href=\"#\" class=\"cta-secondary\">\n \ud83d\udc0d Python Kodunu \u0130ndir\n <\/a>\n <\/div>\n <\/section>\n\n \n <footer class=\"blog-footer\">\n <div class=\"footer-content\">\n <div>\n <p>Bu rehber <strong>Verintra<\/strong> taraf\u0131ndan haz\u0131rlanm\u0131\u015ft\u0131r.<\/p>\n <p>Veri odakl\u0131 dijital pazarlama \u00e7\u00f6z\u00fcmleri i\u00e7in bizimle ileti\u015fime ge\u00e7in.<\/p>\n <\/div>\n <div class=\"footer-links\">\n <a href=\"https:\/\/www.linkedin.com\/company\/verintra\/\">LinkedIn<\/a>\n <a href=\"https:\/\/x.com\/Verintra\">Twitter<\/a>\n <a href=\"https:\/\/verintra.com\/blog\/\">Blog<\/a>\n <\/div>\n <\/div>\n <\/footer>\n <\/div>\n <\/main>\n\n <script>\n function copyToClipboard(elementId) {\n const element = document.getElementById(elementId);\n const text = element.textContent;\n\n if (navigator.clipboard) {\n navigator.clipboard.writeText(text).then(() => {\n \/\/ Kopyalama ba\u015far\u0131l\u0131 feedback'i\n const button = element.parentNode.querySelector('.copy-button');\n const originalText = button.textContent;\n button.textContent = 'Kopyaland\u0131!';\n button.style.backgroundColor = '#10b981';\n\n setTimeout(() => {\n button.textContent = originalText;\n button.style.backgroundColor = '#3eb3d1';\n }, 2000);\n });\n } else {\n \/\/ Fallback for older browsers\n const textArea = document.createElement('textarea');\n textArea.value = text;\n document.body.appendChild(textArea);\n textArea.select();\n document.execCommand('copy');\n document.body.removeChild(textArea);\n\n const button = element.parentNode.querySelector('.copy-button');\n const originalText = button.textContent;\n button.textContent = 'Kopyaland\u0131!';\n setTimeout(() => {\n button.textContent = originalText;\n }, 2000);\n }\n }\n\n \/\/ Smooth scrolling for internal links\n document.querySelectorAll('a[href^=\"#\"]').forEach(anchor => {\n anchor.addEventListener('click', function (e) {\n e.preventDefault();\n const target = document.querySelector(this.getAttribute('href'));\n if (target) {\n target.scrollIntoView({\n behavior: 'smooth',\n block: 'start'\n });\n }\n });\n });\n <\/script>\n<\/body>\n\n<\/html>\n\n\n\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]<\/p>\n","protected":false},"author":1,"featured_media":1953,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"normal-width-container","site-content-style":"unboxed","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"enabled","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11,12],"tags":[],"class_list":["post-1983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-istatistiksel-metodlar","category-veri-analizi"],"acf":[],"yoast_head":"\n<title>Power BI ile Cohort Analizi - Verintra Digital<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI ile Cohort Analizi - Verintra Digital\" \/>\n<meta property=\"og:description\" content=\"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/\" \/>\n<meta property=\"og:site_name\" content=\"Verintra Digital\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-09T20:07:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-15T11:15:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"734\" \/>\n\t<meta property=\"og:image:height\" content=\"734\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"gokhanagarer@gmail.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"gokhanagarer@gmail.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"16\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"},\"author\":{\"name\":\"gokhanagarer@gmail.com\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/person\\\/2d47a094bd20bbb9a1f9965d1234fe48\"},\"headline\":\"Power BI ile Cohort Analizi\",\"datePublished\":\"2025-12-09T20:07:36+00:00\",\"dateModified\":\"2025-12-15T11:15:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"},\"wordCount\":3095,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"articleSection\":[\"\u0130statistiksel Metodlar\",\"Veri Analizi\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\",\"url\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\",\"name\":\"Power BI ile Cohort Analizi - Verintra Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"datePublished\":\"2025-12-09T20:07:36+00:00\",\"dateModified\":\"2025-12-15T11:15:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"width\":734,\"height\":734},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/verintra.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI ile Cohort Analizi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#website\",\"url\":\"https:\\\/\\\/verintra.com\\\/\",\"name\":\"Verintra\",\"description\":\"Veri Odakl\u0131 Dijital Pazaralama Ajans\u0131\",\"publisher\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/verintra.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\",\"name\":\"Verintra Digital\",\"url\":\"https:\\\/\\\/verintra.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/verintra-homepage-logo.png\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/verintra-homepage-logo.png\",\"width\":304,\"height\":76,\"caption\":\"Verintra Digital\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/person\\\/2d47a094bd20bbb9a1f9965d1234fe48\",\"name\":\"gokhanagarer@gmail.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"caption\":\"gokhanagarer@gmail.com\"},\"sameAs\":[\"https:\\\/\\\/verintra.com\"]}]}<\/script>\n","yoast_head_json":{"title":"Power BI ile Cohort Analizi - Verintra Digital","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","og_locale":"de_DE","og_type":"article","og_title":"Power BI ile Cohort Analizi - Verintra Digital","og_description":"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]","og_url":"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","og_site_name":"Verintra Digital","article_published_time":"2025-12-09T20:07:36+00:00","article_modified_time":"2025-12-15T11:15:38+00:00","og_image":[{"width":734,"height":734,"url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","type":"image\/jpeg"}],"author":"gokhanagarer@gmail.com","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"gokhanagarer@gmail.com","Gesch\u00e4tzte Lesezeit":"16\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#article","isPartOf":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"},"author":{"name":"gokhanagarer@gmail.com","@id":"https:\/\/verintra.com\/#\/schema\/person\/2d47a094bd20bbb9a1f9965d1234fe48"},"headline":"Power BI ile Cohort Analizi","datePublished":"2025-12-09T20:07:36+00:00","dateModified":"2025-12-15T11:15:38+00:00","mainEntityOfPage":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"},"wordCount":3095,"commentCount":0,"publisher":{"@id":"https:\/\/verintra.com\/#organization"},"image":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"thumbnailUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","articleSection":["\u0130statistiksel Metodlar","Veri Analizi"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","url":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","name":"Power BI ile Cohort Analizi - Verintra Digital","isPartOf":{"@id":"https:\/\/verintra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"image":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"thumbnailUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","datePublished":"2025-12-09T20:07:36+00:00","dateModified":"2025-12-15T11:15:38+00:00","breadcrumb":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage","url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","contentUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","width":734,"height":734},{"@type":"BreadcrumbList","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/verintra.com\/"},{"@type":"ListItem","position":2,"name":"Power BI ile Cohort Analizi"}]},{"@type":"WebSite","@id":"https:\/\/verintra.com\/#website","url":"https:\/\/verintra.com\/","name":"Verintra","description":"Veri Odakl\u0131 Dijital Pazaralama Ajans\u0131","publisher":{"@id":"https:\/\/verintra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/verintra.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/verintra.com\/#organization","name":"Verintra Digital","url":"https:\/\/verintra.com\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/#\/schema\/logo\/image\/","url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/04\/verintra-homepage-logo.png","contentUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/04\/verintra-homepage-logo.png","width":304,"height":76,"caption":"Verintra Digital"},"image":{"@id":"https:\/\/verintra.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/verintra.com\/#\/schema\/person\/2d47a094bd20bbb9a1f9965d1234fe48","name":"gokhanagarer@gmail.com","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","url":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","contentUrl":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","caption":"gokhanagarer@gmail.com"},"sameAs":["https:\/\/verintra.com"]}]}},"uagb_featured_image_src":{"full":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"thumbnail":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis-150x150.jpg",150,150,true],"medium":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis-300x300.jpg",300,300,true],"medium_large":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"large":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"1536x1536":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"2048x2048":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"trp-custom-language-flag":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",12,12,false]},"uagb_author_info":{"display_name":"gokhanagarer@gmail.com","author_link":"https:\/\/verintra.com\/de\/blog\/author\/gokhanagarergmail-com\/"},"uagb_comment_info":0,"uagb_excerpt":"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query…","_links":{"self":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/comments?post=1983"}],"version-history":[{"count":10,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983\/revisions"}],"predecessor-version":[{"id":2057,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983\/revisions\/2057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/media\/1953"}],"wp:attachment":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/media?parent=1983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/categories?post=1983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/tags?post=1983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":1983,"date":"2025-12-09T20:07:36","date_gmt":"2025-12-09T20:07:36","guid":{"rendered":"https:\/\/verintra.com\/?p=1983"},"modified":"2025-12-15T11:15:38","modified_gmt":"2025-12-15T11:15:38","slug":"power-bi-ile-cohort-analizi","status":"publish","type":"post","link":"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","title":{"rendered":"Power BI ile Cohort Analizi"},"content":{"rendered":"\n\n\n\n\n \n \n Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber<\/title>\n\n \n <meta name=\"description\"\n content=\"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Stratejik yorumdan pratik implementasyona, \u00f6rnek veri seti olu\u015fturmadan sanity check'lere kadar kapsaml\u0131 rehber.\">\n <meta name=\"keywords\"\n content=\"Power BI, cohort analizi, LTV, retention analizi, payment processing, veri analizi, DAX, Power Query\">\n <meta name=\"author\" content=\"Verintra\">\n\n \n <meta property=\"og:title\" content=\"Payment Processing i\u00e7in Power BI Cohort Analizi \u2014 Kapsaml\u0131 Rehber\">\n <meta property=\"og:description\"\n content=\"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Python \u00f6rnek veri kodu ile birlikte.\">\n <meta property=\"og:type\" content=\"article\">\n <meta property=\"og:url\" content=\"https:\/\/verintra.com\/blog\/power-bi-cohort-analizi\">\n <meta property=\"og:image\" content=\"https:\/\/verintra.com\/images\/power-bi-cohort-og.jpg\">\n <meta property=\"og:site_name\" content=\"Verintra\">\n\n \n <meta name=\"twitter:card\" content=\"summary_large_image\">\n <meta name=\"twitter:title\" content=\"Payment Processing i\u00e7in Power BI Cohort Analizi\">\n <meta name=\"twitter:description\"\n content=\"Kapsaml\u0131 Power BI cohort analizi rehberi. Python kodu, DAX \u00f6rnekleri ve ger\u00e7ek d\u00fcnya uygulamalar\u0131.\">\n <meta name=\"twitter:image\" content=\"https:\/\/verintra.com\/images\/power-bi-cohort-twitter.jpg\">\n\n \n <script type=\"application\/ld+json\">\n {\n \"@context\": \"https:\/\/schema.org\",\n \"@type\": \"TechArticle\",\n \"headline\": \"Payment Processing i\u00e7in Power BI Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber\",\n \"description\": \"Sat\u0131c\u0131 retention ve LTV analizini Power BI ile ba\u015ftan sona kurup uygulay\u0131n. Stratejik yorumdan pratik implementasyona, \u00f6rnek veri seti olu\u015fturmadan sanity check'lere kadar her \u015fey bu rehberde.\",\n \"image\": \"https:\/\/verintra.com\/images\/power-bi-cohort-featured.jpg\",\n \"author\": {\n \"@type\": \"Organization\",\n \"name\": \"Verintra\",\n \"url\": \"https:\/\/verintra.com\"\n },\n \"publisher\": {\n \"@type\": \"Organization\",\n \"name\": \"Verintra\",\n \"logo\": {\n \"@type\": \"ImageObject\",\n \"url\": \"https:\/\/verintra.com\/logo.png\"\n }\n },\n \"datePublished\": \"2025-08-23T10:00:00+03:00\",\n \"dateModified\": \"2025-08-23T10:00:00+03:00\",\n \"mainEntityOfPage\": {\n \"@type\": \"WebPage\",\n \"@id\": \"https:\/\/verintra.com\/blog\/power-bi-cohort-analizi\"\n },\n \"articleSection\": \"Veri Analizi\",\n \"keywords\": [\"Power BI\", \"cohort analizi\", \"LTV\", \"retention analizi\", \"payment processing\", \"veri analizi\", \"DAX\", \"Power Query\"],\n \"about\": [\n {\n \"@type\": \"Thing\",\n \"name\": \"Power BI\"\n },\n {\n \"@type\": \"Thing\", \n \"name\": \"Cohort Analizi\"\n },\n {\n \"@type\": \"Thing\",\n \"name\": \"LTV Analizi\"\n }\n ],\n \"teaches\": [\n \"Power BI ile cohort analizi kurulumu\",\n \"DAX measure'lar\u0131 yazma\",\n \"Python ile \u00f6rnek veri olu\u015fturma\",\n \"Retention analizi yapma\"\n ]\n }\n <\/script>\n\n <style>\n * {\n margin: 0;\n padding: 0;\n box-sizing: border-box;\n }\n\n body {\n font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, Cantarell, sans-serif;\n line-height: 1.6;\n color: #ffffff;\n background-color: #1e1d20;\n }\n\n .container {\n max-width: 1200px;\n margin: 0 auto;\n padding: 0 1.5rem;\n }\n\n .blog-header {\n background: linear-gradient(to bottom, #3eb3d1, #05767d);\n padding: 4rem 0;\n text-align: left;\n }\n\n .category-tags {\n font-size: 0.875rem;\n text-transform: uppercase;\n letter-spacing: 0.1em;\n color: rgba(255, 255, 255, 0.8);\n margin-bottom: 1rem;\n }\n\n .main-title {\n font-size: clamp(2rem, 4vw, 3rem);\n font-weight: 700;\n line-height: 1.2;\n margin-bottom: 1.5rem;\n }\n\n .title-subtitle {\n color: rgba(255, 255, 255, 0.9);\n }\n\n .lead-text {\n font-size: 1.125rem;\n color: rgba(255, 255, 255, 0.9);\n margin-bottom: 2rem;\n line-height: 1.6;\n }\n\n .meta-info {\n display: flex;\n flex-wrap: wrap;\n gap: 1rem;\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.8);\n }\n\n .blog-content {\n padding: 3rem 0;\n }\n\n .toc-box {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n margin-bottom: 3rem;\n border: 1px solid #374151;\n }\n\n .toc-title {\n font-size: 1.25rem;\n font-weight: 700;\n color: #3eb3d1;\n margin-bottom: 1rem;\n }\n\n .toc-list {\n list-style: none;\n padding: 0;\n }\n\n .toc-list li {\n margin-bottom: 0.5rem;\n }\n\n .toc-list a {\n color: rgba(255, 255, 255, 0.8);\n text-decoration: none;\n font-size: 0.875rem;\n transition: color 0.3s ease;\n }\n\n .toc-list a:hover {\n color: #3eb3d1;\n }\n\n .content-section {\n margin-bottom: 3rem;\n }\n\n .section-title {\n font-size: 1.5rem;\n font-weight: 700;\n color: #3eb3d1;\n margin-bottom: 1.5rem;\n }\n\n .content-text {\n font-size: 1.125rem;\n color: rgba(255, 255, 255, 0.9);\n margin-bottom: 1.5rem;\n line-height: 1.6;\n }\n\n .highlight-box {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border-left: 4px solid #3eb3d1;\n margin-bottom: 1.5rem;\n }\n\n .highlight-list {\n list-style: none;\n padding: 0;\n }\n\n .highlight-list li {\n display: flex;\n align-items: flex-start;\n gap: 0.75rem;\n margin-bottom: 0.75rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .list-bullet {\n color: #3eb3d1;\n font-weight: bold;\n margin-top: 0.25rem;\n }\n\n .data-table {\n width: 100%;\n background-color: #000000;\n border-radius: 0.5rem;\n border: 1px solid #374151;\n overflow-x: auto;\n margin-bottom: 1.5rem;\n }\n\n .data-table table {\n width: 100%;\n border-collapse: collapse;\n }\n\n .data-table th {\n padding: 1rem;\n text-align: left;\n font-weight: 600;\n background-color: rgba(62, 179, 209, 0.2);\n }\n\n .data-table td {\n padding: 1rem;\n border-top: 1px solid #374151;\n font-size: 0.875rem;\n }\n\n .field-name {\n font-family: 'Courier New', monospace;\n color: #3eb3d1;\n }\n\n .warning-box {\n background-color: rgba(249, 115, 22, 0.2);\n border: 1px solid rgba(249, 115, 22, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-bottom: 1.5rem;\n }\n\n .warning-text {\n color: #fed7aa;\n }\n\n .code-inline {\n background-color: rgba(0, 0, 0, 0.5);\n padding: 0.25rem 0.5rem;\n border-radius: 0.25rem;\n font-family: 'Courier New', monospace;\n font-size: 0.875rem;\n }\n\n .steps-list {\n list-style: none;\n padding: 0;\n }\n\n .steps-list li {\n display: flex;\n gap: 0.75rem;\n margin-bottom: 0.75rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .step-number {\n background-color: #3eb3d1;\n color: #000;\n font-weight: 700;\n padding: 0.25rem 0.5rem;\n border-radius: 0.25rem;\n font-size: 0.875rem;\n min-width: 2rem;\n text-align: center;\n }\n\n .code-block {\n background-color: #1e1e1e;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border: 1px solid #35C7D6;\n margin-bottom: 1.5rem;\n overflow-x: auto;\n}\n\n .code-header {\n display: flex;\n justify-content: space-between;\n align-items: center;\n margin-bottom: 1rem;\n }\n\n .code-title {\n font-weight: 600;\n color: #3eb3d1;\n }\n\n .copy-button {\n font-size: 0.75rem;\n background-color: #3eb3d1;\n color: #000;\n padding: 0.25rem 0.75rem;\n border-radius: 0.25rem;\n border: none;\n cursor: pointer;\n transition: background-color 0.3s ease;\n }\n\n .copy-button:hover {\n background-color: rgba(62, 179, 209, 0.8);\n }\n\n pre {\n font-family: 'Courier New', Consolas, Monaco, monospace;\n font-size: 0.875rem;\n color: #000000;\n overflow-x: auto;\n line-height: 1.6;\n \n margin: 0;\n}\n\n\/* DAX keyword'leri i\u00e7in *\/\npre .keyword {\n color: #569cd6;\n font-weight: 600;\n}\n\n\/* Fonksiyon isimleri i\u00e7in *\/\npre .function {\n color: #dcdcaa;\n}\n\n\/* String'ler i\u00e7in *\/\npre .string {\n color: #ce9178;\n}\n\n\/* Yorum sat\u0131rlar\u0131 i\u00e7in *\/\npre .comment {\n color: #6a9955;\n font-style: italic;\n}\n\n .info-box {\n background-color: rgb(0, 0, 0);\n border: 1px solid rgba(34, 197, 94, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-bottom: 1.5rem;\n }\n\n .info-text {\n color: #bbf7d0;\n }\n\n .tip-box {\n background-color: rgba(59, 130, 246, 0.2);\n border: 1px solid rgba(59, 130, 246, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n margin-top: 1.5rem;\n }\n\n .tip-text {\n color: #bfdbfe;\n }\n\n .error-box {\n background-color: rgba(239, 68, 68, 0.2);\n border: 1px solid rgba(239, 68, 68, 0.5);\n border-radius: 0.5rem;\n padding: 1rem;\n }\n\n .error-text {\n color: #fecaca;\n }\n\n .stats-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(300px, 1fr));\n gap: 1.5rem;\n margin-bottom: 2rem;\n }\n\n .stats-card {\n background-color: #000000;\n border-radius: 0.5rem;\n padding: 1.5rem;\n border: 1px solid #374151;\n }\n\n .stats-title {\n font-weight: 600;\n color: #3eb3d1;\n margin-bottom: 1rem;\n }\n\n .stats-item {\n display: flex;\n justify-content: space-between;\n margin-bottom: 0.5rem;\n font-size: 0.875rem;\n }\n\n .stats-value {\n font-family: 'Courier New', monospace;\n }\n\n .action-section {\n background: linear-gradient(to right, #3eb3d1, #05767d);\n border-radius: 0.5rem;\n padding: 2rem;\n text-align: center;\n margin-top: 3rem;\n }\n\n .action-title {\n font-size: 1.5rem;\n font-weight: 700;\n margin-bottom: 1rem;\n }\n\n .action-grid {\n display: grid;\n grid-template-columns: repeat(auto-fit, minmax(250px, 1fr));\n gap: 1.5rem;\n margin-bottom: 1.5rem;\n }\n\n .action-card {\n background-color: rgba(0, 0, 0, 0.2);\n border-radius: 0.5rem;\n padding: 1rem;\n }\n\n .action-icon {\n font-size: 1.5rem;\n margin-bottom: 0.5rem;\n }\n\n .action-card-title {\n font-weight: 600;\n margin-bottom: 0.5rem;\n }\n\n .action-card-text {\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.9);\n }\n\n .cta-buttons {\n display: flex;\n flex-direction: column;\n gap: 0.75rem;\n align-items: center;\n }\n\n .cta-primary {\n display: inline-block;\n background-color: #ffffff;\n color: #3eb3d1;\n padding: 0.75rem 1.5rem;\n border-radius: 0.5rem;\n text-decoration: none;\n font-weight: 600;\n transition: background-color 0.3s ease;\n }\n\n .cta-primary:hover {\n background-color: rgba(255, 255, 255, 0.9);\n }\n\n .cta-secondary {\n display: inline-block;\n background-color: rgba(0, 0, 0, 0.3);\n color: #ffffff;\n padding: 0.75rem 1.5rem;\n border-radius: 0.5rem;\n text-decoration: none;\n font-weight: 600;\n transition: background-color 0.3s ease;\n }\n\n .cta-secondary:hover {\n background-color: rgba(0, 0, 0, 0.4);\n }\n\n .blog-footer {\n margin-top: 4rem;\n padding-top: 2rem;\n border-top: 1px solid #374151;\n }\n\n .footer-content {\n display: flex;\n flex-wrap: wrap;\n justify-content: space-between;\n align-items: center;\n gap: 1rem;\n font-size: 0.875rem;\n color: rgba(255, 255, 255, 0.6);\n }\n\n .footer-links {\n display: flex;\n gap: 1rem;\n }\n\n .footer-links a {\n color: #3eb3d1;\n text-decoration: none;\n transition: color 0.3s ease;\n }\n\n .footer-links a:hover {\n color: #ffffff;\n }\n\n @media (max-width: 768px) {\n .container {\n padding: 0 1rem;\n }\n\n .blog-header {\n padding: 2rem 0;\n }\n\n .meta-info {\n flex-direction: column;\n gap: 0.5rem;\n }\n\n .stats-grid {\n grid-template-columns: 1fr;\n }\n\n .action-grid {\n grid-template-columns: 1fr;\n }\n\n .footer-content {\n flex-direction: column;\n text-align: center;\n }\n }\n <\/style>\n<\/head>\n\n<body>\n \n <header class=\"blog-header\">\n <div class=\"container\">\n <div class=\"category-tags\">\n Veri Analizi \u2022 Power BI \u2022 Cohort Analizi\n <\/div>\n <h1 class=\"main-title\">\n Power BI ile Cohort Analizi\n <span class=\"title-subtitle\"> \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber<\/span>\n <\/h1>\n <div class=\"lead-text\">\n Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini\n Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query + DAX + model\n tasar\u0131m\u0131) hem de stratejik yorumu i\u00e7erir. <br \/><br \/>Son k\u0131s\u0131mda test edebilmeniz i\u00e7in sentetik \u00f6rnek veri olu\u015fturma kodu da var.\n <\/div>\n <div class=\"meta-info\">\n <span>\ud83d\udcc5 Yay\u0131n Tarihi: 23 A\u011fustos 2025<\/span>\n <span>\u23f1\ufe0f Okuma S\u00fcresi: 15 dakika<\/span>\n <span>\ud83d\udcca Zorluk: Orta<\/span>\n <\/div>\n <\/div>\n <\/header>\n\n \n <main class=\"blog-content\">\n <div class=\"container\">\n\n \n <nav class=\"toc-box\" role=\"navigation\" aria-label=\"\u0130\u00e7indekiler\">\n <h2 class=\"toc-title\">\ud83d\udccb \u0130\u00e7erik<\/h2>\n <ul class=\"toc-list\">\n <li><a href=\"#neden-cohort\">\u2022 Neden Cohort Analizi?<\/a><\/li>\n <li><a href=\"#veri-modeli\">\u2022 Veri Modeli & \u015eema<\/a><\/li>\n <li><a href=\"#power-query\">\u2022 Power Query (ETL) – Temizleme & Normalize<\/a><\/li>\n <li><a href=\"#calculated-columns\">\u2022 Calculated Columns – Cohort Temelleri<\/a><\/li>\n <li><a href=\"#dax-measures\">\u2022 Temel DAX Measures<\/a><\/li>\n <li><a href=\"#ornek-veri\">\u2022 \u00d6rnek Veri Olu\u015fturma (Python)<\/a><\/li>\n <li><a href=\"#test-dogrulama\">\u2022 Test & Do\u011frulama<\/a><\/li>\n <li><a href=\"#gercek-ornekler\">\u2022 Ger\u00e7ek D\u00fcnya \u00d6rnekleri<\/a><\/li>\n <\/ul>\n <\/nav>\n\n \n <section id=\"neden-cohort\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfaf Neden Cohort Analizi? (K\u0131sa ve Net)<\/h2>\n <p class=\"content-text\">\n Cohort analizi, belirli bir zaman diliminde (genellikle ay) sisteme kat\u0131lan kullan\u0131c\u0131lar\u0131n (bu durumda sat\u0131c\u0131lar\u0131n)\n zaman i\u00e7indeki davran\u0131\u015flar\u0131n\u0131 izlemeye yarayan g\u00fc\u00e7l\u00fc bir analiz y\u00f6ntemidir. Payment processing sekt\u00f6r\u00fcnde bu analiz\n \u00f6zellikle de\u011ferlidir \u00e7\u00fcnk\u00fc:<\/p>\n\n \n\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131 edinim maliyeti (CAC)<\/strong> ile <strong>lifetime value (LTV)<\/strong> aras\u0131ndaki dengeyi g\u00f6sterir<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>\u0130\u015f b\u00fcy\u00fcmesinin s\u00fcrd\u00fcr\u00fclebilirli\u011fini de\u011ferlendirme f\u0131rsat\u0131 verir<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Hangi onboarding\/entegrasyonun<\/strong> i\u015fe yarad\u0131\u011f\u0131n\u0131 ortaya koyar<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Churn kritik d\u00f6nemini<\/strong> tahminlemesi ve \u00f6nleme stratejileri geli\u015ftirilmesine yard\u0131mc\u0131 olur<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Segment bazl\u0131 performans<\/strong> kar\u015f\u0131la\u015ft\u0131rmas\u0131 sa\u011flar<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <\/section>\n\n \n <section id=\"is-hedefleri\" class=\"content-section\">\n <h2 class=\"section-title\"> \ud83c\udfaf \u0130\u015f Hedefleri:<\/h2>\n <p class=\"content-text\">\n Bu cohort analizi sistemini kurduktan sonra a\u015fa\u011f\u0131daki stratejik sorulara cevap alabileceksiniz:<\/p>\n\n <h3 class=\"title-subtitle\">Retention & Churn Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Her ay edinilen sat\u0131c\u0131lar\u0131n 1., 3., 6., 12. ayda hayatta kalma (active) oran\u0131 nedir?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Retention d\u00fc\u015f\u00fc\u015f\u00fc hangi aya yo\u011funla\u015f\u0131yor? (kritik m\u00fcdahale zaman\u0131)<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi cohort’lar\u0131n retention performans\u0131 daha iyi?<\/span>\n <\/li>\n <\/ul><br\/>\n\n <h3 class=\"title-subtitle\">LTV & Revenue Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi cohort’lar\u0131n LTV’si h\u0131zl\u0131 y\u00fckseliyor, hangileri d\u00fc\u015f\u00fck kal\u0131yor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Ortalama k\u00fcm\u00fclatif gelir (LTV) nas\u0131l geli\u015fiyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>CAC geri \u00f6deme s\u00fcresi ka\u00e7 ay?<\/span>\n <\/li>\n <\/ul><br\/>\n\n <h3 class=\"title-subtitle\">Segmentasyon Sorular\u0131<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi \u00fcr\u00fcn tiplerinde (API vs iframe vs vPOS) retention farklar\u0131 var?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>\u0130\u015f kollar\u0131na g\u00f6re (MCC kodlar\u0131) sat\u0131c\u0131 davran\u0131\u015flar\u0131 nas\u0131l de\u011fi\u015fiyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>B\u00fcy\u00fck vs k\u00fc\u00e7\u00fck i\u015flem hacimli sat\u0131c\u0131lar aras\u0131nda fark var m\u0131?<\/span>\n <\/li>\n <\/ul><br\/> \n\n <h3 class=\"title-subtitle\">Operasyonel Kararlar<\/h3>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>K\u0131sa d\u00f6nemde hangi metrikleri kullanarak churn riski tespit edebilirim?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Hangi aylarda yeni sat\u0131c\u0131 edinimi daha ba\u015far\u0131l\u0131 oluyor?<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span>Onboarding s\u00fcrecimde hangi iyile\u015ftirmeler en etkili olacak?<\/span>\n <\/li>\n <\/ul><br \/>\n <\/section>\n <section id=\"veri-modeli\" class=\"content-section\">\n <div>\n <h2 class=\"section-title\">\ud83d\uddc3\ufe0f Veri Modeli & \u015eema<\/h2>\n <p class=\"content-text\">\n Power BI modelinin sa\u011fl\u0131kl\u0131 \u00e7al\u0131\u015fmas\u0131 i\u00e7in \u00f6nerilen temel alanlar:\n <\/p>\n <\/div>\n\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Alan<\/th>\n <th>Tip<\/th>\n <th>A\u00e7\u0131klama<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">Ay_Periyodu<\/span><\/td>\n <td>date(ay\u0131n ilk g\u00fcn\u00fc)<\/td>\n <td>Ay bazl\u0131 cohort analiz referans\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Sat\u0131c\u0131_ID<\/span><\/td>\n <td>text\/int<\/td>\n <td>Benzersiz merchant ID<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u00dcr\u00fcn_Tipi<\/span><\/td>\n <td>text<\/td>\n <td>API \/ iframe \/ vPOS \/ POS<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Toplam_Gelir<\/span><\/td>\n <td>decimal<\/td>\n <td>Br\u00fct gelir<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Tum_Maliyetler<\/span><\/td>\n <td>decimal<\/td>\n <td>Banka\/i\u015flem maliyetleri<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Net_Kazan\u00e7<\/span><\/td>\n <td>decimal<\/td>\n <td>Toplam_Gelir – Tum_Maliyetler<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u0130\u015flem_Say\u0131s\u0131<\/span><\/td>\n <td>decimal<\/td>\n <td>Ger\u00e7ekle\u015fen \u0130\u015flem Adedi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">\u0130\u015flem_Hacmi<\/span><\/td>\n <td>decimal<\/td>\n <td>Ger\u00e7ekle\u015fen \u0130\u015flem Hacmi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">Sektor_Kodu<\/span><\/td>\n <td>decimal<\/td>\n <td>Sekt\u00f6rel Gruplama<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <div class=\"warning-box\">\n <p class=\"warning-text\">\n <strong>\u26a0\ufe0f \u00d6nemli:<\/strong> <span class=\"code-inline\">Ay_Periyodu<\/span>\n mutlaka ay\u0131n ilk g\u00fcn\u00fc olmal\u0131 (<span class=\"code-inline\">YYYY-MM-01<\/span>).\n Bu Power BI time-intelligence ile uyumlu \u00e7al\u0131\u015fmay\u0131 sa\u011flar.\n <\/p>\n <p class=\"warning-text\">\n <span class=\"list-bullet\">\u2022<\/span>\n <span class=\"code-inline\">Net_Kazan\u00e7<\/span> hesaplamas\u0131n\u0131 ETL a\u015famas\u0131nda yaparsan\u0131z model performans\u0131 artar.\n <\/p>\n <p class=\"warning-text\">\n <span class=\"list-bullet\">\u2022<\/span>\n Sat\u0131c\u0131 ID’lerin benzersiz oldu\u011fundan emin olun; ayn\u0131 sat\u0131c\u0131n\u0131n birden fazla ID’si varsa \u00f6nce dedupe i\u015flemi yap\u0131n.\n <\/p>\n <\/div>\n <\/section>\n\n <section id=\"ornek-veri\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udc0d \u00d6rnek Veri Olu\u015fturma (Python)<\/h2>\n <p class=\"content-text\">\n A\u015fa\u011f\u0131daki Python kodu, Power BI ile deney yapman\u0131z i\u00e7in ger\u00e7ek\u00e7i davran\u0131\u015flar\u0131 taklit eden\n ~10,000 sat\u0131c\u0131 ayl\u0131k verisi \u00fcretir (2022-01 \u2192 2024-12):\n <\/p>\n \n <div class=\"code-block\" style=\"max-height: 400px; overflow-y: auto;\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">cohort_data_generator.py<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('python-code')\">Kopyala<\/button>\n <\/div>\n <pre id=\"python-code\">\n import pandas as pd\n import numpy as np\n import random\n from datetime import datetime, timedelta\n \n # Seed ayarlama (tekrarlanabilir sonu\u00e7lar i\u00e7in)\n np.random.seed(42)\n random.seed(42)\n \n # Parametreler\n n_merchants = 10000\n start_date = datetime(2022, 1, 1)\n end_date = datetime(2024, 12, 1)\n months = pd.date_range(start=start_date, end=end_date, freq='MS').to_pydatetime().tolist()\n \n # \u00dcr\u00fcn tipleri ve kategori kodlar\u0131\n product_types = ['API', 'iframe', 'vPOS', 'POS']\n mcc_codes = ['5411', '5812', '5651', '5999', '5611', '5311', '5732', '5691']\n \n rows = []\n \n # Her sat\u0131c\u0131 i\u00e7in temel \u00f6zellikler\n merchant_avg_tx_value = np.random.lognormal(mean=8.0, sigma=0.8, size=n_merchants)\n merchant_base_retention = np.random.choice([0.9, 0.7, 0.6, 0.5], size=n_merchants, p=[0.25, 0.25, 0.3, 0.2])\n \n for i in range(n_merchants):\n merchant_id = f\"M{100000 + i}\"\n cohort_month = random.choice(months)\n product = random.choice(product_types)\n mcc = random.choice(mcc_codes)\n avg_tx = merchant_avg_tx_value[i]\n base_ret = merchant_base_retention[i]\n \n # \u00dcr\u00fcn tipine g\u00f6re retention ayarlamas\u0131\n if product == 'API':\n base_ret *= 1.05\n elif product == 'iframe':\n base_ret *= 0.85\n elif product == 'vPOS':\n base_ret *= 0.9\n else:\n base_ret *= 0.95\n \n # Cohort'tan itibaren her ay i\u00e7in\n for month in months:\n if month < cohort_month: continue months_since=(month.year - cohort_month.year) * 12 + (month.month -\n cohort_month.month) # Retention olas\u0131l\u0131\u011f\u0131 zamanla azal\u0131r retention_prob=max(0.01, base_ret * np.exp(-0.25 *\n months_since)) active=np.random.rand() < retention_prob if not active: continue # \u0130\u015flem say\u0131s\u0131 (Poisson da\u011f\u0131l\u0131m\u0131)\n tx_count=max(1, np.random.poisson(lam=2 + 0.02 * months_since)) # Mevsimsellik etkisi seasonal=1.0 if month.month in\n [11, 12]: # Kas\u0131m-Aral\u0131k seasonal=1.2 elif month.month in [6, 7, 8]: # Yaz aylar\u0131 seasonal=1.05 # \u0130\u015flem hacmi\n hesaplama tx_volume=max(0.0, np.random.normal( loc=tx_count * avg_tx * seasonal, scale=0.1 * tx_count * avg_tx ))\n toplam_gelir=float(round(tx_volume, 2)) # Maliyet hesaplamalar\u0131 maliyet_orani=np.random.uniform(0.01, 0.035)\n tum_maliyet=round(toplam_gelir * maliyet_orani, 2) net_kazanc=round(toplam_gelir - tum_maliyet, 2)\n rows.append({ \"Ay_Periyodu\" : month.strftime(\"%Y-%m-01\"), \"Sat\u0131c\u0131_ID\" : merchant_id, \"\u00dcr\u00fcn_Tipi\" :\n product, \"Toplam_Gelir\" : toplam_gelir, \"Kategori_Kodu\" : mcc, \"T\u00fcm_Maliyetler\" : tum_maliyet, \"Net_Kazan\u00e7\" :\n net_kazanc, \"\u0130\u015flem_Hacmi\" : round(toplam_gelir, 2), \"\u0130\u015flem_Say\u0131s\u0131\" : int(tx_count) }) # DataFrame olu\u015fturma\n df=pd.DataFrame(rows) df['Ay_Periyodu']=pd.to_datetime(df['Ay_Periyodu']) # Rastgele s\u0131ralama df=df.sample(frac=1,\n random_state=42).reset_index(drop=True) # CSV olarak kaydetme df.to_csv(\"cohort_sample_10000_2022-2024.csv\",\n index=False) print(f\"Veri seti olu\u015fturuldu: {len(df)} sat\u0131r, {df['Sat\u0131c\u0131_ID'].nunique()} benzersiz sat\u0131c\u0131\")\n print(f\"Tarih aral\u0131\u011f\u0131: {df['Ay_Periyodu'].min()} - {df['Ay_Periyodu'].max()}\") print(f\"Ortalama ayl\u0131k gelir:\n \u20ba{df['Net_Kazan\u00e7'].mean():,.2f}\") # \u0130lk birka\u00e7 sat\u0131r\u0131 g\u00f6sterme print(\"\\n\u00d6rnek veriler:\")\n print(df.head().to_string()) <\/pre>\n <\/div>\n \n <div class=\"info-box\">\n <p class=\"content-text\">\n Bu kod yakla\u015f\u0131k 10.000 sat\u0131c\u0131 i\u00e7in 2022-01 ile 2024-12 tarihleri aras\u0131ndaki ayl\u0131k i\u015flem davran\u0131\u015f\u0131n\u0131 sim\u00fcle eder.\n Sim\u00fclasyonda:\n <\/p>\n <h4 class=\"info-text\"><strong>Kod \u00d6zellikleri:<\/strong><\/h4>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Her sat\u0131c\u0131n\u0131n ortalama i\u015flem de\u011feri log-normal da\u011f\u0131l\u0131mla belirlenir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Ayl\u0131k devam etme (retention) olas\u0131l\u0131\u011f\u0131 zamanla exponential decay g\u00f6sterir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> Mevsimsellik fakt\u00f6rleri (Kas\u0131m-Aral\u0131k yo\u011funlu\u011fu) dahil edilir\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span> \u00dcr\u00fcn tiplerine g\u00f6re retention farkl\u0131l\u0131klar\u0131 modellenir\n <\/ul>\n <\/div>\n <h3 class=\"content-text\"><strong>Veri Seti \u00d6zellikleri:<\/strong><\/h3>\n <li>\n <span>CSV s\u00fctunlar\u0131: <span class=\"code-inline\">Ay_Periyodu<\/span>, <span class=\"code-inline\">Sat\u0131c\u0131_ID<\/span>, <span class=\"code-inline\">\u00dcr\u00fcn_Tipi<\/span>, <span class=\"code-inline\">Toplam_Gelir<\/span>, <span class=\"code-inline\">Kategori_Kodu<\/span>, <span class=\"code-inline\">T\u00fcm_Maliyetler<\/span>, <span class=\"code-inline\">Net_Kazan\u00e7<\/span>, <span class=\"code-inline\">\u0130\u015flem_Hacmi<\/span>,\n <span class=\"code-inline\">\u0130\u015flem_Say\u0131s\u0131<\/span><\/span>\n <\/li>\n <li>\n \n <span><span class=\"code-inline\">Ay_Periyodu<\/span> ay\u0131n ilk g\u00fcn\u00fc format\u0131nda (YYYY-MM-01) geldi\u011fi i\u00e7in do\u011frudan Power BI'da zaman-intelligence i\u015flemlerine\n uygundur\n <\/li>\n <li>\n \n <span>Veri sentetik oldu\u011fu i\u00e7in ger\u00e7ek m\u00fc\u015fteri bilgisi i\u00e7ermez; analiz ve modellerinizi geli\u015ftirmek i\u00e7in g\u00fcvenle\n kullan\u0131labilir<\/span>\n <\/li>\n <\/section>\n\n <section id=\"power-query\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udd04 Power Query (ETL) \u2014 Power Query ile Veri Haz\u0131rl\u0131\u011f\u0131<\/h2>\n <p class=\"content-text\">\n Burada CSV\/veri kayna\u011f\u0131ndan veriyi al\u0131p temizleyip Ay_Periyodu, Net_Kazan\u00e7 s\u00fctunlar\u0131yla \u00e7al\u0131\u015f\u0131r hale getiriyoruz.\n <\/p>\n <h3 class=\"content-text\"><strong>Tipik ETL Ad\u0131mlar\u0131:<\/strong><\/h3>\n <ol class=\"steps-list\">\n <li>\n <span class=\"step-number\">1<\/span>\n <span><strong>Veri oku<\/strong> (CSV \/ SQL \/ parquet)<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">2<\/span>\n <span><strong>Tarih normalizasyonu<\/strong> \u2014 Date.FromText ve Date.StartOfMonth ile Ay_Periyodu\n olu\u015ftur<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">3<\/span>\n <span><strong>Null\/NaN temizli\u011fi<\/strong> \u2014 Sat\u0131c\u0131_ID bo\u015fsa filtrele<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">4<\/span>\n <span><strong>Net_Kazan\u00e7 hesapla<\/strong> (ETL'de yapmak performans kazand\u0131r\u0131r)<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">5<\/span>\n <span><strong>Gereksiz s\u00fctunlar\u0131 kald\u0131r<\/strong> ve tipleri sabitle<\/span>\n <\/li>\n <\/ol><\/section>\n <section>\n <h3>\u00d6nemli A\u00e7\u0131klamalar<\/h3>\n <h3>Neden <span class=\"code-inline\">Date.StartOfMonth<\/span> Kullan\u0131yoruz?<\/h3>\n <li>\n <span>Kesin ay-bucket referans\u0131 olu\u015fturmak i\u00e7in<\/span>\n <\/li>\n <li>\n <span>Power BI'\u0131n time-intelligence fonksiyonlar\u0131 tutarl\u0131 \u00e7al\u0131\u015f\u0131r<\/span>\n <\/li>\n <li>\n <span>Cohort hesaplamalar\u0131nda tarih uyumsuzlu\u011fu \u00f6nlenir<\/span><\/li>\n\n <br \/>\n <h3>Veri Kalite Kontrolleri:<\/h3>\n <li>\n <span>Null\/bo\u015f <span class=\"code-inline\">Sat\u0131c\u0131_ID<\/span> de\u011ferler filtrelenir<\/span>\n <\/li>\n <li>\n <span>Negatif gelir de\u011ferleri temizlenir<\/span>\n <\/li>\n <li>\n <span>Text alanlar trim edilir<\/span>\n <\/li>\n \n <\/br>\n <h3>Performance \u0130pu\u00e7lar\u0131:<\/h3>\n <li>\n <span>Table.Buffer son ad\u0131mda kullan\u0131l\u0131r - d\u00f6n\u00fc\u015f\u00fcmleri sabitleme<\/span>\n <\/li>\n <li>\n <span>ETL a\u015famas\u0131nda Net_Kazan\u00e7 hesaplan\u0131rsa model hafifler<\/span>\n <\/li><\/br>\n <\/section>\n\n <section id=\"dax-measures\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcbb Modelleme: DateTable & \u0130li\u015fkiler<\/h2>\n <p class=\"content-text\">\n <strong>DateTable Olu\u015fturma:<\/strong> <\/br>Her modelde bir DateTable olmal\u0131\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">\u00d6rnek DAX Kodu:<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('m-code')\">Kopyala<\/button>\n <\/div>\n <pre id=\"m-code\">DateTable =\n ADDCOLUMNS(\n CALENDAR(DATE(2021,1,1), DATE(2026,12,31)),\n \"Y\u0131l\", YEAR([Date]),\n \"Ay\", FORMAT([Date], \"MMMM\"),\n \"AyNumaras\u0131\", MONTH([Date]),\n \"Y\u0131lAy\", FORMAT([Date], \"yyyy-MM\"),\n \"Ay_Start\", DATE(YEAR([Date]),MONTH([Date]),1),\n \"\u00c7eyrek\", \"Q\" & QUARTER([Date])\n )<\/pre><\/div>\n\n <h2>Model \u0130li\u015fkileri<\/h2><\/br>\n <li>\n <span><strong>DateTable[Date]<\/strong> \u2192 1-* <strong>Transaction[Ay_Periyodu]<\/strong><\/span>\n <\/li>\n <br><h3> Neden Bu \u0130li\u015fki \u00d6nemli:<\/h3>\n <li>Bu ili\u015fki, zaman serisi analizleri ve raporlamalar\u0131 i\u00e7in kritik \u00f6neme sahiptir. \n DateTable, tarihsel verilerin do\u011fru bir \u015fekilde analiz edilmesini sa\u011flar.<\/li>\n <li>(DATEADD, SAMEPERIODLASTYEAR) gibi fonksiyonlar d\u00fczg\u00fcn \u00e7al\u0131\u015f\u0131r<\/li>\n <li>Tarih aral\u0131\u011f\u0131 y\u00f6netimi tek yerden yap\u0131l\u0131r<\/li>\n<\/section>\n\n <section id=\"calculated-columns\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcca Calculated Columns: Cohort Temellerini Olu\u015fturma<\/h2>\n <p class=\"content-text\">\n Bu s\u00fctunlar sat\u0131c\u0131 ba\u015f\u0131na sabit oldu\u011fundan <strong>calculated column<\/strong> veya ETL'de\n hesaplanmal\u0131 \u00e7\u00fcnk\u00fc:<br>\n 1- Sat\u0131c\u0131 ba\u015f\u0131na bir kez hesaplanan sabit de\u011ferlerdir.<br>\n 2- Her rapor sorgusu s\u0131ras\u0131nda yeniden hesaplanmas\u0131na gerek yoktur.<br>\n 3- Performans a\u00e7\u0131s\u0131ndan avantaj sa\u011flar.\n <\/p>\n\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Date (sat\u0131c\u0131n\u0131n ilk i\u015flem ay\u0131)<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-date')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-date\">Cohort_Date =\nCALCULATE(\n MIN('Transaction'[Ay_Periyodu]),\n ALLEXCEPT('Transaction','Transaction'[Sat\u0131c\u0131_ID])\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n <strong>Ne yapar:<\/strong> Her sat\u0131c\u0131n\u0131n ilk i\u015flem yapt\u0131\u011f\u0131 ay\u0131 (edinim ay\u0131n\u0131) hesaplar. T\u00fcm cohort analizinin temelini olu\u015fturur.\n\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Months_Since_Cohort - Cohort \u0130ndeksi<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('months-since')\">Kopyala<\/button>\n <\/div>\n <pre id=\"months-since\">Months_Since_Cohort =\nIF(\n ISBLANK('Transaction'[Cohort_Date]) || ISBLANK('Transaction'[Ay_Periyodu]),\n BLANK(),\n DATEDIFF('Transaction'[Cohort_Date], 'Transaction'[Ay_Periyodu], MONTH)\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n <strong>Ne yapar:<\/strong> Sat\u0131c\u0131n\u0131n edinim ay\u0131ndan itibaren ka\u00e7 ay ge\u00e7ti\u011fini g\u00f6sterir (0, 1, 2, 3...). Heatmap g\u00f6rsellerinde kullan\u0131lacak temel indekstir.\n <\/p>\n <p class=\"content-text\">\n <strong>Veri Tipi:<\/strong> Whole Number olarak ayarlay\u0131n - g\u00f6rsellerde do\u011fru s\u0131ralama i\u00e7in \u00f6nemli.\n <\/p>\n <div class=\"info-box\">\n <p class=\"info-text\">\n <strong>\u2705 Sanity Check:<\/strong> Her cohort i\u00e7in <span class=\"code-inline\">Months_Since_Cohort =\n 0<\/span>\n sat\u0131rlar\u0131nda <span class=\"code-inline\">Cohort_Active_Count == Cohort_Size<\/span> olmal\u0131.\n <\/p>\n <\/div>\n <\/section>\n\n <section id=\"dax-measures\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a1 Temel DAX Measures<\/h2>\n <p class=\"content-text\">\n A\u015fa\u011f\u0131da, cohort matrisleri ve temel KPI'lar i\u00e7in gerekli t\u00fcm measure'lar yer al\u0131yor:\n <\/p>\n <h3 class=\"title\">Cohort_Size - Cohort Ba\u015flang\u0131\u00e7 B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h3>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Size<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-size')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-size\">Cohort_Size =\n VAR CohortPeriod = SELECTEDVALUE('Transaction'[Cohort_Date])\n RETURN\n CALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n FILTER(ALL('Transaction'), 'Transaction'[Cohort_Date] = CohortPeriod)\n )\n<\/pre>\n <\/div>\n <h3 class=\"title\">Cohort_Active_Count - Aktif Sat\u0131c\u0131 Say\u0131s\u0131<\/h3>\n <p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong> Belirli bir cohort'un t+N ay\u0131nda ka\u00e7 sat\u0131c\u0131n\u0131n aktif oldu\u011funu sayar.\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Active_Count<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-active-count')\">Kopyala<\/button>\n <\/div>\n <pre\n id=\"cohort-active-count\">Cohort_Active_Count =\n VAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\n VAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\n VAR CohortMonthDate = EDATE(SelectedCohort, CohortMonthIndex)\n RETURN\n CALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n 'Transaction'[Ay_Periyodu] = CohortMonthDate)\n )\n<\/pre>\n <\/div>\n <h3 class=\"title\">Cohort_Retention_Rate – Retention Oran\u0131<\/h3>\n <p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong>Ana KPI metri\u011fi. G\u00f6rsellerde y\u00fczde format\u0131nda g\u00f6sterin.\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Retention_Rate<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-retention-rate')\">Kopyala<\/button>\n <\/div>\n <pre\n id=\"cohort-retention-rate\">Cohort_Retention_Rate =\nDIVIDE([Cohort_Active_Count], [Cohort_Size], 0)<\/pre>\n <\/div>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Performans \u0130pucu:<\/strong> <span class=\"code-inline\">Cohort_Date<\/span> ve\n <span class=\"code-inline\">Months_Since_Cohort<\/span> ETL veya calculated column olarak\n saklanmal\u0131.\n B\u00fcy\u00fck transaction tablolar\u0131n\u0131 <span class=\"code-inline\">Merchant_Month_Summary<\/span> tablosuna\n indirgeme.\n <\/p>\n <\/div>\n <\/section>\n<h3 class=\"title\">Cohort_Revenue_Period – D\u00f6nemsel Gelir<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Revenue_Period<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-revenue-period')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-revenue-period\">Cohort_Revenue_Period =\nVAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\nVAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\nVAR CohortMonthDate = EDATE(SelectedCohort, CohortMonthIndex)\nRETURN\nCALCULATE(\n SUM('Transaction'[Net_Kazan\u00e7]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n 'Transaction'[Ay_Periyodu] = CohortMonthDate\n )\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Cohort_Cumulative_Revenue – K\u00fcm\u00fclatif Gelir<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Cumulative_Revenue<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-cumulative-revenue')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-cumulative-revenue\">Cohort_Cumulative_Revenue =\nVAR SelectedCohort = SELECTEDVALUE('Transaction'[Cohort_Date])\nVAR CohortMonthIndex = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\nRETURN\nCALCULATE(\n SUM('Transaction'[Net_Kazan\u00e7]),\n FILTER(\n ALL('Transaction'),\n 'Transaction'[Cohort_Date] = SelectedCohort &&\n DATEDIFF('Transaction'[Cohort_Date], 'Transaction'[Ay_Periyodu], MONTH) <= CohortMonthIndex\n )\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Cohort_Average_LTV - Ortalama Lifetime Value<\/h3>\n<p class=\"content-text\">\n <strong>Kullan\u0131m Amac\u0131:<\/strong> CAC ile kar\u015f\u0131la\u015ft\u0131rma yaparak ROI hesaplar\u0131 i\u00e7in kritik metrik.\n<\/p>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Cohort_Average_LTV<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('cohort-average-ltv')\">Kopyala<\/button>\n <\/div>\n <pre id=\"cohort-average-ltv\">Cohort_Average_LTV =\nDIVIDE(\n [Cohort_Cumulative_Revenue],\n [Cohort_Size],\n 0\n)<\/pre>\n<\/div>\n\n<h2 class=\"section-title\">\ud83d\udcca Ek KPI'lar: Genel Sat\u0131c\u0131 Sa\u011fl\u0131\u011f\u0131<\/h2>\n\n<h3 class=\"title\">Aktif Sat\u0131c\u0131lar<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Aktif_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('aktif-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"aktif-saticilar\">Aktif_Sat\u0131c\u0131lar =\nCALCULATE(\n DISTINCTCOUNT('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] = MAX('Transaction'[Ay_Periyodu])\n)<\/pre>\n<\/div>\n\n<h3 class=\"title\">Yeni Sat\u0131c\u0131lar<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Yeni_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('yeni-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"yeni-saticilar\">Yeni_Sat\u0131c\u0131lar =\nVAR CurrentMonth = MAX('Transaction'[Ay_Periyodu])\nVAR CurrentActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] = CurrentMonth\n )\nVAR PreviouslyActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[Ay_Periyodu] < CurrentMonth\n )\nRETURN\nCOUNTROWS(EXCEPT(CurrentActive, PreviouslyActive))<\/pre>\n<\/div>\n\n<h3 class=\"title\">Churn Oran\u0131<\/h3>\n<div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Churned_Sat\u0131c\u0131lar<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('churned-saticilar')\">Kopyala<\/button>\n <\/div>\n <pre id=\"churned-saticilar\">Churned_Sat\u0131c\u0131lar =\nVAR PreviousMonthActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n DATEADD('Transaction'[Ay_Periyodu], -1, MONTH),\n 'Transaction'[\u0130\u015flem_Say\u0131s\u0131] > 0\n )\nVAR CurrentActive =\n CALCULATETABLE(\n VALUES('Transaction'[Sat\u0131c\u0131_ID]),\n 'Transaction'[\u0130\u015flem_Say\u0131s\u0131] > 0\n )\nRETURN\nCOUNTROWS(EXCEPT(PreviousMonthActive, CurrentActive))<\/pre>\n<\/div>\n<\/section>\n\n<section id=\"dashboard-tasarimi\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcca Dashboard Tasar\u0131m\u0131 ve G\u00f6rselle\u015ftirme<\/h2>\n\n <h3 class=\"content-text\"><strong>Executive Summary Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">KPI Kartlar\u0131:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Aktif Sat\u0131c\u0131lar<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Yeni Sat\u0131c\u0131lar<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Churn Oran\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Toplam Gelir<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Ortalama \u0130\u015flem Hacmi<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Trend Grafikleri:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Ayl\u0131k gelir trendi (line chart)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Yeni sat\u0131c\u0131 edinim trendi<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Churn oran\u0131 trendi<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Cohort Analizi Ana Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">Matrix (Heatmap) Ayarlar\u0131:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Rows:<\/strong> Cohort_Date (Y\u0131lAy format\u0131nda)<\/span>\n <\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Columns:<\/strong> Months_Since_Cohort (0, 1, 2,\n 3...)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Values:<\/strong> Cohort_Retention_Rate (%\n format\u0131nda)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Conditional Formatting:<\/strong> Koyu renk = y\u00fcksek\n retention<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Alternatif Matrix:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Values:<\/strong> Cohort_Average_LTV (LTV \u0131s\u0131 haritas\u0131\n i\u00e7in)<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Segment Analizi Sayfas\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">Slicers:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>\u00dcr\u00fcn_Tipi<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Kategori_Kodu (MCC)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>\u0130\u015f_Orta\u011f\u0131<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Grafikler:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span>Cohort b\u00fcy\u00fckl\u00fc\u011f\u00fc bar chart<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Segment bazl\u0131 LTV kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span>Top 20 sat\u0131c\u0131 tablosu<\/span><\/li>\n <\/ul>\n <\/div>\n<\/section>\n\n<section id=\"gercek-dunya-ornegi\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfe2 Ger\u00e7ek D\u00fcnya \u00d6rne\u011fi: 50,000+ Sat\u0131c\u0131 ile Cohort Analizi<\/h2>\n <p class=\"content-text\">\n T\u00fcrkiye'nin \u00f6nde gelen payment processing \u015firketlerinden birinde yapt\u0131\u011f\u0131m\u0131z ger\u00e7ek bir cohort analizi \u00f6rne\u011fini\n payla\u015f\u0131yorum.\n 2.3 milyon i\u015flem sat\u0131r\u0131 ve 52,000+ sat\u0131c\u0131 verisi \u00fczerinde \u00e7al\u0131\u015farak elde etti\u011fimiz bulgular:\n <\/p>\n\n <h3 class=\"title-subtitle\">Veri Seti \u00d6zellikleri<\/h3>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca Proje B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h4>\n <div class=\"stats-item\">\n <span>Zaman Aral\u0131\u011f\u0131:<\/span>\n <span class=\"stats-value\">Ocak 2022 - Aral\u0131k 2024 (36 ay)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Sat\u0131c\u0131 Say\u0131s\u0131:<\/span>\n <span class=\"stats-value\">52,847 benzersiz sat\u0131c\u0131<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem Sat\u0131r\u0131:<\/span>\n <span class=\"stats-value\">2,347,892 transaction<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem Hacmi:<\/span>\n <span class=\"stats-value\">\u20ba18.4 milyar<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Ayl\u0131k Yeni Sat\u0131c\u0131:<\/span>\n <span class=\"stats-value\">~1,500<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Veri Boyutu:<\/span>\n <span class=\"stats-value\">450 MB (Excel) \/ 180 MB (Power BI)<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <h3 class=\"title-subtitle\">En B\u00fcy\u00fck 10 Cohort (Sat\u0131c\u0131 Say\u0131s\u0131na G\u00f6re)<\/h3>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Cohort Ay\u0131<\/th>\n <th>Sat\u0131c\u0131 Say\u0131s\u0131<\/th>\n <th>\u00d6zel Not<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">2023-01<\/span><\/td>\n <td>2,847<\/td>\n <td>En b\u00fcy\u00fck onboarding ay\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-09<\/span><\/td>\n <td>2,534<\/td>\n <td>Sonbahar kampanyas\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-03<\/span><\/td>\n <td>2,431<\/td>\n <td>Pandemi sonras\u0131 toparlanma<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-06<\/span><\/td>\n <td>2,289<\/td>\n <td>Yaz sezonu<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-07<\/span><\/td>\n <td>2,156<\/td>\n <td>Tatil \u00f6ncesi yo\u011funluk<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2024-02<\/span><\/td>\n <td>2,098<\/td>\n <td>Yeni \u00fcr\u00fcn lansman\u0131<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-11<\/span><\/td>\n <td>1,987<\/td>\n <td>Black Friday etkisi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-04<\/span><\/td>\n <td>1,876<\/td>\n <td>Bahar d\u00f6nemi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-05<\/span><\/td>\n <td>1,743<\/td>\n <td>Normalle\u015fme s\u00fcreci<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-10<\/span><\/td>\n <td>1,692<\/td>\n <td>Okul \u00f6ncesi al\u0131\u015fveri\u015f<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <h3 class=\"title-subtitle\">Retention Analizi - Sekt\u00f6r Benchmarklar\u0131<\/h3>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcc8 Genel Retention Trendi<\/h4>\n <div class=\"stats-item\">\n <span>Month 0:<\/span>\n <span class=\"stats-value\">100.0%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 1:<\/span>\n <span class=\"stats-value\">67.3%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 2:<\/span>\n <span class=\"stats-value\">54.1%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 3:<\/span>\n <span class=\"stats-value\">48.7%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 6:<\/span>\n <span class=\"stats-value\">38.2%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 12:<\/span>\n <span class=\"stats-value\">28.4%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 24:<\/span>\n <span class=\"stats-value\">19.7%<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">\u00d6ne \u00c7\u0131kan Bulgular:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>\"3 Ayl\u0131k Kritik E\u015fik\":<\/strong> \u0130lk 3 ayda %51.3 churn -\n bu d\u00f6nemde yap\u0131lan m\u00fcdahalelerin ROI'\u0131 \u00e7ok y\u00fcksek<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Seasonality Etkisi:<\/strong> Sonbahar aylar\u0131nda edinilen\n cohort'lar %15-20 daha iyi retention g\u00f6steriyor<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Product Mix Impact:<\/strong> API entegrasyonu yapan\n sat\u0131c\u0131lar, iframe kullanlara g\u00f6re 2.3x daha uzun s\u00fcre kal\u0131yor<\/span><\/li>\n <\/ul>\n <\/div>\n\n <h3 class=\"title-subtitle\">Lifetime Value (LTV) Bulgular\u0131<\/h3>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Cohort<\/th>\n <th>Ortalama LTV (24 Ay)<\/th>\n <th>Not<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><span class=\"field-name\">2022-01<\/span><\/td>\n <td>\u20ba47,350<\/td>\n <td>Matured cohort<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-06<\/span><\/td>\n <td>\u20ba52,100<\/td>\n <td>Yaz etkisi<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2022-09<\/span><\/td>\n <td>\u20ba61,200<\/td>\n <td>En performant<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-01<\/span><\/td>\n <td>\u20ba34,600<\/td>\n <td>Hen\u00fcz geli\u015fmekte<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2023-06<\/span><\/td>\n <td>\u20ba31,900<\/td>\n <td>Gen\u00e7 cohort<\/td>\n <\/tr>\n <tr>\n <td><span class=\"field-name\">2024-01<\/span><\/td>\n <td>\u20ba8,750<\/td>\n <td>Sadece 12 ay<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcb0 LTV Distribution (24 Ayl\u0131k)<\/h4>\n <div class=\"stats-item\">\n <span>Top %5:<\/span>\n <span class=\"stats-value\">\u20ba340,000+ (whale merchants)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Top %10:<\/span>\n <span class=\"stats-value\">\u20ba185,000<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Top %25:<\/span>\n <span class=\"stats-value\">\u20ba85,000<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Median:<\/span>\n <span class=\"stats-value\">\u20ba23,400<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Bottom %25:<\/span>\n <span class=\"stats-value\">\u20ba4,200 alt\u0131<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n<h3 class=\"title-subtitle\">Segmentasyon Insights<\/h3>\n<div class=\"highlight-box\">\n <h4 class=\"stats-title\">MCC (Kategori) Bazl\u0131 Performance:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Marketler\/S\u00fcpermarketler (MCC 5411):<\/strong> En y\u00fcksek\n retention (%41 @ 12ay)<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Restoranlar (MCC 5812):<\/strong> Orta retention ama y\u00fcksek\n volume<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Giyim (MCC 5651):<\/strong> Mevsimsel dalgalanma, d\u00fc\u015f\u00fck\n retention<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>E-ticaret Genel (MCC 5999):<\/strong> \u00c7ok de\u011fi\u015fken, segment\n analizi gerekli<\/span><\/li>\n <\/ul>\n\n <h4 class=\"stats-title\">Partner Channel Analizi:<\/h4>\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Direct Sales:<\/strong> %35.2 (12ay retention) - Premium\n segment<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Bank Referral:<\/strong> %28.7 - Stable ama d\u00fc\u015f\u00fck LTV<\/span>\n <\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Digital Marketing:<\/strong> %22.1 - Y\u00fcksek volume, d\u00fc\u015f\u00fck\n quality<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Reseller Network:<\/strong> %31.4 - B\u00f6lgesel farkl\u0131l\u0131k\n y\u00fcksek<\/span><\/li>\n <\/ul>\n<\/div>\n\n<h3 class=\"title-subtitle\">Model Performance ve Optimizasyon<\/h3>\n<div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\u26a1 Power BI Model Specs<\/h4>\n <div class=\"stats-item\">\n <span>Y\u00fckleme S\u00fcresi:<\/span>\n <span class=\"stats-value\">~12s (initial) \/ ~3s (refresh)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Model Boyutu:<\/span>\n <span class=\"stats-value\">178 MB (compressed)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>DAX Hesaplama:<\/span>\n <span class=\"stats-value\"><200ms (cohort matrix)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Concurrent User:<\/span>\n <span class=\"stats-value\">15+ kullan\u0131c\u0131 sorunsuz<\/span>\n <\/div>\n <\/div>\n\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udd27 Performance Optimizasyonlar\u0131<\/h4>\n <div class=\"stats-item\">\n <span>Summary Table:<\/span>\n <span class=\"stats-value\">628,000 sat\u0131r (pre-aggregated)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Partitioning:<\/span>\n <span class=\"stats-value\">Y\u0131l bazl\u0131 (2022, 2023, 2024)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Calculated Columns:<\/span>\n <span class=\"stats-value\">2 adet<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Indexing:<\/span>\n <span class=\"stats-value\">Composite index<\/span>\n <\/div>\n <\/div>\n<\/div>\n\n<h3 class=\"title-subtitle\">\u0130\u015f Etkisi ve Eylem Plan\u0131<\/h3>\n<p class=\"content-text\">Bu cohort analizi sonucunda al\u0131nan somut aksiyonlar:<\/p>\n\n<div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Onboarding UX \u0130yile\u015ftirmesi:<\/strong> \u0130lk 30 g\u00fcn i\u00e7inde %15\n daha fazla sat\u0131c\u0131 aktif kald\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Risk-Based Outreach:<\/strong> Churn riski y\u00fcksek segmente\n \u00f6zel destek program\u0131<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Product Roadmap:<\/strong> API-first yakla\u015f\u0131m, iframe deste\u011fi\n kademeli azaltma<\/span><\/li>\n <li><span class=\"list-bullet\">\u2022<\/span><span><strong>Pricing Strategy:<\/strong> LTV segmentlerine g\u00f6re komisyon\n yap\u0131s\u0131 revize edildi<\/span><\/li>\n <\/ul>\n<\/div>\n\n<div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udc8e ROI Hesaplamas\u0131<\/h4>\n <div class=\"stats-item\">\n <span>Analiz Maliyeti:<\/span>\n <span class=\"stats-value\">~80 saat + tool costs<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130yile\u015ftirme ROAS:<\/span>\n <span class=\"stats-value\">%340 (6 ay i\u00e7inde)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Churn Azalmas\u0131:<\/span>\n <span class=\"stats-value\">-%23 (y\u0131ll\u0131k basis)<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Net Gelir Etkisi:<\/span>\n <span class=\"stats-value\">+\u20ba12.8M (12 ay projeksiyon)<\/span>\n <\/div>\n <\/div>\n<\/div>\n\n<div class=\"info-box\">\n <p class=\"info-text\">\n Bu ger\u00e7ek d\u00fcnya \u00f6rne\u011fi, cohort analizinin sadece bir reporting tool de\u011fil, stratejik karar alma arac\u0131 oldu\u011funu\n g\u00f6steriyor.\n <\/p>\n<\/div>\n<\/section>\n\n<section id=\"yaygin-hatalar\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a0\ufe0f Yayg\u0131n Hatalar ve \u00c7\u00f6z\u00fcmler<\/h2>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">1. Tarih Saat Uyumsuzluklar\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Farkl\u0131 timezone'lar nedeniyle cohort tarihleri yanl\u0131\u015f\n hesaplan\u0131yor.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> ETL a\u015famas\u0131nda t\u00fcm tarihleri UTC'ye \u00e7evirin ve Ay_Periyodu'nu\n ay\u0131n ilk g\u00fcn\u00fc olarak normalize edin.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">2. Duplicate Sat\u0131c\u0131 ID'ler<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Ayn\u0131 sat\u0131c\u0131n\u0131n birden fazla ID'si olmas\u0131.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> M\u00fc\u015fteri matching tablosu kullanarak e-posta veya vergi numaras\u0131\n bazl\u0131 dedupe yap\u0131n.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">3. Performance Sorunlar\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> B\u00fcy\u00fck veri setlerinde yava\u015fl\u0131k.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> Import mode kullan\u0131n, pre-aggregated tablolar olu\u015fturun,\n calculated column'lar\u0131 tercih edin.<\/p>\n <\/div>\n\n <div class=\"highlight-box\">\n <h4 class=\"stats-title\">4. Cohort 0'\u0131n %100 Olmamas\u0131<\/h4>\n <p class=\"content-text\"><strong>Problem:<\/strong> Genellikle Cohort_Date veya Months_Since_Cohort hatal\u0131\n hesaplanmas\u0131.<\/p>\n <p class=\"content-text\"><strong>\u00c7\u00f6z\u00fcm:<\/strong> Her cohort'un Month 0'\u0131nda retention'\u0131n %100 oldu\u011funu kontrol\n edin.<\/p>\n <\/div>\n<\/section>\n\n<section id=\"performans-optimizasyon\" class=\"content-section\">\n <h2 class=\"section-title\">\u26a1 Performans Optimizasyonu \u0130pu\u00e7lar\u0131<\/h2>\n\n <h3 class=\"content-text\"><strong>1. Calculated Column vs Measure Karar\u0131<\/strong><\/h3>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Calculated Columns:<\/strong> Cohort_Date, Months_Since_Cohort gibi sabit hesaplamalar -\n veri yenilendi\u011finde bir kez hesaplan\u0131r<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Measures:<\/strong> Dinamik KPI'lar ve filtrelenebilir metrikler - her sorgu i\u00e7in\n hesaplan\u0131r ama daha esnektir<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <p class=\"content-text\">\n <strong>Karar Kriterleri:<\/strong> E\u011fer de\u011fer sat\u0131c\u0131\/i\u015flem baz\u0131nda sabitse ve filtreleme gerektirmiyorsa\n calculated column kullan\u0131n. Dinamik hesaplama ve filtreleme gerektiren her \u015fey i\u00e7in measure kullan\u0131n.\n <\/p>\n\n <h3 class=\"content-text\"><strong>2. Summary Tablolar<\/strong><\/h3>\n <p class=\"content-text\">\n B\u00fcy\u00fck veri setlerinde (1M+ sat\u0131r) pre-aggregated tablo kullan\u0131n. Bu yakla\u015f\u0131m sorgu performans\u0131n\u0131 10-20x\n h\u0131zland\u0131rabilir:\n <\/p>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Sat\u0131c\u0131_Ay_Summary Tablosu<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('summary-table')\">Kopyala<\/button>\n <\/div>\n <pre id=\"summary-table\">-- Power Query M ile Summary Tablo Olu\u015fturma\nlet\n Source = Transaction,\n Grouped = Table.Group(\n Source, \n {\"Sat\u0131c\u0131_ID\", \"Ay_Periyodu\", \"\u00dcr\u00fcn_Tipi\", \"Kategori_Kodu\"},\n {\n {\"\u0130\u015flem_Say\u0131s\u0131\", each List.Sum([\u0130\u015flem_Say\u0131s\u0131]), type number},\n {\"Net_Kazan\u00e7\", each List.Sum([Net_Kazan\u00e7]), type number},\n {\"Toplam_Gelir\", each List.Sum([Toplam_Gelir]), type number}\n }\n )\nin\n Grouped\n\n-- Alternatif: DAX ile Summary Tablo\nSat\u0131c\u0131_Ay_Summary = \nSUMMARIZE(\n 'Transaction',\n 'Transaction'[Sat\u0131c\u0131_ID],\n 'Transaction'[Ay_Periyodu],\n 'Transaction'[\u00dcr\u00fcn_Tipi],\n \"\u0130\u015flem_Say\u0131s\u0131\", SUM('Transaction'[\u0130\u015flem_Say\u0131s\u0131]),\n \"Net_Kazan\u00e7\", SUM('Transaction'[Net_Kazan\u00e7])\n)<\/pre>\n <\/div>\n <p class=\"content-text\">\n Bu summary tablo \u00fczerinden measure'lar\u0131 \u00e7al\u0131\u015ft\u0131rarak milyonlarca sat\u0131rl\u0131k transaction tablosunu y\u00fcz binlere\n indirgemi\u015f olursunuz.\n <\/p>\n\n <h3 class=\"content-text\"><strong>3. Indexing Stratejisi<\/strong><\/h3>\n <p class=\"content-text\">\n SQL veri kayna\u011f\u0131n\u0131z varsa, a\u015fa\u011f\u0131daki kolonlar \u00fczerinde index olu\u015fturun:\n <\/p>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131_ID:<\/strong> Tek ba\u015f\u0131na index - merchant bazl\u0131 sorgular\u0131 h\u0131zland\u0131r\u0131r<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Ay_Periyodu:<\/strong> Tek ba\u015f\u0131na index - zaman serisi sorgular\u0131 i\u00e7in<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Sat\u0131c\u0131_ID + Ay_Periyodu (composite):<\/strong> En kritik index - cohort hesaplamalar\u0131\n i\u00e7in<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">SQL Index Olu\u015fturma Komutlar\u0131<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('sql-index')\">Kopyala<\/button>\n <\/div>\n <pre id=\"sql-index\">-- Tek kolon indexler\nCREATE INDEX idx_merchant_id ON Transaction(Sat\u0131c\u0131_ID);\nCREATE INDEX idx_period ON Transaction(Ay_Periyodu);\n\n-- Composite index (en \u00f6nemli)\nCREATE INDEX idx_merchant_period ON Transaction(Sat\u0131c\u0131_ID, Ay_Periyodu);\n\n-- \u00dcr\u00fcn tipi segmentasyonu i\u00e7in\nCREATE INDEX idx_product_type ON Transaction(\u00dcr\u00fcn_Tipi);\n\n-- Performance check\nSELECT \n tablename, \n indexname, \n indexdef \nFROM pg_indexes \nWHERE tablename = 'transaction';<\/pre>\n <\/div>\n<\/section>\n\n<section id=\"gelismis-teknikler\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\ude80 Geli\u015fmi\u015f Analiz Teknikleri<\/h2>\n\n <h3 class=\"content-text\"><strong>1. Segmented Cohort Analizi<\/strong><\/h3>\n <p class=\"content-text\">\n Farkl\u0131 sat\u0131c\u0131 segmentleri i\u00e7in ayr\u0131 cohort analizleri yaparak daha derinlemesine i\u00e7g\u00f6r\u00fcler elde edebilirsiniz:\n <\/p>\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca MCC Koduna G\u00f6re<\/h4>\n <p class=\"content-text\">\n Her sekt\u00f6r\u00fcn farkl\u0131 retention paterni vard\u0131r. Marketler genelde y\u00fcksek retention g\u00f6sterirken, giyim\n sekt\u00f6r\u00fc mevsimsel dalgalanmalar g\u00f6sterir.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udd27 \u00dcr\u00fcn Tipine G\u00f6re<\/h4>\n <p class=\"content-text\">\n API entegrasyonu yapan sat\u0131c\u0131lar iframe kullananlara g\u00f6re 2-3x daha uzun s\u00fcre kal\u0131yor. Bu insight \u00fcr\u00fcn\n stratejinizi \u015fekillendirebilir.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udce2 Onboarding Kanal\u0131na G\u00f6re<\/h4>\n <p class=\"content-text\">\n Direct sales vs digital marketing vs partner referral - her kanal farkl\u0131 kalite sat\u0131c\u0131 getirir. CAC ve\n LTV dengesini kanal baz\u0131nda optimize edin.\n <\/p>\n <\/div>\n <\/div>\n\n <h3 class=\"content-text\"><strong>2. Predictive Churn Modeling<\/strong><\/h3>\n <p class=\"content-text\">\n Cohort verilerini kullanarak gelecekteki churn'\u00fc tahminleyebilir ve proaktif aksiyonlar alabilirsiniz:\n <\/p>\n <div class=\"info-box\">\n <p class=\"info-text\"><strong>Erken Uyar\u0131 Sinyalleri:<\/strong><\/p>\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>\u0130lk 3 ayda d\u00fc\u015f\u00fck i\u015flem hacmi:<\/strong> Ayl\u0131k i\u015flem hacmi cohort ortalamas\u0131n\u0131n %50'sinin\n alt\u0131ndaysa y\u00fcksek churn riski<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>Azalan trend:<\/strong> Ard\u0131\u015f\u0131k 2 ayda i\u015flem hacmi d\u00fc\u015f\u00fc\u015f\u00fc g\u00f6steriyorsa m\u00fcdahale\n gerekli<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2022<\/span>\n <span><strong>\u0130\u015flem s\u0131kl\u0131\u011f\u0131 d\u00fc\u015f\u00fc\u015f\u00fc:<\/strong> Ayl\u0131k i\u015flem say\u0131s\u0131 3'\u00fcn alt\u0131na d\u00fc\u015ferse kritik seviye<\/span>\n <\/li>\n <\/ul>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">Churn Risk Score Hesaplama<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('churn-risk')\">Kopyala<\/button>\n <\/div>\n <pre id=\"churn-risk\">Churn_Risk_Score = \nVAR CurrentMonthTx = [\u0130\u015flem_Say\u0131s\u0131]\nVAR PrevMonthTx = CALCULATE([\u0130\u015flem_Say\u0131s\u0131], DATEADD('Transaction'[Ay_Periyodu], -1, MONTH))\nVAR CohortAvgTx = CALCULATE(\n AVERAGE('Transaction'[\u0130\u015flem_Say\u0131s\u0131]),\n FILTER(ALL('Transaction'), 'Transaction'[Cohort_Date] = SELECTEDVALUE('Transaction'[Cohort_Date]))\n)\nVAR MonthsSinceCohort = SELECTEDVALUE('Transaction'[Months_Since_Cohort])\n\n\/\/ Risk fakt\u00f6rleri\nVAR LowVolumeRisk = IF(CurrentMonthTx < CohortAvgTx * 0.5, 30, 0)\nVAR DeclineRisk = IF(CurrentMonthTx < PrevMonthTx, 25, 0)\nVAR EarlyStageRisk = IF(MonthsSinceCohort <= 3 && CurrentMonthTx < 5, 20, 0)\nVAR InactivityRisk = IF(CurrentMonthTx = 0, 50, 0)\n\nRETURN\n LowVolumeRisk + DeclineRisk + EarlyStageRisk + InactivityRisk<\/pre>\n <\/div>\n\n <h3 class=\"content-text\"><strong>3. LTV Segmentasyonu<\/strong><\/h3>\n <p class=\"content-text\">\n Sat\u0131c\u0131lar\u0131 LTV'ye g\u00f6re kategorize ederek farkl\u0131la\u015ft\u0131r\u0131lm\u0131\u015f hizmet stratejileri uygulayabilirsiniz:\n <\/p>\n <div class=\"data-table\">\n <table>\n <thead>\n <tr>\n <th>Segment<\/th>\n <th>LTV Aral\u0131\u011f\u0131<\/th>\n <th>Strateji<\/th>\n <th>Kaynak Tahsisi<\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><strong>Platinum<\/strong><\/td>\n <td>\u20ba100,000+<\/td>\n <td>Dedicated account manager, \u00f6zel fiyatland\u0131rma<\/td>\n <td>Y\u00fcksek<\/td>\n <\/tr>\n <tr>\n <td><strong>Gold<\/strong><\/td>\n <td>\u20ba50,000-\u20ba100,000<\/td>\n <td>Priority support, quarterly reviews<\/td>\n <td>Orta-Y\u00fcksek<\/td>\n <\/tr>\n <tr>\n <td><strong>Silver<\/strong><\/td>\n <td>\u20ba10,000-\u20ba50,000<\/td>\n <td>Standard support, self-service tools<\/td>\n <td>Orta<\/td>\n <\/tr>\n <tr>\n <td><strong>Bronze<\/strong><\/td>\n <td>\n <\u20ba10,000< \/td>\n <td>Automated onboarding, growth programs<\/td>\n <td>D\u00fc\u015f\u00fck<\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/div>\n <div class=\"code-block\">\n <div class=\"code-header\">\n <h4 class=\"code-title\">LTV Segment Hesaplama<\/h4>\n <button class=\"copy-button\" onclick=\"copyToClipboard('ltv-segment')\">Kopyala<\/button>\n <\/div>\n <pre id=\"ltv-segment\">LTV_Segment = \nVAR LTV = [Cohort_Average_LTV]\nRETURN\n SWITCH(\n TRUE(),\n LTV >= 100000, \"Platinum\",\n LTV >= 50000, \"Gold\",\n LTV >= 10000, \"Silver\",\n \"Bronze\"\n )<\/pre>\n <\/div>\n<\/section>\n\n\n<section id=\"test-dogrulama\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udd0d Test & Do\u011frulama (Sanity Checks)<\/h2>\n <div class=\"error-box\">\n <h4 class=\"error-text\"><strong>\u26a0\ufe0f Mutlaka Yap\u0131lmas\u0131 Gerekenler:<\/strong><\/h4>\n <ol class=\"steps-list\">\n <li><span class=\"step-number\">1<\/span><strong>Cohort 0 kontrol\u00fc:<\/strong> <span\n class=\"code-inline\">Months_Since_Cohort = 0<\/span> sat\u0131rlar\u0131nda <span\n class=\"code-inline\">Cohort_Active_Count == Cohort_Size<\/span> olmal\u0131<\/li>\n <li><span class=\"step-number\">2<\/span><strong>Rastgele merchant kontrol\u00fc:<\/strong> Ham veride\n <span class=\"code-inline\">MIN(Ay_Periyodu)<\/span> ile modeldeki <span\n class=\"code-inline\">Cohort_Date<\/span> e\u015fle\u015fmeli\n <\/li>\n <li><span class=\"step-number\">3<\/span><strong>Unique counts:<\/strong> <span\n class=\"code-inline\">DISTINCTCOUNT(Sat\u0131c\u0131_ID)<\/span> ile d\u0131\u015f kaynak sonu\u00e7lar\u0131n\u0131\n kar\u015f\u0131la\u015ft\u0131r<\/li>\n <li><span class=\"step-number\">4<\/span><strong>Tarih\/timezone sorunlar\u0131:<\/strong> ETL'de t\u00fcm\n tarihleri UTC'ye \u00e7evir<\/li>\n <li><span class=\"step-number\">5<\/span><strong>Null\/0 gelir sat\u0131rlar\u0131:<\/strong> LTV hesaplan\u0131rken\n outlier trimming stratejisi belirle<\/li>\n <\/ol>\n <\/div>\n<\/section>\n\n<section id=\"gercek-ornekler\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83d\udcc8 Ger\u00e7ek D\u00fcnya \u00d6rnekleri & Benchmark<\/h2>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83d\udcca Tipik Retention E\u011frisi<\/h4>\n <div class=\"stats-item\">\n <span>Month 0:<\/span>\n <span class=\"stats-value\">100%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 1:<\/span>\n <span class=\"stats-value\">~67%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 3:<\/span>\n <span class=\"stats-value\">~48-50%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 6:<\/span>\n <span class=\"stats-value\">~38%<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Month 12:<\/span>\n <span class=\"stats-value\">~28%<\/span>\n <\/div>\n <\/div>\n\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">\ud83c\udfe2 \u00d6rnek Proje B\u00fcy\u00fckl\u00fc\u011f\u00fc<\/h4>\n <div class=\"stats-item\">\n <span>Zaman aral\u0131\u011f\u0131:<\/span>\n <span class=\"stats-value\">36 ay<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Sat\u0131c\u0131 say\u0131s\u0131:<\/span>\n <span class=\"stats-value\">52,847<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>\u0130\u015flem sat\u0131r\u0131:<\/span>\n <span class=\"stats-value\">~2.35M<\/span>\n <\/div>\n <div class=\"stats-item\">\n <span>Ortalama yeni sat\u0131c\u0131\/ay:<\/span>\n <span class=\"stats-value\">~1,500<\/span>\n <\/div>\n <\/div>\n <\/div>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Kritik \u0130pucu:<\/strong> \u0130lk 3 ay kritik \u00f6neme sahiptir. Bu d\u00f6neme y\u00f6nelik onboarding\n yat\u0131r\u0131m\u0131n\u0131n ROI'si genelde en y\u00fcksektir.\n <\/p>\n <\/div>\n<\/section>\n\n\n<section id=\"sonuc\" class=\"content-section\">\n <h2 class=\"section-title\">\ud83c\udfaf Sonu\u00e7 ve Eylem Plan\u0131<\/h2>\n <p class=\"content-text\">\n Cohort analizi, payment processing \u015firketleri i\u00e7in sadece bir raporlama arac\u0131 de\u011fil, stratejik karar alma ve\n b\u00fcy\u00fcme optimizasyonunun temelidir. Bu rehberi takip ederek:\n <\/p>\n\n <div class=\"stats-grid\">\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">1\ufe0f\u20e3 Hemen Ba\u015flay\u0131n<\/h4>\n <p class=\"content-text\">\n Verilerinizi yukar\u0131daki \u015femaya g\u00f6re organize edin. Ay_Periyodu kolonunu mutlaka ay\u0131n ilk g\u00fcn\u00fc format\u0131nda\n tutun.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">2\ufe0f\u20e3 DAX Kodlar\u0131n\u0131 Kopyalay\u0131n<\/h4>\n <p class=\"content-text\">\n Haz\u0131r measure'lar\u0131 ve calculated column'lar\u0131 modelinize aktar\u0131n. Test edin ve kendi i\u015f kurallar\u0131n\u0131za\n g\u00f6re uyarlay\u0131n.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">3\ufe0f\u20e3 Dashboard'unuzu Kurun<\/h4>\n <p class=\"content-text\">\n Executive summary, cohort heatmap ve segment analizi sayfalar\u0131n\u0131 olu\u015fturun. Conditional formatting ile\n g\u00f6rsel etki yarat\u0131n.\n <\/p>\n <\/div>\n <div class=\"stats-card\">\n <h4 class=\"stats-title\">4\ufe0f\u20e3 \u0130yile\u015ftirme Yap\u0131n<\/h4>\n <p class=\"content-text\">\n \u0130lk sonu\u00e7lara g\u00f6re segmentasyon, filtreleme ve ek KPI'lar ekleyin. Kullan\u0131c\u0131 feedback'i al\u0131n ve\n iterative geli\u015ftirin.\n <\/p>\n <\/div>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Kritik Ba\u015far\u0131 Metrikleri:<\/strong><\/h3>\n <div class=\"highlight-box\">\n <ul class=\"highlight-list\">\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>Ayl\u0131k retention oran\u0131 >80%<\/strong> (ilk ay i\u00e7in) - Bu alt\u0131na d\u00fc\u015f\u00fcyorsa onboarding\n s\u00fcrecinizi g\u00f6zden ge\u00e7irin<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>12 ayl\u0131k LTV\/CAC oran\u0131 >3<\/strong> - S\u00fcrd\u00fcr\u00fclebilir b\u00fcy\u00fcme i\u00e7in minimum hedef<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>Churn oran\u0131 <%15< \/strong> (ayl\u0131k) - Sa\u011fl\u0131kl\u0131 bir retention program\u0131 i\u00e7in \u00fcst limit<\/span>\n <\/li>\n <li>\n <span class=\"list-bullet\">\u2713<\/span>\n <span><strong>3. ay retention >45%<\/strong> - Kritik milestone, bu alt\u0131na d\u00fc\u015fenler i\u00e7in m\u00fcdahale\n program\u0131<\/span>\n <\/li>\n <\/ul>\n <\/div>\n\n <div class=\"warning-box\">\n <p class=\"warning-text\">\n <strong>\u26a0\ufe0f \u00d6nemli Hat\u0131rlatma:<\/strong> Bu analiz sistemini kurduktan sonra, ayl\u0131k bazda cohort\n performans\u0131n\u0131z\u0131 takip ederek onboarding s\u00fcre\u00e7lerinizi optimize edebilir, sat\u0131c\u0131 memnuniyetini art\u0131rabilir ve\n s\u00fcrd\u00fcr\u00fclebilir b\u00fcy\u00fcme sa\u011flayabilirsiniz. Unutmay\u0131n: Cohort analizi bir kerelik de\u011fil, s\u00fcrekli izlenmesi\n gereken bir s\u00fcre\u00e7tir.\n <\/p>\n <\/div>\n\n <h3 class=\"content-text\"><strong>Sonraki Ad\u0131mlar:<\/strong><\/h3>\n <p class=\"content-text\">\n Bu rehberi uygulad\u0131ktan sonra a\u015fa\u011f\u0131daki geli\u015fmi\u015f teknikleri de\u011ferlendirin:\n <\/p>\n <ol class=\"steps-list\">\n <li>\n <span class=\"step-number\">1<\/span>\n <span><strong>A\/B Testleri:<\/strong> Farkl\u0131 onboarding s\u00fcre\u00e7lerinin cohort performans\u0131na etkisini \u00f6l\u00e7\u00fcn.\n \u00d6rne\u011fin: K\u0131sa vs uzun onboarding formu, self-service vs assisted setup<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">2<\/span>\n <span><strong>Machine Learning Modelleri:<\/strong> Churn prediction i\u00e7in logistic regression veya random\n forest modelleri geli\u015ftirin<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">3<\/span>\n <span><strong>Real-time Alerting:<\/strong> Power Automate kullanarak kritik metrikler i\u00e7in otomatik uyar\u0131\n sistemleri kurun<\/span>\n <\/li>\n <li>\n <span class=\"step-number\">4<\/span>\n <span><strong>Competitive Benchmarking:<\/strong> Sekt\u00f6r standartlar\u0131yla kendi performans\u0131n\u0131z\u0131\n kar\u015f\u0131la\u015ft\u0131r\u0131n<\/span>\n <\/li>\n <\/ol>\n\n <div class=\"tip-box\">\n <p class=\"tip-text\">\n <strong>\ud83d\udca1 Pro Tip:<\/strong> \u0130lk 90 g\u00fcn boyunca haftal\u0131k cohort toplant\u0131lar\u0131 yap\u0131n. Erken d\u00f6nem patternleri\n tespit etmek ve h\u0131zl\u0131 iterasyon yapmak i\u00e7in bu kritik. Sonras\u0131nda ayl\u0131k rutine ge\u00e7ebilirsiniz.\n <\/p>\n <\/div>\n<\/section>\n\n \n <section class=\"action-section\">\n <h3 class=\"action-title\">\ud83d\ude80 H\u0131zl\u0131 Eylem Plan\u0131<\/h3>\n <div class=\"action-grid\">\n <div class=\"action-card\">\n <div class=\"action-icon\">1\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">ETL'i Haz\u0131rla<\/h4>\n <p class=\"action-card-text\">CSV\/DB \u2192 Power Query ile Ay_Periyodu normalize et, Net_Kazan\u00e7\n hesapla<\/p>\n <\/div>\n <div class=\"action-card\">\n <div class=\"action-icon\">2\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">Model Kur<\/h4>\n <p class=\"action-card-text\">DateTable, Cohort_Date & Months_Since_Cohort calculated columns,\n measures ekle<\/p>\n <\/div>\n <div class=\"action-card\">\n <div class=\"action-icon\">3\ufe0f\u20e3<\/div>\n <h4 class=\"action-card-title\">Dashboard Olu\u015ftur & Test et<\/h4>\n <p class=\"action-card-text\">Heatmap + Executive + Segment sayfalar\u0131 kur, sanity checks \u00e7al\u0131\u015ft\u0131r\n <\/p>\n <\/div>\n <\/div>\n <div class=\"cta-buttons\">\n <a href=\"#\" class=\"cta-primary\">\n \ud83d\udcca Power BI Template \u0130ndir\n <\/a>\n <a href=\"#\" class=\"cta-secondary\">\n \ud83d\udc0d Python Kodunu \u0130ndir\n <\/a>\n <\/div>\n <\/section>\n\n \n <footer class=\"blog-footer\">\n <div class=\"footer-content\">\n <div>\n <p>Bu rehber <strong>Verintra<\/strong> taraf\u0131ndan haz\u0131rlanm\u0131\u015ft\u0131r.<\/p>\n <p>Veri odakl\u0131 dijital pazarlama \u00e7\u00f6z\u00fcmleri i\u00e7in bizimle ileti\u015fime ge\u00e7in.<\/p>\n <\/div>\n <div class=\"footer-links\">\n <a href=\"https:\/\/www.linkedin.com\/company\/verintra\/\">LinkedIn<\/a>\n <a href=\"https:\/\/x.com\/Verintra\">Twitter<\/a>\n <a href=\"https:\/\/verintra.com\/blog\/\">Blog<\/a>\n <\/div>\n <\/div>\n <\/footer>\n <\/div>\n <\/main>\n\n <script>\n function copyToClipboard(elementId) {\n const element = document.getElementById(elementId);\n const text = element.textContent;\n\n if (navigator.clipboard) {\n navigator.clipboard.writeText(text).then(() => {\n \/\/ Kopyalama ba\u015far\u0131l\u0131 feedback'i\n const button = element.parentNode.querySelector('.copy-button');\n const originalText = button.textContent;\n button.textContent = 'Kopyaland\u0131!';\n button.style.backgroundColor = '#10b981';\n\n setTimeout(() => {\n button.textContent = originalText;\n button.style.backgroundColor = '#3eb3d1';\n }, 2000);\n });\n } else {\n \/\/ Fallback for older browsers\n const textArea = document.createElement('textarea');\n textArea.value = text;\n document.body.appendChild(textArea);\n textArea.select();\n document.execCommand('copy');\n document.body.removeChild(textArea);\n\n const button = element.parentNode.querySelector('.copy-button');\n const originalText = button.textContent;\n button.textContent = 'Kopyaland\u0131!';\n setTimeout(() => {\n button.textContent = originalText;\n }, 2000);\n }\n }\n\n \/\/ Smooth scrolling for internal links\n document.querySelectorAll('a[href^=\"#\"]').forEach(anchor => {\n anchor.addEventListener('click', function (e) {\n e.preventDefault();\n const target = document.querySelector(this.getAttribute('href'));\n if (target) {\n target.scrollIntoView({\n behavior: 'smooth',\n block: 'start'\n });\n }\n });\n });\n <\/script>\n<\/body>\n\n<\/html>\n\n\n\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]<\/p>\n","protected":false},"author":1,"featured_media":1953,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"no-sidebar","site-content-layout":"","ast-site-content-layout":"normal-width-container","site-content-style":"unboxed","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"enabled","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11,12],"tags":[],"class_list":["post-1983","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-istatistiksel-metodlar","category-veri-analizi"],"acf":[],"yoast_head":"\n<title>Power BI ile Cohort Analizi - Verintra Digital<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI ile Cohort Analizi - Verintra Digital\" \/>\n<meta property=\"og:description\" content=\"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/\" \/>\n<meta property=\"og:site_name\" content=\"Verintra Digital\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-09T20:07:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-15T11:15:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"734\" \/>\n\t<meta property=\"og:image:height\" content=\"734\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"gokhanagarer@gmail.com\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"gokhanagarer@gmail.com\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"16\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":[\"Article\",\"BlogPosting\"],\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"},\"author\":{\"name\":\"gokhanagarer@gmail.com\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/person\\\/2d47a094bd20bbb9a1f9965d1234fe48\"},\"headline\":\"Power BI ile Cohort Analizi\",\"datePublished\":\"2025-12-09T20:07:36+00:00\",\"dateModified\":\"2025-12-15T11:15:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"},\"wordCount\":3095,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"articleSection\":[\"\u0130statistiksel Metodlar\",\"Veri Analizi\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\",\"url\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\",\"name\":\"Power BI ile Cohort Analizi - Verintra Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"datePublished\":\"2025-12-09T20:07:36+00:00\",\"dateModified\":\"2025-12-15T11:15:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/statistical-analysis.jpg\",\"width\":734,\"height\":734},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/verintra.com\\\/blog\\\/veri-analizi\\\/power-bi-ile-cohort-analizi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/verintra.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI ile Cohort Analizi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#website\",\"url\":\"https:\\\/\\\/verintra.com\\\/\",\"name\":\"Verintra\",\"description\":\"Veri Odakl\u0131 Dijital Pazaralama Ajans\u0131\",\"publisher\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/verintra.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#organization\",\"name\":\"Verintra Digital\",\"url\":\"https:\\\/\\\/verintra.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/verintra-homepage-logo.png\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/verintra-homepage-logo.png\",\"width\":304,\"height\":76,\"caption\":\"Verintra Digital\"},\"image\":{\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/verintra.com\\\/#\\\/schema\\\/person\\\/2d47a094bd20bbb9a1f9965d1234fe48\",\"name\":\"gokhanagarer@gmail.com\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"url\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"contentUrl\":\"https:\\\/\\\/verintra.com\\\/wp-content\\\/litespeed\\\/avatar\\\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471\",\"caption\":\"gokhanagarer@gmail.com\"},\"sameAs\":[\"https:\\\/\\\/verintra.com\"]}]}<\/script>\n","yoast_head_json":{"title":"Power BI ile Cohort Analizi - Verintra Digital","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","og_locale":"de_DE","og_type":"article","og_title":"Power BI ile Cohort Analizi - Verintra Digital","og_description":"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query […]","og_url":"https:\/\/verintra.com\/de\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","og_site_name":"Verintra Digital","article_published_time":"2025-12-09T20:07:36+00:00","article_modified_time":"2025-12-15T11:15:38+00:00","og_image":[{"width":734,"height":734,"url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","type":"image\/jpeg"}],"author":"gokhanagarer@gmail.com","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"gokhanagarer@gmail.com","Gesch\u00e4tzte Lesezeit":"16\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":["Article","BlogPosting"],"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#article","isPartOf":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"},"author":{"name":"gokhanagarer@gmail.com","@id":"https:\/\/verintra.com\/#\/schema\/person\/2d47a094bd20bbb9a1f9965d1234fe48"},"headline":"Power BI ile Cohort Analizi","datePublished":"2025-12-09T20:07:36+00:00","dateModified":"2025-12-15T11:15:38+00:00","mainEntityOfPage":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"},"wordCount":3095,"commentCount":0,"publisher":{"@id":"https:\/\/verintra.com\/#organization"},"image":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"thumbnailUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","articleSection":["\u0130statistiksel Metodlar","Veri Analizi"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","url":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/","name":"Power BI ile Cohort Analizi - Verintra Digital","isPartOf":{"@id":"https:\/\/verintra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"image":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage"},"thumbnailUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","datePublished":"2025-12-09T20:07:36+00:00","dateModified":"2025-12-15T11:15:38+00:00","breadcrumb":{"@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#primaryimage","url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","contentUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg","width":734,"height":734},{"@type":"BreadcrumbList","@id":"https:\/\/verintra.com\/blog\/veri-analizi\/power-bi-ile-cohort-analizi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/verintra.com\/"},{"@type":"ListItem","position":2,"name":"Power BI ile Cohort Analizi"}]},{"@type":"WebSite","@id":"https:\/\/verintra.com\/#website","url":"https:\/\/verintra.com\/","name":"Verintra","description":"Veri Odakl\u0131 Dijital Pazaralama Ajans\u0131","publisher":{"@id":"https:\/\/verintra.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/verintra.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/verintra.com\/#organization","name":"Verintra Digital","url":"https:\/\/verintra.com\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/#\/schema\/logo\/image\/","url":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/04\/verintra-homepage-logo.png","contentUrl":"https:\/\/verintra.com\/wp-content\/uploads\/2025\/04\/verintra-homepage-logo.png","width":304,"height":76,"caption":"Verintra Digital"},"image":{"@id":"https:\/\/verintra.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/verintra.com\/#\/schema\/person\/2d47a094bd20bbb9a1f9965d1234fe48","name":"gokhanagarer@gmail.com","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","url":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","contentUrl":"https:\/\/verintra.com\/wp-content\/litespeed\/avatar\/27b12f0349e5ce0c2c3b9613de483af8.jpg?ver=1780210471","caption":"gokhanagarer@gmail.com"},"sameAs":["https:\/\/verintra.com"]}]}},"uagb_featured_image_src":{"full":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"thumbnail":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis-150x150.jpg",150,150,true],"medium":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis-300x300.jpg",300,300,true],"medium_large":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"large":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"1536x1536":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"2048x2048":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",734,734,false],"trp-custom-language-flag":["https:\/\/verintra.com\/wp-content\/uploads\/2025\/06\/statistical-analysis.jpg",12,12,false]},"uagb_author_info":{"display_name":"gokhanagarer@gmail.com","author_link":"https:\/\/verintra.com\/de\/blog\/author\/gokhanagarergmail-com\/"},"uagb_comment_info":0,"uagb_excerpt":"Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Veri Analizi \u2022 Power BI \u2022 Cohort Analizi Power BI ile Cohort Analizi \u2014 Ba\u015ftan Sona Kapsaml\u0131 Rehber Hedef: \u00d6deme hizmeti veren \u015firketler i\u00e7in sat\u0131c\u0131 retention ve LTV (lifetime value) analizini Power BI ile ba\u015ftan sona kurup uygulayabilmenizi sa\u011flamak. Rehber hem pratik ad\u0131mlar\u0131 (Power Query…","_links":{"self":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/comments?post=1983"}],"version-history":[{"count":10,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983\/revisions"}],"predecessor-version":[{"id":2057,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/posts\/1983\/revisions\/2057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/media\/1953"}],"wp:attachment":[{"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/media?parent=1983"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/categories?post=1983"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/verintra.com\/de\/wp-json\/wp\/v2\/tags?post=1983"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}