Categories
Antiwork

Can you make this in Excel

Posted here and PowerBI sub So I’m at a small foundry that’s been around 113 years. They do a lot on paper including time tracking and accounting. Zero analytics. I was asked if I could help streamline the quoting process which was manually going through the ERP looking for similar parts based on 8 attributes. I brought the data sources into PowerBI, setting up a nice table that is filtered by all these attributes to give the similar part. All minds were blown and it’s exactly what was needed, except they’re asking if I can build this in Excel (2010) literally because “they move slow on technology.” I explained the (2) end users can download PowerBI to use the report immediately, or we could upload to shared workspace if they wanna go premium to have browser version. The people complaining no one wants to work, literally want to claw back…


Posted here and PowerBI sub

So I’m at a small foundry that’s been around 113 years. They do a lot on paper including time tracking and accounting. Zero analytics.

I was asked if I could help streamline the quoting process which was manually going through the ERP looking for similar parts based on 8 attributes. I brought the data sources into PowerBI, setting up a nice table that is filtered by all these attributes to give the similar part.

All minds were blown and it’s exactly what was needed, except they’re asking if I can build this in Excel (2010) literally because “they move slow on technology.”

I explained the (2) end users can download PowerBI to use the report immediately, or we could upload to shared workspace if they wanna go premium to have browser version.

The people complaining no one wants to work, literally want to claw back technology – want the benefits of PowerBI with no effort or learning curve…. Is this normal?? I understand exporting data sets but this is just wanting to duplicate a whole interface so people can see the excel logo they’re comfortable with.

My gut reaction is “sure I can work on that” and just taking forever (there’s no Fill Down in power pivot power query, I think that’s all one needs to know to recognize how stupid this request is).

Anyone seen this before? Do you agree it’s insane to try to replicate the results of one tool in another?

I understand “moving slow on technology” when it comes to costly upgrades. On the other hand PowerBI is a tool in our office package that helps us work around erp export limitations. You’d want to take it slow where you have to, but leverage available tech, right? You wouldn’t force yourself into the slow lane out of culture, right???

Leave a Reply

Your email address will not be published. Required fields are marked *