{"product_id":"the-informed-company-9781119748007","title":"The Informed Company","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eLearn how to manage a modern data stack and get the most out of data in your organization!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThanks to the emergence of new technologies and the explosion of data in recent years, we need new practices for managing and getting value out of data. In the modern, data driven competitive landscape the best guess approachreading blog posts here and there and patching together data practices without any real visibilityis no longer going to hack it. \u003ci\u003eThe Informed Company\u003c\/i\u003e provides definitive direction on how best to leverage the modern data stack, including cloud computing, columnar storage, cloud ETL tools, and cloud BI tools. You''ll learn how to work with Agile methods and set up processes that''s right for your company to use your data as a key weapon for your success . . . You''ll discover best practices for every stage, from querying production databases at a small startup all the way to setting up data marts for different business lines of an enterprise.\u003c\/p\u003e \u003cp\u003eIn t\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eAbout This Book xiii\u003c\/p\u003e \u003cp\u003eForeword xxi\u003c\/p\u003e \u003cp\u003eIntroduction xxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003eStage 1 Source (aka Siloed Data) 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Starting with Source Data 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eCommon Options for Analyzing Source Data 4\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 The Need to Replicate Source Data 11\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReplicate Sources 12\u003c\/p\u003e \u003cp\u003eCreate Read-Only Access 14\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Source Data Best Practices 15\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eKeep a Complexity Wiki Page 15\u003c\/p\u003e \u003cp\u003eSnippet Dictionary 16\u003c\/p\u003e \u003cp\u003eUse a BI Product 17\u003c\/p\u003e \u003cp\u003eDouble Check Results 18\u003c\/p\u003e \u003cp\u003eKeep Short Dashboards 19\u003c\/p\u003e \u003cp\u003eDesign Before Building 20\u003c\/p\u003e \u003cp\u003e\u003cb\u003eStage 2 Data Lake (aka Data Combined) 23\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Why Build a Data Lake? 25\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is a Data Lake? 26\u003c\/p\u003e \u003cp\u003eReasons to Build a Data Lake Summarized 27\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Choosing an Engine for the Data Lake 33\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eModern Columnar Warehouse Engines 35\u003c\/p\u003e \u003cp\u003eModern Warehouse Engine Products 38\u003c\/p\u003e \u003cp\u003eDatabase Engines 41\u003c\/p\u003e \u003cp\u003eRecommendation 42\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Extract and Load (EL) Data 45\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eETL versus ELT 46\u003c\/p\u003e \u003cp\u003eEL\/ETL Vendors 48\u003c\/p\u003e \u003cp\u003eExtract Options 49\u003c\/p\u003e \u003cp\u003eLoad Options 51\u003c\/p\u003e \u003cp\u003eMultiple Schemas 52\u003c\/p\u003e \u003cp\u003eOther Extract and Load Routes 53\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Data Lake Security 55\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAccess in Central Place 56\u003c\/p\u003e \u003cp\u003ePermission Tiers 57\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Data Lake Maintenance 59\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhy SQL? 60\u003c\/p\u003e \u003cp\u003eData Sources 61\u003c\/p\u003e \u003cp\u003ePerformance 64\u003c\/p\u003e \u003cp\u003eUpgrade Snippets to Views 68\u003c\/p\u003e \u003cp\u003e\u003cb\u003eStage 3 Data Warehouse (aka the Single Source of Truth) 69\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 The Power of Layers and Views 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMake Readable Views 77\u003c\/p\u003e \u003cp\u003eLayer Views on Views 78\u003c\/p\u003e \u003cp\u003eStart with a Single View 81\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Staging Schemas 83\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOrient to the Schemas 84\u003c\/p\u003e \u003cp\u003ePick a Table and Clean It 85\u003c\/p\u003e \u003cp\u003eOther Staging Modeling Considerations 98\u003c\/p\u003e \u003cp\u003eBuilding on Top of Staging Schemas 106\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Model Data with dbt 111\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eVersion Control 111\u003c\/p\u003e \u003cp\u003eModularity and Reusability 112\u003c\/p\u003e \u003cp\u003ePackage Management 112\u003c\/p\u003e \u003cp\u003eOrganizing Files 113\u003c\/p\u003e \u003cp\u003eMacros 113\u003c\/p\u003e \u003cp\u003eIncremental Tables 114\u003c\/p\u003e \u003cp\u003eTesting 115\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Deploy Modeling Code 119\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBranch Using Version Control Software 119\u003c\/p\u003e \u003cp\u003eCommit Message 120\u003c\/p\u003e \u003cp\u003eTest Locally 120\u003c\/p\u003e \u003cp\u003eCode Review 121\u003c\/p\u003e \u003cp\u003eSchedule Runs 122\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Implementing the Data Warehouse 123\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManage Dependencies 124\u003c\/p\u003e \u003cp\u003eCombine Tables Within Schemas 126\u003c\/p\u003e \u003cp\u003eCombine Tables Across Schemas 128\u003c\/p\u003e \u003cp\u003eKeep the Grain Consistent 130\u003c\/p\u003e \u003cp\u003eCreate Business Metrics 131\u003c\/p\u003e \u003cp\u003eKeeping Accurate History 133\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Managing Data Access 135\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eHow to Secure Sensitive Data in the Data Warehouse 137\u003c\/p\u003e \u003cp\u003eHow to Secure Sensitive Data in a BI Tool 140\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Maintaining the Source of Truth 143\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTrack New Metrics 144\u003c\/p\u003e \u003cp\u003eDeprecate Old Metrics 147\u003c\/p\u003e \u003cp\u003eDeprecate Old Schemas 149\u003c\/p\u003e \u003cp\u003eResolve Conflicting Numbers 150\u003c\/p\u003e \u003cp\u003eHandling Ongoing Requests and Ongoing Feedback 151\u003c\/p\u003e \u003cp\u003eUpdating Modeling Code 152\u003c\/p\u003e \u003cp\u003eManage Access 153\u003c\/p\u003e \u003cp\u003eTuning to Optimize 156\u003c\/p\u003e \u003cp\u003eCode Review All Modeling 157\u003c\/p\u003e \u003cp\u003eMaintenance Checklist 158\u003c\/p\u003e \u003cp\u003e\u003cb\u003eStage 4 Data Marts (aka Data Democratized) 161\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Data Mart Implementation 167\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eViews on the Data Warehouse 167\u003c\/p\u003e \u003cp\u003eSegment Tables 168\u003c\/p\u003e \u003cp\u003eAccess Update 169\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17 Data Mart Maintenance 171\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eEducate Team 172\u003c\/p\u003e \u003cp\u003eIdentifies Issues 172\u003c\/p\u003e \u003cp\u003eIdentify New Needs 176\u003c\/p\u003e \u003cp\u003eHelp Track Success 176\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18 Modern versus Traditional Data Stacks: What’s Changed? 177\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat’s Changed? 177\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19 Row-versus\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eColumn-Oriented\u003c\/p\u003e \u003cp\u003eDatabase 181\u003c\/p\u003e \u003cp\u003eRow-Oriented\u003c\/p\u003e \u003cp\u003eDatabases 182\u003c\/p\u003e \u003cp\u003eColumn-Oriented\u003c\/p\u003e \u003cp\u003eDatabases 184\u003c\/p\u003e \u003cp\u003eSummary 190\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20 Style Guide Example 191\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSimplify 192\u003c\/p\u003e \u003cp\u003eClean 194\u003c\/p\u003e \u003cp\u003eNaming Conventions 195\u003c\/p\u003e \u003cp\u003eShare It 197\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21 Building an SST Example 199\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFirst Attempt—Same Tables with Prefixes 199\u003c\/p\u003e \u003cp\u003eSecond Attempt—Operational Schema (Source Agnostic) 205\u003c\/p\u003e \u003cp\u003eThird Attempt—Application Separate, Other Sources Smashed 207\u003c\/p\u003e \u003cp\u003eLess Planning, More Implementing 209\u003c\/p\u003e \u003cp\u003eAcknowledgments and Contributions 211\u003c\/p\u003e \u003cp\u003eIndex 213\u003c\/p\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":48866414199127,"sku":"9781119748007","price":17.84,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119748007.jpg?v=1722278526","url":"https:\/\/bookcurl.com\/products\/the-informed-company-9781119748007","provider":"Book Curl","version":"1.0","type":"link"}