Tag feed

#data-modeling

139 posts13 followers

Explore Hashnode

Alternatives

Trending tags this week

RWRandi Wsalesforcegirl.hashnode.dev16h ago · 8 min read

Real data is messy. Build the model first.

Until this year, every database I'd ever worked in professionally had Salesforce wrapped around it. That's not a confession, exactly. I've been building on Salesforce since 2007: always in IT, always

0

DJDharmesh Joshidharmeshjoshi.hashnode.dev18h ago · 5 min read

Designing a Data Model for Translatable Content Without Breaking Every Existing Record

Adding multi-language support to a content platform sounds like a straightforward data modeling problem until you remember one thing: you already have production data in the old shape, and you can't j

0

EBEvgenii Buchinskiiieccalc.hashnode.dev17h ago · 5 min read

Six provenance classes, and why your calculation tool needs them

Here is a bug report you will never receive, because nobody can see it: The cable schedule says 120 mm². It was 95 mm² last quarter. Nothing in the project changed. Nobody knows which input moved. E

0

KPKPI Partnerskpipartners.hashnode.dev1d ago · 7 min read

Building a Marketing Analytics Layer for Salesforce: From Campaign Data to Decision-Ready Metrics

A marketing analytics layer for Salesforce is a governed data model that sits between raw source data and the dashboards people use. It extracts campaign, campaign member, lead, opportunity, and attri

0

KPKPI Partnerskpipartners.hashnode.dev3d ago · 7 min read

Building a Project Analytics Layer for Oracle Fusion Cloud Project Management

A project analytics layer for Oracle Fusion extracts project, cost, commitment, budget, forecast, revenue, billing and resource data in bulk, lands it in a data platform, models it into facts and dime

0

KPKPI Partnerskpipartners.hashnode.devSep 25 · 7 min read

Building a Manufacturing Analytics Layer for Microsoft Dynamics 365

A manufacturing analytics layer for Microsoft Dynamics 365 is a governed data model that sits between Dynamics 365 Supply Chain Management and your BI tool. It replicates production, inventory, qualit

0

KPKPI Partnerskpipartners.hashnode.devSep 23 · 10 min read

Building a Procurement Analytics Layer for Oracle Fusion Cloud: From Transaction Data to Decision-Ready Metrics

A procurement analytics layer for Oracle Fusion Cloud sits between the ERP and your BI tools. It extracts procurement transactions, models them at a declared grain into facts and conformed dimensions,

0

KPKPI Partnerskpipartners.hashnode.devSep 15 · 6 min read

Modeling Oracle EBS Project Data for Governed Analytics: A Practical Approach

Oracle EBS Projects data is transactional by design. It's optimized for recording budgets, costs, and revenue accurately as they happen, not for answering ad hoc questions about portfolio-level trends

0

SPSalman Parvezmlsystems.hashnode.devSep 11 · 5 min read

Claimants Without Seats — the authority bug in our own ontology

On ML Systems' Master Ledger a fact is not a value. It is a claim — a value, plus who made it, plus the grade of evidence behind it — and several claims sit on the same entry. The ledger decides which

0

KPKPI Partnerskpipartners.hashnode.devSep 9 · 6 min read

Modeling Oracle EBS Manufacturing Data for Analytics: A Data Engineer's Guide

Oracle EBS manufacturing data is scattered across a normalized schema that was designed to process transactions correctly, not to answer analytical questions quickly. If you've been handed a request t

0

#data-modeling

Search Hashnode

#data-modeling

Explore Hashnode

Trending tags this week

Real data is messy. Build the model first.

Designing a Data Model for Translatable Content Without Breaking Every Existing Record

Six provenance classes, and why your calculation tool needs them

Building a Marketing Analytics Layer for Salesforce: From Campaign Data to Decision-Ready Metrics

Building a Project Analytics Layer for Oracle Fusion Cloud Project Management

Building a Manufacturing Analytics Layer for Microsoft Dynamics 365

Building a Procurement Analytics Layer for Oracle Fusion Cloud: From Transaction Data to Decision-Ready Metrics

Modeling Oracle EBS Project Data for Governed Analytics: A Practical Approach

Claimants Without Seats — the authority bug in our own ontology

Modeling Oracle EBS Manufacturing Data for Analytics: A Data Engineer's Guide