SQL Leet Code Nth Highest Salary Problem
Write an SQL query to report the nth highest salary from the Employee table. If there is no nth highest salary, the query should report null. Source:… Read More »SQL Leet Code Nth Highest Salary Problem
Home » Archives for Pradeep Raturi »
Pradeep Raturi
I have 11+ years of working experience in Business Intelligence Data Modelling, Power BI, SQL Server, SSRS, SSIS, Azure Data Factory, Power Apps.
SQL LeetCode Rank Scores Problem
SQL LeetCode problem: Rank Scores Source: LeetCode Write an SQL query to rank the scores. The ranking should be calculated according to the following rules:… Read More »SQL LeetCode Rank Scores Problem
Display Last N months data in Power BI
In this article we will demonstrate how to display last n months data in chart based on selected month in slicer. Means, user will select… Read More »Display Last N months data in Power BI
TOP N and Others in Power BI
In this article we will see how to display the TOP N and Others in Power BI, means to show the top n products and… Read More »TOP N and Others in Power BI
How to get multiple rows data in single row in SQL
This article demonstrates how to Convert multiple rows into a single comma separated row, it can be done by using in-built SQL functions. As you… Read More »How to get multiple rows data in single row in SQL
Field Parameter in Power BI
Power BI released a new preview feature called Field Parameters in May 2022 update. Using Field Parameters you can dynamically change the measure or dimension… Read More »Field Parameter in Power BI
Creating Dynamic Title based on Slicer Selection
You can create a dynamic title based on values selected in slicers or can show slicer selected values in text box. Lets create a dynamic… Read More »Creating Dynamic Title based on Slicer Selection
IN operator in Power Query M code
You can check multiple values in any list using IN operator in Power Query. Lets say, you have a requirement to check for specific categories… Read More »IN operator in Power Query M code
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
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
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
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
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
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
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
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
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
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
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
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