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 MorePython : 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 MoreHello 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 MoreWhat 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 MoreQlik 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 MoreSQL 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 MoreData 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 MoreQlik 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 MoreQlik 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 MoreHello 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