My learning journey in Supply Chain Technology and Systems

My learning journey in supply chain technology and systems has been a fascinating and enlightening experience. At the beginning of the course, I had a basic understanding of technology and systems used in the supply chain. However, through the weeks of study, I have gained a deep understanding of the role of technology and systems in the supply chain.

I started by learning about the different types of supply chain technologies and systems, including enterprise resource planning (ERP), warehouse management systems (WMS), transportation management systems (TMS), and supply chain visibility systems. I was able to understand the functionalities and benefits of each of these systems and how they can be used to improve supply chain performance.

Next, I learned about the importance of data analytics in the supply chain. I gained knowledge about different types of data analytics techniques, such as predictive analytics and prescriptive analytics, and how they can be used to optimize supply chain operations. I realized that accurate data analytics can be a powerful tool in supply chain management as it can help companies make informed decisions and improve their operations.

I also learned about the role of automation and robotics in the supply chain. I was introduced to different types of automated systems, such as automated storage and retrieval systems (ASRS) and automated guided vehicles (AGVs). I was able to appreciate the significance of implementing automated systems in the supply chain to improve efficiency, accuracy, and cost-effectiveness.

Furthermore, I learned about the importance of supply chain visibility and how it can be achieved through the use of technology and systems. I was able to understand the benefits of supply chain visibility, such as improved inventory management and better collaboration between supply chain partners.

In addition, I learned about the importance of cybersecurity in the supply chain. I was introduced to different types of cybersecurity threats and how they can impact supply chain operations. I was able to appreciate the significance of implementing robust cybersecurity measures in the supply chain to protect against cyber-attacks and data breaches.

Week 1:

- Introduction to supply chain technology and systems and their role in supply chain management.
- Learned about different types of supply chain technologies and systems, such as ERP, WMS, TMS, and SCV.
- Discussed how to select the right technology and systems based on a company’s needs and goals.

I found some problems quite interesting:

Part 2

In crow’s foot notation, which relationship is indicated by the notation above?

Week 2:

- Explored the role of data analytics in the supply chain.
- Learned about different types of data analytics techniques, such as predictive analytics and prescriptive analytics.
- Discussed how data analytics can be used to improve supply chain performance.

I found some problems quite interesting:

Graded Assignment 2

Remember that you cannot use Excel for this assignment. You may only use MySQL or SAS. Do not open this SQL file except with MySQL.

You manage data for Screwy, a screw manufacturer in southern Oklahoma City. The Screwy staff aren’t too analytical and only maintain simple records of Orders in a single table. They also maintain two separate tables to keep track of their customers and part offerings. All of this is saved in a single database creatively named “Screwy”.

Open this MySQL code and run it. This will create the database Screwy for you to work with.

Copy and paste the following SAS code (Step 1 -> Step 2) to your SAS on demand instance to import the database. You should only need to use Step 1 the first time you download the data. Step 2 will need to be run each time your reset your SAS session.

The Orders table includes:

Order_Number (Numeric) (PK)
Customer_ID (Numeric) (FK)
Part_Number (Numeric) (FK)
Quantity (Numeric)
Total_Cost (Numeric) (Total_Cost is in USD)

The Parts table includes:

Part_Number (Numeric) (PK)
Part_Name (Text)

The Customers table includes:

Customer_ID (Numeric) (PK)
Customer_Name (Text)
Customer_Credit_Line (Numeric) (Credit line is in USD)

PK- Primary Key, FK- Foreign Key

Part 2 – SQL Coding

How many orders has the customer named “Lows” placed in total (as recorded in Orders)?

Week 3: Inventory Management

- Learned about the importance of automation and robotics in the supply chain.
- Explored different types of automated systems, such as ASRS and AGVs.
- Discussed how automation can be used to improve efficiency, accuracy, and cost-effectiveness.

I found some problems quite interesting:

Part 1

Harrison-Charles Electronics makes a wide variety of tiny electronic components known as ‘transistors’. Each transistor type that Harrison-Charles Electronics makes is identified by a unique 5-digit alpha-numeric SKU identifier. APDL4, SORYQ, and G2U0H are three examples of Harrison-Charles Electronics’s five-digit SKU identifiers. Which MySQL core data type is most appropriate for these SKUs?

Select a response below

Part 2: Unsupervised Machine Learning

Imagine that you are applying an unsupervised machine learning algorithm to a data set containing 4 attributes, (1) information on the location, (2) the length, (3) the number of customers served, and (4) the total delivery cost for each of your company’s 10,000 global delivery routes. Which insight below should you expect?

Select the best answer.

Overall, my learning journey in supply chain technology and systems has been a valuable experience. I am now equipped with the knowledge and skills necessary to design and implement effective supply chain technologies and systems. I am confident that I can apply this knowledge in the real world to help companies optimize their supply chain operations and achieve their business goals.

To view the full journey, please visit: