In this tutorial, we will demonstrate how we can generate week numbers for different quarters of the year in Tableau. Before we move to that, we need to understand some important date functions we will use in our calculation and their uses. With the help...
The Wix Data API allows you to work with your database collections using code and gives you more capabilities than what is available in the Editor alone. You can use this API to work with your site’s registered users. This API lets you get information about...
Azure blob storage is a Microsoft Azure feature that allows users to store a large amount of unstructured data. Azure blob storage can be used as a Delta Lake where you keep all the data that belongs to your organization. Blob is an acronym and...
Extensible Markup Language(XML) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML uses a series of simple tags to describe data and these tags can be created in an easier way.CSV...
Introduction Athena is a serverless query service that allows you to run SQL queries on your data stored in S3. It can easily query large datasets (or Data Lakes), whether they are structured, unstructured, or semi-structured data. A database in Athena is a logical grouping for tables...
Introduction The snowflake connector is a native, pure Python package that does not depend on JDBC or ODBC. It can be installed using pip on Linux, macOS, and Windows platforms where Python 3.6 and upwards are installed. The connector supports developing applications using the Python Database...
Introduction ETL Tools can deliver instant data integration solutions to help businesses in saving time, cost, and resources. Recently, there has been an increase in usage of Alteryx and Fivetran by companies. Both have gained a lot of attention as several companies are really adopting them....
At the beginning of my Tableau Journey back then in 2018, I was going through a goal news edition and I came across something similar to the image below. I thought about it, what if I can do something similar in Tableau with the previous function....
Introduction Data Warehousing is an evolving field. The old models of data warehousing such as batch processing and ETL (extract, transform, load) are inefficient for modern data-intensive applications. Data warehouses can’t handle the number of concurrent updates that occur when they’re in use. Snowflake is a...
An API stands for Application Programming Interface. It is a specific set of codes or instructions and specifications used in software programs to communicate with other applications/devices. It is a software program that facilitates interaction with other software programs. What does Alteryx API do? Alteryx...
