AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Courses
  • Register

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

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
  • EP 35: Ideas for AUGForums.com Live with Ryan Brown (Podcast) December 12, 2020
  • EP 34: Talking Acumatica eCommerce and the Next Normal for Distribution, Wholesale, and Manufacturing with Ted Stenstrom (Podcast) December 11, 2020
Acumatica Learning Resources

Recent Forum Posts

  • RE: Generic Inquiry RESULTS GRID Column Order

    On the Results Grid tab you can drag and drop the items...

    By Michael Roszkowski, 26 mins ago

  • RE: Acumatica 2020 R2 OwnerID Field

    Thank you, Tim. Just faced this problem in a customized...

    By Anna Borisova, 15 hours ago

  • Import Azure AD Groups to User Roles Screen

    Hi AUG, I'm cross posting this from the community as I ...

    By Michael.Barker, 17 hours ago

  • Link EPApproval to APInvoice

    I am trying to write a GI that will link an Invoice to ...

    By Michael Roszkowski, 17 hours ago

  • RE: Using SMS

    Lightspeed Voice has a message service "built" in. Thi...

    By Doug, 22 hours ago

  • User access right - cost on Sales Order

    Hi, I have a problem that i can't solve. I have build...

    By Fosse, 1 day ago

  • RE: Problem when i have more then one Alternate ID

    Thanks for the answers! Unfortunately I don't think ...

    By Fosse, 1 day ago

  • RE: Using « start with » unstead of « contrains »

    It's a contains search, not a "starts with" search unfo...

    By Tim Rodman, 1 day ago

  • RE: Problem when i have more then one Alternate ID

    This article I wrote explains how to work with barcodes...

    By Carl Brooks, 2 days ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.