{"id":69586,"date":"2024-01-11T17:21:21","date_gmt":"2024-01-11T16:21:21","guid":{"rendered":"https:\/\/www.calyps.ch\/?p=69586"},"modified":"2024-12-09T09:33:46","modified_gmt":"2024-12-09T08:33:46","slug":"data-maturity-path-from-spreasheet-to-dashbboard","status":"publish","type":"post","link":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/","title":{"rendered":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard"},"content":{"rendered":"\n

Click here to watch the webinar Step 2: From Spreadsheet to Dashboard.<\/a><\/p>\n\n\n\n

Manual data processing (see our article on step 1 of the Data Maturity Path) and dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple and sometimes inconsistent sources of truth.<\/p>\n\n\n\n

The same answers are found in multiple information systems \u2013 the CRM and a separate solution for generating customer quotes, for example \u2013 operating without data interoperability. While employees search for answers in different parts of the organization, copies of files are scattered as they are analyzed. Finance, sales, marketing, production planning, logistics, or customer service: with the increasing importance of data, every professional must now reinvent themselves as an analyst to understand what is happening within their scope of activities.<\/p>\n\n\n\n

Often, the challenge of data sharing is addressed by flooding each colleague in the loop with… even more data. In this respect, Business Intelligence (BI) can become a misused tool, contradicting the company’s policy despite good intentions. Regardless of the department, the temptation can be great to think to oneself:<\/p>\n\n\n\n

“If we could load these data into a BI solution that the team could manipulate at will, it would be better for everyone!”<\/p>\n\n\n\n

Let’s be clear: this is definitely not the case.<\/p>\n\n\n\n

From Self-Service BI to Shadow IT<\/h4>\n\n\n\n

The desire to better understand one’s sphere of activities can lead to the creation of “parallel IT teams”, or shadow IT, e.g., business teams creating their own tool \u2013 starting with the good old Excel macro \u2013 to process data according to their specific needs. Self-service BI and tools like Qlik Sense<\/a> or Power BI<\/a> have given rise to sometimes illegitimate data dashboards, created without the approval of the IT department.<\/p>\n\n\n\n

For its proponents, shadow IT is seen as a source of innovation, with such initiatives sometimes serving as prototypes for future official solutions. For its detractors, it represents a risk for the entire organization, as these solutions are created in disregard of information governance and good practices in documentation and security.<\/p>\n\n\n\n

From Dashboard to Decision Support Tool<\/h4>\n\n\n\n

Originally designed to provide a simplified view of what is happening within the company, these dashboards can quickly resemble the cockpit of a space shuttle with dozens of dials, displays, and key performance indicators. A good dashboard relies on data literacy and allows for identifying, collecting, processing, analyzing, and interpreting data according to guidelines recognized by experts. In the end, a lot of time (and money) can be lost designing a BI solution, not to mention the hours spent navigating screens to try to get answers!<\/p>\n\n\n\n

To summarize: \u2022 Beyond access to information, the real challenge to overcome for professional organizations wishing to progress on the path of data maturity is the multiple sources of information. \u2022 Self-service BI can provide answers to business teams, but is not a panacea: any data solution must be governed by the organization’s IT manager(s). \u2022 A dashboard must remain simple and effective, proven practices of data modeling and visualization will ensure its relevance to user teams.<\/p>\n\n\n\n

Data Maturity Path: Registrations for the May 4, 2023, webinar are open!<\/h4>\n\n\n\n

Our next webinar will be dedicated to the data dashboard, which can become a real decision support tool for employees and executives of a professional structure looking for answers. Click here to watch the webinar Step 2: From Spreadsheet to Dashboard.<\/a><\/p>\n\n\n\n

Click here to access the previous article and webinar Step 1: Manual Data Processing.<\/a><\/p>\n\n\n\n

Click here to access the next article and webinar Step 3: When Data Finally Tells Our Story.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Click here to watch the webinar Step 2: From Spreadsheet to Dashboard. Manual data processing (see our article on step 1 of the Data Maturity Path) and dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple and sometimes inconsistent sources of truth. The same answers are […]<\/p>\n","protected":false},"author":6,"featured_media":68678,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[317,302,306,474],"tags":[363],"class_list":["post-69586","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bonnes-pratiques","category-business-intelligence","category-evenement","category-webinar","tag-artificial-intelligence"],"yoast_head":"\nData Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS<\/title>\n<meta name=\"description\" content=\"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS\" \/>\n<meta property=\"og:description\" content=\"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\" \/>\n<meta property=\"og:site_name\" content=\"CALYPS\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-11T16:21:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-09T08:33:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Team CALYPS\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Team CALYPS\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\"},\"author\":{\"name\":\"Team CALYPS\",\"@id\":\"https:\/\/calyps.ch\/fr\/#\/schema\/person\/d5fc6dc2214a9582d554051be39d7186\"},\"headline\":\"Data Maturity Path, Step 2: From Spreasheet to Dashbboard\",\"datePublished\":\"2024-01-11T16:21:21+00:00\",\"dateModified\":\"2024-12-09T08:33:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\"},\"wordCount\":591,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/calyps.ch\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg\",\"keywords\":[\"artificial intelligence\"],\"articleSection\":[\"Bonnes pratiques\",\"Business Intelligence\",\"Ev\u00e8nements\",\"Webinar\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\",\"url\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\",\"name\":\"Data Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS\",\"isPartOf\":{\"@id\":\"https:\/\/calyps.ch\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg\",\"datePublished\":\"2024-01-11T16:21:21+00:00\",\"dateModified\":\"2024-12-09T08:33:46+00:00\",\"description\":\"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.\",\"breadcrumb\":{\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage\",\"url\":\"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg\",\"contentUrl\":\"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg\",\"width\":2560,\"height\":1707,\"caption\":\"Chemin de la maturit\u00e9 data, \u00e9tape 2\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/calyps.ch\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"news_page_categories\",\"item\":\"https:\/\/calyps.ch\/en\/category\/news_page_categories\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Webinar\",\"item\":\"https:\/\/calyps.ch\/en\/category\/news_page_categories\/webinar\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Data Maturity Path, Step 2: From Spreasheet to Dashbboard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/calyps.ch\/fr\/#website\",\"url\":\"https:\/\/calyps.ch\/fr\/\",\"name\":\"CALYPS\",\"description\":\"Data Intelligence\",\"publisher\":{\"@id\":\"https:\/\/calyps.ch\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/calyps.ch\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/calyps.ch\/fr\/#organization\",\"name\":\"CALYPS\",\"url\":\"https:\/\/calyps.ch\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/calyps.ch\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.calyps.ch\/wp-content\/uploads\/2020\/09\/CALYPS-DATA-def-h-flag-no-background-e1601405282402.png\",\"contentUrl\":\"https:\/\/www.calyps.ch\/wp-content\/uploads\/2020\/09\/CALYPS-DATA-def-h-flag-no-background-e1601405282402.png\",\"width\":500,\"height\":153,\"caption\":\"CALYPS\"},\"image\":{\"@id\":\"https:\/\/calyps.ch\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/calyps\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/calyps.ch\/fr\/#\/schema\/person\/d5fc6dc2214a9582d554051be39d7186\",\"name\":\"Team CALYPS\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/calyps.ch\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6c7004acdfad25dc55b1c614296babd2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6c7004acdfad25dc55b1c614296babd2?s=96&d=mm&r=g\",\"caption\":\"Team CALYPS\"},\"url\":\"https:\/\/calyps.ch\/en\/author\/team-calyps\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS","description":"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.","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:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/","og_locale":"en_US","og_type":"article","og_title":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS","og_description":"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.","og_url":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/","og_site_name":"CALYPS","article_published_time":"2024-01-11T16:21:21+00:00","article_modified_time":"2024-12-09T08:33:46+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg","type":"image\/jpeg"}],"author":"Team CALYPS","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Team CALYPS","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#article","isPartOf":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/"},"author":{"name":"Team CALYPS","@id":"https:\/\/calyps.ch\/fr\/#\/schema\/person\/d5fc6dc2214a9582d554051be39d7186"},"headline":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard","datePublished":"2024-01-11T16:21:21+00:00","dateModified":"2024-12-09T08:33:46+00:00","mainEntityOfPage":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/"},"wordCount":591,"commentCount":0,"publisher":{"@id":"https:\/\/calyps.ch\/fr\/#organization"},"image":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage"},"thumbnailUrl":"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg","keywords":["artificial intelligence"],"articleSection":["Bonnes pratiques","Business Intelligence","Ev\u00e8nements","Webinar"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/","url":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/","name":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard • CALYPS","isPartOf":{"@id":"https:\/\/calyps.ch\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage"},"image":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage"},"thumbnailUrl":"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg","datePublished":"2024-01-11T16:21:21+00:00","dateModified":"2024-12-09T08:33:46+00:00","description":"Dashboards sold as self-service BI hide one of the main problems at this stage of data maturity: multiple sources.","breadcrumb":{"@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#primaryimage","url":"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg","contentUrl":"https:\/\/calyps.ch\/wp-content\/uploads\/2023\/04\/Chemin-de-la-maturite-data-etape-2-Demio-final-scaled.jpg","width":2560,"height":1707,"caption":"Chemin de la maturit\u00e9 data, \u00e9tape 2"},{"@type":"BreadcrumbList","@id":"https:\/\/calyps.ch\/en\/data-maturity-path-from-spreasheet-to-dashbboard\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/calyps.ch\/en\/"},{"@type":"ListItem","position":2,"name":"news_page_categories","item":"https:\/\/calyps.ch\/en\/category\/news_page_categories\/"},{"@type":"ListItem","position":3,"name":"Webinar","item":"https:\/\/calyps.ch\/en\/category\/news_page_categories\/webinar\/"},{"@type":"ListItem","position":4,"name":"Data Maturity Path, Step 2: From Spreasheet to Dashbboard"}]},{"@type":"WebSite","@id":"https:\/\/calyps.ch\/fr\/#website","url":"https:\/\/calyps.ch\/fr\/","name":"CALYPS","description":"Data Intelligence","publisher":{"@id":"https:\/\/calyps.ch\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/calyps.ch\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/calyps.ch\/fr\/#organization","name":"CALYPS","url":"https:\/\/calyps.ch\/fr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/calyps.ch\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.calyps.ch\/wp-content\/uploads\/2020\/09\/CALYPS-DATA-def-h-flag-no-background-e1601405282402.png","contentUrl":"https:\/\/www.calyps.ch\/wp-content\/uploads\/2020\/09\/CALYPS-DATA-def-h-flag-no-background-e1601405282402.png","width":500,"height":153,"caption":"CALYPS"},"image":{"@id":"https:\/\/calyps.ch\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/calyps"]},{"@type":"Person","@id":"https:\/\/calyps.ch\/fr\/#\/schema\/person\/d5fc6dc2214a9582d554051be39d7186","name":"Team CALYPS","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/calyps.ch\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6c7004acdfad25dc55b1c614296babd2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6c7004acdfad25dc55b1c614296babd2?s=96&d=mm&r=g","caption":"Team CALYPS"},"url":"https:\/\/calyps.ch\/en\/author\/team-calyps\/"}]}},"_links":{"self":[{"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/posts\/69586"}],"collection":[{"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/comments?post=69586"}],"version-history":[{"count":4,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/posts\/69586\/revisions"}],"predecessor-version":[{"id":74198,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/posts\/69586\/revisions\/74198"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/media\/68678"}],"wp:attachment":[{"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/media?parent=69586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/categories?post=69586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/calyps.ch\/en\/wp-json\/wp\/v2\/tags?post=69586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}