{"id":84,"date":"2020-04-13T12:05:50","date_gmt":"2020-04-13T12:05:50","guid":{"rendered":"http:\/\/compurem.de\/?page_id=84"},"modified":"2020-05-18T16:08:53","modified_gmt":"2020-05-18T16:08:53","slug":"power-query-power-pivot-power-bi","status":"publish","type":"page","link":"https:\/\/www.compurem.de\/?page_id=84","title":{"rendered":"Power Query\/Power Pivot\/Power BI"},"content":{"rendered":"\n<p>Folgende Themen k\u00f6nnten interessant f\u00fcr Sie sein:<\/p>\n\n\n\n<ul><li><strong>PowerQuery:<\/strong><\/li><li>Extract, Transform &amp; Load<\/li><li>Abfragen erstellen<\/li><li>Mehrere Dateien in einem Schritt importieren<\/li><li>Der SVERWEIS in Power Query: Tabellen verkn\u00fcpfen<\/li><li>Zellinhalte bearbeiten<\/li><li>Daten entpivotieren<\/li><li>Daten berechnen<\/li><li>Parameter in Berechnungen verwenden<\/li><li>Zugriff aus Daten aus dem Web<\/li><li>Datenabruf von XML- und JSON-Daten<\/li><li>Einf\u00fchrung in M<\/li><li><strong>PowerPivot:<\/strong><\/li><li>Datenbankenaufbau<\/li><li>Power Pivot Datenmodell<\/li><li>Zus\u00e4tzliche Pivot Felder; Zus\u00e4tzliche Elemente<\/li><li>Visualisierung mit bedingten Formatierungsregeln<\/li><li>Selektives Importieren von Daten<\/li><li>Tabellen einrichten<\/li><li>Datenmodell bestimmen<\/li><li>Entwurfsmodus benutzen<\/li><li>Kalender einbauen<\/li><li>Verkn\u00fcpfungen mit Prim\u00e4r- und Sekund\u00e4rschl\u00fcssel anlegen<\/li><li>Zus\u00e4tzliche Felder einrichten mit Power Pivot Measures<\/li><li>Visualisierung von KPIs<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"620\" src=\"https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ-1024x620.png\" alt=\"\" class=\"wp-image-413\" srcset=\"https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ-1024x620.png 1024w, https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ-300x182.png 300w, https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ-768x465.png 768w, https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ-1536x930.png 1536w, https:\/\/www.compurem.de\/wp-content\/uploads\/2020\/05\/20200518PQ.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Folgende Themen k\u00f6nnten interessant f\u00fcr Sie sein: PowerQuery: Extract, Transform &amp; Load Abfragen erstellen Mehrere Dateien in einem Schritt importieren &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_mc_calendar":[]},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/pages\/84"}],"collection":[{"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.compurem.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=84"}],"version-history":[{"count":2,"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/pages\/84\/revisions"}],"predecessor-version":[{"id":415,"href":"https:\/\/www.compurem.de\/index.php?rest_route=\/wp\/v2\/pages\/84\/revisions\/415"}],"wp:attachment":[{"href":"https:\/\/www.compurem.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=84"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}