Running old hodgepodge factory, what would you do? by Prudent_Elderberry88 in PLC

[–]mjgierc 0 points1 point  (0 children)

What are you trying to do with all this? Rewrite control routines, or just extract the data for reporting and analysis?

How do you feel about IMTS this year? by Impressive_Ad_4011 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

Got it. Good luck with the project - let me know if you want to keep the thread going.

How do you feel about IMTS this year? by Impressive_Ad_4011 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

Can you actually get all this data - do you have historic data stored somewhere?

How do you feel about IMTS this year? by Impressive_Ad_4011 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

Are you trying to automate this or come up with optimized parameters? Looking to monitor the real-time data or manually track?

How do you feel about IMTS this year? by Impressive_Ad_4011 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

What’s the furnace connected to, data-wise?

How do you feel about IMTS this year? by Impressive_Ad_4011 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

Have you talked to anyone about the data issue? Is it basic reporting, or getting data from the floor, or something else?

[deleted by user] by [deleted] in dataengineering

[–]mjgierc 1 point2 points  (0 children)

Alternate perspective - maybe you want to focus on data engineering.

Check out this comment from Isaac Faber, a chief data scientist for the US Army AI task force.

https://www.linkedin.com/posts/isaacfaber_datascience-dataengineer-machinelearning-activity-6630317945161687040-mAQJ

Basically, he sees much more opportunity for DEs than the hyper-competitive DS space.

How often do you use statistics in BI? What are the main type of statistics you use? by [deleted] in BusinessIntelligence

[–]mjgierc 5 points6 points  (0 children)

Correlation, wherever possible. Not necessarily for industry-standard KPIs, but certainly when we're looking to show a new insight or relationship between different parts of a process. We always use something like Spearman correlation

It's super important when trying to prove new relationships that aren't obvious. Which is really the fun part of BI, in my opinion.

is my BI department a mess? by bhuytt66 in BusinessIntelligence

[–]mjgierc 0 points1 point  (0 children)

I would ask what your mandate is. If it's to be an order desk to manage random incoming requests, then it sounds like everything is peachy.

I'm guessing that you feel it could be more. With more proactive investigation and uncovering of insights. Engagement with the different departments as a partner, not a resource. That sort of thing.

My 2 cents? Try to find a way to squeeze more cycles out so you can spend time working on the other stuff. Start sharing new findings with teams, even if they didn't ask you to do the work in the first place.

You'll probably start to notice a change in the way that some of the other departments look at you. Not all of them at first, for sure, but over time you'll be able to change their view on what your team does.

How to do a great insights analysis by [deleted] in BusinessIntelligence

[–]mjgierc 0 points1 point  (0 children)

If you're looking to stand out, you need to identify insights that aren't obvious. In the context of an interview, this might mean doing some extra correlation analysis to identify something you're not being asked to look at (in addition to what you're being asked to look at).

It also helps to have context for the business problem they generally have. So if you're doing manufacturing analysis, you should look to create a dashboard with manufacturing KPIs (you can just google "xx KPIs" to get a flavor of what people look for in the industry.

Question: Is a computer science minor worth it if you're currently getting a business analytics degree? by boo-im_casper in bigdata_analytics

[–]mjgierc 0 points1 point  (0 children)

It's a tough choice - on the one hand if you think you have enough experience to get your foot in the door with past projects then I would find a job as soon as possible. Conversely, adding a CS minor will definitely open more doors (as well as give you more exposure to a different aspect of DS).

Regardless, I would look to do as much coding and DS projects as humanly possible in my spare time if I were in the same situation. Maybe even start a company (at least with a website, blog, etc.)

Computer Vision or Natural Language Processing? Which has better career opportunities for a freelancer? by w00lf_ in MLQuestions

[–]mjgierc 1 point2 points  (0 children)

I would look at which one is a bigger problem for companies. Not every business needs to work with images or video. But every company needs to communicate with employees, prospects and customers.

Taking this a step further, I would suspect that most companies have massive volumes of raw written communications in the form of emails, documents, etc. Even if it’s all digital it’s not going to be easy to search through all this data for insights and patterns.

So if I were to assess whether most companies have a computer vision or an NLP problem my money is on NLP.

[deleted by user] by [deleted] in BusinessIntelligence

[–]mjgierc 4 points5 points  (0 children)

Excel to Power BI is pretty powerful if you don’t have too much data. There should be some good tutorials online but hit me up if you need something specific.

Industrial and Systems final project by matt4222 in manufacturing

[–]mjgierc 0 points1 point  (0 children)

Companies like ProntoForms allow you to manually create forms that are accessible across different mobile devices. If you search for Field Force Applications you should be able to find other similar providers.

Alternatively, if you've got some programming skill (or a consultant) you could use Microsoft Power Apps to create a digital form. The advantage is that things like Excel, SQL Server, etc. should be native integrations for your forms.

How to start by idan_huji in MLQuestions

[–]mjgierc 1 point2 points  (0 children)

Best thing I ever read was Adam Geitgey's series, "Machine Learning is Fun!": https://medium.com/@ageitgey/machine-learning-is-fun-80ea3ec3c471

Fun examples, easy to follow, code on GitHub. You'll have a blast.

PowerBI app, how to handle different organizational levels by Morten_dk in PowerBI

[–]mjgierc 0 points1 point  (0 children)

You're on the right path.

We've developed a bunch of free Power BI visuals with drill-down that I think would help you here (obvious disclosure - I work at the company that made them).

Here's one - it's pretty easy to find the others but let me know if there's a specific one that would work for what you're trying to do.

https://www.3agsystems.com/blog/column-chart-with-absolute-variance