Rolling average in SQL
Rolling average is a calculation to analyze data by creating series of average of different subsets of the entire data. For example, you have data… Read More »Rolling average in SQL
156 total views
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
330 total views, 1 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
344 total views, 1 views today
AI Insights in Power BI
Microsoft Power BI team has introduced an AI Insights in Power BI in November 2019 update, which is collection of pre trained machine learning models… Read More »AI Insights in Power BI
490 total views, 1 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
2,112 total views, 1 views today
Load Data from Excel file to Power BI
This article demonstrate how to connect and load data from excel file to Power BI. Lets go step by step, here you can see we… Read More »Load Data from Excel file to Power BI
546 total views
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,587 total views, 2 views today
SSIS Toolbox is not visible in SSDT
Sometimes we close the SSIS toolbox window by mistake, or may be due to some reason it is not showing then you can open the… Read More »SSIS Toolbox is not visible in SSDT
1,520 total views, 7 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
756 total views, 1 views today
Change column data type in Power BI
When data is loaded into Power BI model, most of the time Power BI automatically detect the data type of columns. Some times Power BI… Read More »Change column data type in Power BI
745 total views, 1 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,161 total views, 1 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
2,608 total views, 9 views today
Power BI November 2021 update
Microsoft Power BI team has recently released November updates such as page and bookmark navigators, new format pane preview feature, sort legend, new text box… Read More »Power BI November 2021 update
861 total views
HTML Color picker
HTML Color picker, you can search colors either by color name or color hexacode  916 total views, 1 views today
916 total views, 1 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,400 total views
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,501 total views, 3 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
3,029 total views, 2 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,817 total views, 2 views today
Custom column in Power BI
Power BI Custom column adds a new column in data model based on the existing columns in data model. You can create a custom column… Read More »Custom column in Power BI
1,534 total views, 2 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
5,223 total views, 5 views today