Click here for ways to listen offline and at 2x speed
Click here to listen to this episode on YouTube
0:00 Introduction
2:21 Hazen Metro: Background and Origin Story
3:48 History of American Meadows
8:24 Category Management and building Seasonal Lineups
10:57 What companies manufacture seeds?
13:14 Migrating to Acumatica in 2018
15:32 Sticking with Magento for eCommerce and integrating with Akinator
16:17 High transaction volume and special pricing from acumatica
19:24 Unique business processes and accumatica customizations
22:17 Quick kits customization from Kensium
23:45 Unique quantity availability calculations
26:58 USDA Hardiness Zones
28:16 Making Mass Changes to Sales Orders
32:50 Using Power BI as Middleware
35:09 Tim’s idea for a Course with Power BI examples
39:07 Connecting Power BI to Google Analytics and Shipping Carrier APIs
40:24 The benefit of a creative background in ERP
43:20 The Python script gets the current shipping statuses from UPS and USPS
47:58 Using Power BI, Google Analytics, and Email Marketing data to understand where orders are coming from
52:49 Demand Monitoring and Capacity Monitoring
53:20 Using Power BI for Picking!?!
54:28 Power BI Incremental Refresh over OData
54:57 Power BI OData Web.Contents and JSON (secret trick)
56:29 OData / Query Folding, DataSelf ETL+, and Velixo
1:02:44 An Acumatica User Group in Vermont or Montreal, Canada?
1:03:25 Wrapping up
Hazen Metro
Location: Burlington, Vermont