AUG

Acumatica User Group

  • Start
  • Forums
  • Blog
  • Courses
  • Login

Of Acumatica and Power BI – A Tale Loosely Inspired by the title of a classic novel by John Steinbeck (Guest Post)

October 13, 2015 by Tim Rodman

Guest post by Brad Kostreva

Quick intro from Tim: I was thrilled when Brad asked me last month about doing some guest posts here on the blog. We first connected about a year ago through the blog and have kept in touch ever since. I mentioned him recently on the bottom of the What is Power BI post. Unlike me, an Acumatica reporting hobbyist, Brad is actually using Acumatica, Excel, and Power BI in the real world. I’m looking forward to hearing his real world experiences in this and future posts. Take it away Brad!

Of Acumatica and Power BI – A Tale Loosely Inspired by the title of a classic novel by John Steinbeck

“Brad, for God’s sake, don’t VLOOKUP so much! Brad, you hear me? You gonna be #REF like the last column!”

Excel Formula Errors

Greetings all, my name is Brad Kostreva, roughly pronounced Brad Kerstereereesvo apparently – though mostly by my Uber drivers. Tim Rodman has been gracious enough to allow me to guest post here and there on his blog about my experiences using Acumatica, and some tips and tricks I’ve learned along the way, as well as perhaps some challenges that I’ve hacked through, or even could still use some advice, guidance, or sanity checks to overcome.

Some ideas I have for my blog entries here include:

  1. “Generic Inquiries – Show me your OData Face!” which I hope to outline some of the ways I’ve used GI’s within Acumatica and getting the data to front end analytic tools for massaging and consumption. Or as I like to call it “Data Second Base”ODATA
  2. “Now You’re Playing With PROCESSING POWER!” which is where I will discuss what happens when the data set is massive, and you need to find the balance between getting hyper-granular within the Generic Inquiries, let Power Query do the Heavy Lifting, or building more or less “clean” Data Models within Power Pivot and massaging from there. Also important in this entry will be a discussion on what the end users will be using. It’s all well and good for me as a Business / Data Analyst to have a tricked out 64 bit version of Windows and Office 2013 with more internal memory than a new iPhone… but what about our end users, and how will they be affected?Power BI
  3. “PowerBI – Stop it, You’re KILLING ME with Functionality!” which is where I get to basically play around with easily my favorite tool from Microsoft since Minesweeper. In the past six months, the functionality of the PowerBI.com site combined with PBI Desktop has blown me away in terms of what you can do in the SMB space for both self-service BI as well as coming off as a hero to the Execs with pretty pictures, relevant data, and actionable information. Acumatica has embraced this front end in a VERY smart move, I believe, to both extend the Excel Jockey’s toolset in the SMB space as well as show how easy integration can be. And don’t get me STARTED on Power BI Tiles for Office!

The pieces are all in place. Acumatica is the ERP solution, Odata is the transport protocol, Excel is the analysis tool, and Power BI is the presentation. I’ll touch on all these and more (until Tim tells me he’s heard enough from me)!

Credit where credit’s due – I’ve learned a TON from Tim himself and his journey as a Perpetual Acumatica Learner and here at augforums.com over the last year. If you’re not following him on Twitter or LinkedIn, get on that.

Rob Collie

Rob Collie’s DAX Formulas for PowerPivot (I own 1st Ed, but 2nd Ed is on its way) probably taught me more on constructing  and combining data via DAX for Power Query and Power Pivot in a manner that is directly applicable to use cases. Between his and Avi Singh’s posts (as well as guest posts) on PowerPivotPro.com, they take that to the next level with up to date and timely information on the Microsoft toolset that unlocks the data in Acumatica and makes it usable.

Microsoft’s Business Intelligence Team – If you’ve ever used PowerBI.com or the PBI Desktop and wanted or needed any help, they’ve been extremely responsive to customer input and feedback, as well as assistance should you ever click the “frowny face” in the applications.

So look for these and other posts from me on occasion here at augforums.com!

Also, feel free to follow me on Twitter or LinkedIn. Thanks, and don’t hesitate to shoot a comment or two below with ideas or suggestions for a blog post or two as well!

2017-05-11-03-56-56

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Excel Connector, Acumatica OData, Acumatica Reporting, Acumatica Reports in Excel, Acumatica Training, Microsoft Excel, Power BI, Power Pivot, Power Query

AUG, an Acumatica User Group

AUG, an Acumatica User Group

AUG, an Acumatica User Group, connects the Acumatica user community together, providing an online place to ask questions about Acumatica, share information about Acumatica, and improve your Acumatica skill set.

AUG Forums
AUG Query Quarry
AUG Blog
AUG Local

Recent AUG Forums Topics

  • Style Color not switching on Value

    By Fred Reiter, 2 days ago

  • Add Custom Field from Location to Customer Locations Tab

    By Kevin Ruppert, 5 days ago

  • SO Error: Shipment counters are corrupted

    By Wendy Pratley, 1 week ago

  • Edited 2019R1 Modern UI format. Reverted to default menu when I install a customization

    By Saiful Murad, 2 weeks ago

  • Pick Ticket Lines Duplicating

    By Kristin Christian, 2 weeks ago

Recent AUG Blog Posts

  • What is AUGForums.com? (Audio Post) November 11, 2019
  • Acumatica 2019 R2 Roadshow – Columbus, Ohio November 8, 2019
  • Acumatica 2019 R2 Launch Series (Audio Post) November 7, 2019
  • Columbus Ohio After Party @ Acumatica 2019 R2 Launch Event November 6, 2019
  • What is an AUG Blog Audio Post? (Audio Post) November 4, 2019

Other Acumatica Resources

Acumatica.com
LinkedIn Acumatica User Group
Acumatica Learning Resources
Recent Tweets

Copyright © 2019 · Tim Rodman
The views and opinions expressed on this website are solely my own and are not necessarily those of Acumatica or Aktion Associates. This is a personal website that is completely disconnected from my day job.