{"id":7420,"date":"2020-07-16T11:44:47","date_gmt":"2020-07-16T07:14:47","guid":{"rendered":"https:\/\/nazmaran.com\/data-warehouse\/"},"modified":"2023-11-03T23:54:55","modified_gmt":"2023-11-03T20:24:55","slug":"data-warehouse","status":"publish","type":"post","link":"https:\/\/nazmaran.com\/en\/data-warehouse\/","title":{"rendered":"data warehouse"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"7420\" class=\"elementor elementor-7420 elementor-1151\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f993251 elementor-section-stretched elementor-section-full_width elementor-section-height-min-height elementor-section-items-stretch elementor-section-height-default\" data-id=\"f993251\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b4925fd\" data-id=\"b4925fd\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ac4a61c elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"ac4a61c\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">data warehouse<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-3e392e8 elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"3e392e8\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-155603f\" data-id=\"155603f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f7bba3b elementor-widget elementor-widget-image\" data-id=\"f7bba3b\" 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\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"97\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Layer-95-1024x97.png\" class=\"attachment-large size-large wp-image-6293\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Layer-95-1024x97.png 1024w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Layer-95-300x28.png 300w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Layer-95-768x73.png 768w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Layer-95.png 1238w\" sizes=\"(max-width: 1024px) 100vw, 1024px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-aa59b0a elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"aa59b0a\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-62ac0024\" data-id=\"62ac0024\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-781de2f6 elementor-widget elementor-widget-text-editor\" data-id=\"781de2f6\" 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\t<p>Data warehouse refers to a set of data that is collected, categorized and stored from various information sources of the organization. In other words, &#8220;a data warehouse is a subject-oriented, integrated, time-varying and non-volatile collection of data that supports decision-making management&#8221;. The main purpose of creating a data warehouse is to use the data produced and stored by operational systems in the data warehouse and to use them correctly in the decision-making process at strategic levels. It is also the future.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-578ffb51\" data-id=\"578ffb51\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-786e7111 elementor-widget elementor-widget-heading\" data-id=\"786e7111\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Links<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5bb3dbf5 elementor-widget elementor-widget-text-editor\" data-id=\"5bb3dbf5\" 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\t<p><a href=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/DWH.pdf\">Download the data warehouse catalog<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-3e04e91 elementor-section-stretched elementor-section-full_width elementor-section-height-min-height elementor-section-height-default elementor-section-items-middle\" data-id=\"3e04e91\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bd760b9\" data-id=\"bd760b9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-baee2a7 elementor-widget elementor-widget-image\" data-id=\"baee2a7\" 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\t\t\t\t\t\t\t<img decoding=\"async\" width=\"683\" height=\"410\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Data-warehouse.png\" class=\"attachment-full size-full wp-image-6345\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Data-warehouse.png 683w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Data-warehouse-300x180.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-6bb5130 elementor-section-stretched elementor-section-full_width elementor-reverse-mobile elementor-section-height-default elementor-section-height-default\" data-id=\"6bb5130\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-558b46f7\" data-id=\"558b46f7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-34dee9a7 elementor-widget elementor-widget-image\" data-id=\"34dee9a7\" 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\t\t\t\t\t\t\t<img decoding=\"async\" width=\"510\" height=\"353\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0644\u0632\u0648\u0645_\u0628\u0647_\u06a9\u0627\u0631_\u06af\u06cc\u0631\u06cc_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647.png\" class=\"attachment-full size-full wp-image-6289\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0644\u0632\u0648\u0645_\u0628\u0647_\u06a9\u0627\u0631_\u06af\u06cc\u0631\u06cc_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647.png 510w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0644\u0632\u0648\u0645_\u0628\u0647_\u06a9\u0627\u0631_\u06af\u06cc\u0631\u06cc_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647-300x208.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-336956f\" data-id=\"336956f\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-31b746bf elementor-widget elementor-widget-heading\" data-id=\"31b746bf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Necessity of employment<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40eec65c elementor-widget elementor-widget-text-editor\" data-id=\"40eec65c\" 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\t<p>Since performing statistical operations and complex reports have a very heavy workload for the database servers of operational systems, the existence of a data warehouse means that such operations do not affect the activity of the organization&#8217;s application programs (OLTP). By creating a data warehouse, a suitable and stable platform is provided for the preparation of fast, integrated and diverse reports. A data warehouse can be seen as an information database that is kept separately from the operational databases of the organization and is ultimately used by analytical tools.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-67f949e3 elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"67f949e3\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-4e7bb0f1\" data-id=\"4e7bb0f1\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-708b3549 elementor-widget elementor-widget-heading\" data-id=\"708b3549\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Creation steps<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64737550 elementor-widget elementor-widget-text-editor\" data-id=\"64737550\" 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\t<div>In general, the construction of a data warehouse, in the form of a project, includes the following main steps: <\/div>\n<ul>\n<li>Extracting operational data from different databases into a single repository<\/li>\n<li>Expanding and transforming data<\/li>\n<li>Loading the converted data into a database<\/li>\n<li>Generating pre-calculated data values \u200b\u200bto increase reporting speed<\/li>\n<li>Preparation of an analytical reporting tool and business intelligence<\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-49edd2ba\" data-id=\"49edd2ba\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-35be8a6a elementor-widget elementor-widget-image\" data-id=\"35be8a6a\" 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\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"578\" height=\"383\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0645\u0631\u0627\u062d\u0644_\u0627\u06cc\u062c\u0627\u062f_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647.png\" class=\"attachment-large size-large wp-image-6285\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0645\u0631\u0627\u062d\u0644_\u0627\u06cc\u062c\u0627\u062f_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647.png 578w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0645\u0631\u0627\u062d\u0644_\u0627\u06cc\u062c\u0627\u062f_\u0627\u0646\u0628\u0627\u0631_\u062f\u0627\u062f\u0647-300x199.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-5321c897 elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"5321c897\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b50f7af\" data-id=\"b50f7af\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-269c733b elementor-widget elementor-widget-heading\" data-id=\"269c733b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Tools<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fc56690 elementor-widget elementor-widget-text-editor\" data-id=\"3fc56690\" 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\t<div class=\"s-12 l-12\">Due to the fact that the choice of tools to create a data warehouse depends a lot on the type of organization&#8217;s activity and the dependence of processes on each other, for this reason, after the Feasibility Study, the selection of tools to create a data warehouse is done. But generally one of the two tools SQL Server or Oracle are suitable for this part.<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-b1dd15b elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"b1dd15b\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-246e4e60\" data-id=\"246e4e60\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d982525 elementor-widget elementor-widget-heading\" data-id=\"6d982525\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Final tools<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3b0e545b elementor-widget elementor-widget-text-editor\" data-id=\"3b0e545b\" 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\t<div>In order to make data warehouse information available to users, various tools are used in data warehouse architecture, which are called &#8220;final tools&#8221;.<\/div>\n<div> The category of final tools includes the following:<\/div>\n<ul>\n<li>Query and reporting tools<\/li>\n<li>Developed application tools<\/li>\n<li>Executive information systems tools<\/li>\n<li>Simultaneous analytical processing tools<\/li>\n<li>Data mining and analytical tools<\/li>\n<\/ul>\n<div>Most of these tools fall into the category of business intelligence.<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-616977e9\" data-id=\"616977e9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5beee466 elementor-widget elementor-widget-image\" data-id=\"5beee466\" 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\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"303\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Tool-data-warehouse.png\" class=\"attachment-full size-full wp-image-6344\" alt=\"\u0628\u0631\u062a\u0631\u06cc \u06a9\u0644\u06cc\u06a9 \u0648\u06cc\u0648 \u0627\u0632 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631\u0647\u0627\u06cc \u062c\u0627\u0645\u0639 \u062f\u06cc\u06af\u0631\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Tool-data-warehouse.png 415w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Tool-data-warehouse-300x219.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-6efdcf1 elementor-section-stretched elementor-section-full_width elementor-reverse-mobile elementor-section-height-default elementor-section-height-default\" data-id=\"6efdcf1\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-10f71014\" data-id=\"10f71014\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7ca7e8bb elementor-widget elementor-widget-image\" data-id=\"7ca7e8bb\" 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\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1015\" height=\"610\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0647\u062f\u0641_\u0627\u0646\u0628\u0627\u0631\u062f\u0627\u062f\u0647.jpg\" class=\"attachment-full size-full wp-image-6286\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0647\u062f\u0641_\u0627\u0646\u0628\u0627\u0631\u062f\u0627\u062f\u0647.jpg 1015w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0647\u062f\u0641_\u0627\u0646\u0628\u0627\u0631\u062f\u0627\u062f\u0647-300x180.jpg 300w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/\u0647\u062f\u0641_\u0627\u0646\u0628\u0627\u0631\u062f\u0627\u062f\u0647-768x462.jpg 768w\" sizes=\"(max-width: 1015px) 100vw, 1015px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-3ae62a0c\" data-id=\"3ae62a0c\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f313676 elementor-widget elementor-widget-heading\" data-id=\"1f313676\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Purpose and application<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24956f6 elementor-widget elementor-widget-text-editor\" data-id=\"24956f6\" 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\t<div style=\"direction: ltr;\">The primary goal in Data Warehouse architecture is to create a centralized data warehouse with specified and standard definitions. After this stage, analytical reports can be created on the data warehouse using powerful business intelligence tools such as <a title=\"Qlikview\" href=\"https:\/\/nazmaran.com\/en\/qlikview\/\"><strong>QlikView<\/strong><\/a> or other tools such as OLAP-Based. In such a way that after forming a data warehouse and cleaning and collecting data in it, an analytical tool is placed on it and a platform for analytical, statistical, data mining and management dashboards is provided.<\/div><div>The opposite figure shows an overview of the combination of a <a href=\"https:\/\/nazmaran.com\/en\/business-intelligence\/\"><strong>business intelligence<\/strong><\/a> tool with a data warehouse.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-2a5e8583 elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"2a5e8583\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-71a45acf\" data-id=\"71a45acf\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-329f43c8 elementor-widget elementor-widget-heading\" data-id=\"329f43c8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Advantages of using data warehouse<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-182e2805 elementor-widget elementor-widget-text-editor\" data-id=\"182e2805\" 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\t<ul>\n<li>It provides accurate information about the previous and current status of the organization.<\/li>\n<li>It provides an integrated and refined memory for the organization.<\/li>\n<li>It reduces the costs of software development and their integration.<\/li>\n<li>It provides the information of the organization in the form of themes and information from several areas.<\/li>\n<li>It can be used as a platform for analytical, statistical and management tools.<\/li>\n<li>It provides the ability to report and analyze quickly and at low cost.<\/li>\n<li>It enables the transformation of raw and scattered data into integrated and strategic information.<\/li>\n<\/ul>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-72616fd1\" data-id=\"72616fd1\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3a190522 elementor-widget elementor-widget-image\" data-id=\"3a190522\" 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\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"415\" height=\"262\" src=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Advantages.png\" class=\"attachment-full size-full wp-image-6346\" alt=\"\" srcset=\"https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Advantages.png 415w, https:\/\/nazmaran.com\/wp-content\/uploads\/2020\/07\/Advantages-300x189.png 300w\" sizes=\"(max-width: 415px) 100vw, 415px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\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-4e1eefa elementor-section-stretched elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"4e1eefa\" data-element_type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;,&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fb7f910\" data-id=\"fb7f910\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c48578e elementor-widget elementor-widget-heading\" data-id=\"c48578e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">other services<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>The main purpose of creating a data warehouse is to use the data produced and stored by operational systems in the data warehouse and to use them correctly in the decision-making process at strategic levels&#8230;<\/p>\n","protected":false},"author":6,"featured_media":6378,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[235],"tags":[],"class_list":["post-7420","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-services","entry","has-media"],"_links":{"self":[{"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/posts\/7420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/comments?post=7420"}],"version-history":[{"count":1,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/posts\/7420\/revisions"}],"predecessor-version":[{"id":8106,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/posts\/7420\/revisions\/8106"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/media\/6378"}],"wp:attachment":[{"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/media?parent=7420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/categories?post=7420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nazmaran.com\/en\/wp-json\/wp\/v2\/tags?post=7420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}