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…
In this video we will create a dashboard, using Sankey diagram. Sankey diagrams are a type of flow diagram, in which the width of the arrows is proportional, to the flow rate of the depicted extensive property. We will use a third party custom visual. The link to the custom visual is placed below. You…
Today, we will use Northwind Traders data, to create multiple dashboards in Power BI. Northwind Traders is a fictitious organization that manages orders, products, customers, suppliers, and many other aspects of a small business. This sample appeared with the first versions of Microsoft Access, and is still available as an Access template. You can download…
Today we will create a dashboard, showing crimes in Los Angeles, from 2020 onward. We will show you how to display crimes by type of crime, age, area, gender, descent, status, premises, weapon and location. We will use donut charts and map charts to display this information. Source data: https://data.lacity.org/api/views/2nrs-mtv8/rows.csv?accessType=DOWNLOAD #powrbi
Today we will create a drill through report in Power b i. With drill through in Power B I reports, you can create a destination target page in your report, that focuses on a specific entity, such as a supplier, customer, or manufacturer. When your report readers right-click a data point, in other source report…
Today we will use Data Analysis Expressions (DAX) to create columns and tables in the Power BI and use those tables to display visualizations. Excel file: https://docs.google.com/spreadsheets/d/1cSmnIs9vW6cyJ5Z-vf1IjV-Gb7vk7feD/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true Power BI File: https://drive.google.com/file/d/1FH8r45s8sO672lBCE0VVMwYw_PQyUD6J/view?usp=share_link #powerbi #dax
Today we will show you how to create reports with tool tip pages. We will create a sales report by country and products where products and countries will have tooltip pages which will appear when you will hover over their relevant fields. Link to the xlsx file used: https://docs.google.com/spreadsheets/d/1cSmnIs9vW6cyJ5Z-vf1IjV-Gb7vk7feD/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true #powerbi #tooltip #tooltips #powerbitooltips
In this video, we will show you how to analyze the performance of teams, their members, product categories and products through Power BI dashboard. We will create monthly sales and profit charts and use slicers to filter the data by teams/members and products/categories. The excel file used for the data can be accessed at: https://docs.google.com/spreadsheets/d/1105HJYAt6hzP4tfY-t6W3Sf3ZDw6HRQ8/edit?usp=share_link&ouid=111966831820301688680&rtpof=true&sd=true…
In this video we will show you how to use Key Influencers (Powe BI Artificial Intelligence). We will use credit risk data from web, and try to explain the loan default, by borrowers age, income, intent, home ownership, loan amount, etc. Dataset used in this tutorial can be downloaded from https://www.kaggle.com/datasets/laotse/credit-risk-dataset #AI #creditrisk #keyinfluencers #ai
In this video we will create a report with drill down mode turned on. We will show you how to drill down charts to further details. We will drill down charts by date (years, quarters, months, days), by store location (country, state, city), by product (location, category, product name). Sample data used in this report…