{"id":14707,"date":"2022-12-29T08:26:15","date_gmt":"2022-12-29T07:26:15","guid":{"rendered":"https:\/\/www.itta.net\/formations\/course_excel_powerquery\/"},"modified":"2026-05-07T10:13:52","modified_gmt":"2026-05-07T08:13:52","slug":"excel-powerquery","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/","title":{"rendered":"Excel &#8211; PowerQuery"},"content":{"rendered":"<p>The Power Query training introduces you to the ETL tool integrated in Excel that automates data collection, cleaning and transformation. Over a full day, you master the Power Query editor, common transformations, source combinations and automatic refresh. A strategic skill for data analysts and management controllers in French speaking Switzerland.<\/p>\n<p><strong>Automate data preparation and save hours on each refresh<\/strong><\/p>\n<p>For data analysts in French speaking Switzerland, Power Query has become a pivotal tool in daily work. This Power Query training focuses on hands on cases: multi-source import, automated cleaning, table merging, parameterizable queries.<\/p>\n","protected":false},"featured_media":41300,"parent":0,"menu_order":0,"template":"","editeurs":[1539,1537],"domaine":[1265,1269],"class_list":["post-14707","formations","type-formations","status-publish","has-post-thumbnail","hentry","editeurs-microsoft-excel-microsoft-office","editeurs-microsoft-office","domaine-office-automation","domaine-spreadsheet"],"acf":{"reference":"MOE-43","duree_nombre":1,"duree_unite":"jour","prix_virtuel":700,"prix_presentiel":750,"prix_blended":"","prix_elearning":"","views":1743,"niveau":["Expert"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":"","financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"Excel - Power Query Training","objectifs":"<ul>\n\t<li>Master the Power Query editor integrated in Excel<\/li>\n\t<li>Import data from CSV, Excel, databases and web<\/li>\n\t<li>Apply common transformations (filter, deduplicate, combine)<\/li>\n\t<li>Merge and concatenate multiple sources in a single query<\/li>\n\t<li>Build replayable and parameterizable Power Query queries<\/li>\n\t<li>Save considerable time on recurring data preparation<\/li>\n<\/ul>","connaissances":"<ul>\r\n<li>Master advanced Excel features<\/li>\r\n<li>Know pivot tables and formulas<\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n<li>Data analysts and management controllers<\/li>\r\n<li>Administrative and financial managers<\/li>\r\n<li>Project managers and consultants<\/li>\r\n<li>Professionals regularly handling large data volumes<\/li>\r\n<\/ul>","examen":"","documentation":"<ul>\r\n \t<li>Digital course material included<\/li>\r\n<\/ul>","lab__exercices":"<ul>\r\n<li>This course includes hands-on exercises designed to reinforce your knowledge and apply your skills in real-world professional scenarios.<\/li>\r\n<\/ul>","contenu_cours":"<strong>Module 1: Theory - relational databases<\/strong>\r\n<ul>\r\n \t<li>Dimension tables<\/li>\r\n \t<li>Fact Tables<\/li>\r\n \t<li>Relations between tables<\/li>\r\n \t<li>Primary Keys<\/li>\r\n \t<li>Secondary keys (Fremd Keys)<\/li>\r\n \t<li>Different types of data<\/li>\r\n \t<li>PowerQuery, display<\/li>\r\n \t<li>Excel data model<\/li>\r\n<\/ul>\r\n<strong>Module 2: PowerQuery<\/strong>\r\n<ul>\r\n \t<li>The PowerQuery Editor<\/li>\r\n \t<li>Importing data<\/li>\r\n \t<li>How and where to load data<\/li>\r\n \t<li>Edit the data<\/li>\r\n \t<li>Adding data<\/li>\r\n \t<li>Merging data<\/li>\r\n<\/ul>","cours_recommandes":[83831,14701,14698],"infos_additionnelles":"<h3>Power Query: the silent revolution of Excel for data analysts<\/h3>\n<p>Power Query is probably the most powerful Excel feature of the last ten years, yet the least known. Natively integrated in Excel since 2016, it turns the tool into a true ETL platform: connection to external sources, transformations recorded as a replayable pipeline, automatic refresh.<\/p>\n<h3>The Power Query editor and ETL logic<\/h3>\n<p>The training starts with hands on use of the Power Query editor integrated in Excel. You discover its logic: import a source, apply a sequence of recorded transformations, load the result in an Excel sheet or data model.<\/p>\n<h3>Importing data from any source<\/h3>\n<p>Power Query connects Excel to a multitude of sources: CSV and Excel files, entire folders, SQL databases, web services, SharePoint, JSON. The training details the most common imports.<\/p>\n<h3>Common transformations and source combinations<\/h3>\n<p>The heart of the training is mastering Power Query transformations. Filter rows, remove duplicates, split or merge columns, change data types, handle errors, unpivot or pivot.<\/p>\n<p>Merge and append are key operations: merge two tables on a common key (XLOOKUP equivalent on steroids), concatenate multiple similar tables (e.g. monthly sales of all branches) into one.<\/p>\n<h3>Parameterizable queries and automatic refresh<\/h3>\n<p>The training ends with creating parameterizable Power Query queries. You learn to expose a parameter that can be changed without touching the query logic.<\/p>\n<h3>Profiles in French speaking Switzerland who get the most<\/h3>\n<p>The Power Query training is designed for management controllers, analysts, data analysts, reporting managers and self employed professionals.<\/p>\n<h3>Practical Power Query training in Carouge and Le Flon<\/h3>\n<p>In ITTA premises in Carouge and Le Flon, this Power Query training runs over one day led by an expert instructor in a reduced group for personalized support.<\/p>\n<h3>FAQ Power Query training<\/h3>\n<p><strong>What is Power Query?<\/strong><\/p>\n<p>Power Query is an ETL tool integrated in Excel that automates import, transformation and loading of data.<\/p>\n<p><strong>Is Power Query included in Microsoft 365?<\/strong><\/p>\n<p>Yes, Power Query is included in Excel 365 and all Excel 2016+ versions.<\/p>\n<p><strong>Do I need to know SQL to use Power Query?<\/strong><\/p>\n<p>No, the graphical Power Query interface allows everything without coding.<\/p>\n<p><strong>What is the difference between Power Query and VBA?<\/strong><\/p>\n<p>VBA is a programming language to automate Excel. Power Query is a graphical ETL tool.<\/p>\n<p><strong>Is this training accessible from Lausanne?<\/strong><\/p>\n<p>Yes, at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.<\/p>\n<p><strong>How long to be comfortable with Power Query?<\/strong><\/p>\n<p>The basics are acquired in a structured day.<\/p>\n<p><strong>Which course should follow this Power Query training?<\/strong><\/p>\n<p>The Mastering M Language course to go far beyond the graphical interface.<\/p>\n<h3>Who this power query training is for<\/h3>\n<p>Analyst, controlling, BI, operations profiles needing to consolidate and prepare data from multiple sources (files, databases, web) for analysis. In Geneva and Lausanne, the course welcomes participants from international organizations, banking, consulting and growing SMEs. No specific prerequisite is required other than a concrete willingness to progress on the subject.<\/p>\n<h3>Concretely, what will you be able to do at the end<\/h3>\n<p>You leave with an operational mastery of the fundamentals, reusable canvases on your concrete cases, a structured action plan for the weeks that follow. Many participants report a visible effect from the first week back, with sustainable anchoring over four to six weeks of regular practice. The course combines short theory inputs, practical exercises on your real situations and personalized trainer debrief.<\/p>\n<h3>Concrete use cases in business<\/h3>\n<p>An analyst automatically consolidating 30 monthly Excel files into a clean dataset. A controller connecting Excel to a database and refreshing analyses in one click. An operational person transforming web data into exploitable dataset without code. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.<\/p>\n<h3>Articulation with other ITTA courses<\/h3>\n<p>This training combines well with Excel Pivot tables for analysis, Excel Dashboards for reporting, and M language to go further. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.<\/p>\n<h3>Why this training makes a difference in professional environment<\/h3>\n<p>PowerQuery has transformed Excel into a real data preparation platform, applicable in almost all analytical functions. Connection (200+ sources), transformation (300+ operations) and automation features rival specialized ETL tools. This training targets profiles wanting to professionalize their data preparation.<\/p>\n\n<h3>Sustained anchoring after the course<\/h3>\n<p>Most participants report a noticeable effect from the first week of return, with deeper anchoring over four to six weeks of regular practice on real files. The course closes with a personalized practice plan calibrated on your professional context, including milestones and review prompts to ensure the techniques become permanent rather than fading after a few weeks.<\/p>\n<h3>ITTA pedagogy oriented towards practice in Geneva and Lausanne<\/h3>\n<p>At ITTA centers in Geneva and Lausanne, this course runs in a small group with an expert trainer and a format alternating concise theory, practical exercises and personalized debrief. Group confidentiality is explicit and held. Each participant arrives with a real case and leaves with an action plan calibrated to their context. The course integrates recent evolutions of the domain (digital tools, hybrid formats, 2025-2026 practices) without losing focus on fundamentals.<\/p>\n<p><strong>Does PowerQuery replace Power BI?<\/strong><\/p>\n<p>No, complementary: PowerQuery prepares data, Power BI visualizes and shares.<\/p>\n<p><strong>Need to know M to use PowerQuery?<\/strong><\/p>\n<p>No, graphical interface covers 80% of cases.<\/p>\n<p><strong>Suitable for beginner analysts?<\/strong><\/p>\n<p>Yes, the course lays PowerQuery fundamentals.<\/p>\n<p><strong>Where do sessions take place?<\/strong><\/p>\n<p>ITTA has three centers in French speaking Switzerland: in Geneva (Carouge, Route des Jeunes 35), in Lausanne at the Flon (Rue des Cotes de Montbenon 16) and at Lausanne Mon-Repos (Avenue de Mon-repos 24). The training is also available in virtual classroom.<\/p>","inclus_dans_ce_cours_virtuel":"<ul>\r\n \t<li>Training provided by an expert trainer<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement Badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_presentiel":"<ul>\r\n \t<li>Training provided by an expert trainer<\/li>\r\n \t<li>Documentation in digital format<\/li>\r\n \t<li>Achievement Badge<\/li>\r\n<\/ul>","inclus_dans_ce_cours_blended":"","inclus_dans_ce_cours_elearning":"","inclus_dans_ce_cours_surmesure":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel - Power Query Training - ITTA<\/title>\n<meta name=\"description\" content=\"Power Query training in Geneva and Lausanne. 1 day to master Excel ETL, transformations and automation at ITTA Switzerland.\" \/>\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.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/\",\"name\":\"Excel - Power Query Training - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Microsoft_Excel-Logo.wine_.png\",\"datePublished\":\"2022-12-29T07:26:15+00:00\",\"dateModified\":\"2026-05-07T08:13:52+00:00\",\"description\":\"Power Query training in Geneva and Lausanne. 1 day to master Excel ETL, transformations and automation at ITTA Switzerland.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Microsoft_Excel-Logo.wine_.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/Microsoft_Excel-Logo.wine_.png\",\"width\":2048,\"height\":1365,\"caption\":\"Microsoft Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerquery\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office Automation\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Spreadsheet\",\"item\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Excel &#8211; PowerQuery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"name\":\"ITTA\",\"description\":\"Formations &amp; Certifications en Suisse Romande\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itta.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Organization\",\"EducationalOrganization\"],\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#organization\",\"name\":\"ITTA\",\"alternateName\":\"IT TRAINING ACADEMY SA\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"contentUrl\":\"https:\\\/\\\/www.itta.net\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/Logo-transparent.png\",\"width\":1500,\"height\":623,\"caption\":\"ITTA\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/ITTA\\\/100063747262936\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/1001738\",\"https:\\\/\\\/www.instagram.com\\\/itta_suisse\\\/\"],\"contactPoint\":{\"@type\":\"ContactPoint\",\"telephone\":\"+41 58 307 73 00\",\"contactType\":\"customer service\",\"availableLanguage\":[\"French\",\"English\"],\"areaServed\":[{\"@type\":\"Country\",\"name\":\"Switzerland\"},{\"@type\":\"Country\",\"name\":\"France\"}]},\"location\":[{\"@type\":\"Place\",\"name\":\"ITTA Geneve\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Route des Jeunes 35\",\"addressLocality\":\"Carouge\",\"postalCode\":\"1227\",\"addressRegion\":\"GE\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.18274,\"longitude\":6.12922}},{\"@type\":\"Place\",\"name\":\"ITTA Lausanne\",\"address\":{\"@type\":\"PostalAddress\",\"streetAddress\":\"Rue des Cotes-de-Montbenon 16\",\"addressLocality\":\"Lausanne\",\"postalCode\":\"1003\",\"addressRegion\":\"VD\",\"addressCountry\":\"CH\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":46.52111,\"longitude\":6.62734}}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel - Power Query Training - ITTA","description":"Power Query training in Geneva and Lausanne. 1 day to master Excel ETL, transformations and automation at ITTA Switzerland.","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.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/","name":"Excel - Power Query Training - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/#primaryimage"},"image":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/Microsoft_Excel-Logo.wine_.png","datePublished":"2022-12-29T07:26:15+00:00","dateModified":"2026-05-07T08:13:52+00:00","description":"Power Query training in Geneva and Lausanne. 1 day to master Excel ETL, transformations and automation at ITTA Switzerland.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/#primaryimage","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/Microsoft_Excel-Logo.wine_.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2022\/12\/Microsoft_Excel-Logo.wine_.png","width":2048,"height":1365,"caption":"Microsoft Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itta.net\/en\/"},{"@type":"ListItem","position":2,"name":"Office Automation","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/"},{"@type":"ListItem","position":3,"name":"Spreadsheet","item":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/"},{"@type":"ListItem","position":4,"name":"Excel &#8211; PowerQuery"}]},{"@type":"WebSite","@id":"https:\/\/www.itta.net\/en\/#website","url":"https:\/\/www.itta.net\/en\/","name":"ITTA","description":"Formations &amp; Certifications en Suisse Romande","publisher":{"@id":"https:\/\/www.itta.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itta.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Organization","EducationalOrganization"],"@id":"https:\/\/www.itta.net\/en\/#organization","name":"ITTA","alternateName":"IT TRAINING ACADEMY SA","url":"https:\/\/www.itta.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","contentUrl":"https:\/\/www.itta.net\/wp-content\/uploads\/2023\/02\/Logo-transparent.png","width":1500,"height":623,"caption":"ITTA"},"image":{"@id":"https:\/\/www.itta.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/ITTA\/100063747262936\/","https:\/\/www.linkedin.com\/company\/1001738","https:\/\/www.instagram.com\/itta_suisse\/"],"contactPoint":{"@type":"ContactPoint","telephone":"+41 58 307 73 00","contactType":"customer service","availableLanguage":["French","English"],"areaServed":[{"@type":"Country","name":"Switzerland"},{"@type":"Country","name":"France"}]},"location":[{"@type":"Place","name":"ITTA Geneve","address":{"@type":"PostalAddress","streetAddress":"Route des Jeunes 35","addressLocality":"Carouge","postalCode":"1227","addressRegion":"GE","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.18274,"longitude":6.12922}},{"@type":"Place","name":"ITTA Lausanne","address":{"@type":"PostalAddress","streetAddress":"Rue des Cotes-de-Montbenon 16","addressLocality":"Lausanne","postalCode":"1003","addressRegion":"VD","addressCountry":"CH"},"geo":{"@type":"GeoCoordinates","latitude":46.52111,"longitude":6.62734}}]}]}},"_links":{"self":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations"}],"about":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/types\/formations"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14698"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14701"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/83831"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media\/41300"}],"wp:attachment":[{"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/media?parent=14707"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14707"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}