Practical notes
Articles · data
Articles on data platforms, applications, AI and cloud, explaining technical mechanisms and architecture decisions.
Choosing a Power BI architecture and licences for an SME
A data warehouse and one shared semantic model keep the figures consistent. The number of readers and the size of the models then decide between per-user licences and a Fabric capacity.
A data platform for analytics, applications and AI
Data models, history and publishing interfaces that connect a data warehouse to analytical queries, applications and predictive models.
A mobile application stays consistent through its synchronisation protocol
Operation identifiers, retries and concurrent-update handling between a mobile application’s local database and its server.
Defining the exchange contract between APIs and events
Transactional publishing, retries and message-schema evolution between an order application and its read projections.
A versioned knowledge base for teams and AI assistants
Approved sources, their history and controlled updates determine a knowledge base’s reliability. Text files can make that chain easier to inspect and maintain.
Reliable reporting without replacing every tool
Defined metrics, identifiable sources and a tested first pipeline provide a foundation that teams can explain and extend.