The Informed Company. Dave Fowler

Chapter Thirteen: Implementing the Data Warehouse Manage Dependencies Combine Tables Within Schemas Combine Tables Across Schemas Keep the Grain Consistent Create Business Metrics Keeping Accurate History Chapter Fourteen: Managing Data Access How to Secure Sensitive Data in the Data Warehouse How to Secure Sensitive Data in a BI Tool Chapter Fifteen: Maintaining the Source of Truth Track New Metrics Deprecate Old Metrics Deprecate Old Schemas Resolve Conflicting Numbers Handling Ongoing Requests and Ongoing Feedback Updating Modeling Code Manage Access Tuning to Optimize Code Review All Modeling Maintenance Checklist

      11  STAGE 4: DATA MARTS aka Data Democratized Chapter Sixteen: Data Mart Implementation Views on the Data Warehouse Segment Tables Access Update Chapter Seventeen: Data Mart Maintenance Educate Team Identifies Issues Identify New Needs Help Track Success Chapter Eighteen: Modern versus Traditional Data Stacks: What's Changed? What's Changed? Chapter Nineteen: Row‐ versus Column‐Oriented Database Row‐Oriented Databases Column‐Oriented Databases Summary Chapter Twenty: Style Guide Example Simplify Clean Naming Conventions Share It Chapter Twenty-One: Building an SST Example First Attempt—Same Tables with Prefixes Second Attempt—Operational Schema (Source Agnostic) Third Attempt—Application Separate, Other Sources Smashed Less Planning, More Implementing

      12  Acknowledgments and Contributions Thank‐yous

      13  Index

      14  End User License Agreement

      List of Tables

      1 Chapter 5TABLE 5.1 Selection Factors

      2 Chapter 10TABLE 10.1 FriendsTABLE 10.2TABLE 10.3TABLE 10.4

      3 Chapter 13TABLE 13.1 OrdersTABLE 13.2TABLE 13.3TABLE 13.4TABLE 13.5

      4 Chapter 19TABLE 19.1 Facebook_FriendsTABLE 19.2TABLE 19.3TABLE 19.4TABLE 19.5TABLE 19.6TABLE 19.7 Facebook_FriendsTABLE 19.8TABLE 19.9TABLE 19.10TABLE 19.11TABLE 19.12TABLE 19.13TABLE 19.13

      5 Chapter 21TABLE 21.1 Duplicate Records by Email

      List of Illustrations

      1 About This BookFigure A.1 Data management is a collaborative process.Figure A.2

      2 IntroductionFigure I.1 Business context vs technical know how chart.Figure I.2 The four stages of agile data organization represent a process th...

      3 Chapter 1Figure 1.1 Various methods for data analysis for data sources.Figure 1.2 Example built in dashboard showing common metrics from Zendesk....Figure 1.3 A basic export feature on a web services dashboard providing a CS...Figure 1.4 pgAdmin dashboard is a popular IDE for PostgreSQL.Figure 1.5 Geckoboard like dashboard displaying standard sales metrics.Figure 1.6 Mixpanel cohort analysis.Figure 1.7 Chartio Dashboard Executive Summary of Sales Metrics.

      4 Chapter 2Figure 2.1 A production system should be used with care.Figure 2.2 A cloned data source with read‐only access.Figure 2.3 It is dangerous to use a production system for non production pur...

      5 Chapter 3Figure 3.1 Using an SQL file in an editor to manage dashboard metrics.Figure 3.2 A custom SQL building feature, "Visual SQL" from Chartio.Figure 3.3 A very long dashboard.Figure 3.4 A simple dashboard outline.Figure 3.5 The book cover for How to Design a Dashboard, by Matt David.

      6 Chapter