{"id":178,"date":"2026-10-29T22:26:56","date_gmt":"2026-10-29T21:26:56","guid":{"rendered":"https:\/\/www.bkw-consult.de\/?page_id=178"},"modified":"2026-10-29T22:26:57","modified_gmt":"2026-10-29T21:26:57","slug":"dataflow-gen2","status":"publish","type":"page","link":"https:\/\/www.bkw-consult.de\/?page_id=178","title":{"rendered":"Dataflow Gen2"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u201eDataflow Gen2 und Datenaufbereitung\u201c<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\">Ziele und Erwartungen der Teilnehmer<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kl\u00e4rung individueller Lernziele und Erwartungen f\u00fcr ein praxisnahes und relevantes Seminar<\/li>\n\n\n\n<li>Vorkenntnisse<\/li>\n\n\n\n<li>Praxisbeispiele aus den Unternehmen<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Von Power Query zu Dataflow Gen2<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gemeinsame Konzepte<\/li>\n\n\n\n<li>Unterschiede<\/li>\n\n\n\n<li>Vorteile der Cloud-Nutzung<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Datenquellen<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dateien<\/li>\n\n\n\n<li>Datenbanken<\/li>\n\n\n\n<li>SharePoint<\/li>\n\n\n\n<li>Cloud-Dienste<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Dataflow Gen2<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Aufbau<\/li>\n\n\n\n<li>Benutzeroberfl\u00e4che<\/li>\n\n\n\n<li>Datenvorschau<\/li>\n\n\n\n<li>Abfragen<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Transformationen<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Filtern<\/li>\n\n\n\n<li>Sortieren<\/li>\n\n\n\n<li>Gruppieren<\/li>\n\n\n\n<li>Pivotieren<\/li>\n\n\n\n<li>Entpivotieren<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Datenqualit\u00e4t<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fehler erkennen<\/li>\n\n\n\n<li>Datentypen korrigieren<\/li>\n\n\n\n<li>Daten validieren<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Wiederverwendbarkeit<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Zentralisierung<\/li>\n\n\n\n<li>Pflege<\/li>\n\n\n\n<li>Aktualisierung<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Permanente \u00dcbungen zu allen o. g. Themenbereichen, z. Bsp. mit:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Daten importieren<\/li>\n\n\n\n<li>Daten bereinigen<\/li>\n\n\n\n<li>Daten oder Ordner konsolidieren<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Diskussionen und Fragestellungen dazu:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Wann reicht Excel?<\/li>\n\n\n\n<li>Wann ist ein Dataflow sinnvoll?<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Lakehouse<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Grundidee<\/li>\n\n\n\n<li>Vorteile<\/li>\n\n\n\n<li>Einsatzgebiete<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Warehouse<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Grundidee<\/li>\n\n\n\n<li>Vorteile<\/li>\n\n\n\n<li>Einsatzgebiete<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Lakehouse vs. Warehouse<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gemeinsamkeiten<\/li>\n\n\n\n<li>Unterschiede<\/li>\n\n\n\n<li>Entscheidungshilfen<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u201eDataflow Gen2 und Datenaufbereitung\u201c Ziele und Erwartungen der Teilnehmer Von Power Query zu Dataflow Gen2 Datenquellen Dataflow Gen2 Transformationen Datenqualit\u00e4t Wiederverwendbarkeit Permanente \u00dcbungen zu allen o. g. Themenbereichen, z. Bsp. mit: Diskussionen und Fragestellungen dazu: Lakehouse Warehouse Lakehouse vs. Warehouse<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-178","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Dataflow Gen2 - BKW Consult UG<\/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:\/\/www.bkw-consult.de\/?page_id=178\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dataflow Gen2 - BKW Consult UG\" \/>\n<meta property=\"og:description\" content=\"\u201eDataflow Gen2 und Datenaufbereitung\u201c Ziele und Erwartungen der Teilnehmer Von Power Query zu Dataflow Gen2 Datenquellen Dataflow Gen2 Transformationen Datenqualit\u00e4t Wiederverwendbarkeit Permanente \u00dcbungen zu allen o. g. Themenbereichen, z. Bsp. mit: Diskussionen und Fragestellungen dazu: Lakehouse Warehouse Lakehouse vs. Warehouse\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bkw-consult.de\/?page_id=178\" \/>\n<meta property=\"og:site_name\" content=\"BKW Consult UG\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-29T21:26:57+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BKWConsultGmbH\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/?page_id=178\",\"url\":\"https:\\\/\\\/www.bkw-consult.de\\\/?page_id=178\",\"name\":\"Dataflow Gen2 - BKW Consult UG\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#website\"},\"datePublished\":\"2026-10-29T21:26:56+00:00\",\"dateModified\":\"2026-10-29T21:26:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/?page_id=178#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bkw-consult.de\\\/?page_id=178\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/?page_id=178#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.bkw-consult.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dataflow Gen2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#website\",\"url\":\"https:\\\/\\\/www.bkw-consult.de\\\/\",\"name\":\"BKW Consult\",\"description\":\"IT Beratung f\u00fcr Business Intelligence, Automatisierung und moderne Zusammenarbeit. Und das mit Sicherheit.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#organization\"},\"alternateName\":\"BKWCUG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bkw-consult.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#organization\",\"name\":\"BKW Consult UG (haftungsbeschr\u00e4nkt)\",\"alternateName\":\"BKWC UG\",\"url\":\"https:\\\/\\\/www.bkw-consult.de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bkw-consult.de\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Screenshot-2023-06-16-132406.png\",\"contentUrl\":\"https:\\\/\\\/www.bkw-consult.de\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/Screenshot-2023-06-16-132406.png\",\"width\":1352,\"height\":283,\"caption\":\"BKW Consult UG (haftungsbeschr\u00e4nkt)\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bkw-consult.de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/BKWConsultGmbH\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bkw-consult-ug\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Dataflow Gen2 - BKW Consult UG","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:\/\/www.bkw-consult.de\/?page_id=178","og_locale":"de_DE","og_type":"article","og_title":"Dataflow Gen2 - BKW Consult UG","og_description":"\u201eDataflow Gen2 und Datenaufbereitung\u201c Ziele und Erwartungen der Teilnehmer Von Power Query zu Dataflow Gen2 Datenquellen Dataflow Gen2 Transformationen Datenqualit\u00e4t Wiederverwendbarkeit Permanente \u00dcbungen zu allen o. g. Themenbereichen, z. Bsp. mit: Diskussionen und Fragestellungen dazu: Lakehouse Warehouse Lakehouse vs. Warehouse","og_url":"https:\/\/www.bkw-consult.de\/?page_id=178","og_site_name":"BKW Consult UG","article_modified_time":"2026-10-29T21:26:57+00:00","twitter_card":"summary_large_image","twitter_site":"@BKWConsultGmbH","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bkw-consult.de\/?page_id=178","url":"https:\/\/www.bkw-consult.de\/?page_id=178","name":"Dataflow Gen2 - BKW Consult UG","isPartOf":{"@id":"https:\/\/www.bkw-consult.de\/#website"},"datePublished":"2026-10-29T21:26:56+00:00","dateModified":"2026-10-29T21:26:57+00:00","breadcrumb":{"@id":"https:\/\/www.bkw-consult.de\/?page_id=178#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bkw-consult.de\/?page_id=178"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bkw-consult.de\/?page_id=178#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.bkw-consult.de\/"},{"@type":"ListItem","position":2,"name":"Dataflow Gen2"}]},{"@type":"WebSite","@id":"https:\/\/www.bkw-consult.de\/#website","url":"https:\/\/www.bkw-consult.de\/","name":"BKW Consult","description":"IT Beratung f\u00fcr Business Intelligence, Automatisierung und moderne Zusammenarbeit. Und das mit Sicherheit.","publisher":{"@id":"https:\/\/www.bkw-consult.de\/#organization"},"alternateName":"BKWCUG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bkw-consult.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.bkw-consult.de\/#organization","name":"BKW Consult UG (haftungsbeschr\u00e4nkt)","alternateName":"BKWC UG","url":"https:\/\/www.bkw-consult.de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.bkw-consult.de\/#\/schema\/logo\/image\/","url":"https:\/\/www.bkw-consult.de\/wp-content\/uploads\/2023\/06\/Screenshot-2023-06-16-132406.png","contentUrl":"https:\/\/www.bkw-consult.de\/wp-content\/uploads\/2023\/06\/Screenshot-2023-06-16-132406.png","width":1352,"height":283,"caption":"BKW Consult UG (haftungsbeschr\u00e4nkt)"},"image":{"@id":"https:\/\/www.bkw-consult.de\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/BKWConsultGmbH","https:\/\/www.linkedin.com\/company\/bkw-consult-ug\/"]}]}},"_links":{"self":[{"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/pages\/178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=178"}],"version-history":[{"count":1,"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/pages\/178\/revisions"}],"predecessor-version":[{"id":179,"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=\/wp\/v2\/pages\/178\/revisions\/179"}],"wp:attachment":[{"href":"https:\/\/www.bkw-consult.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}