Who is Power BI Developer?
Who or what is a Power BI developer? A specialist who has a thorough understanding of the Power BI platform and its capabilities is a Power BI developer. A Power…
SQL RANK ( ) Function
The RANK() function assigns a unique rank for each row in the result set. If two records have the same value then it will assign the same rank by skipping…
Who is a Tableau Consultant (and what do they do?)
A Tableau Consultant is a professional who specializes in using Tableau software to analyze and visualize data. They work with clients to understand their data and business needs and then…
SQL WINDOW Function
Like the Aggregate function, the WINDOW Function also aggregates the values in the particular window (or, set of rows ) and it returns the aggregated values for each row. These…
Build a Calculated field using DAX in Power BI
Data Analysis Expressions (DAX) are formulas or expressions used to examine and calculate data. These expressions consist of a collection of functions, operators, and constants that are combined into a…
SQL CROSS JOIN
The CROSS JOIN which is also known as Cartesian Join is used to return the set of records by the Cartesian product of the joined tables. Syntax of CROSS JOIN…
Business intelligence: A complete overview
Business Intelligence (BI) is a powerful tool that enables organizations to make informed decisions by providing access to valuable insights and data analysis. BI is a broad term that encompasses…
SQL LAST_VALUE( ) Function
The LAST_VALUE () Function in SQL is a Value Window Function that is used to fetch the last value within the ordered partition of the set or the entire table…
Data Relationships in Power BI
Most Power BI data models involve data from many tables that must be connected via relationships. To slice and dice graphics utilizing data from different tables, well-prepared and well-thought-out tables…
SQL FIRST_VALUE( ) Function
The FIRST_VALUE () Function in SQL is a Value Window Function that is used to fetch the first value within the ordered partition of the set or the entire table…