Home ยป Archives for Pradeep Raturi

Pradeep Raturi

I am having a 7 + years of experience in microsoft technologies including Asp .NET, C# Power BI, SQL Server, SSRS, SSIS, Azure Fundamentals, & Python.

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

 127 total views,  8 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

 127 total views,  5 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,605 total views,  29 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,260 total views,  6 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

 644 total views,  6 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,044 total views,  3 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,957 total views,  15 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,200 total views,  5 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,065 total views,  12 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,579 total views,  13 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,487 total views,  11 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,126 total views,  26 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,422 total views,  8 views today