Posts
All the articles I've posted.
-
Creating a Running Total in SQL Server with Window Functions
Introduction Calculating a running total is a common requirement in many data analysis tasks, such as tracking cumulative sales, computing cumulative scores, or keeping track of inventory levels. In
-
Filtering Items in Azure Data Factory: Excluding Items That Begin with an Underscore
Azure Data Factory (ADF) is a powerful tool for building ETL (Extract, Transform, Load) workflows in the cloud. One common requirement is to filter data or files based on certain conditions. In this
-
Using the OVER() Clause with Window Functions in SQL Server
Introduction SQL window functions have become an indispensable tool for data analysts and developers. They allow for advanced calculations that go beyond simple aggregates, enabling analysis over a
-
Extracting Year, Month, and Day from Dates in Azure Data Factory
In Azure Data Factory (ADF), working with dates is a common task, especially when dealing with data transformations and scheduling tasks. ADF allows you to handle dates in different formats, such as
-
Splitting Strings and Accessing Elements in Azure Data Factory
Introduction Azure Data Factory (ADF) is a powerful cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data
-
Extracting the Header from a CSV File in Python
When working with CSV files in Python, it's often necessary to extract the header (the first row of the file) to understand the structure of the data or to perform specific operations on the remaining
-
Handling CSV Files in Python: Writing Specific Rows with Custom Headers
When working with CSV files in Python, you often need to filter and write specific rows to a new file, including handling headers properly. This blog post will guide you through the process using
-
Understanding Window Functions in SQL: A Deep Dive
Introduction When working with databases, you'll often need to perform calculations across a set of rows related to the current row in your query. Whether you're calculating a running total, ranking