Locally
Code Review
Schedule Runs
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
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
