Create and Use Custom Date Hierarchies in Power BI
Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this...
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...
SQL Server Business Intelligence (BI) – Traditional Tools and Technologies
If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the knowledge and tools. If you target the...
SQL Server Business Intelligence (BI) – Basic Understanding
In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts...
How to Use Multicast in SSIS with Examples
This article explains how to configure the job of multicasting data with the help of SSIS (SQL Server Integration Services) Packages. Also,...
Multicast SSIS: How to Create, Setup and Test
The current article focuses on setting up and testing the necessary environment for multicasting data with SQL Server Integration Services...
SQL Reference Table: How to Create and Write Basic Queries
This article will focus on writing SQL queries against the database reference table with a fairly...
SQL Basic Commands: How to Write Simple Queries with Examples
This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and...
SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios
The current article focuses on slightly advanced use of the DELETE statement to remove one or more records (rows) from a table. While it...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of...