{"id":189919,"date":"2022-11-10T15:22:27","date_gmt":"2022-11-10T14:22:27","guid":{"rendered":"https:\/\/learnesy.com\/?p=189919"},"modified":"2022-11-10T15:25:56","modified_gmt":"2022-11-10T14:25:56","slug":"uppdatering-av-power-bi-bas-nytt-kapitel-om-datamodellering-och-relationer","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/uppdatering-av-power-bi-bas-nytt-kapitel-om-datamodellering-och-relationer\/","title":{"rendered":"Uppdatering av Power BI Bas \u2013 nytt kapitel om datamodellering och relationer"},"content":{"rendered":"<span id=\"heading-vad-ar-datamodellering\"><h2 id=\"s1\">Vad \u00e4r datamodellering?<\/h2><\/span>\n<p><em><strong>Datamodeller<\/strong><\/em> inkluderar tabeller, kolumner och relationer, \u00e4ven kallat samband, mellan tabeller. De kan \u00e4ven inneh\u00e5lla information om datatyper och s\u00e5 kallade nycklar. Nycklarna hj\u00e4lper till att matcha tabeller och \u00e4r fundamentala f\u00f6r att v\u00e5r <em><strong>datamodell<\/strong><\/em> ska fungera.<\/p>\n<p>En popul\u00e4r datamodell \u00e4r att dela upp tabeller i <em><strong>fakta och dimensioner<\/strong><\/em>. Kortfattat s\u00e5 \u00e4r faktatabellen m\u00e5tten fr\u00e5n en aff\u00e4rsprocess, och dimensionerna ger sammanhanget. Denna datamodell har flera namn, men kallas ofta f\u00f6r stj\u00e4rnschema.<\/p>\n<p>Detta knyter an till f\u00f6reg\u00e5ende kapitel d\u00e5 ett f\u00f6rsta steg i datamodellering \u00e4r just att rensa och st\u00e4da data, f\u00f6r vilket <em><strong>Power Query-redigeraren<\/strong><\/em> har anv\u00e4nts.<\/p>\n<p>Denna exempellektion visar hur man addera <em><strong>lookup-tabeller<\/strong><\/em> till sin datamodell.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/768554579?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<span id=\"heading-avslutande-ord\"><h2 id=\"s2\">Avslutande ord<\/h2><\/span>\n<p>\u00c4r man nyfiken p\u00e5 den nya delen av\u00a0<strong>Power BI Bas <\/strong>hittar man kursen <a href=\"https:\/\/learnesy.com\/sv\/courses\/power-bi\/\">h\u00e4r<\/a>. Nya kapitel kommer adderas, men de gamla lektionerna finns fortfarande kvar. Dessa lektioner fungerar som ett bra snabbsp\u00e5r till att b\u00f6rja arbeta med Power BI.<\/p>\n<p>&nbsp;<\/p>\n<p><em>\/Niklas p\u00e5 Learnesy<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>P\u00e5 Learnesy har vi uppdaterat v\u00e5r kurs Power BI Bas med ett nytt kapitel som avhandlar datamodellering och relationer. <\/p>\n","protected":false},"author":54291,"featured_media":190260,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[30],"tags":[],"class_list":["post-189919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ovrigt"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/189919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=189919"}],"version-history":[{"count":1,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/189919\/revisions"}],"predecessor-version":[{"id":190368,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/189919\/revisions\/190368"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/190260"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=189919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=189919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=189919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}