{"id":8893,"date":"2020-07-19T08:47:09","date_gmt":"2020-07-19T06:47:09","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8893"},"modified":"2020-07-24T13:09:04","modified_gmt":"2020-07-24T11:09:04","slug":"elaborer-un-tableau-de-bord-avec-des-elements-visuels-percutants","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8893","title":{"rendered":"Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants"},"content":{"rendered":"<p style=\"text-align: justify;\">Tous ceux qui ont eu \u00e0 \u00e9laborer un tableau de bord ont \u00e9t\u00e9 confront\u00e9s \u00e0 la difficult\u00e9 de faire ressortir l\u2019information pertinente parmi la masse d\u2019information chiffr\u00e9e dont ils ont la disposition.<\/p>\n<p style=\"text-align: justify;\">Excel offre maintes possibilit\u00e9s de mise en forme assurant la mise en lumi\u00e8re de telle ou telle information et de rendre la donn\u00e9e plus lisible, plus percutante.<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8894\" rel=\"attachment wp-att-8894\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8894\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final.png\" alt=\"TB final\" width=\"940\" height=\"402\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final.png 940w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-300x128.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-768x328.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2020\/07\/TB-final-730x312.png 730w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Ce sont ces techniques que propose modestement d&#8217;exposer cet article en trois parties :<\/p>\n<ul>\n<li style=\"text-align: justify;\">La premi\u00e8re partie pr\u00e9sente les <a href=\"https:\/\/www.auditsi.eu\/?tag=graphique-sparkline\">graphiques Sparkline<\/a> (graphique qui tient dans une cellule et qui montre visuellement la tendance suivie par une s\u00e9rie de donn\u00e9es) et<\/li>\n<li style=\"text-align: justify;\">les deuxi\u00e8me et troisi\u00e8me les <a href=\"https:\/\/www.auditsi.eu\/?tag=formats-conditionnels\">formats conditionnels<\/a> de type barres de donn\u00e9es et jeux d\u2019ic\u00f4nes.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">A l&#8217;issue de chaque partie, le tableau de bord est propos\u00e9 en t\u00e9l\u00e9chargement (classeur Excel).<\/p>\n<p style=\"text-align: justify;\">L\u2019objectif final de cet article est d\u2019obtenir le tableau dont l\u2019aper\u00e7u figure plus haut. Il s\u2019agit dans cet exemple de suivre le chiffre d\u2019affaires de deux magasins (\u00e9volution sur l\u2019ann\u00e9e compar\u00e9e \u00e0 celle de l\u2019ann\u00e9e pr\u00e9c\u00e9dente et comparaison des r\u00e9alisations par rapport aux objectifs fix\u00e9s).<\/p>\n<p style=\"text-align: justify;\">Ce tableau montre beaucoup de donn\u00e9es parfaitement compr\u00e9hensibles mais il ne para\u00eet pas \u00e9vident d\u2019un coup d\u2019\u0153il rapide de d\u00e9celer les grandes tendances. Les <a href=\"https:\/\/www.auditsi.eu\/?tag=graphique-sparkline\">graphiques Sparkline<\/a> et <a href=\"https:\/\/www.auditsi.eu\/?tag=formats-conditionnels\">formats conditionnels<\/a> apportent un certain confort en pr\u00e9sentant ces m\u00eames donn\u00e9es chiffr\u00e9es sous une forme visuelle facilitant ainsi leur interpr\u00e9tation et la <a href=\"https:\/\/www.auditsi.eu\/?tag=informatique-decisionnelle\">prise de d\u00e9cision<\/a>.<\/p>\n<p style=\"text-align: justify;\">Cet article pr\u00e9sente les aspects techniques \u00e0 ma\u00eetriser pour r\u00e9aliser un tel tableau de bord mais, bien entendu, il convient en amont de sa conception, de r\u00e9fl\u00e9chir \u00e0 l\u2019objectif assign\u00e9 au tableau et aux sources d\u2019information n\u00e9cessaires \u00e0 sa r\u00e9alisation.<\/p>\n<p style=\"text-align: justify;\">A suivre\u2026<\/p>\n<p>D\u00e9couvrir <a href=\"https:\/\/www.auditsi.eu\/?cat=2251\">tous les articles de cette s\u00e9rie<\/a>.<\/p>\n<p>___<\/p>\n<p>Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?p=8969\">Cr\u00e9er un tableau de bord dynamique avec Excel en quelques clics<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a> \/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a>&nbsp;\/ En savoir plus sur l\u2019<a href=\"https:\/\/www.auditsi.eu\/?tag=analyse-de-donnees\">analyse de donn\u00e9es<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Elaborer%20un%20tableau%20de%20bord%20avec%20des%20%C3%A9l%C3%A9ments%20visuels%20percutants\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Tous ceux qui ont eu \u00e0 \u00e9laborer un tableau de bord ont \u00e9t\u00e9 confront\u00e9s \u00e0 la difficult\u00e9 de faire ressortir l\u2019information pertinente parmi la masse d\u2019information chiffr\u00e9e dont ils ont la disposition. Excel offre maintes possibilit\u00e9s de mise en forme assurant la mise en lumi\u00e8re de telle ou telle information et de rendre la donn\u00e9e &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8893\" class=\"more-link\">Continue reading &lsquo;Elaborer un tableau de bord avec des \u00e9l\u00e9ments visuels percutants&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Elaborer%20un%20tableau%20de%20bord%20avec%20des%20%C3%A9l%C3%A9ments%20visuels%20percutants\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[50,48,1326,2251],"tags":[165,166,1633,293,2252,164,375],"class_list":["post-8893","post","type-post","status-publish","format-standard","hentry","category-audit-de-donnees","category-excel","category-maitriser-excel","category-tableaux-de-bord-visuels","tag-aide-a-la-decision","tag-analyse-de-donnees","tag-excel","tag-formats-conditionnels","tag-graphique-sparkline","tag-informatique-decisionnelle","tag-tableau-de-bord"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8893"}],"version-history":[{"count":13,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8893\/revisions"}],"predecessor-version":[{"id":9066,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8893\/revisions\/9066"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}