Python : Manipulating HTTP APIs

Python : Manipulating HTTP APIs Hello everyone, this is a list of helpful functions for manipulating APIs in Python. 0. GET Request Sending data to an API endpoint using a GET request. 1. POST Request Sending data to an API endpoint using a POST request. 2. PUT Request Updating data at an API endpoint using

Read More

Python : Files manipulation

Python : Files manipulation Hello everyone, this is a small list of useful functions to manipulate files in Python, this is just the first part, i will make an other articles for APIs, Pandas etc.. These techniques provide a solid foundation for working with files in Python. Remember to adapt them to your specific needs

Read More

SQL Derived Tables, CTEs

Hello everyone, whether you work as a data analyst, engineer, or data scientist, knowing Derived Tables and Common Table Expressions (CTEs) is a must. It’s important to know how to use them. Derived tables and Common Table stand are used on advanced SQL queries, offering an extensive range of functionalities to handle complex data sets

Read More

What is SQL Transactions ? and when you should use it ?

What is SQL Transactions ? and when you should use it ? Hello everyone, if you’re a data analyst, you might not use transactions in your everyday tasks since you access data mostly in read-only mode. However, understanding how they work is crucial because they are a fundamental principle in managing databases. Ensuring data integrity

Read More

Qlik Tricks and Tips #5 : Installation of a new node (multi node architecture)

Qlik Tricks and Tips #5 : Installation of a new node (multi node architecture) Hi everyone, this is one of my administrator formation videos on how to install a new Qlik Sense node and configure it. To check Qlik sense ports : https://help.qlik.com/en-US/sense-admin/February2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Ports.htm System requirements : https://help.qlik.com/en-US/sense-admin/February2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/Common/system-requirements.htm

Read More

SQL vs NoSQL, the simple difference

SQL vs NoSQL, the simple difference Hello everyone, today, we will focus on the differences between relational and non-relational databases, which are commonly referred to as SQL and NoSQL. As a data analytics or data engineer, you are likely already familiar with these differences. However, beginners may find the concepts of each type unclear. And

Read More

Data Warehouse vs Data Lake vs Data Lakehouse | What is the Difference ?

Data Warehouse vs Data Lake vs Data Lakehouse | What is the Difference ? Hello everyone, in this article we will discover the difference between Data Warehouse, Data Lake, and Data Lakehouse. As all you know in today’s world, a business collects all sorts of data from various places. Think about all the informations from

Read More

Qlik Tricks and Tips #4 : Qlik Automation – Qlik Cloud

Qlik Tricks and Tips #4 : Qlik Automation – Qlik Cloud Hello everyone, today we will talk about Qlik Automation, it’s a no-code tool that enables the automation of manual tasks. Instead of writing code, users combine configurable blocks that they drag and drop onto a canvas, forming a sequence of action steps from various

Read More

Qlik Tricks and Tips #3 : recover database password in qlikview

Qlik Tricks and Tips #3 : recover database password qlikview Hello everyone, if you’re reading this article, I strongly suspect that you’ve encountered this scenario: unable to find your database password in your Keepass. Perhaps the application is simply too old, and nobody seems to have access to the password or knows who to contact

Read More

Inside the Life of a Data Analyst: Understanding the Role, Its Skills and Potential Salary

Hello everyone, today, we will exploring what does a data Analyst actually do, necessary qualifications and skills, as well as the expected salary. This profession is heart of many organizations, harnessing the power of data to turn it into valuable insights. Let’s start by breaking down the actual responsibilities of a data analyst. 1. Defining

Read More