{"id":3335,"date":"2025-12-11T11:48:21","date_gmt":"2025-12-11T10:48:21","guid":{"rendered":"https:\/\/heydata.fr\/?p=3335"},"modified":"2025-12-17T09:29:30","modified_gmt":"2025-12-17T08:29:30","slug":"post-1","status":"publish","type":"post","link":"https:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/","title":{"rendered":"Starting a Qlik Project: Exploring and Extracting Data"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"3335\" class=\"elementor elementor-3335\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3208e2f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3208e2f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0facb6c\" data-id=\"0facb6c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a7f70b4 elementor-widget elementor-widget-text-editor\" data-id=\"a7f70b4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<h4 style=\"text-align: left;\"><span style=\"color: #000000;\"><strong>Welcome to the very first article on the blog!\u00a0<\/strong><\/span><\/h4><p style=\"text-align: left;\"><span style=\"color: #333333;\">And to kick things off, we are drawing the same parallel as with the beginning of any successful Qlik project: we start by laying the foundations. Our goal is to share our vision with you and to consolidate our experience through content that is accessible, rigorous, and useful.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">On this blog, we will cover topics that are both highly technical (scripting, modeling, performance) and broader (modern BI and the Qlik ecosystem).\u00a0<\/span><\/p><p>\u00a0<\/p><h5 style=\"text-align: left;\" aria-level=\"3\"><span style=\"color: #000000;\"><strong>Why Qlik? The Fundamentals\u00a0<\/strong><\/span><\/h5><p style=\"text-align: left;\"><span style=\"color: #333333;\">Often, the data related to your operations (finance, HR, orders, etc.) is stored in one or more databases managed by dedicated software. While these tools are excellent for operational tasks, they rarely offer advanced analytics or statistical capabilities.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">One of Qlik\u2019s key use cases is to make this data accessible beyond the users of the management software, while providing superior analysis capabilities.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">To achieve this, the major phases of a project are always the same:\u00a0<\/span><\/p><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Connect to <\/b>the source and extract the data.\u00a0<\/span><\/li><\/ul><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Transform<\/b> <b>it<\/b> into an optimized data model.\u00a0<\/span><\/li><\/ul><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"1\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Create<\/b> indicators and a meaningful design.\u00a0<\/span><\/li><\/ul><p>\u00a0<\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">As you have understood, the first step is to master the source. We will focus on the critical phases that are often overlooked:\u00a0<\/span><\/p><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Understanding<\/b> the structure of the data source.\u00a0<\/span><\/li><\/ul><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Exploring<\/b> its actual content to prepare for modeling.\u00a0<\/span><\/li><\/ul><p>\u00a0<\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">These steps are essential for any high-performing analytical model\u2014discover how to master them.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #000000;\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559685&quot;:0,&quot;335559738&quot;:220,&quot;335559739&quot;:220}\">\u00a0<\/span><\/p><h5 style=\"text-align: left;\"><span style=\"color: #008080;\"><b>Phase 1 \u2013 Understanding the Structure and Logic of the Database<\/b>\u00a0<\/span><\/h5><p style=\"text-align: left;\"><span style=\"color: #333333;\">Most Qlik projects rely on one or more databases originating from business applications: financial management, HR, production, or logistics. These systems store data in a relational model optimized for operations but rarely designed for analytics.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">For the developer, this first phase feels like the work of a miner: documentation is often incomplete, and the relationships between tables are far from explicit. It is often tedious and highly technical.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">To avoid moving forward blindly, a mapping of the database is essential. We will share tools and tips to speed up and industrialize this crucial step of identifying:\u00a0<\/span><\/p><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span style=\"color: #333333;\">The relevant schemas and tables\u00a0<\/span><\/li><\/ul><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span style=\"color: #333333;\">The implicit relationships and functional keys\u00a0<\/span><\/li><\/ul><ul style=\"text-align: left;\"><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span style=\"color: #333333;\">The fields that carry business value\u00a0<\/span><\/li><\/ul><p>\u00a0<\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">Mastering this mapping is key to simplifying the rest of the project and preparing your Qlik data model.\u00a0<\/span><\/p><p>\u00a0<\/p><h6 style=\"text-align: left;\" aria-level=\"2\"><span style=\"color: #000000;\"><b>Accessing the Schema\u00a0<\/b>\u00a0<\/span><\/h6><p style=\"text-align: left;\"><span style=\"color: #333333;\">The first step is to retrieve the complete schema of the database to obtain a detailed view of its structure. Let\u2019s take the example of a PostgreSQL database, though the equivalent can be done for other technologies.\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"color: #333333;\">A simple script allows you to automatically list all tables and columns. You just need to connect by providing the connection string, then execute the following script:\u00a0<\/span><\/p><p>\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b9ede7 elementor-widget elementor-widget-image\" data-id=\"4b9ede7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"484\" height=\"1014\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52.png 484w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-143x300.png 143w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-6x12.png 6w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-48x100.png 48w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-38x80.png 38w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-145x303.png 145w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-334x700.png 334w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52-453x950.png 453w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75daf3c elementor-widget elementor-widget-text-editor\" data-id=\"75daf3c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p>Thanks to this extraction, you can quickly create a structural exploration dashboard showing: <b>tableau de bord d\u2019exploration structurelle<\/b> d\u00e9crivant :\u00a0<\/p><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\">The list of tables\u00a0<\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\">The field types\u00a0<\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"4\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\">The presence of keys\u00a0\u00a0<\/li><\/ul><p>\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0e82dfc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0e82dfc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a9a4cb8\" data-id=\"a9a4cb8\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2ac6270 elementor-widget elementor-widget-image\" data-id=\"2ac6270\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"551\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-1024x551.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-1024x551.png 1024w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-300x161.png 300w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-768x413.png 768w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-1536x827.png 1536w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-18x10.png 18w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-186x100.png 186w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-149x80.png 149w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-394x212.png 394w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-915x493.png 915w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-1240x668.png 1240w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39-1920x1034.png 1920w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.27.39.png 1984w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f36776 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f36776\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0c6148c\" data-id=\"0c6148c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3c4e0a6 elementor-widget elementor-widget-text-editor\" data-id=\"3c4e0a6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<h6 aria-level=\"2\">\u00a0<\/h6><h6 aria-level=\"2\"><span style=\"color: #000000;\"><strong>Why is this mapping essential ?\u00a0<\/strong><\/span><\/h6><h6 aria-level=\"2\"><span style=\"color: #333333;\">This initial analysis allows you to:\u00a0<\/span><\/h6><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span style=\"color: #333333;\">Assess the quality of the relational model\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span style=\"color: #333333;\">Anticipate the transformations required for an analytical model\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span style=\"color: #333333;\">Identify unnecessary technical fields\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span style=\"color: #333333;\">Understand the data granularity\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span style=\"color: #333333;\">Detect fact tables, dimension tables, or mixed tables\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"5\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"6\" data-aria-level=\"1\"><span style=\"color: #333333;\" data-contrast=\"none\">Identify the keys and relationships between tables<\/span><\/li><\/ul><p>\u00a0<\/p><p><span style=\"color: #333333;\">This is the stage where you start imagining the final structure of the Qlik model, keeping in mind that the original model will never be used as is.\u00a0<\/span><br \/><span style=\"color: #333333;\">Transformations, merges, and enrichments will always be necessary.\u00a0<\/span><\/p><h5>\u00a0<\/h5><h5><span style=\"color: #008080;\"><b>Phase 2 \u2013 Exploring the Actual Content to Prepare for Modeling<\/b>\u00a0<\/span><\/h5><p><span style=\"color: #333333;\">Once the structure of the database has been mapped, the next step is to extract the data so it can be explored in Qlik. This phase must be optimized for speed, as it will be repeated until all relevant data has been identified.\u00a0<\/span><\/p><p>\u00a0<\/p><h6 aria-level=\"3\"><span style=\"color: #000000;\"><b>Extraction Strategy Based on Data Volume<\/b>\u00a0<\/span><\/h6><p><span style=\"color: #333333;\">The way we extract the data depends heavily on the size of the source tables:\u00a0<\/span><\/p><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Reasonable Volume:<\/b> We perform a full load of all data rows.\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"6\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span style=\"color: #333333;\"><b>Large Volume:<\/b> For very large tables, we prefer partial loading.\u00a0<\/span><\/li><\/ul><p>\u00a0<\/p><h6><span style=\"color: #000000;\"><strong>The Extraction Script and the Role of the QVD\u00a0<\/strong><\/span><\/h6><p><span style=\"color: #333333;\">Our approach is to perform a \u201cSELECT *\u201d on all relevant tables in the data model and immediately store them in QVD files. <b>QVD<\/b>.\u00a0<\/span><\/p><p><span style=\"color: #333333;\">This initial load is done using a fairly simple script, as shown here:<i>\u00a0<\/i>\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9bda1d elementor-widget elementor-widget-image\" data-id=\"b9bda1d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"1024\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-849x1024.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-849x1024.png 849w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-249x300.png 249w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-768x926.png 768w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-10x12.png 10w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-83x100.png 83w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-66x80.png 66w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-251x303.png 251w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-581x700.png 581w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02-788x950.png 788w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.55.02.png 894w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dd15190 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd15190\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0ac7c02\" data-id=\"0ac7c02\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-102eda7 elementor-widget elementor-widget-text-editor\" data-id=\"102eda7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p>\u00a0<\/p><p><span data-contrast=\"none\">This method offers two major advantages:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"7\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><b><span data-contrast=\"none\">Speed:<\/span><\/b><span data-contrast=\"none\"> The QVD is an optimized format for Qlik, making future reloads nearly instantaneous.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:220,&quot;335559739&quot;:220}\">\u00a0<\/span><\/li><\/ul><ul><li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"7\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><b><span data-contrast=\"none\">Separation:<\/span><\/b><span data-contrast=\"none\"> QVDs act as a raw storage layer, isolated from transformation logic.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:220,&quot;335559739&quot;:220}\">\u00a0<\/span><\/li><\/ul><p>\u00a0<\/p><h6 aria-level=\"3\"><b><span data-contrast=\"none\">Preparing for Exploration: the \u201cQualify\u201d Trick<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:280,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h6><p><span data-contrast=\"none\">The \u201cQualify\u201d trick makes it possible to prefix all fields with the name of their source table. The goal is simple: to avoid the automatic creation of links between tables in Qlik\u2019s data model. For this exploration phase, we simply want to inspect the tables in isolation, without any analytical structure.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p>\u00a0<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd8f7b1 elementor-widget elementor-widget-image\" data-id=\"dd8f7b1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"656\" height=\"210\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30.png 656w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30-300x96.png 300w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30-18x6.png 18w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30-312x100.png 312w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30-250x80.png 250w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.02.30-394x126.png 394w\" sizes=\"auto, (max-width: 656px) 100vw, 656px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-42a550d elementor-widget elementor-widget-text-editor\" data-id=\"42a550d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<h6>\u00a0<\/h6><h6><b><span data-contrast=\"none\">Exploration Using Smart Search<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:280,&quot;335559739&quot;:80}\">\u00a0<\/span><\/h6><p><span data-contrast=\"none\">Once the data is loaded, the Qlik application (in a sheet dedicated to exploration) becomes a powerful search tool. If you are looking for a specific value without knowing which field it is stored in, Qlik\u2019s Smart Search is your best ally. It allows you to find data and trace it back to its source, even within a model you don\u2019t yet fully understand.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4270e8b elementor-widget elementor-widget-image\" data-id=\"4270e8b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"813\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-1024x813.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-1024x813.png 1024w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-300x238.png 300w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-768x610.png 768w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-15x12.png 15w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-126x100.png 126w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-101x80.png 101w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-381x303.png 381w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44-881x700.png 881w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.42.44.png 1060w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c3f23f elementor-widget elementor-widget-image\" data-id=\"2c3f23f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"796\" src=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-1024x796.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-1024x796.png 1024w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-300x233.png 300w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-768x597.png 768w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-15x12.png 15w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-129x100.png 129w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-103x80.png 103w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-390x303.png 390w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02-900x700.png 900w, https:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-11.47.02.png 1204w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72203cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72203cc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-19c2d09\" data-id=\"19c2d09\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-39d0a45 elementor-widget elementor-widget-text-editor\" data-id=\"39d0a45\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<h6 aria-level=\"3\">\u00a0<\/h6><h6 aria-level=\"3\"><span style=\"color: #000000;\"><b>Optimization for Exploration<\/b>\u00a0<\/span><\/h6><p><span data-contrast=\"none\">To ensure this phase runs quickly, don\u2019t forget to include this variable in your script: <\/span><span data-contrast=\"none\">d&rsquo;int\u00e9grer cette variable dans votre script :<\/span><\/p><p><span data-contrast=\"none\">\u00a0<\/span><\/p><p><span data-contrast=\"none\">\u201c<\/span><b><span data-contrast=\"none\">SET CreateSearchindexOnReload=0\u201d<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-contrast=\"none\">This prevents Qlik from indexing the content of all fields during the load, speeding up reload times while you are working on extraction. (Also note that the QVD storage path will be managed through project variables that need to be adjusted depending on your file system.)<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">This exploration method applies to any Qlik project that relies on a database. Its rapid implementation makes it a valuable tool for both technical and functional decision-making.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-contrast=\"none\">Indeed, this exploration environment is ideal for discussions with business experts (developers, users, database administrators) to validate data relevance and define the business rules required for the indicators.<\/span> <span data-contrast=\"none\">m\u00e9tiers (d\u00e9veloppeurs, utilisateurs, administrateurs de la base de donn\u00e9es) afin de valider la pertinence des donn\u00e9es et d&rsquo;\u00e9tablir les r\u00e8gles de gestion n\u00e9cessaires aux indicateurs.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p class=\" translation-block\">Here is the sample application to use : Heydata_1 \u2013 GoaGS \u2013 1.qvf<\/p><p><span data-contrast=\"none\">Once the source data is fully understood and its future use defined, we can move on to the industrialization stages of the extraction process, which will be the topic of our next article.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p><p><span data-contrast=\"none\">See you soon!<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Welcome to the very first article on the blog! \n\nAnd to kick things off, we are drawing the same parallel as with the beginning of any successful Qlik project: we start by laying the foundations. Our goal is to share our vision with you... <a href=\"https:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/\">Read More<\/a><\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-3335","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.11 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData\" \/>\n<meta property=\"og:description\" content=\"Bienvenue sur le tout premier article du blog !\u00a0 Et pour son lancement, nous faisons le m\u00eame parall\u00e8le qu&rsquo;avec le d\u00e9but de tout projet Qlik r\u00e9ussi : nous commen\u00e7ons par poser les bases. Notre ambition est de partager avec vous &hellip; Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/\" \/>\n<meta property=\"og:site_name\" content=\"HeyData\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-11T10:48:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-17T08:29:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52.png\" \/>\n<meta name=\"author\" content=\"admin1983\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin1983\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/\",\"url\":\"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/\",\"name\":\"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData\",\"isPartOf\":{\"@id\":\"http:\/\/heydata.fr\/#website\"},\"datePublished\":\"2025-12-11T10:48:21+00:00\",\"dateModified\":\"2025-12-17T08:29:30+00:00\",\"author\":{\"@id\":\"http:\/\/heydata.fr\/#\/schema\/person\/5ade0fcc8cac198f15ef1493db7b08e0\"},\"breadcrumb\":{\"@id\":\"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/heydata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/heydata.fr\/#website\",\"url\":\"http:\/\/heydata.fr\/\",\"name\":\"HeyData\",\"description\":\"Exploitez toute la valeur dans vos donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/heydata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"http:\/\/heydata.fr\/#\/schema\/person\/5ade0fcc8cac198f15ef1493db7b08e0\",\"name\":\"admin1983\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/heydata.fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fb00be25c83f140a57af712c4caa0c78c24d06387bee1407cf0c2e9ad090f9e6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fb00be25c83f140a57af712c4caa0c78c24d06387bee1407cf0c2e9ad090f9e6?s=96&d=mm&r=g\",\"caption\":\"admin1983\"},\"sameAs\":[\"http:\/\/heydata.fr\"],\"url\":\"https:\/\/heydata.fr\/en\/author\/admin1983\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData","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:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/","og_locale":"en_US","og_type":"article","og_title":"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData","og_description":"Bienvenue sur le tout premier article du blog !\u00a0 Et pour son lancement, nous faisons le m\u00eame parall\u00e8le qu&rsquo;avec le d\u00e9but de tout projet Qlik r\u00e9ussi : nous commen\u00e7ons par poser les bases. Notre ambition est de partager avec vous &hellip; Read More","og_url":"https:\/\/heydata.fr\/en\/2025\/12\/11\/post-1\/","og_site_name":"HeyData","article_published_time":"2025-12-11T10:48:21+00:00","article_modified_time":"2025-12-17T08:29:30+00:00","og_image":[{"url":"http:\/\/heydata.fr\/wp-content\/uploads\/2025\/12\/Capture-decran-2025-12-15-a-12.10.52.png"}],"author":"admin1983","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin1983","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/","url":"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/","name":"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es - HeyData","isPartOf":{"@id":"http:\/\/heydata.fr\/#website"},"datePublished":"2025-12-11T10:48:21+00:00","dateModified":"2025-12-17T08:29:30+00:00","author":{"@id":"http:\/\/heydata.fr\/#\/schema\/person\/5ade0fcc8cac198f15ef1493db7b08e0"},"breadcrumb":{"@id":"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/heydata.fr\/2025\/12\/11\/post-1\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/heydata.fr\/2025\/12\/11\/post-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/heydata.fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9marrer un projet Qlik : Explorer et extraire les donn\u00e9es"}]},{"@type":"WebSite","@id":"http:\/\/heydata.fr\/#website","url":"http:\/\/heydata.fr\/","name":"HeyData","description":"Exploitez toute la valeur dans vos donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/heydata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/heydata.fr\/#\/schema\/person\/5ade0fcc8cac198f15ef1493db7b08e0","name":"admin1983","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/heydata.fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fb00be25c83f140a57af712c4caa0c78c24d06387bee1407cf0c2e9ad090f9e6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fb00be25c83f140a57af712c4caa0c78c24d06387bee1407cf0c2e9ad090f9e6?s=96&d=mm&r=g","caption":"admin1983"},"sameAs":["http:\/\/heydata.fr"],"url":"https:\/\/heydata.fr\/en\/author\/admin1983\/"}]}},"_links":{"self":[{"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/posts\/3335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/comments?post=3335"}],"version-history":[{"count":118,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/posts\/3335\/revisions"}],"predecessor-version":[{"id":3545,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/posts\/3335\/revisions\/3545"}],"wp:attachment":[{"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/media?parent=3335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/categories?post=3335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heydata.fr\/en\/wp-json\/wp\/v2\/tags?post=3335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}