 Hello, everyone. All right, welcome to the third live event of Etsy 4x supply chain technology and systems Firstly, I have to admit I am very jet lagged and I very much apologize for the multiple emails to receive this morning. I Mixed up the time and the link and so I just have to apologize for flooding your email I just wanted to make sure you had the right information. So again first just want to start off with that. So Hopefully you're not too annoyed with me for sending multiple emails, but hopefully that also means that you're here and you get to hang out with us So this is sort of a more general session than we've had in the past couple sessions It will be a general wrap-up of the course So I have mr. Connor Mikowski with here as you guys you've met him several times and you know, he's one of our key colleagues on a MIT digital engineer. He helps us with all kinds of things So he's going to help me recap the course from weeks one to four and Also discuss the fresh connection and then I'll be talking about the latter weeks and in this at point you know, we're going to have our breakout rooms where we're gonna do a little something a little different instead of Posing questions to you. We want you to tell us what you've learned in this course And how you're applying it in your everyday work And we really feel like this is the really interesting stuff and these kind of anecdotes really drive our work So as we're talking, you know, just brainstorm some things that possibly you plan to use or you're already using And that's what we'll do in the breakout sessions. So first Just as sort of a recap of who is in this course So we ended up right around 11,190 students total in supply chain Se forex this time. We have 917 verified students So you guys are part of that cohort of students This is only a second time that this course has ever been run So this is, you know, it's some of it's all new material and you guys are Experimenting right along with us. So we're so grateful to have you The median learner age is 30 years old. So a young crowd here and the top Countries represented are the United States, India, Canada and Brazil Canada actually moved into the third spot. Brazil is generally in our third spot So I thought that was an interesting switch up for this course There's over 168 countries represented, which is always Super amazing to me and it's such a cool thing to have such a global population with us and 22.8% of you are female. So while that seems low, you know Supply chain is generally very heavy male dominated So I'm really happy to see almost a quarter being female and hope hoping we're driving that percentage up So you ladies out there, you know, get out and tell the other ladies how how good this course is and how Central supply chain is as you already know and the fan last little note is You know, we're gonna have sort of an open-ended Q&A breakout session this time But one thing I would like you to ask to save your questions on the comprehensive final exam So as we've kind of been sending out some notes, there will be a session on the comprehensive final exam Next Monday, so I will absolutely double, you know, right the right time So that will actually be at 1600 UTC On December 11th, and that will be myself Alexis Bateman and Dr. Eva Ponce the executive director of the program And what we'll be doing is really just giving an overview of the final exam How you're going to get enrolled as we actually will be Manually enrolling you because we have to make sure that everyone's past the course as well as Requirements what what you could have during the exam how it's really going to run So if you have any questions about the comprehensive final exam, please save those for next week And you can of course there's a the help email see effects help at MIT edu So if you have kind of questions in between then or you can't make to the live event, please You know use that email as well so At this point, I'm gonna turn it over to mr. Conor Macaucy, so he's our you guys know him very well so I don't know if he needs more introduction, but He's been very key to this course So he's gonna do a little bit of a review of the first weeks that you guys went through and hopefully you can Recap and remember back to those those early weeks. All right. Thanks Conor. All right. Hey guys It's it's nice to be here today I really appreciate the introduction Alexis and I really appreciate everything you've got going on All right, so I'm gonna start with the recap of the course I'm just gonna start with week zero and I'm gonna move all the way through week four and then I'm gonna let Alexis take back over and then she'll go for the rest of the course So in week zero we actually did a lot of like course introduction stuff This is also where we introduced the fresh connection So the fresh connection is a game that we actually didn't have as much participation as we had hoped And this is a game that I know some of you have played but some of you have not So I'm gonna quickly go over what that is the fresh connection is a global simulation game. It's played online There's a log in you you go into this platform and you can play the game now as part of this We cover all aspects of supply chain management In this we cover purchasing operations supply chain and sales So you start with purchasing you'll choose your suppliers You'll choose how much you're gonna pay them you're gonna choose the different Levels of service that they'll give you and that's all negotiated And then you then have them ship those things to you they come into your warehouse And so your supply chain person or you your supply chain on part of the game you would decide how much inventory to have in the inbound warehouse and also how much inventory to have in an outbound warehouse after production happens and then in the middle you've got this operations role that you'd be playing and In that you'll actually be deciding, you know How often to produce how much to produce of different products in this game? It's a it's a juice game. And so you're choosing how much to produce of these juices Then at the end You go back into this outbound warehouse and you go into sales your salesman contracts with different customers What products to offer them how much of those products offer and the different levels of service that you give to those customers as well as other timing restrictions and So this is a very very interesting game that actually ties in everything we've learned in all of our courses I would highly recommend that in the next one of se forks you come back And you just play the game if you haven't had a chance to do that so far So that was week zero week one We covered data modeling and so we started with relational tables tables attributes those types of things We worked into standardization data integrity We covered relationships and enterprise enterprise resource diagrams as well as keys Like prime and four keys how we can tie these tables together And so the idea is we would kind of build this foundation up build a common vocabulary And then we would work you into more advanced parts of database management like in week one lesson two normalization We covered different standardization of that normalization and essentially that just allows a lot more modularity and efficiency It can allow you to keep data structures longer and then also do a bunch of other things in this we covered first through fifth normal form and We covered different Aspects of that now each one of them have different kind of performance levels And they actually slows down your performance as you go but it saves The amount of space that you're gonna have in your servers and so in doing all of this We kind of discussed the trade-offs of that and that kind of It's something that we discussed later on and at the same time we also discover or discover Discuss client server architecture and so how do we tile of this together and what does this mean for a database? And we discuss in week two how we move into these how we get information out of a database once it's set up And so this we have how to create and remove databases how to create and remove tables columns primary and foreign keys We even add data to that to that function there And so in doing this we can then move into pulling data out from that database We can answer some questions, so we answered all sorts of different business questions for example What what is the name of some guy in states? Jay and so we can pull these different data insights out from our database using different queries And then we move into some different database extras We talk about the connections between databases how to optimize databases or even set up data warehouses And then the benefits of using the cloud we also discuss data cleaning And how you can clean data and what that means for your databases And then we kind of tie this right in directly to machine learning This is where most of the database systems are moving today It's how do we not only just collect this data, but what do we do with it? and so we discuss machine learning in general a lot of general terms and We start with a higher level of that and so we start what is machine learning and and when do we use it? And what does it mean to use that? Machine learning we also talks about we also talk about types of machine learning like supervised and unsupervised learning As well as how to use different learning mechanisms To make inferences about our data So then we get into the nitty-gritty in week four and we start with dimensionality reduction So we talk about principle component analysis and how we reduce dimensions that way what it means to reduce those dimensions And how also we might lose a little bit of data depending on how many of those dimensions we keep But we can also keep all of our data structures. We also talk about unsupervised classification So specifically we discussed k-means clustering and how we can classify data using different clustering algorithms So that way we can look at it and we can garner insights even if it hasn't been labeled before We also look at supervised learning which is once again We have the data labeled and then how do we predict future labels of data We haven't seen before and we can then use all sorts of different techniques to estimate how well we'll do Predicting this data in the future and so in that we learned about Decision trees k nearest neighbors and random forests. I think as well as naive bays and We discussed what it means to measure that using cross-validation folds We also discussed how we measure sensitivity and specificity what that means for our models and how we can use that better in the future And then at the end we connect all of the dots together We dive into the transaction data and we use queries to explore the data We then use different machine learning techniques and data visualization techniques to view and garner insights from that data Which then gives us a really good kind of tie around for everything that we did in the first half of the course Now at the end of all that essentially what we do is we have a mid-term exam and we go into the next part of the course I don't want you to think that that's not connected the next part of the course is all all of these different systems that have Everything like this built in this is the foundational aspect of what the next part of the course will cover And so I'm going to pass it on to Alexa so she can cover those those next larger parts of the course those different systems that we use Perfect great. Thanks so much kind of that was a great recap for the first four weeks And I know that you know those those weeks were really an eye-opener for for some of you some of you obviously work With the with big data all the time and are able you know data management systems But I know that you know having that in a supply chain perspective was incredibly useful So then after week one through four you guys remember we had the midterm which was Average of eighty four percent amazing average ninety five percent Pass rates so it seemed like you guys really got the concepts who are really pleased to see how well you were grasping all that information So as we moved on from the midterm we kind of took that to the next level So then you know you have you have sort of these Data management skillset and then we moved into some of the areas that I think many of you work with every day So looking at sort of the supply chain software system So those you know as as we've talked about throughout these series of courses There's really three flows and supply chains right so you have Information material and money essentially and so what we've touched on probably the least at this point is really how you're managing that Information so the week one through four started with that and then we continued into sort of now the systems that that so often Managed those so we looked at them from a variety different perspectives So we classify supply chaining to the IT systems into really three main ways You know, there's really enterprise report resource planning ERP's as many of you I'm sure work with on the very daily basis Then there's a little bit more supply chain planning systems that are really doing some of the forecast and planning and then there are really the supply chain Execution system so that's things like transportation and warehouse management and they really are More about executing and carrying out the movement of product So enterprise enterprise report resource systems are really kind of the decentralized database for much of a business's Information, you know, and it has a lot of pros and cons, but it has a few core functions So, you know, there's really the the customer management component manufacturing procurement logistics product data Finance asset management and human resources so the you know, of course, you know Different ERP systems are set up in different ways and that can be not necessarily comprehensive There may be offshoots of other systems that come together to support that that bigger ERP system. There's also three main kind of data sources that go into ERP systems This would obviously be organization data. So that's really the structure of the enterprise, you know How your business is set up others are master's data, which are entities like customers and vendors and then Transaction data really is the outcome of executing process steps. So and within ERP There's different forms of communication as we talked about which was really, you know, there's the business-to-business So transitions between manufacturers whole sailors retailers, then there's really the business to consumer. So Transaction between firms and and and consumers such as ourselves and Accelerating and validating B2B and B2C transactions. So this is really then, you know Trying to accelerate that communication between the business-to-business and business to communication interchange So, you know, and then we really got into sort of how that information exchange works So electronic data interchange EDI and and how really the computer computer to computer Interchange of messages takes place the time period the restrictions the challenges and We we ended really week seven with the the value of ERP for SEM so that can be, you know Reducing the impact of bullwhip effects, right? So as we we've learned out sort of the whole course is the challenge of You know the bullwhip of limited communication Challenge of planning So then, you know having these ERP and communication systems Enabling more transparency and visibility and and planning capabilities and then also allowing a lot of analytics So having that core data repository being able to use that to plan and to forecast that it is another capability and then we move more firmly into the Supply chain systems or supply chain models. So kind of looking at the difference between, you know, planning and execution Software Packages and so this can you know, some of these are really based around Timelines, so if you have advanced planning systems, you're thinking a little bit further out the time periods a little bit longer And if you're you know, the execution systems, we really talked about two different execution systems So we talked about the TMS transportation management systems, which I know many of you are quite experts in and we use daily and you know, how that really Guides the transportation management really planning creating ships from shipments from orders executing selecting and tender to carriers Monitoring and reconciling so actually auditing the invoices and paying for transportation And then we went into the warehouse management system. So WMS. So this, you know, it could include different components whether that was You know automatic identification technologies whether that's barcodes scanners, you know RFID Smart cards things of that also communication technologies so radio frequency data communications and the like and also automated material handling technology So, you know carousels robotics of all of those likes and we got into some of those, you know type of Even more advanced technologies in week 10. Obviously So then, you know, we also walked through a lot of the in each of these really the software components what they handle You know, so order processing Receiving putting away picking shipping so that that's really into a WMS system And then we also went through manufacturing execution system So each of these have their, you know, their their strengths and weaknesses and applications in different sectors in week 8 We got into supply chain visibility. So, you know, we have these various supply chain Systems and you know in in the perfect world they would all work very clearly together and and you know communicate very clearly across and also provide us upstream's Visibility, but as we all know in the real world that doesn't always necessarily happen So many companies these days are really seeking more visibility across the supply chain to further reduce things like the bubble up effect Risk management, you know uncertainties. So in week 8, you know, Chris Chris really walked through what visibility means So tracking and tracing so whether you're, you know tracking it down You know to consumer or you're chasing it upwards from supplier and really, you know identifying Different components tracing where did it come from? Where's it been? You know and then tracking. Where is it now? Where will it be? When will it get there? So, you know differentiating between those and really the different resources you need to get that granularity of information So and you know, there's a lot of different interacting components here, you know different technologies So, you know, there's kind of three different components capture and translate Transmit and upload and access in action action ability. So we really walk through, you know, some of the, you know components so, you know barcode and RFID for capture and translation and then the different ways for transition and uploading EDI API and GPS and talking about the pros and cons limitations Advances and then obviously talking about how we access and then take action on that So, you know integration into existing systems or possibly an additional supply chain platform like supply chain event management or something like a supply chain control tower and The reender that week I dived into a case study on beefs to kind of give you I hope I didn't, you know gross you out too much a beef statistics But you know looking at some of the challenges and things like the food industry of recall and having limited Visibility and you know, really some of the risks there and you know Some you know, some industries are really pushing for that increased visibility visibility some of the challenges and opportunities there And then the last kind of core content week We, you know, we went into more kind of the selection and implementation component So, you know this we walk through sort of the evolution of architecture and supply chain systems Looking at, you know, some of the advancement now whether it be cloud computing Platform as a service software as a service So how come companies are really, you know, selecting their their platforms and and integrating them in the system. So And really there's, you know, kind of four different types of you know sources to select your software systems And that's you know, you can customize it internally as some companies do which is expensive and time consuming There's kind of the ERP expanded system, which is sort of the bolt-ons to an ERP system Then there's for these best breed solutions. So, you know, possibly, you know The TMS that's really the the best of breed in that sector and then there's the best of breed platform So, you know, just giving you a sense, of course, this is not, you know End all but some good kind of organizing factors to think about these systems Then, you know, once you've thought about the systems, how, you know, you know, how do you select that vendor? What do you need? What's going to be the total cost of Implementation and then, you know, really thinking about, you know How you implement this and as as I'm sure many of you have been experienced in this, you know It's a it's a huge task takes a lot of time takes a lot of resources. So, you know What are the challenges of implementing different soft software supply chain solutions? And then we really got into we ended in week 10 and this is where we got to do some fun stuff You know, we didn't well, I mean, I would argue right that everything is fun in this course, but You know, it's some of the week 10 with some kind of new technology trends. So In this week, we really got to touch on a few different things. So we got to touch on You know, things like out of additive manufacturing autonomous vehicles robotics Augmented reality and so it was a really nice kind of Week where you just kind of saw some things that are impacting Supply chains and also, hopefully you were able to do some of the polls or you'll be able to do the polls on You know, what you see is coming down the line Whether it be mobile computing crowd sourcing delivery drones And blockchain, you know, of course a huge buzz around each of these things and you know that we did it sort of in a Continuum in some sense on what is sort of already, you know Pretty well adopted. So Whether that's obviously something like additive manufacturing to something that's more very early day something like blockchain So we got a series of experts that, you know, really gave some insight here And then also some discussion and around it and of course we want to see what you guys You know, take away or you see as, you know active professionals in the field So that was sort of the the latter half of the course covered a lot of material and things that I think are very core to some Your activities Just as, you know, before I hand it back over to conor to wrap up the fresh connection We we really, uh, you know as we get to the the final exam so next next wednesday at 1500 UTC the final exam will release so we'll cover All the weeks with the exception of week 10. So you won't have any material on the technology trends That that's more for just kind of, you know, thinking about things coming down the line So it will really be on weeks one through four and seven through nine So that'll release next week. So all right. Well, thanks and I'll head it over to conor to for the wrap up the fresh connection All right guys, so we're going to wrap up the fresh connection right now So I'm going to start by going through the winners of the fresh connection Um, and then maybe a couple special mentions and then I'm going to address some of the questions about the fresh connection that you currently have So, uh, we'll start with the third place overall winner for the fresh connection and that's going to be, um Um, uh, Deval de Tarro with a 5.94 percent ROI the the username is uh, Deval de Tarro and uh, first name of that student is Diego In second place is Brent m 33 with a 5.98 percent ROI. That's a very good ROI and uh, that's Brent And then in first place with a 6.25 percent total ROI. That's the average ROI through the whole game Is rd fi or Rashad. So congratulations to you three. You guys did an excellent job I'd also like to acknowledge our top round Played by any student through all four of these rounds is by julio and it was in round four He scored an ROI of 7.63 percent, which is very very good for this particular game Now we also have some questions regarding the fresh connection. Um, so Amarecio Rodriguez 70 says really great game and experience. How can we continue playing the fresh connection next year on the global tournament? um And so essentially that is going to be something that the fresh connection will connect will contact you about Um, and so I will be in contact with them making sure Of what's going on there connecting some timelines But my guess is they're going to contact you sometime next spring So I will get with them and I will follow up with you guys after that. Um And then so another question is how can we confirm our registration for the fresh connection? um And once again, that's going to be a follow-up email by them and uh, then you'll be able to register through that And then it turns out that the results were closed after week that was by design With that being said, I can post the results online and I'll do that after this hangout So I will post them. I think I think week 11 will be a good place to post them So I'll probably post them in week 11 We'll have like a little section saying the fresh connection results and it'll probably be a csv or an excel sheet That'll just give all the results. Um, and then the usernames of the students that did that So let's see. What else do we have here? Uh, there's another question about the talent connection. Um, and where we can be matched with businesses who are hiring That's once again something that's going to be specifically done by the fresh connection So I will be in contact with Hans and I will follow up with you guys on that as well So I'm going to say back to you. Alexis for any other follow-up and those last questions that we have Well, it turns out Alexis is currently muted. So, um, We're going to move into our hangout room shortly So the question that I want you guys to ask yourself is how are you currently using? Supply chain things that you've learned in this class in your job As well as how do you plan to use it in the future? So discuss that with each other and the hangout rooms and come back with some questions and some follow-up And even some answers for us to see how you've done that Perfect. Thanks. Yeah. So once again the question for the hangout rooms is going to be how Did you use supply chain things that you learned in this class and your current job? Or how do you plan to use them in your job in the future? If you could come back in the end, um, we'll uh address some of those answers that you have and some of the questions You might have about that All right, we'll see you in about 15 or 20 minutes