Your blog category
Introduction Power BI IF statement is used to check whether a condition is met, it return one value if TRUE and other value if FALSE. Syntax: Return Type is single value i.e. Scalar. Example: Suppose you have a table with column ‘PARKING_SPACE_QTY’ Suppose you want to add a new column ‘Parking’ where the value is …
What is incremental refresh? Power BI incremental refresh is a feature that allows you to refresh only a subset of your data instead of refreshing the entire dataset. This can significantly improve the performance of data refreshes, especially when dealing with large datasets. Incremental refresh is commonly used when working with data sources that contain …
Introduction What is a ribbon chart? A Ribbon Chart is a sort of stacked line graph that visualizes the ranking of objects through the years. It is an evolution of the conventional stacked area chart. The Ribbon Chart distinguishes itself by its precise method of highlighting rank changes using ribbons that glide from one time …
Introduction The ease of studying Power BI can vary depending to your past experience with data handling , familiarity with statistics, and experience with similar softwares. Generally, Power BI is designed to be user-friendly and on hand to a wide range of users, which includes the ones without huge technical or information analysis backgrounds. Here …
What is a line chart? A line chart in Power Bi is used to display data points connected by line on chart. It is used to visualize trends over time. In a line chart X-axis represents time and Y-axis represents the variable How to create line chart in Power Bi ? To create a line …
Introduction Power BI is somewhat complex tool if you are working with big data and several data streams, it is good to know what needs to be optimized in order to get optimal results. Recommendation and Tips Here are the things a beginner needs to focus on for optimizing power BI reports and dashboards Data …
SQL Group By is one of the most important concepts of SQL. It is used to group the data by similar values. There are many ways by which you can use Group By but the most confusing one is Group by with multiple columns. For example, we are going to use the table below. Now …
SQL Order Of Execution In SQL, the order of execution tells us about the sequence in which parts of the query are executed. Reader should keep in mind that this is the general order of execution in SQL, it is basically a framework for understanding SQL queries. It is important to note that not all …
Optimizing SQL Performance: A Guide to Query Execution Order Read More »
FLOOR() Function: SQL FLOOR is used to return the largest integer less than or equal to the specified numeric expression. Syntax: EXAMPLE: The result is the numeric part with the same data type. CEILING() Function: SQL CIELING() is used to get the smallest integer greater than, or equal to, the specified numeric expression as return …
ROW_NUMER() SQL ROW_NUMBER() is used to number the result set. The return type is integers. Syntax: EXAMPLE: For example purpose we will use table named ‘EMPLOYEE’. Lets use ROW_NUMBER() to number the rows. You can see a new column is created and numbers have been given according to ‘SALARY’ . We used ORDER BY clause …
