If you are new to PowerBI or upgrading your analysis from Excel getting acquainted with transformation tools will make it easier to perform analysis
Vanity metrics often involve big numbers and as a standalone measure can be misleading and sometimes harmful
It doesn’t replace databases and BI tools for reporting, but Excel is just what you need for quick analysis and cleansing of small data sets
CASE is SQL’s equivalent to IF-ELSE statements in other programming languages. This expression allows you to test a condition and return a value.
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers.
SQL window functions are incredibly powerful and allow us to see the rows in a table with a new column showing a running total, rank or moving average.