A software architect's humorous account of a client derailing a professional Power BI dashboard project with a chaotic, self-built data model.
A recap of AWS re:Invent 2024 Day 3, covering sessions on advanced DynamoDB data modeling and key AI/Data announcements from Amazon Bedrock.
Argues against using LLMs to generate SQL queries for novel business questions, highlighting the importance of human analysts for precision.
A guide on how to model and calculate DynamoDB costs during the design phase to make informed architectural decisions.
Analyzing the compatibility of GraphQL with DynamoDB's single-table design, discussing trade-offs and when each approach is preferable.
A technical guide to modeling one-to-one, one-to-many, and many-to-many relationships in MongoDB using the Mongoose ODM in Node.js.
An introductory guide to database fundamentals, covering data design, relationships, and types of databases for application development.
A deep dive into DynamoDB partitions, explaining their role in data modeling and performance for the NoSQL database.
A guide to advanced data modeling in Amazon DynamoDB, covering access patterns, single-table design, and filtering strategies.
Key takeaways from a talk on Amazon DynamoDB data modeling, covering primary keys, access patterns, and single-table design strategies.
A guide to designing a data model for a Django survey application, covering models for Survey, Question, Option, and Submission.
A deep dive into single-table design for DynamoDB, covering its concepts, benefits, and trade-offs for scalable applications.
Explains DynamoDB filter expressions, their limitations, and when to use them versus proper table design for efficient queries.
A technical guide on splitting delimited text into a table using DAX functions like PATH, GENERATESERIES, and PATHITEM for Power BI data modeling.
A guide on creating a Power BI Push Dataset using Power BI Desktop and the PowerBIPS.Tools module to simplify API dataset creation.
