Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Aarti Kaushik
60 articles
Create a simple clustered chart to show the Gender Distribution in the employee dataset
Introduction Visualization is an effective technique where the users can showcase their data in the presentation form. Numerous built-in visuals are available in Power BI tools like Simple clustered charts, Line charts, Heat maps, Funnels, Gauge charts, Pie charts, and so on. Through these visuals, the segregation of data based on accuracy enables quicker identification of useful information while eliminating time-consuming manual corrections. We will examine the clustered chart in this article to observe how the gender distribution in the employee dataset is displayed. Creation of a simple clustered chart to show gender distribution in the dataset Step 1 ...
Read MoreHow to create a Radial Gauge Chart in Power BI?
Introduction Users can identify the critical areas of businesses after monitoring numerous KPIs and visualize them through radial gauge charts. It comprises of semi-circular arc representing a solitary value that slowly reaches a destination value. Users may set the smallest value, destination value, and largest value, add a specific field on the gauge chart, and develop a vibrant Gauge chart by employing conditional formatting. The present field value lies between the smallest and largest values on the Gauge chart. To develop a radial Gauge chart in Power BI Step 1 Consider the sample datasets named Sheet1(2) consisting of six columns ...
Read MoreGenerate a DAX measure to compute the average BMI for hypertension patients
Introduction In today's era, youngsters and older adults are suffering from hypertension and diabetes due to excessive work pressure. Manually calculating the average BMI in an enormous dataset is time-consuming for data analysts. To overcome this problem, the DAX measure is an excellent way to evaluate the average BMI of hypertension patients and count the number of diabetes patients. The complex problem would also be resolved swiftly, and accurate results would be generated through the DAX function. We can follow these steps to create new measures in the Power BI desktop − Creation of a table in Microsoft ...
Read MoreExplain the concept of Report View, Data View, and Model View in Power BI
Power BI is a good tool with three major views Report View, Data View, and Model View which we will discuss in this article. Power BI can be useful for an individual who wants to derive some useful insights from the data and permits users to visualize. In short, it can be defined as a tool used to connect different data sources, by transforming and modeling data, creating an interactive visual report, and sharing these reports with others. Power BI is developed to help organizations and individuals make data-driven decisions by turning raw data into actionable insights. The first window ...
Read MoreHow to compute the average monthly income for employees and illustrate it in a card visualization
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 MoreAdvanced Filtering: How to create a Slicer in Power BI?
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 MoreHow to quickly list all hyperlinks in Excel?
Hyperlinks enable easy access to external resources such as websites, documents, emails, or even specific locations within other worksheets or workbooks. By simply clicking on a hyperlink placed within an Excel cell or object (like shape), users can instantly open relevant files without wasting time manually searching their computer directories or browser bookmarks. This quick access ensures seamless integration with other applications while maintaining workflow efficiency. While many are familiar with hyperlinks in web pages, they can bring tremendous benefits when used within an Excel workbook too. Quickly Restoring all Hyperlinks Using “Replace Option” Step 1 To expedite the process ...
Read MoreHow to quickly insert unique sequence numbers in Excel?
Introduction Unique sequence numbers provide a simple yet effective way to track and identify individual entries within a dataset or database. By assigning each record a distinct number, it becomes effortless to locate specific information during analysis or filtering processes. This feature significantly improves data management by reducing time spent searching through vast amounts of information manually. We can set up macros or formulas that automatically generate the next unique sequence number for new entries, preventing human errors in the numbering process and ensuring consistency across updates. Quickly Inserting Unique Sequence Numbers Using “AutoFill” Feature Step 1 Excel's built-in AutoFill ...
Read MoreHow to create the Venn diagram in Excel?
Introduction Microsoft Excel is an efficient tool that is used to create interactive charts that more precisely visualize the data. Professionals are said to utilize charts as a tool for graphically communicating ideas or sharing data. Among them, the Venn diagram facilitates the relationships between the defined data in the given range or items that consist of three circles by default, each of which specifies the column data. In this article, we will learn how to insert the basic Venn ...
Read MoreHow to create a User Defined Function to determine the type of triangle in Excel?
Introduction Manually identifying the type of triangle among the massive datasets is challenging, time-consuming, and susceptible to errors. VBA is one of the prominent applications in Excel where users can customize the functions and resolve complex tasks efficiently. In this article, we will develop the user-defined function in the VBA to identify the triangle’s type. Key Points to Remember Before Writing the User-defined Function Equilateral triangles are those whose all ...
Read More