{"id":820,"date":"2017-07-31T08:56:44","date_gmt":"2017-07-31T06:56:44","guid":{"rendered":"http:\/\/kalkulacija.com\/wordpress\/?p=820"},"modified":"2017-09-23T19:37:50","modified_gmt":"2017-09-23T17:37:50","slug":"model-podataka","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/","title":{"rendered":"Model podataka"},"content":{"rendered":"Model podataka se koristi za dodavanje i povezivanje tabela iz vi\u0161e razli\u010ditih izvora u jedinstveni model baze podataka kao jednu celinu, koja vm je neophodna za analizu i izve\u0161tavanje.<\/p>\n<figure id=\"attachment_821\" aria-describedby=\"caption-attachment-821\" style=\"width: 479px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-821 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png\" alt=\"model podataka\" width=\"479\" height=\"165\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png 479w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1-350x121.png 350w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1-300x103.png 300w\" sizes=\"auto, (max-width: 479px) 100vw, 479px\" \/><figcaption id=\"caption-attachment-821\" class=\"wp-caption-text\">model podataka<\/figcaption><\/figure>\n<p>To je virtuelni model baze podataka (pseudo database), i snima se kao sastavni deo Excel dokumenta. Dodavanjem tabela u model podaci se automatski kompresuju; kasnije, kada nam zatrebaju za izve\u0161tavanje, oni se dekompresuju i koriste kao izve\u0161tajne dimenzije u Pivot tabelama.<\/p>\n<p>Prilikom preuzimanja podataka iz razli\u010ditih izvora \u010desto je potrebno da se oni \u201epre\u010diste\u201c. U tu svrhu postoji alat koji se zove <a href=\"https:\/\/kalkulacija.com\/wordpress\/2017\/09\/07\/power-query-mocni-upiti\/\">PowerQuery<\/a>. Ure\u0111ene podatke dodajemo i povezujemo u modelu, a na osnovu njih se mogu kreirati PowerPivot tabele. Vi\u0161e o tome mo\u017eete pro\u010ditati na slede\u0107i<a href=\"http:\/\/excelk.com\/sr\/model-podataka\/\"> link<\/a>.<\/p>\n<p>&nbsp;\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;820&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Ocenite post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Model podataka&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Ocenite post<\/span>\n    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>Model podataka se koristi za dodavanje i povezivanje tabela iz vi\u0161e razli\u010ditih izvora u jedinstveni model baze podataka kao jednu<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,39],"tags":[],"class_list":["post-820","post","type-post","status-publish","format-standard","hentry","category-power-excel","category-powerpivot"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Model podataka - Kalkulacija u osnovi svega!<\/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:\/\/kalkulacija.com\/wordpress\/model-podataka\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[:sr]Model podataka[:en]Data Model[:] - Kalkulacija u osnovi svega!\" \/>\n<meta property=\"og:description\" content=\"Model podataka se koristi za dodavanje i povezivanje tabela iz vi\u0161e razli\u010ditih izvora u jedinstveni model baze podataka kao jednu\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/\" \/>\n<meta property=\"og:site_name\" content=\"Kalkulacija u osnovi svega!\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-31T06:56:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-09-23T17:37:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Model podataka\",\"datePublished\":\"2017-07-31T06:56:44+00:00\",\"dateModified\":\"2017-09-23T17:37:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/\"},\"wordCount\":145,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/modelpodataka1.png\",\"articleSection\":[\"Power Excel\",\"PowerPivot\"],\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/\",\"name\":\"[:sr]Model podataka[:en]Data Model[:] - Kalkulacija u osnovi svega!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/modelpodataka1.png\",\"datePublished\":\"2017-07-31T06:56:44+00:00\",\"dateModified\":\"2017-09-23T17:37:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#breadcrumb\"},\"inLanguage\":\"sr-SR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#primaryimage\",\"url\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/modelpodataka1.png\",\"contentUrl\":\"http:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/modelpodataka1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/model-podataka\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Model podataka\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sr-SR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sr-SR\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[:sr]Model podataka[:en]Data Model[:] - Kalkulacija u osnovi svega!","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:\/\/kalkulacija.com\/wordpress\/model-podataka\/","og_locale":"en_US","og_type":"article","og_title":"[:sr]Model podataka[:en]Data Model[:] - Kalkulacija u osnovi svega!","og_description":"Model podataka se koristi za dodavanje i povezivanje tabela iz vi\u0161e razli\u010ditih izvora u jedinstveni model baze podataka kao jednu","og_url":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/","og_site_name":"Kalkulacija u osnovi svega!","article_published_time":"2017-07-31T06:56:44+00:00","article_modified_time":"2017-09-23T17:37:50+00:00","og_image":[{"url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Model podataka","datePublished":"2017-07-31T06:56:44+00:00","dateModified":"2017-09-23T17:37:50+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/"},"wordCount":145,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png","articleSection":["Power Excel","PowerPivot"],"inLanguage":"sr-SR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/","url":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/","name":"[:sr]Model podataka[:en]Data Model[:] - Kalkulacija u osnovi svega!","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#primaryimage"},"thumbnailUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png","datePublished":"2017-07-31T06:56:44+00:00","dateModified":"2017-09-23T17:37:50+00:00","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#breadcrumb"},"inLanguage":"sr-SR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/model-podataka\/"]}]},{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#primaryimage","url":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png","contentUrl":"http:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/modelpodataka1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/model-podataka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Model podataka"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sr-SR"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"sr-SR","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=820"}],"version-history":[{"count":2,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/820\/revisions"}],"predecessor-version":[{"id":823,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/820\/revisions\/823"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}