Found 784 Articles for Data Visualization

Advanced Filtering: How to create a Slicer in Power BI?

Aarti Kaushik
Updated on 03-Jan-2024 14:55:27

60 Views

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

Power BI - Right Outer Join

Aarti Kaushik
Updated on 21-Dec-2023 13:02:27

61 Views

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

How to merge tables using Inner Join and Left Outer Join in Power BI?

Aarti Kaushik
Updated on 21-Dec-2023 13:05:21

101 Views

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

How to merge tables using Left Anti and Right Anti joins in Power BI?

Aarti Kaushik
Updated on 21-Dec-2023 13:03:48

67 Views

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

Power BI - Full Outer Join

Aarti Kaushik
Updated on 21-Dec-2023 12:59:06

144 Views

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

How To Visualize Sparse Matrix in Python using Matplotlib?

Rohan Singh
Updated on 16-Oct-2023 11:26:50

488 Views

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

How to Change the Line Width of a Graph Plot in Matplotlib?

Utkarsha Nathani
Updated on 11-Oct-2023 15:05:22

251 Views

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

How to Change the Font Size of the Title in Matplotlib Figure?

Utkarsha Nathani
Updated on 11-Oct-2023 15:07:46

1K+ Views

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

How to Change Color of a Graph Plot in Matplotlib With Python?

Utkarsha Nathani
Updated on 11-Oct-2023 14:56:38

355 Views

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

How to Change Matplotlib Color Bar Size in Python?

Utkarsha Nathani
Updated on 11-Oct-2023 14:20:29

775 Views

Visualization tools are a vital part of Matplotlib library. One of the tools is colorbar. It shows the mapping between data values and colors in a plot. For adjusting the size of the colorbar to make it more visible or to fit it better with the plot we have several parameters presented by the colorbar() function in Matplotlib. In this article, we will discuss how to change matplotlib colorbar size using different approaches. What is Matplotlib and How to Install it? Matplotlib is a widespread library for creating static, animated and interactive visualization in python. It has module ... Read More

Advertisements