EP 95: Jon Flinn, Using Power Query with ERP Systems (Podcast)

AUGForums.com Real Talk is an Acumatica Podcast: Acumatica User Interviews, Info, News, and More! Our Two Rules: 1. No Editing. 2. Publish Immediately.

Click here for ways to listen offline and at 2x speed
Click here to listen to this episode on YouTube

0:00 Introduction
3:07 Jon Flinn: Origin Story
6:52 High School Basketball, Getting Arrested, and Getting into Finance
11:37 Being Smart Academically vs. Working Hard and Finding Your Path
13:57 Coach Jeff Armstrong and Improving Incrementally
18:44 Using Power Query to Automate Accounting Tasks
23:02 Using Power Query in Financial Planning & Analysis (FP&A)
25:20 Accepting Inputs in Power Query
27:17 What does the Power Query Output look like?
30:33 Just solve it, then worry about performance
34:02 Copy/Paste from Power Query in Excel to Power BI
36:14 Using Workday data with PowerBI.com
38:54 Writeback capabilities with Power On, Power Apps, Adaptive Planning, etc.
41:23 Building a 10 person Finance Transformation team
44:32 Using Power Query to fight fires when going public and conducting 100+ person Power Query training
46:57 Speed, Simplicity, and Automation since Finance is more of an Art than Accounting
48:34 Write down your process steps on a piece of paper, then try to Automate with Power Query
53:16 Wrapping up

Jon Flinn
Location: Phoenix, Arizona

PostID	Related Links
Test	#AcumaticaTnT #1 - Adding nicely formatting links to a Dashboard
Test	#AcumaticaTnT #1 - How to make redirects in Acumatica and Popup warning
Test	#AcumaticaTnT #1 - How to print multiple product labels based on a line item quantity WITHOUT a customization
Test	#AcumaticaTnT #1 - Sync Sales Order User Defined Fields at time of Order Import from BigCommerce to Acumatica
Test	#AcumaticaTnT #2 - Code to properly display totals on a Grid / Inquiry
Test	#AcumaticaTnT #2 - Get Last Sales Price and Quantity without SQL
Test	#AcumaticaTnT #2 - How to make selector for CSAnswers
Test	#AcumaticaTnT #2 - Vote on Idea to merge customers/vendors, not just prospects
Test	#AcumaticaTnT #3 - Default Sorting on Aggregate Results
Test	#AcumaticaTnT #3 - Dynamically changing a selector for a given data record in grid for Acumatica
Test	#AcumaticaTnT #3 - Joining to DateInfo Table Challenge
Test	#AcumaticaTnT #3 - Mapping Acumatica Customer ID into BigCommerce
Test	#AcumaticaTnT #4 - Acumatica Events Page
Test	#AcumaticaTnT #4 - Creating "Harvester" Parameters
Test	#AcumaticaTnT #4 - Sync an Item from BigCommerce to Acumatica using Sync Status as Side Panel
Test	#AcumaticaTnT #4 - User-Defined Fields in Workflow and Attributes getting deprecated in future Acumatica versions
Test	1st ever Power BI User Group - Tim's the guy who brought his laptop to Mavis Winkle’s
Test	Acumatica 2021 R1 Release Notes
Test	Acumatica and Excel OData Credentials on Local Computer
Test	Acumatica OData announcement and why it matters
Test	Acumatica Summit 2021
Test	Acumatica Summit 2021
Test	Acumatica Summit 2021
Test	Acumatica University
Test	Arline Welty crashes the party
Test	Big Data Iceberg - Calculation Engine vs. Data Visualization
Test	BigCommerce University
Test	Broadcast Notes
Test	Broadcast Notes
Test	Chip Fritsch
Test	City Worth Loans
Test	Contact Arline
Test	Contact Laura
Test	Creating Parameters in Excel that restrict data returned from Acumatica
Test	DataQuest
Test	Discussion Forum for Acumatica, OData, and Power BI
Test	Doug and Steven Session at Summit 2021: "Low Code/No Code Development with the New Workflow Engine"
Test	Doug Presentation Slides
Test	Embed Excel Online in Acumatica
Test	Embed Power BI in Acumatica
Test	Hackathon at Acumatica Summit 2021
Test	Hackathon Recap Blog Post
Test	Julian Schrenzel
Test	Laura's Blog Post
Test	Live Suggestions
Test	New #AcumaticaTnT Feature on AUGForums.com
Test	New Course: W150 Workflows
Test	New GI Features coming to Acumatica in the future
Test	Parallel Solutions
Test	Picture of Ryan's Team Winning 1st Place
Test	Rewind Copy for BigCommerce Sandboxes
Test	Rob Collie - Guy who Tim Rodman learned Power BI from
Test	Rob Collie's Best-Selling Book - Excel user's guide to Power BI
Test	Ryan Brown Automation Steps Generic Inquiry
Test	Ryan Brown Automation Steps Generic Inquiry Side Panel
Test	Sample xByte BigCommerce Product Page
Test	Skyvia database update tool for BigCommerce
Test	SQL Joins
Test	Ten Ways to Deliver Business Impact with Power BI
Test	Thanks Shawn Slavin and ITA Alliance
Test	Thanks Shawn Slavin for your office
Test	Tim's Thoughts on Sage
Test	Toon Six
Test	What is Power BI?