Agile Data Warehouse Design
by Lawrence Corr, Jim Stagnitto · DecisionOne Press
Introduces BEAM (Business Event Analysis and Modeling), a collaborative method for gathering data warehouse requirements with stakeholders using the 7Ws and modelstorming. Readers learn to turn business events into star schemas and conformed dimensional models iteratively.
This link may earn us a small commission at no extra cost to you. Affiliate disclosure
More resources on Data Modeling
vertabelo.com
Vertabelo is an online data modeling and database design platform that lets you create and visualize ER diagrams, design schemas, and generate SQL code. It also offers tutorials, articles, and resources on database design best practices for learners and professionals.
Understand Star Schema and the Importance for Power BI
Microsoft guidance on shaping Power BI semantic models as star schemas with fact and dimension tables. Covers surrogate keys, snowflaking, role-playing, slowly changing, junk and degenerate dimensions, and factless fact tables for many-to-many relationships, so models perform well and totals stay correct.
Data Modeling Essentials
Graeme Simsion and Graham Witt's widely used text on conceptual, logical and physical data modeling. Covers normalization, entity-relationship notation, business rules and quality criteria, so readers can design and critique relational models that reflect real business requirements.
The Data Model Resource Book
A library of reusable logical data models for functions common to most businesses, including parties, products, orders, shipments, invoicing, work efforts and accounting, plus matching data warehouse designs, so modelers can adapt proven patterns instead of starting from scratch.
datamodel.com
Datamodel.com is a resource hub for data modeling, offering tutorials, articles, and practical examples on database design, data architecture, and modeling techniques.
SQLShack
Free article library started by ApexSQL, written by SQL Server professionals, covering T-SQL, indexing, query tuning, backup and recovery, high availability, auditing and SSIS. Readers can follow step-by-step examples to administer, secure and tune SQL Server instances.