{"id":14708,"date":"2022-12-29T08:26:15","date_gmt":"2022-12-29T07:26:15","guid":{"rendered":"https:\/\/www.itta.net\/formations\/course_excel_powerpivot\/"},"modified":"2025-11-13T11:04:00","modified_gmt":"2025-11-13T10:04:00","slug":"excel-powerpivot","status":"publish","type":"formations","link":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/","title":{"rendered":"Excel &#8211; PowerPivot"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Excel data analysis quickly reaches its limits when facing large volumes. PowerPivot changes the game. This powerful tool allows you to manipulate millions of rows without slowdown. You can create dynamic and professional reports in just a few clicks.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-transform-your-data-into-high-performance-reports-with-powerpivot\">Transform your data into high-performance reports with PowerPivot<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This training teaches you the essential PowerPivot techniques. You learn to connect different external data sources. Access databases, CSV or Excel files integrate easily into your analyses. The PowerPivot add-in becomes your ally for managing complex information.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The DAX language represents the core of PowerPivot. You master its expressions to calculate relevant indicators. KPIs allow you to track your performance in real time. Each DAX function provides an answer to your specific analytical needs.<\/p>\n","protected":false},"featured_media":41300,"parent":0,"menu_order":0,"template":"","editeurs":[1539,1537],"domaine":[1265,1269],"class_list":["post-14708","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-44","duree_nombre":2,"duree_unite":"jour","prix_virtuel":1200,"prix_presentiel":1300,"prix_blended":"","prix_elearning":"","views":1844,"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":"Formation PowerPivot - Excel ","objectifs":"<ul>\r\n \t<li>Installer et configurer le compl\u00e9ment PowerPivot dans Excel<\/li>\r\n \t<li>Connecter et importer des donn\u00e9es depuis sources externes multiples<\/li>\r\n \t<li>Cr\u00e9er des tableaux crois\u00e9s dynamiques PowerPivot performants<\/li>\r\n \t<li>D\u00e9velopper des champs calcul\u00e9s avec le langage DAX<\/li>\r\n \t<li>Concevoir et param\u00e9trer des indicateurs de performance KPI<\/li>\r\n \t<li>Utiliser les fonctions DAX avanc\u00e9es pour analyses complexes<\/li>\r\n \t<li>G\u00e9n\u00e9rer des rapports format\u00e9s et graphiques crois\u00e9s dynamiques<\/li>\r\n<\/ul>","connaissances":"<ul>\r\n \t<li>General Excel and Report building skills<\/li>\r\n \t<li>To have the equivalent knowledge or to have followed the trainings: <a href=\"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-preparing-for-data-analysis\/\">Excel - Preparing for data analysis<\/a> and <a href=\"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-analyze-your-data\/\">Excel - Analyze your data<\/a><\/li>\r\n<\/ul>","profils_participants":"<ul>\r\n \t<li>Excel users with an advanced level<\/li>\r\n \t<li>Data analysts and management controllers<\/li>\r\n \t<li>Reporting and business intelligence managers<\/li>\r\n \t<li>Project managers requiring dashboards<\/li>\r\n \t<li>Consultants and business experts handling data<\/li>\r\n \t<li>Managers wanting to analyze their performance<\/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 provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.<\/li>\r\n\r\n<\/ul>","contenu_cours":"<strong>Module 1: Introduction to PowerPivot\u00a0<\/strong>\r\n<ul>\r\n \t<li>Adding the PowerPivot Add-In to Excel<\/li>\r\n \t<li>Introduction to PowerPivot<\/li>\r\n<\/ul>\r\n<strong>Module 2: PowerPivot Data Sources\u00a0<\/strong>\r\n<ul>\r\n \t<li>Importing Excel and Access files<\/li>\r\n \t<li>Importing CSV files<\/li>\r\n<\/ul>\r\n<strong>Module 3: Creating Reports with PowerPivot\u00a0<\/strong>\r\n<ul>\r\n \t<li>Creating Pivot Tables<\/li>\r\n \t<li>Modifying the Pivot Table Structure<\/li>\r\n \t<li>Setting up row, column, page and data fields<\/li>\r\n \t<li>Creating grouping criteria<\/li>\r\n \t<li>Creating calculated fields<\/li>\r\n \t<li>Automatic sorting and filtering<\/li>\r\n \t<li>Using segments<\/li>\r\n \t<li>Formatting the pivot table<\/li>\r\n \t<li>Pivot charts<\/li>\r\n<\/ul>\r\n<strong>Module 4: Performance Indicators (KPI)\u00a0<\/strong>\r\n<ul>\r\n \t<li>Creating a calculated field<\/li>\r\n \t<li>Creating a KPI<\/li>\r\n \t<li>Modifying a KPI<\/li>\r\n \t<li>Use in pivot tables<\/li>\r\n<\/ul>\r\n<strong>Module 5: Advanced DAX functions<\/strong>\r\n<ul>\r\n \t<li>Using DATE and TIME functions<\/li>\r\n \t<li>Using STATISTICAL functions<\/li>\r\n \t<li>Using VALUE functions<\/li>\r\n \t<li>Using LOGICAL and INFORMATION functions<\/li>\r\n \t<li>Using TEXT functions<\/li>\r\n<\/ul>","cours_recommandes":[14698,14695],"infos_additionnelles":"<h3>The evolution of decision-making analysis with PowerPivot<\/h3>\r\nThe professional world generates exponential data volumes each year. Traditional methods quickly show their limits when facing this growth. PowerPivot responds precisely to this modern challenge. This technology transforms Excel into a true decision-making analysis platform.\r\n\r\nCompanies invest massively in Business Intelligence. However, complex solutions often remain inaccessible to operational teams. PowerPivot bridges this technological gap. Each employee becomes autonomous in their analyses without depending on the IT department.\r\n\r\nData compression constitutes a major technical advantage. Microsoft PowerPivot stores information in an optimized manner. A file of several gigabytes reduces to a few megabytes. Performance remains fluid even with substantial datasets.\r\n\r\n<h3>Understanding the relational logic of data models<\/h3>\r\nPowerPivot's strength lies in its ability to link tables. This relational approach avoids information duplication. You build a coherent model where each element finds its logical place.\r\n\r\nPrimary and foreign keys structure your relationships between tables. This concept borrowed from databases guarantees referential integrity. Your analyses gain in reliability and relevance. Consolidation errors disappear naturally.\r\n\r\nCreating business dimensions facilitates data organization. You separate measurable facts from descriptive attributes. This star architecture simplifies navigation in your models. End users intuitively understand the proposed structure.\r\n\r\n<h3>Intelligently exploiting DAX calculation contexts<\/h3>\r\nThe DAX language relies on two fundamental contexts. Row context evaluates formulas record by record. Filter context applies restrictions on calculated data. Understanding this distinction considerably improves your results.\r\n\r\nDAX aggregation functions differ from classic Excel functions. SUMX traverses tables row by row before adding. This iterative approach offers incomparable flexibility. You perform calculations impossible with traditional formulas.\r\n\r\nAutomatic filter propagation between tables constitutes a powerful mechanism. Your slicers act simultaneously on multiple dimensions. The user experience becomes intuitive and consistent. Multidimensional analyses truly become democratized.\r\n\r\n<h3>Optimizing the performance of your PowerPivot Excel models<\/h3>\r\nModel design directly influences response times. Calculated columns consume memory permanently. Measures are calculated on demand according to needs. This architectural choice significantly impacts overall performance.\r\n\r\nSorting columns by cardinality improves compression. PowerPivot uses sophisticated algorithms to optimize storage. You gain speed without sacrificing data richness. Good modeling practices make the difference.\r\n\r\nRemoving unnecessary columns considerably lightens files. Each piece of information kept must serve the final analysis. This design discipline guarantees optimal performance. Your colleagues appreciate the responsiveness of shared reports.\r\n\r\n<h3>Integrating PowerPivot into your existing business processes<\/h3>\r\nAutomatic data refresh transforms your reports into living tools. You schedule refreshes according to your operational rhythm. Decisions always rely on the most recent information. Confidence in the numbers naturally increases.\r\n\r\nReport standardization facilitates communication between departments. You create reusable templates for the entire organization. Analysis consistency becomes a concrete reality. Interdepartmental comparisons gain relevance.\r\n\r\nData historization allows identifying underlying trends. PowerPivot efficiently manages temporal dimensions. You build robust and reliable time series. Future projections rely on solid foundations.\r\n\r\n<h3>FAQ<\/h3>\r\n<strong>How many tables can be integrated into a PowerPivot model?<\/strong>\r\n\r\nThe theoretical limit depends on available memory. In practice, dozens of tables integrate without major difficulty.\r\n\r\n<strong>Does PowerPivot completely replace classic Excel formulas?<\/strong>\r\n\r\nNo, both approaches complement each other harmoniously. PowerPivot excels at aggregation while Excel remains relevant for simple calculations.\r\n\r\n<strong>How to handle errors in DAX formulas?<\/strong>\r\n\r\nDebugging involves progressive construction of measures. You test each component before assembling the final formula.\r\n\r\n<strong>Are PowerPivot reports compatible with older Excel versions?<\/strong>\r\n\r\nThe add-in requires Excel 2010 minimum. Recent versions offer more features and performance.\r\n\r\n<strong>Can access to certain data be secured in PowerPivot Excel?<\/strong>\r\n\r\nRow-level security requires SharePoint or Power BI. In Excel alone, protection remains limited to the entire workbook.\r\n\r\n<strong>What is the difference between PowerPivot and Power Query?<\/strong>\r\n\r\nPower Query prepares and transforms data upstream. PowerPivot models and analyzes this prepared data. These Microsoft tools work in perfect synergy.","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>Microsoft PowerPivot Training - Excel - ITTA<\/title>\n<meta name=\"description\" content=\"Master PowerPivot Excel: connect your data, create DAX reports and analyze effectively. Practical and comprehensive training.\" \/>\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-powerpivot\/\" \/>\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-powerpivot\\\/\",\"url\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/\",\"name\":\"Microsoft PowerPivot Training - Excel - ITTA\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/#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\":\"2025-11-13T10:04:00+00:00\",\"description\":\"Master PowerPivot Excel: connect your data, create DAX reports and analyze effectively. Practical and comprehensive training.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.itta.net\\\/en\\\/trainings\\\/office-automation\\\/spreadsheet\\\/excel-powerpivot\\\/#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-powerpivot\\\/#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; PowerPivot\"}]},{\"@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":"Microsoft PowerPivot Training - Excel - ITTA","description":"Master PowerPivot Excel: connect your data, create DAX reports and analyze effectively. Practical and comprehensive training.","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-powerpivot\/","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-powerpivot\/","url":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/","name":"Microsoft PowerPivot Training - Excel - ITTA","isPartOf":{"@id":"https:\/\/www.itta.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/#primaryimage"},"image":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/#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":"2025-11-13T10:04:00+00:00","description":"Master PowerPivot Excel: connect your data, create DAX reports and analyze effectively. Practical and comprehensive training.","breadcrumb":{"@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.itta.net\/en\/trainings\/office-automation\/spreadsheet\/excel-powerpivot\/#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-powerpivot\/#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; PowerPivot"}]},{"@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\/14708","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\/14695"},{"embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/formations\/14698"}],"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=14708"}],"wp:term":[{"taxonomy":"editeurs","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/editeurs?post=14708"},{"taxonomy":"domaine","embeddable":true,"href":"https:\/\/www.itta.net\/en\/wp-json\/wp\/v2\/domaine?post=14708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}