Power Query Date Format: How to change it on Excel and Power BI
There are different ways to change the Power Query Date Format for Microsoft Excel or Power BI: an indispensable task for data analysis and Business Intelligence. Find out everything you need to know! When collecting data from different sources, it’s not uncommon to be confronted with dates in different formats. This can cause problems. That’s […]
Power BI Direct Query vs Import: Which to choose?
Power BI Direct Query vs Import: When connecting data in Power BI, you have two choices: Direct Query vs. Power BI Import. To choose the ideal strategy, it’s important to be familiar with both methods, their advantages and disadvantages. Each method can be used depending on the type of report, but your organization needs to […]
Computational Resources: Definition, operation and role
Computational Resources are essential in the world of computing and science, especially for Data Science. Find out everything you need to know. Computers and their ability to perform calculations play a crucial role in our modern world. They are the basis of many recent innovations such as digital simulation, machine learning, image recognition, artificial intelligence […]
API Rest: What is it? What is it for?
Today, web and mobile applications are ubiquitous in our daily lives. Companies are constantly looking for ways to improve the user experience and performance of their applications. This is where REST APIs (API for Application Programming Interface and REST for REpresentational State Transfer) come in. REST APIs are programming interfaces that enable communication between different […]
DB-GPT, the solution against data leakage
As artificial intelligence models become more powerful and present in our daily lives, the risks to our privacy grow. That’s why a group of independent developers have created DB-GPT, the solution to data leakage. What is DB-GPT? DB-GPT is a project aimed at creating a complete private LLM solution for databases. It has been designed […]
Amazon Aurora: Overview of this cloud database
Amazon Aurora is a relational database solution based on a cloud-native architecture designed to deliver high performance, high availability and flexible scalability, while reducing costs. Amazon Aurora is based on open-source technologies such as MySQL and PostgreSQL, enabling it to offer advanced functionalities, as we’ll see in this article. Amazon Aurora’s challenges are manifold. On […]
SQL UPDATE: Update data with this command
Because databases are constantly evolving, it’s essential to be familiar with the UPDATE SQL query. This allows you to modify one or more rows in your table. So how do you use it? We explain it all in this article. What is SQL UPDATE? The SQL UPDATE command is used to update data within a […]
SQL GROUP BY: Everything you need to know about this query
One of the most useful SQL commands for data analysts is GROUP BY. It allows you to easily generate advanced statistics from categories. Suffice to say, it’s one of the 10 commands you’ll use the most, so you might as well know what it’s all about. SQL’s strengths are well established. This language offers an […]
Page Rank Algorithm: All you need to know
Are you familiar with the Page Rank algorithm? At the heart of Google positioning, let’s find out how it works You’ve probably wondered why certain web pages appear first when you make a query on a search engine. If you try to search for the term “python” in your Google search bar, the official python […]
Cloudera Course: What you should know
A Cloudera training course will help you master this widely-used enterprise platform, and maximize your chances of passing the certification exam. Find out why and how to acquire this expertise! In the age of Big Data, companies have more and more data to process and analyze. This is both an opportunity and a challenge. So, […]
Records Manager: A key Data Governance job
A Records Manager is a professional in charge of a company’s document management. He or she oversees the management, storage and use of data, while ensuring its security and compliance with current legislation. Find out all you need to know about this essential Data Governance profession! Records management is an essential corporate practice. It encompasses […]
Amazon SNS: The messaging service connected to AWS
Amazon SNS is a service for sending push notifications from an application to the end user or other programs. It’s a comprehensive messaging service that enables communication between applications (Aapplication To Aapplication – A2A) or persons (Aapplication To Person – A2B). It allows you to create topics (i.e. subjects) that will be the logical access […]
