Star Schema The Complete Reference
()
About this ebook
Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts.
This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology.
- Master the fundamentals of star schema design and slow change processing
- Identify situations that call for multiple stars or cubes
- Ensure compatibility across subject areas as your data warehouse grows
- Accommodate repeating attributes, recursive hierarchies, and poor data quality
- Support conflicting requirements for historic data
- Handle variation within a business process and correlation of disparate activities
- Boost performance using derived schemas and aggregates
- Learn when it's appropriate to adjust designs for BI and ETL tools
Related to Star Schema The Complete Reference
Related ebooks
The Data Model Resource Book: Volume 3: Universal Patterns for Data Modeling Rating: 0 out of 5 stars0 ratingsAzure Data Factory A Complete Guide - 2020 Edition Rating: 0 out of 5 stars0 ratingsModelling Business Information: Entity relationship and class modelling for Business Analysts Rating: 0 out of 5 stars0 ratingsDatabase Management for Business Leaders: Building and Using Data Solutions That Work for You Rating: 0 out of 5 stars0 ratingsBuilding a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Data Modeling Essentials Rating: 4 out of 5 stars4/5Data Mapping for Data Warehouse Design Rating: 5 out of 5 stars5/5DW 2.0: The Architecture for the Next Generation of Data Warehousing Rating: 4 out of 5 stars4/5Business Metadata: Capturing Enterprise Knowledge Rating: 4 out of 5 stars4/5Developing High Quality Data Models Rating: 0 out of 5 stars0 ratingsData Quality: The Accuracy Dimension Rating: 4 out of 5 stars4/5Data Warehousing in the Age of Big Data Rating: 0 out of 5 stars0 ratingsMaster Data Management Rating: 4 out of 5 stars4/5Data Stewardship: An Actionable Guide to Effective Data Management and Data Governance Rating: 3 out of 5 stars3/5Executing Data Quality Projects: Ten Steps to Quality Data and Trusted Information<sup>TM</sup> Rating: 3 out of 5 stars3/5Data Virtualization for Business Intelligence Systems: Revolutionizing Data Integration for Data Warehouses Rating: 4 out of 5 stars4/5Data Governance: How to Design, Deploy and Sustain an Effective Data Governance Program Rating: 4 out of 5 stars4/5Microsoft Tabular Modeling Cookbook Rating: 0 out of 5 stars0 ratingsData Architecture: From Zen to Reality Rating: 4 out of 5 stars4/5Data warehouse Complete Self-Assessment Guide Rating: 4 out of 5 stars4/5MDM for Customer Data: Optimizing Customer Centric Management of Your Business Rating: 0 out of 5 stars0 ratingsThe Data Governance Imperative Rating: 0 out of 5 stars0 ratingsTabular Modeling with SQL Server 2016 Analysis Services Cookbook Rating: 4 out of 5 stars4/5Business Intelligence Guidebook: From Data Integration to Analytics Rating: 4 out of 5 stars4/5The Data and Analytics Playbook: Proven Methods for Governed Data and Analytic Quality Rating: 5 out of 5 stars5/5The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling Rating: 0 out of 5 stars0 ratingsAgile Data Warehousing for the Enterprise: A Guide for Solution Architects and Project Leaders Rating: 0 out of 5 stars0 ratingsDatabase Design: Know It All Rating: 5 out of 5 stars5/5DAX Patterns: Second Edition Rating: 5 out of 5 stars5/5
Databases For You
Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Serverless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing Rating: 0 out of 5 stars0 ratingsJoe Celko's SQL Programming Style Rating: 4 out of 5 stars4/5Codeless Data Structures and Algorithms: Learn DSA Without Writing a Single Line of Code Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsGo in Action Rating: 5 out of 5 stars5/5Practical Data Analysis Rating: 4 out of 5 stars4/5Mastering the Microsoft Deployment Toolkit Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Access 2016 For Dummies Rating: 0 out of 5 stars0 ratingsCOMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsA Concise Guide to Object Orientated Programming Rating: 0 out of 5 stars0 ratingsAccess 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5Access 2019 For Dummies Rating: 0 out of 5 stars0 ratingsBeginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsBig Data Forensics – Learning Hadoop Investigations Rating: 0 out of 5 stars0 ratingsThe Visual Imperative: Creating a Visual Culture of Data Discovery Rating: 4 out of 5 stars4/5Data Science Strategy For Dummies Rating: 0 out of 5 stars0 ratingsVisualizing Graph Data Rating: 0 out of 5 stars0 ratingsThe SQL Workshop: Learn to create, manipulate and secure data and manage relational databases with SQL Rating: 0 out of 5 stars0 ratingsPython and SQLite Development Rating: 0 out of 5 stars0 ratingsBusiness Intelligence Guidebook: From Data Integration to Analytics Rating: 4 out of 5 stars4/5Data Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5Implementing Cloud Design Patterns for AWS Rating: 0 out of 5 stars0 ratingsMeasuring Data Quality for Ongoing Improvement: A Data Quality Assessment Framework Rating: 5 out of 5 stars5/5
Reviews for Star Schema The Complete Reference
0 ratings0 reviews