Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Build an Automatic Accounting Dashboard for Business Analytics

Jono Catliff via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to build an automated accounting dashboard that tracks real-time business data in this 33-minute tutorial. Follow along as the instructor demonstrates how to create a comprehensive system using Make.com automation platform, PandaDoc for document management, Google Sheets for data storage, and Looker Studio (formerly Data Studio) for visualization. Master the process of setting up PandaDoc triggers to automatically capture contract and payment data, use iterators to process multiple data points, and seamlessly transfer information to Google Sheets for organization. Discover how to model your financial data effectively in Looker Studio and create professional graphs and visualizations that provide instant insights into your business performance. The tutorial covers essential automation concepts including document watching, payment filtering, and real-time data synchronization, making it valuable for business owners, entrepreneurs, and automation enthusiasts looking to streamline their financial tracking and reporting processes.

Syllabus

0:00 Intro
2:53 Software involved
6:05 PandaDoc starting trigger
8:20 Iterator
9:55 Dump PandaDoc data into Google Sheets
20:57 Modelling data in DataStudio/LookerStudio
24:19 Creating graphs in LookerStudio
29:49 PandaDoc watch for documents
31:38 PandaDoc filtering document by paid
32:40 Conclusion

Taught by

Jono Catliff

Reviews

Start your review of Build an Automatic Accounting Dashboard for Business Analytics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.