1 min read
AI-Assisted Data Modeling: Accelerating Schema Design
AI-assisted modeling reduces design time while improving schema quality.
Data Modeling
9 articles
1 min read
AI-Assisted Data Modeling: From Requirements to Schema
AI-assisted data modeling accelerates the initial design phase but doesn't replace expertise. Use it to generate options quickly, then apply your domain…
1 min read
Graph Database Fundamentals for Azure Developers
Graph databases unlock powerful relationship-based queries that would be complex or impossible with traditional relational approaches.
1 min read
Hierarchical Partition Keys in Azure Cosmos DB
Traditional single partition keys can lead to hot partitions in scenarios where data is naturally hierarchical. Hierarchical partition keys solve this by…
1 min read
Sharding Strategies for Distributed PostgreSQL
The distribution column (also called the shard key) determines how data is partitioned across nodes. Citus uses consistent hashing on this column to assign…
1 min read
Power BI Hybrid Tables: Real-Time Meets Historical
Hybrid tables provide the perfect balance between real-time data freshness and historical data performance.
1 min read
Power BI Composite Models: The Best of Both Worlds
Composite models let you use both in the same dataset. Composite models unlock new scenarios in Power BI, enabling enterprise-scale analytics with the…
1 min read
Dataverse Tables - Data Modeling for the Power Platform
Tables you create for your specific business needs. Connect to external data sources without importing data.
1 min read
Azure Analysis Services for Enterprise Semantic Models
A semantic model sits between raw data and end user tools, providing: Business friendly names and descriptions Calculated measures and KPIs Row level…