Decoded©
-
CONCATENATE function in Power Query: Full tutorial
While Power Query offers a multitude of functions, some are not directly accessible from the ribbon. This is precisely the case with the CONCATENATE function, which allows you to merge several columns. So how do you use CONCATENATE in Power Query? That’s what we’re going to look at in this article. What is the CONCATENATE […]
Lire la suite -
Power Query Date function: How do I use it?
There are various functions and formulas for using today’s date in Power Query, for analysing data in Power BI or Microsoft Excel. Find out everything you need to know about the Power Query Date function. In the field of analysis, the date is an important piece of information. It contextualises the data in terms of […]
Lire la suite -
Classification algorithms: Definition and main models
If machine learning allows organizations to be more efficient and make the best decisions, it is essential for data science experts to master various artificial intelligence algorithms. There are dozens of these algorithms, each serving a specific purpose. In this article, we will precisely examine the different classification algorithms. What is a classification algorithm? Definition […]
Lire la suite -
Understanding Correlation Coefficient: Definition and Applications
To better understand data, it’s essential to analyze its relationships. And to facilitate this analysis when faced with tens of thousands of lines of data, there are mathematical formulas. In particular, the correlation coefficient. What is the correlation coefficient? Relationship and dependence between two variables Before we can understand the correlation coefficient, we need to […]
Lire la suite -
ROC AUC curve: essential metrics for Machine Learning models
The ROC (Receiver Operating Characteristic) curve and its associated metric AUC (Area Under the Curve) are essential tools for assessing classification models in machine learning. These metrics offer crucial insights into a model’s capability to differentiate between classes, particularly in binary classification scenarios. The Fundamentals of ROC AUC The ROC curve essentially serves as a […]
Lire la suite -
What is a root mean square error?
.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px} The root mean square error (RMSE) is an indicator for verifying the reliability of a model. This tool studies the discrepancies between the values actually observed and the values predicted by the model. The squared error is a value that is always positive. The closer the values obtained […]
Lire la suite -
Prompt Engineer: Everything you need to know about this new AI role
With the democratization of generative artificial intelligences like ChatGPT, new needs are emerging in the business world. To fully harness the potential of these chatbots, it is essential to understand how to communicate with them and make oneself understood in order to achieve the best possible results. This is why experts capable of “taming” AI […]
Lire la suite -
Genspark: the super AI agent that turns your prompts into actions
Genspark is an innovative AI agent transforming queries into actions: enhanced research, sourced summaries, slide/document creation, automatic downloads, and even phone calls. Discover its main features, strengths, and drawbacks compared to Perplexity and ChatGPT Search, along with a handy guide to mastering it! Online search is rapidly evolving. We no longer simply type a query […]
Lire la suite -
Facebook Prophet : All you need to know
Facebook Prophet is an open-source Python library offering an intuitive, automated approach to capturing trends, seasons and exceptional events in time series. Discover why this Machine Learning-based tool has revolutionized predictive data analysis! One of the great recent technological advances is the ability to predict future trends from historical data. This is one of the […]
Lire la suite -
NoSQL: All about non-relational databases
NoSQL is a type of database, whose specificity is to be non-relational. These systems allow the storage and analysis of Big Data. Find out everything you need to know: definition, history, functioning, use cases, advantages, training… In the age of Big Data, relational databases are no longer adequate. To handle the immense volumes of data, […]
Lire la suite -
Demystifying SQL Index: Understanding its Purpose and Functionality
An SQL index enables you to quickly locate the data you’re looking for in a relational database. Find out all you need to know about this valuable tool, and why it’s so useful in Data Science! Efficient access to information is a priority in Data Science. That’s why professionals use databases to manage, store and […]
Lire la suite -
Data Engineer: All about the job, required skills, and salary
The Data Engineer’s role is to prepare the data for the Data Scientist to analyze. Big Data and Data Science are growing, and more and more jobs are emerging in this field. Today, we’re going to take a closer look at one of the three main data science jobs, alongside the roles of Data Scientist and […]
Lire la suite
The newsletter of the future
Get a glimpse of the future straight to your inbox. Subscribe to discover tomorrow’s tech trends, exclusive tips, and offers just for our community.
