Author: Jorge Sandoval

Jorge Sandoval is a professor at the Florianópolis Institute of Higher Education (IESGF) in Brazil, where he teaches and researches data science, Artificial Intelligence, machine learning, deep learning, and energy and time series forecasting. He also serves as a consultant specializing in data science, Artificial Intelligence, and machine learning for state government sectors like law enforcement and healthcare.

What Is a Data Warehouse?

We help you understand the data warehouse and its concepts. Data and analytics have become indispensable for businesses to remain competitive. Business users rely on reports, dashboards, and analytics to extract insights from data, monitor business performance, and support decision-making. Data warehouses are used to feed these reports, dashboards, and analysis tools. It does so by efficiently storing data to minimize input and output (I/O) and deliver query results quickly to hundreds and thousands of users simultaneously.

The Best ER Diagram Tools in 2021

The top 10 tools you can use to build your entity-relationship models in 2021! There are several relational modeling tools. A simple Google search yields dozens of options for all kinds of purposes. But the question remains: what is the best tool for professional use or in teams? Which tool will give me access to all the features I need without having to switch between multiple tools? There are some resources to help you answer this question like this article, but we can look at more.

Top 15 Database Modeling Tips for 2021

Here are 15 simple tips that will guarantee the quality of your database model! Prior to the emergence of NoSQL databases, data modeling had followed a standard norm. However, with the hybridization of storage models and especially with the integration among them, it has become necessary to consider NoSQL databases in systems that use relational databases. This article covers 15 tips for modeling databases in 2021 (the database modeling tool used in this article is Vertabelo).

Data Modeling Tools: Choosing the Best for Your Needs

Data Modeling Tools: Choosing the Best for Your Needs Before you can choose the right data modeling tools, you have to understand what a data model is and how to use it. This article will explain those concepts and then compare some of the various data modeling tools available. A data model is defined as an abstract model that organizes several aspects of data (e.g. data description and semantics and the consistency of data constraints).