{"id":3201,"date":"2020-07-05T14:06:00","date_gmt":"2020-07-05T12:06:00","guid":{"rendered":"https:\/\/thebipower.fr\/?p=3201"},"modified":"2021-01-09T13:53:32","modified_gmt":"2021-01-09T12:53:32","slug":"translations-life-cycle-management","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2020\/07\/05\/translations-life-cycle-management\/","title":{"rendered":"Translations life cycle management"},"content":{"rendered":"\n<p>Translations life cycle management must be considered seriously as soon as we decide to translate Power BI reports. Translating a report in several languages takes some time when we do it for the first time. But we expect the maintenance of translations will be as easy as possible when the report will be modified or when a new language will be added.<\/p>\n\n\n\n<p>Some of our colleagues or customers reject reports in a language they are not used to. So when we want to reach a larger audience, our reports need to be translated. <\/p>\n\n\n\n<p>Even if the report has been designed in users&#8217; language, we might need to transform an IT format to a business format. For example, &#8220;TotalSalesAmount&#8221; -&gt; &#8220;Total sales amount&#8221; or &#8220;Dim_Date&#8221; -&gt; &#8220;Calendar&#8221;. This way, IT and business people will be comfortable with terms they are used to. Both of them will be efficient without effort.<br>You may have a look at this interesting blog post from Chris Webb :   <a aria-label=\"undefined (opens in a new tab)\" href=\"https:\/\/blog.crossjoin.co.uk\/2020\/06\/28\/naming-tables-columns-and-measures-in-power-bi\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/blog.crossjoin.co.uk\/2020\/06\/28\/naming-tables-columns-and-measures-in-power-bi\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Translators profiles<\/h2>\n\n\n\n<p>Depending on the languages quantity, we might need several people to help translating or validating translations. Some of this people will be business users located in different places, in different business units and not working at the same time. For these users, we need to find a comfortable way to manage translations allowing : <\/p>\n\n\n\n<ul><li>copy and paste<\/li><li>automatic translation <\/li><li>easy identification of new labels<\/li><li>easy identification of the labels needing a review after modification<\/li><li>splitting translations between translators with an appropriate level of security<\/li><\/ul>\n\n\n\n<p>The most popular tool to manage data for business users is definitely Excel. An Excel file can be hosted on the network or on OneDrive and shared among multiple users. No need to train them to a new tool and support will be minimal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Entities to be translated<\/h2>\n\n\n\n<ul><li>Model<ul><li>Tables name &amp; description<\/li><li>Columns name, display folder &amp; description<\/li><li>Measures name, display folder &amp; description<\/li><li>Hierachy name &amp; description<\/li><li>Perspective name &amp; description<\/li><\/ul><\/li><li>Report<ul><li>Visuals title, legend name &amp; header tootltip<\/li><li>Pages name<\/li><li>Textbox content<\/li><\/ul><\/li><li>Data to be translated outside of the database<\/li><\/ul>\n\n\n\n<p>Fot each of these entities, we need to detect any creation, modification and deletion to maintain translations and eventually to activate translators.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Example of methodology to ease the task<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Initialization<\/h3>\n\n\n\n<ul><li>Create 3 sheets in the Excel file : Model, Visuals, Data<\/li><li>Load entities to translate in these sheets. Color the cells in yellow to identify a new entity was appened<\/li><li>Add 1 column by language<\/li><li>Initialize translations for each language with an automatic translator. Color these cells in yellow<\/li><li>Share the file with translators asking them to validate their languages. For security purpose, it is possible to split the file in as many files as translators<\/li><li>Once the translations are validated, remove the yellow color <\/li><li>Once there is no more yellow in the file(s), it is time to publish. Use the file(s) as a datasource in Power BI<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Evolutions<\/h3>\n\n\n\n<p>Each time an entity is added or modified we need to update translations. From time to time, we need to clean the file removing entities no longer used.<\/p>\n\n\n\n<ul><li>Load entities into the file(s)<\/li><li>Color new or modified entities in yellow and color removed entities in grey<\/li><li>Optionally remove lines with a grey color<\/li><li>Share the file(s) with translators asking them to validate only yellow cells for their languages<\/li><li>Once the translations are validated, remove the yellow color<\/li><li>Publish<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Do you feel it is hard ?<\/h3>\n\n\n\n<p>Don&#8217;t worry, in the blog posts down below, I share with you automatic tools to accomplish these tasks with a minimal effort.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion about translations life cycle management<\/h2>\n\n\n\n<p>Report translation is very important for data culture adoption. The initialization might be a boring task without a proper methodology and tool but the maintenance might be even worse. So translations life cycle management must be considered properly before starting the task.<\/p>\n\n\n\n<p>Please have a look at the blog posts down below for more details and feel free to comment.<\/p>\n\n\n\n<p>You might begin with this post :   <a class=\"rank-math-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/07\/visuals-labels-translations-in-power-bi-reports\/\">Visuals labels translations in Power BI reports<\/a><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-2b60c133     uagb-post__arrow-outside uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1\" data-total=\"1\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/10\/automatic-translation-of-visuals-labels\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"158\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations.png\" class=\"attachment-large size-large\" alt=\"Visuals translations Power BI reports\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations.png 468w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations-300x101.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/10\/automatic-translation-of-visuals-labels\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Automatic translation of visuals labels<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Automatic translation of visuals labels in Power BI reports is possible using conditional formating, Tabular&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/10\/automatic-translation-of-visuals-labels\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/07\/visuals-labels-translations-in-power-bi-reports\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"158\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations.png\" class=\"attachment-large size-large\" alt=\"Visuals translations Power BI reports\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations.png 468w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/05\/Visuals-labels-translations-300x101.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/07\/visuals-labels-translations-in-power-bi-reports\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Visuals labels translations in Power BI reports<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Visuals labels translations in Power BI reports are not supported natively. However, there is a&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/05\/07\/visuals-labels-translations-in-power-bi-reports\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/04\/12\/automatic-translation-of-tabular-model\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"159\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/04\/Automatic-translation-of-tabular-model.png\" class=\"attachment-large size-large\" alt=\"Automatic translation of tabular model\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/04\/Automatic-translation-of-tabular-model.png 614w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/04\/Automatic-translation-of-tabular-model-300x78.png 300w\" sizes=\"(max-width: 614px) 100vw, 614px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/04\/12\/automatic-translation-of-tabular-model\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Automatic translation of tabular model<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Automatic translation of tabular model using Tabular Editor and Excel is possible since the Power&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/04\/12\/automatic-translation-of-tabular-model\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\n\n<h2 class=\"wp-block-heading\">More<\/h2>\n\n\n\n<p>Video from Parker Stevens about currency conversion :   <a href=\"https:\/\/www.youtube.com\/watch?v=UqTAJxp--c4\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\">https:\/\/www.youtube.com\/watch?v=UqTAJxp&#8211;c4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Translations life cycle management must be considered seriously as soon as we decide to translate Power BI reports. Translating a report in several languages takes some time when we do it for the first time. But we expect the maintenance of translations will be as easy as possible when the report will be modified or&#8230;<\/p>\n","protected":false},"author":2,"featured_media":3238,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[2,69],"tags":[24,70,41],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management-150x150.jpg",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management-300x160.jpg",300,160,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/07\/Translations-life-cycle-management.jpg",640,341,false]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":0,"uagb_excerpt":"Translations life cycle management must be considered seriously as soon as we decide to translate Power BI reports. Translating a report in several languages takes some time when we do it for the first time. But we expect the maintenance of translations will be as easy as possible when the report will be modified or...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3201"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3201"}],"version-history":[{"count":33,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3201\/revisions"}],"predecessor-version":[{"id":3779,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3201\/revisions\/3779"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/3238"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=3201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=3201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}