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 internet or you can say on cloud. The computing services…

 285 total views,  3 views today

Read More...

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 a chosen dimension. Power BI has introduced a preview version…

 201 total views

Read More...

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 values into single data points. It always has two value…

 252 total views,  1 views today

Read More...

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 the cloud and several Microsoft cloud services. There are two…

 337 total views

Read More...

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 to remove. Lets take a look at how to use…

 243 total views

Read More...

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, a funnel chart is shaped like a funnel with the…

 369 total views,  3 views today

Read More...

REMOVEFILTERS Function DAX


REMOVEFILTER function is a Power BI filter function in DAX, It removes filters from the specified tables or columns. It can only be used to remove filters but not to return a table. SYNTAX REMOVEFILTERS([<table>…

 278 total views

Read More...

Split columns by positions


Power Query allows you to split a column with various options, one of them is split columns by positions which split a text columns at specific positions within a given text value. Lets see how…

 270 total views

Read More...

TOTALYTD Function DAX


TOTALYTD is a Power BI time intelligence function in DAX, which evaluates the year-to-date value of the expression in the current context. DAX SYNTAX TOTALYTD(<expression>,<dates>[,<filter>][,<year_end_date>]) expression An expression that returns a scalar value. dates Is a…

 324 total views,  10 views today

Read More...

Difference between clustered index and non clustered index


SQL Server indexes are used by queries to find data values quickly in tables and views. Basically it speed up the queries performance. You can also relate a SQL Server Indexes with any text book…

 572 total views,  6 views today

Read More...

SQL NULLIF


SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIF  expression is equivalent to a searched CASE expression in which…

 210 total views

Read More...

SET STATISTICS IO


SQL STATISTICS IO is a set statement , when it is enabled it causes SQL Server to display information about the amount of disk activity generated by T- SQL statement. SYTANX SET STATISTICS IO {…

 161 total views

Read More...

SQL IS NULL


The IS NULL is used in SQL to find a NULL value. It returns TRUE if a NULL value is found, otherwise it returns FALSE. SYNTAX SELECT col1, col2, .. FROM Table WHERE Expression IS…

 118 total views,  1 views today

Read More...

SQL IS NOT NULL


The IS NOT NULL is used in SQL to find a non-NULL value. It returns TRUE if a non-NULL value is found, otherwise it returns FALSE. SYNTAX SELECT col1, col2, .. FROM Table WHERE Expression…

 162 total views,  2 views today

Read More...

REPLACE Function DAX


REPLACE function is a Power BI text function in DAX, which replaces part of a text string based on the number of characters you specify, with a different text string. SYNTAX REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)…

 261 total views,  1 views today

Read More...

Calculated Columns


Microsoft Power BI allows you to create a calculated columns means you can add a new column to an existing table in your data model, and instead of querying and loading values for new column…

 403 total views,  1 views today

Read More...

Pivot Columns in Power BI


Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs an aggregation that you specify such as sum, max, min,…

 442 total views

Read More...

How to Update from Select Statement in SQL


SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some specific conditions. Following is the basic syntax of update statement….

 614 total views,  1 views today

Read More...

PATHREVERSE function DAX


PATHREVERSE function is a Power BI Parent and Child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted backwards from…

 110 total views

Read More...

PATHITEM Function DAX


PATHITEM function is a Power BI parent and child function in DAX which returns the item at the specified position from a string resulting from evaluation of a PATH function. Positions are counted from left…

 89 total views

Read More...