Conditional formatting in Microsoft Excel is a useful tool for highlighting and visualizing data based on specified conditions. There are several predefined rules, such as “Greater Than”, “Less Than”, “Between”, “Equal To”, “Text That Contains”, “A Date Occurring”, “Duplicate Values”, “Top 10 Items”, “Bottom 10 Items”, “Above Average”, “Below Average”, “Data Bars”, “Color Scales”, and…
This video is about analyzing human resource data using Microsoft Power BI. It covers how to import data from a Google spreadsheet, perform data modeling and cleaning, and create various visualizations such as slicers, gauge charts, map charts, bar charts, pie charts, and stacked bar charts. These visualizations help in analyzing employee data such as…
The video explains how to calculate basic statistics in Python. It covers the steps involved in importing libraries for statistical calculations, generating a list of random numbers, plotting the data on charts, calculating mean, median, mode, standard deviation, variance, covariance, correlation and linear regression. The results are displayed on the console window and bar chart….
The video is showing how to use the mapping technique in Microsoft Excel to summarize data. The data being used is a large set of sales from January 1st, 2018 to December 31st, 2018, of various grocery items. The goal is to create a table that shows the total sales of each grocery item, grouped…
The video is demonstrating how to use the forecasting feature in Power BI, a business intelligence and data visualization tool. The tutorial is using global temperature data to create a forecast. The speaker starts by importing historical temperature data and creating a dashboard with a title and a map chart that shows the average temperature…
In Power BI, grouping data allows you to combine multiple data elements into a single unit. This can be useful for summarizing and analyzing data in a more meaningful way. For example, you can group similar items, and display their data combined. In today’s tutorial, we will group fruits and non-fruit items, and display more…
In Java Script, the if else statement is used to perform different actions based on different conditions. In this video, we will show you the structure of if-else condition statement, and its practical usage within a web page, using a drop down. #html #javascript #ifelsestatement #ifelse
The World Bank Group has a lot of economic and social data on their servers, which is available for free. You can download and use the data too, but today we will show you how to connect power bi directly to their data, through API, and create dashboards using that data. World Bank API is…
In this video, we will show you how to perform mathematical operations in HTML, using JavaScript. There are many ways you can perform mathematical operations in JS. Using plus, minus, multiply and divide signs/operators is the most basic one. Then you can use the Math object i.e. Math.Random(). You can also use external libraries to…
Banks analyze there loans in several ways to minimize credit risk, one of them is loans cycle / loans classification / loans movement analysis. In these analysis, they try to make sense of data using aging buckets, and how loans move from one bucket to another, as periods change. In this demonstration, we have the…