Welcome to Practical Data Modeling! Whether you're a beginner or an experienced data professional interested in leveling up your data modeling, we will help you take your skills to the next level.
| Platform |  | Pricing | Freemium | Publishes | Twice weekly |
|---|---|---|---|---|---|
| Issues | 118 | Founded | 4 years ago | Last Issue | 9 days ago |
| Active | |||||
Read this Newsletter
practicaldatamodeling.substack.comLatest Issues
Week 3 - Counting Tickets Without Counting Them Twice
Read Chapters 7–9, printed pages 125–193: Relationships: Tying It Together; Grain: Choosing Your Level of Detail; Counting and Aggregation: Controlling the Grain.
One support ticket mentions two products and contains ten chat messages. Joi...
Week 2 - Recognizing the Same Ticket in Different Forms of Data
Read Chapters 4–6, printed pages 63–124: Beyond Rows and Columns: The Five Forms of Data; Entities, Instances, and Identifiers: Naming What You Model; Attributes: Describing the Entity.
A customer emails support, starts a chat, and eventua...
Fan-Out: Why Your Dashboard Counts Customers Twice
Say a SaaS company builds a “Customer Health” dashboard. The query joins three tables: Customers (one row per customer), Subscriptions (one row per active subscription), and Support Tickets (one row per ticket). A customer can have multiple...
Week 1 - Choosing a Data Modeling Approach That Fits the Problem
Assignment: Read Chapters 1–3: The Dawn of Mixed Model Arts, What Data Modeling Is (and Isn’t), Why Data Modeling Matters.
You’ve probably been here, or experienced a version of this problem. A support application can work perfectly for it...
Mixed Model Arts Book Club Kickoff
We’re starting the Mixed Model Arts book club on Wednesday, October 14, from 10 to 10:45 a.m. Mountain Time. This is the updated time, so please change it if you saved 9 a.m. from the original announcement. You don’t need to read anything b...
Audience Metrics
Subscribers, engagement, traffic and sponsorship for Practical Data Modeling.
| Subscribers | Engagement | 78 | Monthly Web Visits | ||
|---|---|---|---|---|---|
| Accepts Sponsors | Estimated Cost per Ad | ||||
SEO Reach
Where Practical Data Modeling ranks on Google, and how much search traffic it brings in.
| Ranked Keywords | 3.6k | Monthly Search Traffic | Top Keywords |
|---|
Chart Rankings
How this newsletter ranks in the official Substack charts.
| #96 |
Authors
The writers behind this newsletter.
Best Selling author of Mixed Model Arts and co-author of Fundamentals of Data Engineering (O'Reilly) | Data Engineer and Architect | Recovering Data Scientist ™ | Speaker | Professor | Podcaster & content creator | DJ | Occasional athlete
Frequently Asked Questions
How can I access the email archive for Practical Data Modeling?
You can find recent issues that have been published by Practical Data Modeling on Reletter by scrolling up to where it says Latest Issues. Tap on the link for any of the most recent emails or hit More Issues to see older ones.
How many subscribers does Practical Data Modeling have?
To see how many people subscribe to Practical Data Modeling, simply upgrade your Reletter account. We provide readership numbers and lots of other stats for this newsletter so you can decide if it's worth reaching out to.
How can I advertise in Practical Data Modeling?
Newsletter advertising can be extremely effective when it's done right. Before you pitch Practical Data Modeling as a potential sponsor or partner, make sure that you've done your research and checked its newsletter stats with Reletter.
Then, personalize one of our winning pitching templates and send it to the right person using the contact info provided.
How much does it cost to sponsor a publication like Practical Data Modeling?
Newsletter ad rates (or CPM) vary depending on many factors, including industry, number of subscribers, open rate, ad placement and more.
To find out how much an ad will cost, contact Practical Data Modeling using the contact information provided and ask for a copy of their media kit.
How can I find newsletters related to Practical Data Modeling?
Scroll up to where it says Related Newsletters to see other publications like Practical Data Modeling. You can also search our email newsletter directory to discover other newsletters that cover the topics you're interested in.
How do I contact Practical Data Modeling?
Reletter provides this newsletter's website URL above, where you will often find their contact information. We also provide links to associated social media accounts and pitching templates so you can reach out fast.