© 2023 Hashnode
#data-modeling
Data modeling is the process of creating a model for the data you want to store in a database. To design a database you need to understand: The business requirements Build a conceptual model of the …
When it comes to data storage options, two main types of databases stand out: SQL and NoSQL. Each of these database types has its own strengths and weaknesses, and choosing between them often depends …
I’ve been excited about SQLMesh since it was released to the public a few weeks ago. It’s fantastic to see innovation in the data transformation space and teams boldly testing out novel approaches to …
Introduction Data modeling is a crucial component in DAX (Data Analysis Expressions), which is the formula language used in Power BI, Excel, and other Microsoft data analysis tools. A well-designed da…
Introduction Heart disease is a leading cause of death worldwide, with an estimated 17.9 million deaths each year. As a data scientist, I understand the challenges of early detection and diagnosis, es…
In one of my previous posts, we discussed what temporal tables are and how to join multiple such tables into a single one. In this short practical exercise, we’re going to look at how we can generate …
Suppose we were asked to build a computing system that answers whether an individual is healthy or not. The system employs a sophisticated machine learning model to give an accurate reply most of the …
What is QVT? Query-View-Transformation (QVT) is a standard set of languages defined by the Object Management Group to perform model transformations. The QVT specification includes three languages: Re…
Introduction LinkedIn stands out as a professional networking platform with a user base of over 750 million professionals worldwide. It handles an enormous amount of user data, including profiles, con…
Welcome to the 41st day of your "Code, Blog, Repeat: A 50-Day Quest for Back-End Mastery" blog series! Today, we will delve into the world of data modeling with MongoDB. Data modeling is an essential …