Accounts Receivable Dashboard in Power BI
This video is designed to show you how to create a dashboard in Power BI in a practical and simple way.
The Accounts Receivable Dashboard is designed to help you effectively manage your receivables.
Using a Power BI dashboard, users can create visualizations and DAX expressions from multiple data sets.
To create this Accounts Receivable dashboard, we will use visualizations such as:
Cards, area charts, bar charts, tables, doughnut charts, funnel charts, etc.
We will also use DAX expressions: sum, average, calculate, if, divide, and variables (var).
All of this will help you design a great dashboard in Power BI.
🎞️Chapters
00:00 Introduction
01:45 Database, Dashboard Background, and Report Requirements
04:18 Importing Data
04:44 Creating Relationships Between Tables
05:08 Importing Dashboard Backgrounds
06:01 METRICS
06:01 Average Arrears
11:46 % Past Due
14:52 Overdue Invoice Rate
18:25 Segmentators
20:55 DETAILS
21:04 Multi-Row Card - Amount Invoiced, Amount Paid, and Amount Due
24:06 Bar Chart - Aging of Arrears
27:59 Funnel Chart - Billing Funnel
30:15 Doughnut Chart - Invoice Status
32:50 Table
42:19 Navigation Menu
📌Download the worksheet.
https://drive.google.com/file/d/1FQQW...
Song: Brisket Taco
Author: Cumbia Deli