December 6, 2016 at 1:45 pm #2815
In your work or internships, what programming languages do you use the most? Or what programming languages do you wish you had learned at UW? What do you find has been most useful in the work of IE?December 6, 2016 at 1:54 pm #2820
Kristen CherneyParticipantDecember 7, 2016 at 1:10 pm #2822
I agree with Kristen. During past internships I think the most useful thing would have been an advanced knowledge of Microsoft Excel. I know you can go to FREE tech training classes through Do-IT but I never seem to have the time. I’ll have to make it a priority in the spring. https://sts.doit.wisc.edu/December 7, 2016 at 2:29 pm #2827
I think Microsoft Excel is definitely important (pivot tables, v-lookup). Another software could be useful is Microsoft Access for using the database. You could definitely find tutorials on Lynda.com. As a UW student, you can use Lynda.com for free. Here is the link to login lynda from UW Information Technology page: https://it.wisc.edu/services/online-training-lynda-com/December 8, 2016 at 7:16 am #2830
I agree with the above comments that ExCel is very important. I did an entire project with Pivot Tables and conditional formatting at my internship last summer. I also had a lot of interaction with SAP. I think being an IE gives us additional background for Supply Chain jobs and SAP was a huge part of that and I ended up spending a lot of time learning how to use it.December 9, 2016 at 8:50 am #2835
I went to a session Intern Sharing night held by Institute of Industrial and Engineers where they talks about the useful tools used in their interns. They talks about the more advanced methods used in excel and also the use of Microsoft projects~December 12, 2016 at 9:09 am #2836
At my CO-OP, I mostly use Excel functions, Pivot table & charts, conditional formatting, and data filters.
My company also uses SAPFebruary 19, 2018 at 2:47 pm #3287
I worked for 9 months as a data analytics intern at a company in Madison. The most useful programming languages in my experience were Python and Excel. Further, an understanding of relational (e.g. SQL) vs non-relational (e.g. MongoDB) database structures was crucial.April 11, 2018 at 10:35 pm #3425
Through my work experiences, Excel has been by far the most used by me as well as my colleagues. It probably sounds lame to say, but because so many of your coworkers will work with you on stuff, it doesn’t always help to know how to do XXX in Python or whatever. The other industrial engineering I worked with used Minitab, but since there was only 1 license we had to share lol.
In short, depending on what industry you enter, the most “useful” softwares will change.April 15, 2018 at 6:55 pm #3446
I have been using Python for everything although Julia appears to be a great language for scientific computing especially in clusters. Julia maintains all the functionality of python while making cluster integration really simple.
Additionally, I have been impressed with visual coding environments namely McNeel Rhino’s Plug-in grasshopper for computer aided design application. Multiple compilers can be run together at once for even different versions of the same language or different languages simultaneously. This makes integration compatibility of different types of data really straightforward. Base language again is Python.April 15, 2018 at 7:04 pm #3449
I have found that python, R, AMPL (or similar tools), and excel would be the most powerful languages that I wish I could gain more experience from. Excel in particular is listed despite not being a full language because it comes with many useful packages and programming components that can effectively answer a variety of questions. I think that a course on excel would do all students well and give them an edge when entering the workforce. I have also gained a lot of experience in MATLAB and Java which might be less valuable in terms of IE but still very good to understand in terms of developing programming skills.April 16, 2018 at 9:58 am #3451
I think as baseline, Excel is necessary. For large scale data manipulation, repeatability, and analytics python is incredibly useful and is used by many companies. For data analysis R/RStudio is also often used. The benefit of the last two is that they are free to the general public so can easily be used wherever you go. Tableau is gaining in popularity for data visualization and extremely easy to use.April 16, 2018 at 5:56 pm #3466
It’s really dependent on what you are intending to use the language for. In my personal experience I feel like Minitab has been one of the more useful programs I have learned how to use, it can do a lot of different things in regards to DOE and quality. Tableau seems very similar in the way it can easily do exactly what you want it to do and it can make some very interesting visualizations. I would really like to learn how to use R more because it is a more conventional language and can do a lot of really incredible things once you have mastered it.April 16, 2018 at 6:00 pm #3467
I definitely think you have the right idea. It all does depend on what your needs for the language are. Tableau and R can do many similar things but R can allow for more custom programs and calculations that Tableau may not be set up to handle. I would also like to learn how to use R as I think it has many applications in Industry.April 17, 2018 at 8:41 pm #3471
It wasn’t until I was working that I wished I had paid more attention to the Excel portion of my freshman engineering classes. Excel and Tableau are the main platforms we use for updating our ever changing data.
You must be logged in to reply to this topic.