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…
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…
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 create a dashboard from data collected from FDIC Bank Failure dataset: https://catalog.data.gov/dataset/fdic-failed-bank-list. We will show you how to use various charts including map charts and multi row cards. #bankruptcy #financialcrisis #dashboard