Profile Data in Power BI
The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI
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.
LASTNONBLANK function DAX
LASTNONBLANK function is a Power BI time intelligence function in DAX which returns the last value in the column filtered by the current context for… Read More »LASTNONBLANK function DAX
Row-Level Security (RLS) in Power BI
Row-Level security (RLS) is a feature of Power BI that can be used to restrict data access for given users, so the appropriate person can… Read More »Row-Level Security (RLS) in Power BI
Custom function in Power BI
Custom function in Power BI allows you to use a same piece of code repeatedly multiple times. Sometime, you may get a situation where you… Read More »Custom function in Power BI
Monitor usage and performance in workspace
This is a performance and usage metrics features that you can use in a workspace. Using these metrics, you can view who is using your… Read More »Monitor usage and performance in workspace
Radial Gauge Chart Power BI
A Radial Gauge chart has a circular arc and shows a single value that measures progress toward a goal or a Key Performance Indicator (KPI).… Read More »Radial Gauge Chart Power BI
Power BI Report Performance Analyzer
Performance Analyzer is a tool within Power BI desktop, that allows you assess your report’s performance and identify area of improvement. Using this you can… Read More »Power BI Report Performance Analyzer
How to fetch alphanumeric string from table
Assume you have a table containing alphabetic, numeric, alphanumeric strings, and special characters, and you need to retrieve only the alphanumeric strings from that data.… Read More »How to fetch alphanumeric string from table
TRUNC function DAX
TRUNC function is a Power BI math and trig function in DAX, which truncates a number to an integer by removing the decimal, or fractional… Read More »TRUNC function DAX
Import JSON data files in Power BI
Microsoft Power BI allows us to connect with multiple data sources such as SQL Server, Excel, Text/Csv, XML, Pdf, and JSON and many more, here… Read More »Import JSON data files in Power BI
LOWER function DAX
LOWER function is a Power BI text functions which converts a text string to all lowercase letters. SYNTAX LOWER (<text>) text is the text you… Read More »LOWER function DAX
UPPER Function DAX
UPPPER function is a Power BI text functions which converts a text string to all uppercase letters. SYNTAX UPPER (<text>) text is the text you… Read More »UPPER Function DAX
MID Function DAX
MID function is a Power BI text functions in DAX, it returns a string of characters from the middle of a text string based on… Read More »MID Function DAX
FORMAT Function DAX
FORMAT function is a Power BI text function in DAX, which converts a value to text according to the specified format. Syntax FORMAT(<value>, <format_string>) value… Read More »FORMAT Function DAX
Public, Private and Hybrid clouds
Public, Private, and Hybrid clouds all these are basically a deployment models of cloud computing. Cloud computing is the delivery of computing services over the… Read More »Public, Private and Hybrid clouds
Small Multiples Preview
Small Multiple or trellising allows you to split a visual into multiple versions of itself, presented side-by-side, with its data partitioned across these versions by… Read More »Small Multiples Preview
Scatter charts in Power BI
A scatter chart shows the relationship between two numerical values and displays points at the intersection of an x and y numerical value, combining these… Read More »Scatter charts in Power BI
Install and Configure on-premises data gateway (personal mode)
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data basically a data that is not in… Read More »Install and Configure on-premises data gateway (personal mode)
Choose and Remove columns in Power Query
Choose columns and Remove columns are operations that allows you to define what columns you need to keep in your table and which ones it needs… Read More »Choose and Remove columns in Power Query
Funnel Chart Power BI
A funnel chart allows you to visualize a linear process that has sequential connected stages. It is named as funnel because in most of cases,… Read More »Funnel Chart Power BI