{"id":15868,"date":"2021-08-12T09:00:00","date_gmt":"2021-08-12T07:00:00","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=15868"},"modified":"2023-06-23T15:28:44","modified_gmt":"2023-06-23T13:28:44","slug":"data-warehouse-implementations-best-practices","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/","title":{"rendered":"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server"},"content":{"rendered":"\t\t\t\t<div class=\"wp-block-uagb-table-of-contents uagb-toc__align-left uagb-toc__columns-1  uagb-block-eba6590b      \"\n\t\t\t\t\tdata-scroll= \"1\"\n\t\t\t\t\tdata-offset= \"30\"\n\t\t\t\t\tstyle=\"\"\n\t\t\t\t>\n\t\t\t\t<div class=\"uagb-toc__wrap\">\n\t\t\t\t\t\t<div class=\"uagb-toc__title\">\n\t\t\t\t\t\t\tTable Of Contents\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"uagb-toc__list-wrap \">\n\t\t\t\t\t\t<ol class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#data-warehouse-definition-and-purposes\" class=\"uagb-toc-link__trigger\">Data Warehouse: Definition and Purposes<\/a><li class=\"uagb-toc__list\"><a href=\"#what-is-microsoft-sql-server\" class=\"uagb-toc-link__trigger\">What is Microsoft SQL Server?\u00a0<\/a><li class=\"uagb-toc__list\"><a href=\"#advanced-guide-to-data-warehouse-implementation\" class=\"uagb-toc-link__trigger\">Advanced Guide to Data Warehouse Implementation<\/a><li class=\"uagb-toc__list\"><a href=\"#tips-of-implementing-data-warehouse-using-ms-sql\" class=\"uagb-toc-link__trigger\">Tips of Implementing Data Warehouse using MS SQL<\/a><ul class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#1-fragment-the-large-fact-tables\" class=\"uagb-toc-link__trigger\">#1 Fragment the Large Fact Tables<\/a><li class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#2-consider-a-right-partition-grain-for-your-data\" class=\"uagb-toc-link__trigger\">#2 Consider a Right Partition Grain for Your Data<\/a><li class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#3-plan-the-effective-dimension-tables\" class=\"uagb-toc-link__trigger\">#3 Plan the Effective Dimension Tables<\/a><li class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#4-use-sliding-window-to-maintain-the-data\" class=\"uagb-toc-link__trigger\">#4 Use Sliding Window to Maintain the Data<\/a><li class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#5-manually-operate-statistics\" class=\"uagb-toc-link__trigger\">#5 Manually Operate Statistics<\/a><\/li><\/ul><\/li><li class=\"uagb-toc__list\"><a href=\"#wrapping-up\" class=\"uagb-toc-link__trigger\">Wrapping Up<\/a><\/ul><\/ol>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\n\n\n<p>At present, companies and organizations from different industries generate massive volumes of data. For any of them, the data storage and deep analysis is a key component of creating a competitive and profitable model of further development.&nbsp;<\/p>\n\n\n\n<p>In such a way it becomes more clear for the entrepreneurs <a href=\"https:\/\/zyro.com\/blog\/how-to-start-an-online-store\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">how to start their business<\/a>, to understand the market trends, and learn more from their competitors.<\/p>\n\n\n\n<p>However, as a Data Scientist you know that collecting and operating big data implies also using powerful technologies for its managing, reporting, and other essential processes. That\u2019s where the data warehouses (DW) can greatly help analytics with the data aggregation, storage, and analysis.&nbsp;&nbsp;<\/p>\n\n\n\n<p>In this article, we will discover how to make the most of your data warehouse using, as an example, Microsoft <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/backend-dev\/sql-server-index-fragmentation\/\" target=\"_blank\" rel=\"noopener\">SQL Servers<\/a>. Similar operations can be conducted with AWS too. Let\u2019s get that covered!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-data-warehouse-definition-and-purposes\">Data Warehouse: Definition and Purposes<\/h2>\n\n\n\n<p>A data warehouse is the large storage of structured data that is driven from multiple sources. In general, that\u2019s the repository where the <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/big-data-analyst\/data-cleaning\/\" target=\"_blank\" rel=\"noopener\">data has been cleansed<\/a>, categorized yet stored in the complex systems.&nbsp;<\/p>\n\n\n\n<p>The historical and current records stored in a DW can be widely used for the forecasting tables and trend reports, thus providing essential information for further business development.<\/p>\n\n\n\n<p>The basic <a href=\"https:\/\/www.n-ix.com\/data-lake-vs-data-warehouse\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">features of a data warehouse<\/a> include:<\/p>\n\n\n\n<ul class=\"is-style-default wp-block-list\">\n<li><strong>Data analytics processes<\/strong>. The DW system provides an extended analysis of the data coming from different sources, including online transaction processing systems, enterprise resource planning systems, customer relationship management, and human resources management systems, etc.&nbsp;<\/li>\n\n\n\n<li><strong>Improved <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/big-data-analyst\/popmon-data-quality-monitoring\/\" target=\"_blank\" rel=\"noopener\">data quality<\/a> and storage<\/strong>. Being extracted from different resources, the DW checks the data integrity and stores it in a unified format.&nbsp;<\/li>\n\n\n\n<li><strong>Data historical comparison<\/strong>. Allows discovering the historical changes of the data by providing detailed info regarding the data comparison via reporting systems.<\/li>\n\n\n\n<li><strong>Easy integration to the other structures<\/strong>. Compliance with uniform data sources allows it to easily fit any type and size of a business.&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>So, a data warehouse is a perfect option for organizations that know exactly what data they are going to work with, what results they want to get with its analysis, and what are the main benefits of this process for their business.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-microsoft-sql-server\">What is Microsoft SQL Server?&nbsp;<\/h2>\n\n\n\n<p>A <a href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/backend-dev\/sql-server-index-fragmentation\/\" target=\"_blank\" rel=\"noopener\">SQL Server<\/a> refers to a relational database system developed by Microsoft company. At present, it is one of the most simple and popular data solutions employed today, as it provides plenty of tools for boosting database development. Because of using various types of database software, a SQL Server by Microsoft includes a relational database engine, that can store various tools for data structuring and analysis, for instance:&nbsp;<\/p>\n\n\n\n<ul class=\"is-style-default wp-block-list\">\n<li>Data in tables, columns, and rows &#8211; just like a standard DW system.<\/li>\n\n\n\n<li>Integration Services (SSIS) &#8211; a data movement tool for importing, exporting, and transforming data.&nbsp;<\/li>\n\n\n\n<li>Reporting Services (SSRS) &#8211; utilized for creating and serving the reports to final consumers.&nbsp;&nbsp;<\/li>\n\n\n\n<li>Analysis Services (SSAS) &#8211; a multidimensional database, employed to query data from the main database engine.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/O7o46LP06PA0ovob93bu1lJBg7NHaB2fbm-Yz71PKRBjRU8QWuOXq3j56_OttBqOw7VUaNnSfgkeSccrH5g6BoPlMCsRxKZlcrinb-Jbk_lKmCet3x7DWiRhJo7QYhwZ4w1OkQby\" alt=\"A diagram of Microsoft SQL Server functionalities.\"\/><figcaption class=\"wp-element-caption\">Source: <a href=\"https:\/\/www.atlantic.net\" target=\"_blank\" aria-label=\"Atlantic (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"ek-link\">Atlantic<\/a><\/figcaption><\/figure>\n\n\n\n<p>The system works with the assistance of several extracting, transforming, and loading tools, various reporting services where data can be added, modified, and queried. And, because these processes are performed using a standardized structured query language (SQL), it has got the name of MS SQL server.<\/p>\n\n\n\n<p>As a rule, the platform works with various types of data analysis to provide the essential data solutions for business on-premise, in the cloud, and on hybrid platforms as well.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-advanced-guide-to-data-warehouse-implementation\">Advanced Guide to Data Warehouse Implementation<\/h2>\n\n\n\n<p>After you\u2019re ready to employ a data warehouse in your business, it\u2019s time to start planning the implementation process. Here are the simple yet effective steps for it:&nbsp;<\/p>\n\n\n\n<ol class=\"is-style-default wp-block-list\">\n<li>Get clear business objectives from your CEO and other stakeholders: analytics, <a class=\"wpil_keyword_link\" href=\"https:\/\/www.codemotion.com\/magazine\/dev-hub\/cto\/how-to-become-cto\/\" target=\"_blank\" rel=\"noopener\" title=\"CTO\" data-wpil-keyword-link=\"linked\">CTO<\/a>, decision-makers, legal and compliance experts.&nbsp;&nbsp;<\/li>\n\n\n\n<li>Choose an effective warehouse environment. This step requires selecting the warehouse environment that works best for your project: on-premise (hosts on local hardware), public cloud (managed using a hosted cloud services like AWS or Azure), private cloud (hosted on your own hardware or authoritative third party), or hybrid cloud (a cloud that combines the functions mentioned above)<\/li>\n\n\n\n<li>Create at least 3 separate environments for your data warehouse, that cover Development (launch new projects, develop various features, hold test data), Testing (QA and basic testing, UX\/UI improving), and Production (accessed by users and your <a aria-label=\" (opens in a new tab)\" href=\"https:\/\/capturly.com\/features\/analytics-platform\" target=\"_blank\" rel=\"noreferrer noopener\" class=\"ek-link\">analytics team<\/a>, is critical to check the changes before its final release) sections.&nbsp;<\/li>\n\n\n\n<li>Determine the data model &#8211; a single warehouse schema that suits all the existed data, can easily fit the incoming data, and also can easily scale up for the future. The basic data model schemas are usually introduced by: star type (the fact tables with dimensional tables linked), snowflake type (the similar to a star schema, complemented by the additional level of the dimensional tables), galaxy type (the multiple fact tables, that are connected by the common dimensional tables) and constellation type (similar to galaxy type with the additional schemes of dimensional tables). Any of these types of data model schemas can be adapted to the business objectives and needs of a data scientist.&nbsp;<\/li>\n\n\n\n<li>Upload the sources to a data warehouse &#8211; that step requires completing 2 different processes. Firstly, it\u2019s needed to extract the data from your current data source (using the API call, file transfer systems, or via the direct SQL query). Secondly, the data obtained from the source should be loaded into the data warehouse. Automated once, that process is also called a data pipeline.&nbsp;<\/li>\n\n\n\n<li>Convert the incoming data using the ETL transformation to make sure the data will slot correctly into the destination tables. Additionally, that process can include the data validation, cleansing, harmonization, and enrichment before it is fully transferred to the destination schema.&nbsp;<\/li>\n\n\n\n<li>Create data marts &#8211; the limited sections within the data warehouse that can show the relevant results for certain users. This can help not only to improve the warehouse performance but also to improve data security.<\/li>\n\n\n\n<li>Configure and employ the business intelligence and analytics tools to get the results faster and receive better insights and visualizations. With this employed, you can enable 3 main options for your analytics team: a) detailed analytics due to a large amount of data; b) quick performance for the real-time dashboards; c) high-quality of the data, that accurately describes the picture of the current state.&nbsp;<\/li>\n\n\n\n<li>Regularly audit and review your data warehouse contents to ensure there are no issues between the raw and stored data. The best practice here is to use the automated data testing tools like Bitwise QualiDI, Codoid, and others.&nbsp;<\/li>\n<\/ol>\n\n\n\n<p>[jwp-video n=&#8221;1&#8243;]<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-tips-of-implementing-data-warehouse-using-ms-sql\">Tips of Implementing Data Warehouse using MS SQL<\/h2>\n\n\n\n<p>If you\u2019re considering designing a data warehouse, the MS SQL server can easily assist you in building an effective large-scale relational data warehouse. Here are the top suggestions offered by the Microsoft team for making the most of your data warehouse system.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-fragment-the-large-fact-tables\">#1 Fragment the Large Fact Tables<\/h3>\n\n\n\n<p>The so-called partitioning of the large fact tables can significantly enhance the performance benefits and data managing of your DW system.&nbsp;<\/p>\n\n\n\n<p>By fragmenting the tables with the size of about 50 GB, you will get better data loading and deleting more flexible restoning and backup options. According to experts, a typical partition should be based on the date key.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-consider-a-right-partition-grain-for-your-data\">#2 Consider a Right Partition Grain for Your Data<\/h3>\n\n\n\n<p>To make the most of your SQL Server, you should choose the partition key really carefully, as it affects the overall data managing process. For instance, it can affect query parallelism, loading speed, and segment editing or deleting.&nbsp;<\/p>\n\n\n\n<p>As a rule, customers used to choose the time grains for the data fragmentation: month, quarter, or year.&nbsp;&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-plan-the-effective-dimension-tables\">#3 Plan the Effective Dimension Tables<\/h3>\n\n\n\n<p>Instead of using the Date dimension, we recommend trying the integer surrogate keys. It is better to use the smallest possible integer for the dimension surrogate keys as it keeps the fact table narrow.&nbsp;<\/p>\n\n\n\n<p>Instead of inputting the data, make a meaningful data key that can be easily gotten from the actual date (for example 20210713 instead of 2021\/07\/13, etc.).<\/p>\n\n\n\n<p>Avoid partitioning dimension tables, as it can influence the analysis quality.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-use-sliding-window-to-maintain-the-data\">#4 Use Sliding Window to Maintain the Data<\/h3>\n\n\n\n<p>Use a rolling time window for loading the newest data of the fact tables. Additionally, make sure to have the empty partitions at both ends of a data fragment, to make sure the partition split (before the new data loading) and merge (after the old data is unloaded) will not change the data itself.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-manually-operate-statistics\">#5 Manually Operate Statistics<\/h3>\n\n\n\n<p>To optimize the data management for Data Warehouse using MS SQL, experts suggest manually updating the stats on the large fact tables after the new data is uploaded to the system. Additionally, optimize the queries which should read only the fresh-loaded data.<\/p>\n\n\n\n<p>For getting a more accurate analysis of the query, feel free to use the FULLSCAN option on the stats updating for the dimension tables.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-wrapping-up\">Wrapping Up<\/h2>\n\n\n\n<p>Data Warehouse implementation is now a must-have for storing and sourcing the data for the SQL Server&#8217;s further functioning. Various tools included in the database software allows effective data managing, adding, modifying, and querying.&nbsp;<\/p>\n\n\n\n<p>So, if you\u2019re still doubting whether it\u2019s worth getting &#8211; just give it a shot!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At present, companies and organizations from different industries generate massive volumes of data. For any of them, the data storage and deep analysis is a key component of creating a competitive and profitable model of further development.&nbsp; In such a way it becomes more clear for the entrepreneurs how to start their business, to understand&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/\">Read more<\/a><\/p>\n","protected":false},"author":123,"featured_media":16685,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[8457],"tags":[],"collections":[],"class_list":{"0":"post-15868","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-data-science","8":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Best Practices for Data Warehouse Implementation<\/title>\n<meta name=\"description\" content=\"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server\" \/>\n<meta property=\"og:description\" content=\"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/\" \/>\n<meta property=\"og:site_name\" content=\"Codemotion Magazine\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Codemotion.Italy\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-12T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-23T13:28:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"540\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vanessa Friedman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:site\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vanessa Friedman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/\"},\"author\":{\"name\":\"Vanessa Friedman\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/5c61b3f1f025b3e0e2fe3b22e7472c85\"},\"headline\":\"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server\",\"datePublished\":\"2021-08-12T07:00:00+00:00\",\"dateModified\":\"2023-06-23T13:28:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/\"},\"wordCount\":1570,\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cloud-computing-2001090_960_720.jpg\",\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/\",\"name\":\"Best Practices for Data Warehouse Implementation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cloud-computing-2001090_960_720.jpg\",\"datePublished\":\"2021-08-12T07:00:00+00:00\",\"dateModified\":\"2023-06-23T13:28:44+00:00\",\"description\":\"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cloud-computing-2001090_960_720.jpg\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/cloud-computing-2001090_960_720.jpg\",\"width\":960,\"height\":540},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/data-science\\\/data-warehouse-implementations-best-practices\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Science\",\"item\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/ai-ml\\\/data-science\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\",\"name\":\"Codemotion Magazine\",\"description\":\"We code the future. Together\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\",\"name\":\"Codemotion\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/codemotionlogo.png\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/codemotionlogo.png\",\"width\":225,\"height\":225,\"caption\":\"Codemotion\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Codemotion.Italy\\\/\",\"https:\\\/\\\/x.com\\\/CodemotionIT\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/5c61b3f1f025b3e0e2fe3b22e7472c85\",\"name\":\"Vanessa Friedman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g\",\"caption\":\"Vanessa Friedman\"},\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/author\\\/vanessa-friedman\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Best Practices for Data Warehouse Implementation","description":"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.","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:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/","og_locale":"en_US","og_type":"article","og_title":"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server","og_description":"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.","og_url":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2021-08-12T07:00:00+00:00","article_modified_time":"2023-06-23T13:28:44+00:00","og_image":[{"width":960,"height":540,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg","type":"image\/jpeg"}],"author":"Vanessa Friedman","twitter_card":"summary_large_image","twitter_creator":"@CodemotionIT","twitter_site":"@CodemotionIT","twitter_misc":{"Written by":"Vanessa Friedman","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/"},"author":{"name":"Vanessa Friedman","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/5c61b3f1f025b3e0e2fe3b22e7472c85"},"headline":"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server","datePublished":"2021-08-12T07:00:00+00:00","dateModified":"2023-06-23T13:28:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/"},"wordCount":1570,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg","articleSection":["Data Science"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/","url":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/","name":"Best Practices for Data Warehouse Implementation","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg","datePublished":"2021-08-12T07:00:00+00:00","dateModified":"2023-06-23T13:28:44+00:00","description":"A Data Warehouse is necessary for companies to do data aggregation, storage and analysis. Learn the best practices for SW implementation.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg","width":960,"height":540},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/data-science\/data-warehouse-implementations-best-practices\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.codemotion.com\/magazine\/"},{"@type":"ListItem","position":2,"name":"Data Science","item":"https:\/\/www.codemotion.com\/magazine\/ai-ml\/data-science\/"},{"@type":"ListItem","position":3,"name":"Becoming a Data Scientist: Best Practices for Data Warehouse Implementation with Microsoft SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.codemotion.com\/magazine\/#website","url":"https:\/\/www.codemotion.com\/magazine\/","name":"Codemotion Magazine","description":"We code the future. Together","publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.codemotion.com\/magazine\/#organization","name":"Codemotion","url":"https:\/\/www.codemotion.com\/magazine\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","width":225,"height":225,"caption":"Codemotion"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Codemotion.Italy\/","https:\/\/x.com\/CodemotionIT"]},{"@type":"Person","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/5c61b3f1f025b3e0e2fe3b22e7472c85","name":"Vanessa Friedman","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1caabb5d64eeb9b6d7af83f53630b489c3570428e9a7fe1b3c7acfda33ed38e1?s=96&d=mm&r=g","caption":"Vanessa Friedman"},"url":"https:\/\/www.codemotion.com\/magazine\/author\/vanessa-friedman\/"}]}},"featured_image_src":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-600x400.jpg","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-600x540.jpg","author_info":{"display_name":"Vanessa Friedman","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/vanessa-friedman\/"},"uagb_featured_image_src":{"full":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg",960,540,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-150x150.jpg",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-300x169.jpg",300,169,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-768x432.jpg",768,432,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg",960,540,false],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg",960,540,false],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg",960,540,false],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720.jpg",100,56,false],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-180x128.jpg",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-896x504.jpg",896,504,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-400x225.jpg",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-600x400.jpg",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2021\/08\/cloud-computing-2001090_960_720-600x540.jpg",600,540,true]},"uagb_author_info":{"display_name":"Vanessa Friedman","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/vanessa-friedman\/"},"uagb_comment_info":0,"uagb_excerpt":"At present, companies and organizations from different industries generate massive volumes of data. For any of them, the data storage and deep analysis is a key component of creating a competitive and profitable model of further development.&nbsp; In such a way it becomes more clear for the entrepreneurs how to start their business, to understand&#8230;&hellip;","lang":"en","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/15868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/users\/123"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/comments?post=15868"}],"version-history":[{"count":6,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/15868\/revisions"}],"predecessor-version":[{"id":21573,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/15868\/revisions\/21573"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/16685"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=15868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=15868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=15868"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=15868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}