Technical Platforms

Google Cloud

• How to Search Google Cloud Storage

General

• All Distinct Values in a Column

Database KPIs

• Invoices: How Many Days to Pay by Invoice

ETL Works

• The Basics of ETL Works
• Firm Creates Change Tracking tables in their Database

Database Queries

• Billing: Finding WIP and Jobs
• Collections: All Collections Triggers for a Given Firm
• Collections: Deactivating all staged Smart Statements from the Firm Portal
• Collections: Staging Analysis
• Invoices: Trace Inbound to Outbound Invoice Email
• Payments: All Refunds, Disputes, and Failed ACH Payments

See all 11 articles

Automated Reporting

• Creating a New Routine in Postgresql
• Google Scheduler