{"id":2824,"date":"2022-03-17T13:47:45","date_gmt":"2022-03-17T12:47:45","guid":{"rendered":"https:\/\/republify.se\/?post_type=product&#038;p=2824"},"modified":"2025-11-21T08:40:04","modified_gmt":"2025-11-21T07:40:04","slug":"data-cleansing-with-power-bi","status":"publish","type":"product","link":"https:\/\/republify.se\/index.php\/produkt\/data-cleansing-with-power-bi\/","title":{"rendered":"Data Cleansing with Power BI"},"content":{"rendered":"<p><strong>Audience<\/strong><\/p>\n<p>This training is targeted for Data professionals such as data Stewards, or Power users that are looking to design their own Power BI solutions. In other words, this course will take the Self- Service-Business- Intelligence (SSBI) concept to its edge.<\/p>\n<p><strong>Prerequisites<\/strong><\/p>\n<ul>\n<li>Knowledge of how to create content using Power BI Desktop.<\/li>\n<li>Basic understanding of data warehouse schemas and ETL\/ELT operations<\/li>\n<\/ul>\n<p><strong>Course Topics<\/strong><\/p>\n<ul>\n<li>What is Power Query<\/li>\n<li>How Power BI Handles your Data<\/li>\n<li>Query Editor Best Practices<\/li>\n<li>Preparing Data<\/li>\n<li>Shape and Clean your Data<\/li>\n<li>Understanding Errors<\/li>\n<li>Understanding Parameters<\/li>\n<li>Understanding Template Files<\/li>\n<li>Getting Data<\/li>\n<li>Keeping data current in Power BI<\/li>\n<li>Integration with Various Azure Services<\/li>\n<li>Text Transformations<\/li>\n<li>Numeric Transformations<\/li>\n<li>Structured Column Transformations<\/li>\n<li>Add Column Transformations<\/li>\n<li>Error Handling<\/li>\n<li>Date and Time Transformations<\/li>\n<li>Understanding M Code<\/li>\n<li>Introducing the Power Query M Formula Language<\/li>\n<li>Working with M Data Structures<\/li>\n<li>Advanced M Scripting<\/li>\n<li>Dynamic Parameters in Power Query<\/li>\n<li>Introducing Functions Main Concepts<\/li>\n<li>Using Power Query Functions<\/li>\n<li>Creating Custom Functions<\/li>\n<li>Creating Parameterized Functions<\/li>\n<li>Designing with Function Queries<\/li>\n<li>Performance Tips and Tricks for Power Query<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Kursen levereras i samarbete med<\/h3>\n<p><img decoding=\"async\" class=\"alignnone size-medium wp-image-2815 lazyload\" data-src=\"https:\/\/republify.se\/wp-content\/uploads\/2022\/03\/LMC-300x68.jpg\" alt=\"\" width=\"300\" height=\"68\" data-srcset=\"https:\/\/republify.se\/wp-content\/uploads\/2022\/03\/LMC-300x68.jpg 300w, https:\/\/republify.se\/wp-content\/uploads\/2022\/03\/LMC-768x174.jpg 768w, https:\/\/republify.se\/wp-content\/uploads\/2022\/03\/LMC-600x136.jpg 600w, https:\/\/republify.se\/wp-content\/uploads\/2022\/03\/LMC.jpg 773w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/68;\" \/><\/p>\n<h2>Kontakta oss om denna kurs<\/h2>\n<div data-test='contact-form'\n\t\t\tid='contact-form-2824'\n\t\t\tclass='jetpack-contact-form-container '\n\t\t\tdata-wp-interactive='jetpack\/form' data-wp-context='{\"formId\":\"2824\",\"formHash\":\"ccdf5118499c8ad563d1cc2df0a7380b641d99e0\",\"showErrors\":false,\"errors\":[],\"fields\":[],\"isMultiStep\":false,\"useAjax\":true,\"submissionData\":null,\"formattedSubmissionData\":[],\"submissionSuccess\":false,\"submissionError\":null,\"elementId\":\"jp-form-ccdf5118499c8ad563d1cc2df0a7380b641d99e0\",\"isSingleInputForm\":false,\"isForcedHorizontal\":false}'\n\t\t\tdata-wp-watch--scroll-to-wrapper=\"callbacks.scrollToWrapper\"\n\t\t>\n<div class=\"contact-form-submission contact-form-ajax-submission\" data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" data-wp-class--submission-success=\"context.submissionSuccess\" id=\"contact-form-success-ccdf5118499c8ad563d1cc2df0a7380b641d99e0\" tabindex=\"-1\" aria-labelledby=\"contact-form-success-header-ccdf5118499c8ad563d1cc2df0a7380b641d99e0\"><p class=\"go-back-message\"><a class=\"link\" role=\"button\" tabindex=\"0\" data-wp-on--click=\"actions.goBack\" href=\"\/index.php\/wp-json\/wp\/v2\/product\/2824\">\u2190 Tillbaka<\/a><\/p><h4 data-wp-bind--aria-hidden=\"state.isSuccessMessageAriaHidden\" id=\"contact-form-success-header-ccdf5118499c8ad563d1cc2df0a7380b641d99e0\">Tack f\u00f6r din respons. \u2728<\/h4>\n\n<template data-wp-each--submission=\"context.formattedSubmissionData\">\n\t\t\t\t\t<div class=\"jetpack_forms_contact-form-success-summary\">\n\t\t\t\t\t\t<div class=\"field-name-wrapper\">\n\t\t\t\t\t\t\t<div class=\"field-type-icon\" data-wp-watch=\"callbacks.watchFieldTypeIcon\"><\/div>\n\t\t\t\t\t\t\t<div class=\"field-name\" data-wp-text=\"context.submission.label\" data-wp-bind--hidden=\"!context.submission.label\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-value\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.showPlainValue\"><\/div>\n\t\t\t\t\t\t<a class=\"field-url\" data-wp-bind--href=\"context.submission.url\" data-wp-text=\"context.submission.value\" data-wp-bind--hidden=\"!context.submission.url\" target=\"_blank\" rel=\"noopener noreferrer\"><\/a>\n\t\t\t\t\t\t<div class=\"field-rating\" data-wp-bind--hidden=\"!context.submission.rating\" data-wp-watch=\"callbacks.watchRatingIcons\"><\/div>\n\t\t\t\t\t\t<div class=\"field-images\" data-wp-bind--hidden=\"!context.submission.images\">\n\t\t\t\t\t\t\t<template data-wp-each--image=\"context.submission.images\">\n\t\t\t\t\t\t\t\t<div class=\"field-image-option\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t<figure class=\"field-image-option__image\" data-wp-class--is-empty=\"!context.image.src\">\n\t\t\t\t\t\t\t\t\t\t<img data-wp-bind--src=\"context.image.src\" data-wp-bind--hidden=\"!context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODlhAQABAAD\/ACwAAAAAAQABAAACADs=\" data-wp-bind--hidden=\"context.image.src\" \/>\n\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<div class=\"field-image-option__label-wrapper\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label-code\" data-wp-text=\"context.image.letterCode\"><\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"field-image-option__label\" data-wp-text=\"context.image.label\" data-wp-bind--hidden=\"!context.image.label\"><\/span>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"field-files\" data-wp-bind--hidden=\"!context.submission.files\">\n\t\t\t\t\t\t\t<template data-wp-each--file=\"context.submission.files\">\n\t\t\t\t\t\t\t\t<div class=\"field-file\">\n\t\t\t\t\t\t\t\t\t<div class=\"field-file__thumbnail\" data-wp-style--background-image=\"context.file.previewUrl\" data-wp-style--mask-image=\"context.file.iconUrl\" data-wp-bind--hidden=\"!context.file.hasPreview\"><\/div>\n\t\t\t\t\t\t\t\t\t<svg class=\"field-file__icon\" data-wp-bind--hidden=\"context.file.hasPreview\" width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t<path d=\"M14 2H6C4.9 2 4 2.9 4 4V20C4 21.1 4.89 22 5.99 22H18C19.1 22 20 21.1 20 20V8L14 2ZM18 20H6V4H13V9H18V20Z\" fill=\"currentColor\"\/>\n\t\t\t\t\t\t\t\t\t<\/svg>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__name\" data-wp-text=\"context.file.name\"><\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"field-file__size\" data-wp-text=\"context.file.size\"><\/span>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/template>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/template><\/div><form action='https:\/\/republify.se\/index.php\/produkt\/data-cleansing-with-power-bi\/'\n\t\t\t\tid='jp-form-ccdf5118499c8ad563d1cc2df0a7380b641d99e0'\n\t\t\t\tmethod='post'\n\t\t\t\tclass='contact-form commentsblock jetpack-contact-form__form has-no-jetpack-form-layout' aria-label=\"Data Cleansing with Power BI\"\n\t\t\t\tdata-wp-on--submit=\"actions.onFormSubmit\"\n\t\t\t\tdata-wp-on--reset=\"actions.onFormReset\"\n\t\t\t\tdata-wp-class--submission-success=\"context.submissionSuccess\"\n\t\t\t\tdata-wp-class--is-first-step=\"state.isFirstStep\"\n\t\t\t\tdata-wp-class--is-last-step=\"state.isLastStep\"\n\t\t\t\tdata-wp-class--is-ajax-form=\"context.useAjax\"\n\t\t\t\tnovalidate >\n<input type='hidden' name='jetpack_contact_form_jwt' value='eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJlbmNyeXB0ZWRfYXR0cmlidXRlcyI6IldkNkcyLzdQbENCcTY4aTR0K0ptajZ6alY5dmI1cjdrQUs3VzlPTHRGcEhKZVZiUHQzbk9rM2liWUJkTXZWZmZkS2tvV1dSeWxDb05seVdqWkgxSzF2ZC9yNVdmeGsvQ1RlL0lSQmlhSWN3RC9OUlFxNFo0TWEvRFNGTzBqZnhudlVpaW1IWTF3Tnczc2JuNng4SVBsVmgxKzlqb3M5amZtZ2dCMXdQWEJxRWFYTjRNZXVlUW0zb1dTUDR6MEx5cmFWWE9QNHlGOFVvdWNuNC8rSktMUnRSd0t4dVZEbHliclhEeEllcFcwakdWdlUybmt0R0cwbDZmQWMrRmc5SWF0b1U1YndTZTlFMUhzMHRKQW9hMzhpOGl0YmJIZnlpeXNpTWRpUWI4UWV6WUxTYXNGMXdXNW01a1NjT2I3YktVQnZsRVlKK2h2L3o3bjFCcWtOMDRVeTlkekRSVVNvYUYzaG5kdWpqN1hyb3F5WXFIdExMZU1IUFhiR0Rwd1lhTFRNb29nTmV1TWhsTzhTZEtuYURSc2xRMGFjU2UvZmh5NEl6UDJZTGt2cXMzb3J6em52MlB5b2c3dUZwM055eW1ZRUl4VEE1aHpkalF0Q0dnL2RsbjdoOUxGdlJWcktMQ1laOFplaUVGSGF0VDZkWTBXWVlaNzJ5WHJIbGF2UFZSTWhBbk9JeTdTRUZjSFQyaUkrNkFNaE9lZUU4ZU9CN1IyWXRWQ2w0eThHVTg5c0NRbEsrZ2RvVURmY1V6Yi9FclQvM2x5NkxTTXIwUkQ0aHZGZ3gyRU5HNUExSTJvcmtja1pPaUpRb0NJZTk4d1BxaXVkS2pGVVFVZUJLSFMyQ2NOWWFONi9lajhzSHJDdkRWanpabkFiWHRkS0duN1dLYVRjSGtXS2kzNEhRbGFNMFQxMXB1bjNVekozTDhrOGJDVXFFVnE3QzlCN1pIRm9sTEN6Uy9ZbWw0eWthT1FhNkZjM0NsVlU3L2FZa3l3bHF2MzRiUUQxU3JKalc1b3JRRUFzVFVUdlVZc0JlRFFHTTBseVlsSU5EdHZGbnd0c0w2UjRXVGFkQlZkRlNpblpCN3luSWt4QjBYZ094Mk5FMmlGQWJRN09QVHlTcVU2OHErV0ZDc0RLRTFDMTc2S2oySTJQc3FSYk1RVlZ6V3NXSGxUb3JTWHp4Vjg3RmNmbkF4NEpsdWZCck9BMXJ1LzIxRlF1eWZJeGNGV0E9PSIsImNvbnRlbnQiOiJbY29udGFjdC1maWVsZCBsYWJlbD1cIk5hbW5cIiB0eXBlPVwibmFtZVwiIHJlcXVpcmVkPVwiMVwiXVtjb250YWN0LWZpZWxkIGxhYmVsPVwiRS1wb3N0XCIgdHlwZT1cImVtYWlsXCIgcmVxdWlyZWQ9XCIxXCJdW2NvbnRhY3QtZmllbGQgbGFiZWw9XCJNZWRkZWxhbmRlXCIgdHlwZT1cInRleHRhcmVhXCJdIiwiaGFzaCI6ImNjZGY1MTE4NDk5YzhhZDU2M2QxY2MyZGYwYTczODBiNjQxZDk5ZTAiLCJzb3VyY2UiOnsiZW50cnlfdGl0bGUiOiJEYXRhIENsZWFuc2luZyB3aXRoIFBvd2VyIEJJIiwiZW50cnlfcGFnZSI6MSwic291cmNlX2lkIjoyODI0LCJzb3VyY2VfdHlwZSI6InNpbmdsZSIsInJlcXVlc3RfdXJsIjoiaHR0cHM6Ly9yZXB1YmxpZnkuc2Uvd3AtanNvbi93cC92Mi9wcm9kdWN0LzI4MjQifSwidmVyc2lvbiI6MiwiY2lwaGVyIjoiYWVzLTI1Ni1nY20ifQ.zi-OIB1hj115l5VIFglBqxGgHsUDqkRKTffNUMTHCdU' \/>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g2824-namn\",\"fieldType\":\"name\",\"fieldLabel\":\"Namn\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"ccdf5118499c8ad563d1cc2df0a7380b641d99e0\"}'  class='grunion-field-name-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g2824-namn' class=\"grunion-field-label name\" >Namn<span class=\"grunion-label-required\" aria-hidden=\"true\">(obligatoriskt)<\/span><\/label>\n<input\n\t\t\t\t\ttype='text'\n\t\t\t\t\tname='g2824-namn'\n\t\t\t\t\tid='g2824-namn'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g2824-namn-text-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='name  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g2824-namn-text-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g2824-namn-text-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g2824-epost\",\"fieldType\":\"email\",\"fieldLabel\":\"E-post\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"1\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"ccdf5118499c8ad563d1cc2df0a7380b641d99e0\"}'  class='grunion-field-email-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='g2824-epost' class=\"grunion-field-label email\" >E-post<span class=\"grunion-label-required\" aria-hidden=\"true\">(obligatoriskt)<\/span><\/label>\n<input\n\t\t\t\t\ttype='email'\n\t\t\t\t\tname='g2824-epost'\n\t\t\t\t\tid='g2824-epost'\n\t\t\t\t\tvalue=''\n\n\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\tdata-wp-bind--value='state.getFieldValue'\n\t\t\t\t\taria-describedby='g2824-epost-email-error-message'\n\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\n\t\t\t\t\tclass='email  grunion-field' \n\t\t\t\t\trequired='true' aria-required='true'  \/>\n \n\t\t\t<div id=\"g2824-epost-email-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g2824-epost-email-error-message\"><\/span>\n\t\t\t<\/div> \n\t<\/div>\n\n<div style=\"\"  data-wp-interactive=\"jetpack\/form\" data-wp-context='{\"fieldId\":\"g2824-meddelande\",\"fieldType\":\"textarea\",\"fieldLabel\":\"Meddelande\",\"fieldValue\":\"\",\"fieldPlaceholder\":\"\",\"fieldIsRequired\":\"\",\"fieldErrorMessage\":\"\",\"fieldExtra\":[],\"formHash\":\"ccdf5118499c8ad563d1cc2df0a7380b641d99e0\"}'  class='grunion-field-textarea-wrap grunion-field-wrap'  data-wp-init='callbacks.initializeField' data-wp-on--jetpack-form-reset='callbacks.initializeField' >\n<label\n\t\t\t\tfor='contact-form-comment-g2824-meddelande' class=\"grunion-field-label textarea\" >Meddelande<\/label>\n<textarea\n\t\t                style=''\n\t\t                name='g2824-meddelande'\n\t\t                id='contact-form-comment-g2824-meddelande'\n\t\t                rows='20'\n\t\t\t\t\t\tdata-wp-text='state.getFieldValue'\n\t\t\t\t\t\tdata-wp-on--input='actions.onFieldChange'\n\t\t\t\t\t\tdata-wp-on--blur='actions.onFieldBlur'\n\t\t\t\t\t\tdata-wp-class--has-value='state.hasFieldValue'\n\t\t\t\t\t\taria-describedby='g2824-meddelande-textarea-error-message'\n\t\t\t\t\t\tdata-wp-bind--aria-invalid='state.fieldAriaInvalid'\n\t\t\t\t\t\tclass='textarea  grunion-field'  ><\/textarea>\n \n\t\t\t<div id=\"g2824-meddelande-textarea-error\" class=\"contact-form__input-error\" data-wp-class--has-errors=\"state.fieldHasErrors\">\n\t\t\t\t<span class=\"contact-form__warning-icon\" aria-hidden=\"true\">\n\t\t\t\t\t<svg width=\"16\" height=\"16\" viewBox=\"0 0 16 16\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\n\t\t\t\t\t\t<path d=\"M8.50015 11.6402H7.50015V10.6402H8.50015V11.6402Z\" \/>\n\t\t\t\t\t\t<path d=\"M7.50015 9.64018H8.50015V6.30684H7.50015V9.64018Z\" \/>\n\t\t\t\t\t\t<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M6.98331 3.0947C7.42933 2.30177 8.57096 2.30177 9.01698 3.09469L13.8771 11.7349C14.3145 12.5126 13.7525 13.4735 12.8602 13.4735H3.14004C2.24774 13.4735 1.68575 12.5126 2.12321 11.7349L6.98331 3.0947ZM8.14541 3.58496C8.08169 3.47168 7.9186 3.47168 7.85488 3.58496L2.99478 12.2251C2.93229 12.3362 3.01257 12.4735 3.14004 12.4735H12.8602C12.9877 12.4735 13.068 12.3362 13.0055 12.2251L8.14541 3.58496Z\" \/>\n\t\t\t\t\t<\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span data-wp-text=\"state.errorMessage\" id=\"g2824-meddelande-textarea-error-message\"><\/span>\n\t\t\t<\/div>\n\t<\/div>\n\t<p class='contact-submit'>\n<div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showFormErrors\"><span class=\"contact-form__warning-icon\" aria-hidden=\"true\"><i><\/i><\/span><span class=\"contact-form__error-message\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnValidationError\" data-wp-text=\"state.getFormErrorMessage\"><\/span><ul aria-label=\"Formul\u00e4rfel\">\n\t\t\t\t<template data-wp-each=\"state.getErrorList\" data-wp-key=\"context.item.id\">\n\t\t\t\t\t<li><a data-wp-bind--href=\"context.item.anchor\" data-wp-on--click=\"actions.scrollIntoView\" data-wp-text=\"context.item.label\"><\/a><\/li>\n\t\t\t\t<\/template>\n\t\t\t\t<\/ul><\/div><div class=\"contact-form__error\" data-wp-class--show-errors=\"state.showSubmissionError\" data-wp-text=\"context.submissionError\" tabindex=\"-1\" data-wp-watch=\"callbacks.focusOnSubmissionError\"><\/div>\t\t<button type='submit' class='pushbutton-wide'>Skicka<\/button>\t\t<input type='hidden' name='contact-form-id' value='2824' \/>\n\t\t<input type='hidden' name='action' value='grunion-contact-form' \/>\n\t\t<input type='hidden' name='contact-form-hash' value='ccdf5118499c8ad563d1cc2df0a7380b641d99e0' \/>\n\t<\/p>\n<\/form>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p><strong>This training is designed for data engineers, data wranglers, developers or data transformers, who need to transform raw data coming from one or more data sources and to make it ready for further modeling and analytics. In this training, you will learn all you need to know about Power Query from zero to hero. You will learn about table transformations and column transformations as well as optimizing techniques. <\/strong><\/p>\n<p>You will also learn to use M (Power Query Formula Language) to create custom functions and many other advanced level features such as dynamic<br \/>\nparameters. In short, this course will give you the skills needed to transform raw data into good quality data to be used for analytics.<\/p>\n","protected":false},"featured_media":2818,"comment_status":"open","ping_status":"closed","template":"","meta":{"wds_primary_product_brand":0,"wds_primary_product_cat":0},"product_brand":[],"product_cat":[30,90,43,54,29],"product_tag":[],"class_list":{"0":"post-2824","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-business","7":"product_cat-business-intelligence","8":"product_cat-microsoft","9":"product_cat-powerbi","10":"product_cat-technical","12":"first","13":"instock","14":"taxable","15":"shipping-taxable","16":"purchasable","17":"product-type-simple"},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product\/2824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/comments?post=2824"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media\/2818"}],"wp:attachment":[{"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/media?parent=2824"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_brand?post=2824"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_cat?post=2824"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/republify.se\/index.php\/wp-json\/wp\/v2\/product_tag?post=2824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}