The Informed Company. Dave Fowler
Чтение книги онлайн.

Читать онлайн книгу The Informed Company - Dave Fowler страница 2

Название: The Informed Company

Автор: Dave Fowler

Издательство: John Wiley & Sons Limited

Жанр: Маркетинг, PR, реклама

Серия:

isbn: 9781119748014

isbn:

СКАЧАТЬ 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

      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 СКАЧАТЬ