Ribbon Chart in Power BI

Ribbon chart is used to visualize the data and quickly identify which data category has the highest rank (largest value). Ribbon charts are effective at… Read More »Ribbon Chart in Power BI

 106 total views,  6 views today

100% Stacked bar chart in Power BI

Power BI 100% stacked bar chart is used to display relative percentage of multiple data series in stacked bars, where the total (cumulative) of each stacked bar always… Read More »100% Stacked bar chart in Power BI

 110 total views,  6 views today

Load Multiple .text or .csv files to table in SSIS

This article demonstrate how to load multiples .txt or .csv files to a SQL Server table. As you can see here we have two flat… Read More »Load Multiple .text or .csv files to table in SSIS

 1,503 total views,  15 views today

Row Count transformation in SSIS

The Row Count transformation counts rows as they pass through a data flow and stores the final count in a variable. Row Count Transformation does not… Read More »Row Count transformation in SSIS

 1,204 total views,  12 views today

Copy Column Transformation in SSIS

Copy Column Transformation in SSIS allow us to create a duplicate columns means it takes an input column and creates a duplicate of it with a… Read More »Copy Column Transformation in SSIS

 628 total views,  7 views today

Add Saprkline to matrix in Power BI

Microsoft Power BI team has released a December 2021 update. In this update they have added new features and one of the most excited feature… Read More »Add Saprkline to matrix in Power BI

 1,026 total views,  9 views today

How to get top salary of each department

To find the highest salary of employee in each department, first we will create a sample tables named EmployeeDetails and Department as shown below. CREATE… Read More »How to get top salary of each department

 1,900 total views,  16 views today

Change matrix background color based on value

In this article you will see how to change the background color for specific rows in a matrix based on values in column. Here, we… Read More »Change matrix background color based on value

 1,166 total views,  9 views today

How to get the size of table in SQL

There are multiple ways to get the size of table in SQL Server. Lets take a look on them one by one. Using sp_spaceused system… Read More »How to get the size of table in SQL

 2,000 total views,  8 views today

Insert same rows multiple times in table

Sometimes you need to insert same row multiple times in a table. There are many ways to do that but here we will see one… Read More »Insert same rows multiple times in table

 2,528 total views,  14 views today

Conditional Column in Power BI

A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI

 1,432 total views,  8 views today

How to compare column names in two tables in SQL

Assume that, you have two tables and you are asked to find out the columns which exists in both table with same name or column… Read More »How to compare column names in two tables in SQL

 4,014 total views,  37 views today

How to find leading and trailing spaces in SQL Server ?

You may have faced a situation where you are asked to find values in a column with leading or trailing spaces or remove the leading… Read More »How to find leading and trailing spaces in SQL Server ?

 1,380 total views,  7 views today