Introduction Power BI is an awesome tool for creating interactive reports and modeling data. Various built-in visuals are exclusive in the Visualization pane where measures, aggregation functions, and so on can be applied to construct the specific model. A card visual is one of the crucial visuals where a computed solitary value like average salary, maximum salary, or total production in a specific year is to be highlighted on a card. In this article, we will explore how to compute the average monthly income for employees and illustrate it in card visualization. Computation of Average Monthly Salary Step 1 You ... Read More

Introduction Users may populate the selected employee data through the slicer on the dashboard. Two options Filter and Slicer assist users in filtering data. Slicers are more flexible and dynamic, provide quick accessibility of data, are easily embedded into the Report editor, and are also compatible with other charts. The disadvantage of slicers is that a Visual filter is not permitted in slicer visual, and choices like drill down, and input fields can’t be endorsed. In this article, we will learn the fundamental concepts of creating a slicer to shortlist the employees’ names based on age categories. To create a ... Read More

Introduction When two tables require their common column field values to match, a right outer join is used to combine them, and all the records of the second table are extracted along with their matching field value from the first table. It is just the opposite of another type which is Left Outer Join. In this article, we will gain in-depth knowledge of Right Outer Join which is one of the most important types of joins. The users must transform the data before performing the Right Outer Join in the power query editor. For Example Assume that we have two ... Read More

Introduction In this article, we will gain deep insights into Inner Join and Left Outer Join in Power BI. A wide variety of joins, like full join, inner join, and left anti-join are available in Power BI to join tables. The inner join merges two tables and extracts only those records that contain the matching values in the common column of both tables. The left-outer join also matches the common values from the two tables but retrieves all the first table records along with the corresponding records of the matched values from the second table. Implementation of Inner Join in ... Read More

Introduction Numerous built-in options like Inner Join, Full Join, Left Outer join, and so on are embedded to merge and append tables in the Power query editor. In this article, we will discuss Left Anti and Right Anti joins in Power BI. Left anti-join is used to combine tables where the common column between two tables would be selected, and the unmatched records from the first table would be retrieved along with their corresponding data in the second column. Right Anti Join extracts records from the second table along with their associated field value in the first table and excludes ... Read More

Introduction Different kinds of joins are available in the Power Query Editor, like Left outer join, Right join, Inner join, and so on. Users may swiftly combine the tables and examine the result by employing these joins. In this article, we will explore the fundamental concepts of Full Outer Join where all the records from both tables are to be retrieved based on the equivalent value presented in the tables’ common column. If there are any missing matches in any of the tables, null values must be entered. Full Outer Join in Power BI Desktop Step 1 Click on the ... Read More

Sparse matrices are a specialized type of matrix that contain mostly zero values. These matrices are commonly encountered in applications such as graph theory, machine learning, and network analysis. Visualizing sparse matrices can provide valuable insights into the distribution and patterns of non-zero values. In this article, we will understand how to visualize sparse matrices in Python using the popular data visualization library, Matplotlib. Understanding Sparse Matrices A sparse matrix is a matrix in which most of the elements are zero. These matrices are typically large and inefficient to store in memory if all the zeros are explicitly represented. ... Read More

Matplotlib one of the libraries of python, which plays an important role in beautifying plots and making the data analysis and data visualization an easier task. You can use Matplotlib for experimenting, by using different options available in it and creating a more appealing, informative plot. One common customization in Matplotlib is changing the line width of a graph plot. Since, line width controls the thickness of the lines, which are used in the plots at various points such as in connecting the plot points, etc. In this article, we will be learning how to change the line ... Read More

Python being a versatile programming language supports a wide range of libraries for various applications. It supports multiple programming paradigms, including structured, object-oriented, and functional programming. In this article, we will learn about matplotlib, how to create a graph using this library and then how to change the font size of the title in matplotlib figure by various methods. What is Matplotlib? Matplotlib is a multi-platform data visualization library. It is a full library for creating an animated and interactive visualization in python. It is an amazing visualization library in python for 2D and 3D plots of the array. ... Read More

Matplotlib is a popular data visualization library used in python. It has wide range of tools and techniques for creating different types of plots. When we work in data visualization, color plays an important role in conveying information and making the work more appealing and easy to understand. We will start with the basics of Matplotlib, pyplot, creating graphs and then different methods to change the color of a graph plot with various examples. What is Matplotlib? Matplotlib is a simple interface for making different plots, where you have a variety of options to make changes to the plots. ... Read More