{"id":15349,"date":"2025-07-15T13:34:52","date_gmt":"2025-07-15T13:34:52","guid":{"rendered":"https:\/\/functiontranslator.com\/kupkumesi\/"},"modified":"2021-02-25T16:24:53","modified_gmt":"2021-02-25T16:24:53","slug":"cubeset","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/tr\/cubeset\/","title":{"rendered":"K\u00dcPK\u00dcMES\u0130"},"content":{"rendered":"

Excel ve Google E-Tablolar’da kullan\u0131lan fonksiyonlar, veri analizi ve i\u015flem yapma konusunda olduk\u00e7a g\u00fc\u00e7l\u00fc ara\u00e7lard\u0131r. Bu rehberde, Excel’deki “CUBESET” fonksiyonunun yap\u0131s\u0131 ve kullan\u0131m alanlar\u0131 \u00fczerinde duraca\u011f\u0131z, \u00e7\u00fcnk\u00fc bu i\u015flev \u00f6zellikle b\u00fcy\u00fck veri setleri ile \u00e7al\u0131\u015f\u0131rken olduk\u00e7a i\u015fe yarar. <\/p>\n

K\u00dcPK\u00dcMES\u0130 Fonksiyonuna Genel Bak\u0131\u015f<\/h2>\n

CUBESET i\u015flevi, bir k\u00fcp olarak tan\u0131mlanan veri k\u00fcmesi i\u00e7erisinden belirli kriterlere uyan \u00f6\u011feleri bir k\u00fcme olarak d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r. Bu, \u00f6zellikle i\u015f zekas\u0131 g\u00f6revlerinde ve karma\u015f\u0131k veri analizlerinde kullan\u0131\u015fl\u0131d\u0131r. Excel’deki s\u00f6zdizimi a\u015fa\u011f\u0131daki \u015fekildedir: <\/p>\n

  CUBESET(ba\u011flant\u0131, k\u00fcp ifadesi, [altnot], [s\u0131ralama_sabit], [s\u0131ralama_k\u00fcp_\u00f6\u011fesi]) <\/code> <\/pre>\n
    \n
  • ba\u011flant\u0131<\/strong>: Veri k\u00fcp\u00fcne olan ba\u011flant\u0131y\u0131 temsil eder.<\/li>\n
  • k\u00fcp ifadesi<\/strong>: K\u00fcme i\u00e7indeki \u00f6\u011feleri tan\u0131mlayan, genellikle bir MDX (Multi-Dimensional Expressions) ifadesi.<\/li>\n
  • altnot<\/strong> (iste\u011fe ba\u011fl\u0131): D\u00f6nd\u00fcr\u00fclen k\u00fcmeye verilecek ad.<\/li>\n
  • s\u0131ralama_sabit<\/strong> (iste\u011fe ba\u011fl\u0131): K\u00fcme i\u00e7indeki \u00f6\u011felerin nas\u0131l s\u0131ralanaca\u011f\u0131n\u0131 belirten bir sabit (1, -1, 0).<\/li>\n
  • s\u0131ralama_k\u00fcp_\u00f6\u011fesi<\/strong> (iste\u011fe ba\u011fl\u0131): Hangi \u00f6\u011feye g\u00f6re s\u0131ralama yap\u0131laca\u011f\u0131n\u0131 belirtir.<\/li>\n<\/ul>\n
    K\u00dcPK\u00dcMES\u0130 ile Veri Analizi<\/h2>\n
     Bu fonksiyon, \u00f6zellikle belirli ko\u015fullar\u0131 sa\u011flayan veri k\u00fcmelerini \u00e7ekmek i\u00e7in kullan\u0131l\u0131r. \u0130\u015fte bu fonksiyonu kullanarak yapabilece\u011finiz birka\u00e7 pratik g\u00f6rev: <\/p>\n
    Pratik G\u00f6rev 1: Sat\u0131\u015f Verileri Analizi<\/h2>\n
     Diyelim ki, farkl\u0131 \u00fcr\u00fcn kategorilerine g\u00f6re toplam sat\u0131\u015flar\u0131 bulmak istiyorsunuz. CUBESET fonksiyonu ile belirli bir kategoriye ait \u00fcr\u00fcnlerin sat\u0131\u015flar\u0131n\u0131 \u00e7ekmek m\u00fcmk\u00fcnd\u00fcr. <\/p>\n
      =CUBESET(\"Sat\u0131\u015fVeritaban\u0131Ba\u011flant\u0131s\u0131\", \"FILTER(\u00dcr\u00fcnler, [\u00dcr\u00fcnler].[Kategori].&[Teknoloji])\", \"Teknoloji \u00dcr\u00fcnleri\") <\/code> <\/pre>\n
     Bu \u00f6rnekte, “Teknoloji” kategorisine ait \u00fcr\u00fcnlerin bir k\u00fcmesi olu\u015fturulacak ve “Teknoloji \u00dcr\u00fcnleri” olarak adland\u0131r\u0131lacak. <\/p>\n
    Pratik G\u00f6rev 2: M\u00fc\u015fteri Segmentasyonu<\/h2>\n
     M\u00fc\u015fterileri sat\u0131n alma frekanslar\u0131na g\u00f6re s\u0131n\u0131fland\u0131rarak daha hedefli pazarlama kampanyalar\u0131 d\u00fczenlenebilir. CUBESET fonksiyonu kullan\u0131larak, belirli bir sat\u0131n alma frekans\u0131 e\u015fi\u011finin \u00fczerindeki m\u00fc\u015fteriler kolayl\u0131kla filtrelenir. <\/p>\n
      =CUBESET(\"M\u00fc\u015fteriVeritaban\u0131Ba\u011flant\u0131s\u0131\", \"FILTER(M\u00fc\u015fteriler, [M\u00fc\u015fteriler].[Sat\u0131nAlmaFrekans\u0131] > 5)\", \"Aktif M\u00fc\u015fteriler\") <\/code> <\/pre>\n
     Bu kullan\u0131mda, sat\u0131n alma frekans\u0131 5’in \u00fczerinde olan m\u00fc\u015fteriler “Aktif M\u00fc\u015fteriler” ad\u0131 alt\u0131nda bir k\u00fcme olarak olu\u015fturulmu\u015ftur. <\/p>\n","protected":false},"excerpt":{"rendered":"
    K\u00fcmeyi olu\u015fturan ve ard\u0131ndan bu k\u00fcmeyi Microsoft Office Excel’e getiren sunucudaki k\u00fcpe k\u00fcme ifadelerini g\u00f6ndererek hesaplanan \u00fcye veya kay\u0131t k\u00fcmesini tan\u0131mlar<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[587],"tags":[],"class_list":["post-15349","post","type-post","status-publish","format-standard","hentry","category-kup"],"acf":[],"yoast_head":"\nExcel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri<\/title>\n<meta name=\"description\" content=\"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/tr\/cubeset\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta property=\"og:description\" content=\"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/tr\/cubeset\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T16:24:53+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubeset\/\",\"url\":\"https:\/\/functiontranslator.com\/tr\/cubeset\/\",\"name\":\"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:52+00:00\",\"dateModified\":\"2021-02-25T16:24:53+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubeset\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/tr\/cubeset\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/tr\/cubeset\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel i\u015flevleri\",\"item\":\"https:\/\/functiontranslator.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"K\u00fcp\",\"item\":\"https:\/\/functiontranslator.com\/tr\/kup\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"K\u00dcPK\u00dcMES\u0130\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","description":"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","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:\/\/functiontranslator.com\/tr\/cubeset\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","og_description":"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","og_url":"https:\/\/functiontranslator.com\/tr\/cubeset\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:52+00:00","article_modified_time":"2021-02-25T16:24:53+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","twitter_misc":{"Yazan:":"glavadmin","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/tr\/cubeset\/","url":"https:\/\/functiontranslator.com\/tr\/cubeset\/","name":"Excel'de CUBESET (K\u00dcPK\u00dcMES\u0130) Fonksiyonu: Nas\u0131l \u00c7al\u0131\u015f\u0131r, Kullan\u0131m \u00d6rnekleri","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:52+00:00","dateModified":"2021-02-25T16:24:53+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Excel ve Google E-Tablolar'da CUBESET (K\u00dcPK\u00dcMES\u0130) fonksiyonunun detayl\u0131 incelemesi. S\u00f6z dizimi, form\u00fcl\u00fcn kullan\u0131m \u00f6rnekleri ve parametrelerin a\u00e7\u0131klamas\u0131.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/tr\/cubeset\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/tr\/cubeset\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/tr\/cubeset\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel i\u015flevleri","item":"https:\/\/functiontranslator.com\/tr\/"},{"@type":"ListItem","position":2,"name":"K\u00fcp","item":"https:\/\/functiontranslator.com\/tr\/kup\/"},{"@type":"ListItem","position":3,"name":"K\u00dcPK\u00dcMES\u0130"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/tr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/comments?post=15349"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15349\/revisions"}],"predecessor-version":[{"id":27048,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/posts\/15349\/revisions\/27048"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/media?parent=15349"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/categories?post=15349"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/tr\/wp-json\/wp\/v2\/tags?post=15349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}