{"id":1067,"date":"2022-01-11T09:23:09","date_gmt":"2022-01-11T08:23:09","guid":{"rendered":"https:\/\/newdatalabs.com\/en\/?page_id=1067"},"modified":"2024-04-08T14:58:48","modified_gmt":"2024-04-08T12:58:48","slug":"power-query","status":"publish","type":"page","link":"https:\/\/newdatalabs.com\/en\/power-query\/","title":{"rendered":"Power Query"},"content":{"rendered":"\n<section class=\"powerquery_1\">\n<div class=\"wrap_in\"> \n<div class=\"first one-half\"> \n<h1><span>Power Query<\/span><\/h1> \n<div>Do you associate working with data with manually pasting and cleaning data in Excel? Are you wasting your valuable time organizing data from different sources? Or maybe you suspect that your Excel sheets are hiding a lot of valuable information, but you don&#8217;t know how to extract it and how long it will take you? Don&#8217;t have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists? <\/div><br>\n<a class=\"what-tableau-button1\" href=\"https:\/\/newdatalabs.com\/en\/power-query\/#contact\">Contact us &gt;<\/a> \n<\/div> \n<\/div><\/section>\n<section id=\"powerquery-more\" class=\"powerquery_2\">\n<div class=\"wrap_in\"> \n<h2 class=\"powerquery_title\"><span class=\"bold_title_\">Power Query <\/span>&#8211; what is it<\/h2> \n<div style=\"width: 80%; margin: 0 auto; text-align: center;\"> \n          Power Query is a free Excel add-on that allows you to: <br><br>\n<ul>\n<li>Automatically retrieve data from multiple data sources, \n\t<\/li><li>Create a data model based on multiple sources, in the cloud or locally, \n\t<\/li><li>Modify data \n\t<\/li><li>Create advanced reports\n<\/li><\/ul>\n<div style=\"width: 100%; overflow: hidden; text-align: center;\"> \n<a class=\"what-tableau-button1\" href=\"https:\/\/newdatalabs.com\/en\/power-query\/#powerquery-benefits\">Learn more &gt;<\/a> \n<\/div> \n<\/div> \n<\/div> \n<\/section> \n\n<section id=\"powerquery-benefits\" class=\"powerquery_3\">\n<div class=\"wrap_in\"> \n<h2 class=\"powerquery_title\"><span class=\"bold_title_\">Power Query Training <\/span><\/h2>\nWho is Power Query training for? The training is designed for people who: <br><br> \n<ul>\n\t<li>use advanced Excel options, \n      <\/li><li>working with large amounts of data, \n      <\/li><li>are responsible for analysis, \n      <\/li><li>combine data from multiple Excel worksheets or multiple Excel files, \n      <\/li><li>download data from text files or CSV. \n\t  <\/li>\n<\/ul>\nExcel training along with a discussion of the PowerQuery \n<br>add-on will significantly improve the speed and quality of your work. \n<\/div> \n<\/section> \n<section id=\"powerquery-zalety\" class=\"powerquery_6\">\n<div class=\"wrap_in\"> \n<h2 class=\"powerquery_title\"><span class=\"bold_title_\">After the Power Query training<\/span><\/h2>\n<div class=\"first one-fourth\"> \n<img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><br>\nYou will save time in completing tasks compared to MS Excel. \n<\/div> \n<div class=\"one-fourth\"> \n<img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_2.jpg\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><br>\nYou will learn how to process data with tools that were previously unavailable in Excel. \n<\/div> \n<div class=\"one-fourth\"> \n<img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_3.jpg\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><br>\nYou will make it easy to download and combine data from many sources, including Excel, TXT, CSV, Access, web pages, SQL, Oracle and many others. \n<\/div> \n<div class=\"one-fourth\"> \n<img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_4.jpg\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><br>\nYou will automate your queries without using VBA. \n<\/div> \n<\/div> \n<\/section> \n<section id=\"contact\" class=\"powerquery_5\">\n<div class=\"wrap_in\"> \n<h2 class=\"powerquery_title\">Contact with us<\/h2> \n<div class=\"first one-half contact_tableau-new\">\n<a href=\"https:\/\/newdatalabs.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2023\/12\/logo_Newdatalabs_en.svg\" alt=\"logo Newdatalabs\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><\/a><br><br>\n<div class=\"contact\"> <img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/contact_icon3-6.png\" alt=\"email\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 31px; --smush-placeholder-aspect-ratio: 31\/31;\"> <a href=\"mailto:contact@newdatalabs.com\">contact@newdatalabs.com<\/a><\/div>\n<div class=\"contact starting9-contact2\"> <img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/contact_icon2-6.png&quot;\" alt=\"telefon\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 31px; --smush-placeholder-aspect-ratio: 31\/31;\"> <a style=\"font-weight: 300; color: inherit; text-decoration: none;\" href=\"tel:+48 781648194\">781 648 194<\/a><\/div>\n<br class=\"tableau-new_br\"><br class=\"tableau-new_br\"> \n<a href=\"https:\/\/twitter.com\/newdatalabs\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" style=\"--smush-placeholder-width: 26px; --smush-placeholder-aspect-ratio: 26\/26;padding-right: 7px;\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/a-2.png\" alt=\"twitter Ndls\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><\/a> <a href=\"https:\/\/pl-pl.facebook.com\/pg\/NewDataLabS\/posts\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" style=\"--smush-placeholder-width: 26px; --smush-placeholder-aspect-ratio: 26\/26;padding-right: 7px;\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/b-2.png\" alt=\"facebook Ndls\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><\/a> <a href=\"https:\/\/www.youtube.com\/channel\/UCttQFNPfT1QdZA4MBPIbJmQ\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" style=\"--smush-placeholder-width: 26px; --smush-placeholder-aspect-ratio: 26\/26;padding-right: 7px;\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/c-3.png\" alt=\"youtube Ndls\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><\/a> <a href=\"https:\/\/www.linkedin.com\/company\/newdatalabs\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" style=\"--smush-placeholder-width: 26px; --smush-placeholder-aspect-ratio: 26\/26;padding-right: 7px;\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/d-2.png\" alt=\"linkedin Ndls\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\"><\/a> <a href=\"https:\/\/www.instagram.com\/newdatalabs\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" data-src=\"https:\/\/newdatalabs.com\/en\/wp-content\/uploads\/2021\/10\/e-4.png\" alt=\"instagram Ndls\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 26px; --smush-placeholder-aspect-ratio: 26\/26;\"><\/a>\n<\/div>\n<div class=\"one-half tableau-new_contact_form\">\n<!-- [contact-form-7 id=\"77\" title=\"contact\"] --> \n<iframe data-src=\"https:\/\/go.newdatalabs.com\/l\/1024551\/2024-03-27\/q5pf\" width=\"100%\" height=\"715\" type=\"text\/html\" frameborder=\"0\" allowtransparency=\"true\" style=\"border: 0\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe>  \n<\/div>\n<\/div> \n<\/section>\n","protected":false},"excerpt":{"rendered":"<p>Power Query Do you associate working with data with manually pasting and cleaning data in Excel? Are you wasting your valuable time organizing data from different sources? Or maybe you suspect that your Excel sheets are hiding a lot of valuable information, but you don&#8217;t know how to extract it and how long it will [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-1067","1":"page","2":"type-page","3":"status-publish","5":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power Query | NewDataLabS<\/title>\n<meta name=\"description\" content=\"Don&#039;t have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newdatalabs.com\/en\/power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query | NewDataLabS\" \/>\n<meta property=\"og:description\" content=\"Don&#039;t have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newdatalabs.com\/en\/power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"NewDataLabs\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-08T12:58:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/\",\"url\":\"https:\/\/newdatalabs.com\/en\/power-query\/\",\"name\":\"Power Query | NewDataLabS\",\"isPartOf\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg\",\"datePublished\":\"2022-01-11T08:23:09+00:00\",\"dateModified\":\"2024-04-08T12:58:48+00:00\",\"description\":\"Don't have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?\",\"breadcrumb\":{\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newdatalabs.com\/en\/power-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage\",\"url\":\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg\",\"contentUrl\":\"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newdatalabs.com\/en\/power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/newdatalabs.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newdatalabs.com\/en\/#website\",\"url\":\"https:\/\/newdatalabs.com\/en\/\",\"name\":\"NewDataLabs\",\"description\":\"Tableau - Business Intelligence Tools\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newdatalabs.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power Query | NewDataLabS","description":"Don't have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?","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:\/\/newdatalabs.com\/en\/power-query\/","og_locale":"en_US","og_type":"article","og_title":"Power Query | NewDataLabS","og_description":"Don't have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?","og_url":"https:\/\/newdatalabs.com\/en\/power-query\/","og_site_name":"NewDataLabs","article_modified_time":"2024-04-08T12:58:48+00:00","og_image":[{"url":"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/newdatalabs.com\/en\/power-query\/","url":"https:\/\/newdatalabs.com\/en\/power-query\/","name":"Power Query | NewDataLabS","isPartOf":{"@id":"https:\/\/newdatalabs.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage"},"image":{"@id":"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg","datePublished":"2022-01-11T08:23:09+00:00","dateModified":"2024-04-08T12:58:48+00:00","description":"Don't have time to learn Power Query technology from the beginning? Do you prefer to outsource the construction of ETL to specialists?","breadcrumb":{"@id":"https:\/\/newdatalabs.com\/en\/power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newdatalabs.com\/en\/power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newdatalabs.com\/en\/power-query\/#primaryimage","url":"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg","contentUrl":"https:\/\/newdatalabs.com\/wp-content\/uploads\/2021\/03\/p_1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/newdatalabs.com\/en\/power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/newdatalabs.com\/en\/"},{"@type":"ListItem","position":2,"name":"Power Query"}]},{"@type":"WebSite","@id":"https:\/\/newdatalabs.com\/en\/#website","url":"https:\/\/newdatalabs.com\/en\/","name":"NewDataLabs","description":"Tableau - Business Intelligence Tools","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newdatalabs.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/1067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/comments?post=1067"}],"version-history":[{"count":6,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/1067\/revisions"}],"predecessor-version":[{"id":3319,"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/pages\/1067\/revisions\/3319"}],"wp:attachment":[{"href":"https:\/\/newdatalabs.com\/en\/wp-json\/wp\/v2\/media?parent=1067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}