Creation of Pandas DataFrame in Python with Examples
Python is a general-purpose language that can work with various types of data structures and solve...
Provisioning an Oracle Autonomous Database
Let’s assume that you are developing a data warehouse project, and your team needs the appropriate environment immediately and under the...
Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage
Let’s imagine you have a large raw file and need to determine the best way to load it into an Oracle Autonomous Data Warehouse...
LINQ in C#: A tutorial with Query Examples in LINQ to Objects
Less is more – this is definitely true when it comes to object collections and LINQ queries. One...
Create and Use Custom Date Hierarchies in Power BI
Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the...
Creating the Date Table in Power BI Desktop Using DAX Function
The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use...
How to Create and Configure Microsoft Azure DevOps CI/CD Pipeline Agent
What is CI / CD Pipeline in Azure DevOps? In the process of learning Azure DevOps, you’ll face...
SQL Server TRIM, LTRIM, and RTRIM Functions
The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a character string. A leading space is...
SQL Server Business Intelligence Explained: Tools, Techniques and Trends
In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data...
SQL Date Format: How to Handle It the Smart Way
Thanks to the diversity of cultures on Earth, we have a variety of date formats. For numeric...