{"id":3379,"date":"2023-11-30T13:10:15","date_gmt":"2023-11-30T18:10:15","guid":{"rendered":"https:\/\/www.kuriosit.ca\/?p=3379"},"modified":"2025-03-06T11:19:51","modified_gmt":"2025-03-06T16:19:51","slug":"series-creating-an-agile-dashboard-using-power-bi","status":"publish","type":"post","link":"https:\/\/www.kuriosit.ca\/en\/serie-la-creation-dun-tableau-de-bord-agile-a-laide-de-power-bi\/","title":{"rendered":"Series - Creating an agile dashboard with Power BI"},"content":{"rendered":"<p class=\"wp-block-paragraph\">During the Agile Tour Qu\u00e9bec, my colleague Simon-Pierre Morin challenged me to write a blog related to our presentation on the agile project tracking dashboard. What a trap! I realize that one blog won't be enough! So Simon-Pierre and I are preparing a series of blogs based on the main points of our conference.<\/p>\n\n\n\n<h2 class=\"wp-block-heading has-medium-font-size\">Why an agile dashboard presentation?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Because the subject sparked an interesting discussion between Simon-Pierre and me. For my part, I've just joined the Kurios IT team, following a term in which I held the role of interim product manager for over a year. During this period, I was responsible for reporting on development projects and contributed to the revision of project management processes within my organization. For his part, Simon Pierre is currently supporting a program manager, responsible for monitoring the progress of software development in a manufacturing group.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By taking an interest in Simon-Pierre's work, I discovered some interesting solutions to the difficulty I frequently encounter in building an accountability tool with data from agile planning tools such as Jira or Azure DevOps.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Our blog series will therefore explore the needs and challenges faced by a manager wishing to track the progress of his agile projects, and will also look at Simon-Pierre's practical solutions using Power BI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">1<sup>er<\/sup> blog : <a href=\"https:\/\/www.kuriosit.ca\/en\/dashboard-template-for-agile-projects\/\">Dashboard template for agile projects<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2<sup>e<\/sup> blog : <a href=\"https:\/\/www.kuriosit.ca\/en\/power-query-data-grouping\/\">Power Query - Data grouping<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3rd blog: <a href=\"https:\/\/www.kuriosit.ca\/en\/power-query-odata-web-and-vsts\/\">Power Query - OData, Web and VSTS<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4th blog: <a href=\"https:\/\/www.kuriosit.ca\/en\/power-query-optimization-reduce-steps\/\">Power Query - Optimization - Fewer steps<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5th blog: <a href=\"https:\/\/www.kuriosit.ca\/en\/power-query-optimization-variable-functions\/\">Power Query - Optimization with functions and variables<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6th blog: <a href=\"https:\/\/www.kuriosit.ca\/en\/powerquery-dataflow-model-optimization\/\">Power Query - Optimization with templates and dataflows<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">7th blog: <a href=\"https:\/\/www.kuriosit.ca\/en\/how-to-keep-agile-projects-on-budget\/\">How do you ensure that agile projects don't go over budget?<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>During the Agile Tour Qu\u00e9bec, my colleague Simon-Pierre Morin challenged me to write a blog related to our presentation on the agile project tracking dashboard. What a trap! I realize that one blog won't be enough! So Simon-Pierre and I are preparing a series of blogs that will...<\/p>","protected":false},"author":39,"featured_media":3431,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"default","_kad_post_layout":"default","_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,"_kad_post_classname":"","footnotes":""},"categories":[46],"tags":[],"class_list":["post-3379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-agilite"],"acf":[],"taxonomy_info":{"category":[{"value":46,"label":"Agilit\u00e9"}]},"featured_image_src_large":["https:\/\/www.kuriosit.ca\/wp-content\/uploads\/2023\/12\/pile_de_revues-scaled.jpg",2560,1706,false],"author_info":{"display_name":"adminti","author_link":"https:\/\/www.kuriosit.ca\/en\/author\/adminti\/"},"comment_info":0,"category_info":[{"term_id":46,"name":"Agilit\u00e9","slug":"agilite","term_group":0,"term_taxonomy_id":46,"taxonomy":"category","description":"","parent":0,"count":3,"filter":"raw","cat_ID":46,"category_count":3,"category_description":"","cat_name":"Agilit\u00e9","category_nicename":"agilite","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/posts\/3379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/comments?post=3379"}],"version-history":[{"count":2,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/posts\/3379\/revisions"}],"predecessor-version":[{"id":3937,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/posts\/3379\/revisions\/3937"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/media\/3431"}],"wp:attachment":[{"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/media?parent=3379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/categories?post=3379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuriosit.ca\/en\/wp-json\/wp\/v2\/tags?post=3379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}