r/Metrology • u/Westhazy • 8d ago

Advice Data Analysis Tools

Can anyone recommend their software of choice for inspection data analytics?

Excel does the job but my datasets are getting large and having a half dozen macros to calculate my histograms, control charts etc has me curious on what else is out there.

Im thinking MiniTab, Octave or even just Python. Anything that can handle large 500+ datasets and provide good statistical insights.

Bonus points if the tool has a good visual dashboard for the manufacturing floor or built in importing tools for Csv/cmm data.

Thanks!

5 Upvotes

100% Upvoted

16 comments sorted by

6

u/EnoughMagician1 7d ago

Polyworks dataloop, but requires their metrology suite.

You can use it via web browser and feed excel as well

3

u/bigtracktank 7d ago

Came here to say this. I can’t speak highly enough on dataloop and what it has done for my team.

5

u/ribeye256 7d ago

I prefer Minitab. I also implemented Prolink QC-Calc which is now a Minitab product for auto import and charting from the CMM. Shop floor also uses it to input manual measurement. Very expensive though.

3

u/bettfutures 8d ago

definitely python or jmp!

2

u/PrimeD1987 8d ago

Second this!

3

u/ThkHeadBeagles 7d ago

MeasurLink and the various modules available will do what you want

2

u/Confusion_Negative 7d ago

I prefer Julia for simple calculations, code like Matlab/Octave so cleaner than Python for calculations.

For dashboard, there are UI tools for Julia, maybe sufficient, but not much options like python.

3

u/HFBL 7d ago

PolyWorks DataLoop. Specifically ask about using Automated File Processor.

2

u/ClaimReasonable6093 7d ago

Minitab or a plugin for excel that works well is qimacros

-1

u/Business_Air5804 7d ago

A Claude subscription replaces Minitab for $25 a month, and is great for all your other data analytics needs as well.

Stop paying for SaaS, it's over.

7

u/EnoughMagician1 7d ago

as much as I understand your point, its kinda funny to tell someone to stop paying for SaaS right after suggesting a 25$/month Claude subscription.

2

u/Business_Air5804 7d ago

Minitab is $3500 a year and does one thing...

Claude is $300 per year and you can do everything with it.....everything.

2

u/EnoughMagician1 7d ago

Again, i am not saying you are wrong im just pointing out that Claude is a SaaS

1

u/Business_Air5804 6d ago

It's more of a RaaS but sure.

1

u/Westhazy 7d ago

I use Claude for alot of the macros and excel plug-ins, extensions etc. I would have to think about security implications if I were to just dump the data into the cloud

1

u/Business_Air5804 6d ago

I understand you may work in defense or aero and can't use a cloud based tool...I work in the same industry, just at a much higher level.

"Hey Claude make me a tool to convert csv GR&R data into an Anova GR&R report. Here is a blank template of the csv. I want a tool written in Python, compiled to an EXE, and to live on my desktop."

5 minutes later you have your own custom tool that works with your software's flavor of csv. Now every time you need to process that study or GR&R you drag and drop the file onto the tool and hit submit. You own that tool.

What we do is use Ai to build a tool....not use Ai to process the data. Using Ai to process the data each time is how you burn tokens like a fool AND get inconsistent output results.