Supply Chain Analytics

Excel Supply Chain Analysis: Solving Inventory Problems

Course details

• 1h 20m
• Intermediate
• Released: 12/15/2020

Excel pro Curt Frye shows how to analyze inventory costs and develop effective inventory policies within a supply chain. He explains how to calculate total costs and total relevant costs for a product. He covers how to incorporate the effects of lead time into analysis and how to determine how much extra those minimum orders cost. Curt goes into how to evaluate quantity discounts and how to calculate production quantities to maximize profit. He discusses how back orders affect inventory policies and how to calculate the economic order quantity for inventory policies that allow back orders. He introduces you to difficulties associated with goods that have a limited lifespan, often called the newsvendor problem, then shows you how to generate the data and summaries required to solve a newsvendor problem. In conclusion, Curt walks you through how to calculate the base stock level for a target level of service and how to calculate a reorder point based on cycle service level performance.

Excel Supply Chain Analysis: Solving Transportation Problems

Course details

• 1h 55m
• Intermediate
• Released: 11/25/2020

Microsoft Excel can be a secret advantage when it comes to solving complex supply chain challenges. Follow along with instructor Curt Frye as he shows how to use the Excel Solver add-in to minimize transportation and transshipment costs within a supply chain. Curt covers a range of topics, including how to analyze fixed costs and facility opening decisions, enforce level of service constraints, and perform scenario analysis. He also provides problem scenarios for you to solve, then goes through the solutions for each. After watching this course and working through the examples, you’ll be able to describe the techniques specialized supply chain programs use to arrive at their results.

Excel: Power Query (Get & Transform)

Course details

• 2h 28m
• Intermediate
• Released: 1/13/2020

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz demonstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training.

Learning objectives

• What is Power Query (Get & Transform)?
• Working with queries
• Data types explained
• Working with columns and formulas
• Pivoting and unpivoting data
• Grouping data
• Appending queries
• Merging data
• Drill down to use variables
• Fuzzy matching
• Sorting and filtering

Power BI Essential Training

Course details

• 3h 20m
• Beginner + Intermediate
• Released: 2/21/2020

Discover how to quickly glean insights from your data using Power BI. This formidable set of business analytics tools—which includes the Power BI service, Power BI Desktop, and Power BI Mobile—can help you more effectively create and share impactful visualizations with others in your organization. In this course, Gini von Courter helps you get started with this powerful toolset. Gini begins by covering the web-based Power BI service, explaining how to import data, create visualizations, and arrange those visualizations into reports. She discusses how to pin visualizations to dashboards for sharing, as well as how to ask questions about your data with Power BI Q&A. She also provides coverage of Power BI Mobile and shows how to use the data modeling capabilities in Power BI Desktop.

Learning objectives

• Apply the required hardware to successfully run Power BI.
• Distinguish between different data types in Power BI.
• Correlate the similarities between visualizations in Power BI.
• Identify the outcomes when changes are made within Power BI and Power BI Desktop.
• Differentiate between dashboards and reports within Power BI.
• Determine user roles within a workspace in Power BI.
• Manage workspaces and tools within the Power BI mobile application.

Tableau Essential Training

Course details

• 4h 40m
• Beginner
• Updated: 9/4/2020

Tableau is a widely used data analytics and visualization tool that many consider indispensable for data-science-related work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories. In this course, learn what you need to know to analyze and display data using Tableau 2020—and make better, more data-driven decisions for your company. Discover how to install Tableau, connect to data sources, and sort and filter your data. Instructor Curt Frye also demonstrates how to create and manipulate data visualizations—including highlight tables, charts, scatter plots, histograms, maps, and dashboards—and shows how to share your visualizations. Along the way, he highlights the new features packed into this edition of the software, including Viz Animations, which allows you to visually follow the movement of marks in a data visualization to see and understand your changing data.

Learning objectives

• Explain where a user would navigate to seek specific help in Tableau.
• Determine the best approach for using Excel in Tableau.
• Interpret how to use the features and functions of Tableau when creating charts.
• Describe how best to manage data in a worksheet or visualization.
• Explain how to create a selection filter for certain values.
• Explain how to manage data for different chart formats.

Learning R

Course details

• 2h 51m
• Beginner + Intermediate
• Released: 8/29/2019

If you want to participate in the data revolution, you need the right tools and skills. R is a free, open-source language for data science that is among the most popular platforms for professional analysts. Learn the basics of R and get started finding insights from your own data, in this course with professor and data scientist Barton Poulson. The lessons explain how to get started with R, including installing R, RStudio, and code packages that extend R’s power. You also see first-hand how to use R and RStudio for beginner-level data modeling, visualization, and statistical analysis. By the end of the course, you’ll have a thorough introduction to the power and flexibility of R, and understand how to leverage this tool to explore and analyze a wide variety of data.

Learning objectives

• Installing R and RStudio
• Navigating the RStudio environment
• Importing data from a spreadsheet
• Working with the tidyverse
• Piping commands with %>%
• Visualizing data with R base graphics and ggplot2
• Visualizing hierarchical clusters
• Selecting cases and subgroups
• Recoding variables
• Calculating frequencies
• Calculating descriptives
• Calculating correlations
• Computing a linear regression

Learning Python

Course details

• 2h 27m
• Beginner
• Updated: 10/7/2020

Python—the popular and highly readable object-oriented language—is both powerful and relatively easy to learn. Whether you’re new to programming or an experienced developer, this course can help you get started with Python. Joe Marini provides an overview of the installation process, basic Python syntax, and an example of how to construct and run a simple Python program. Learn to work with dates and times, read and write files, and retrieve and parse HTML, JSON, and XML data from the web.

Learning objectives

• Installing Python
• Choosing an editor or IDE
• Working with variables and expressions
• Writing loops
• Using the date, time, and datetime classes
• Reading and writing files
• Fetching internet data
• Parsing and processing HTML

Artificial Intelligence Tools and Concepts

Course details

• 1h 33m
• Intermediate
• Released: 9/16/2020

There are many business needs that artificial intelligence can help solve: logistics, market analysis, customer support, inventory prediction, and more. Yet business managers often don’t make the connection between these challenges and the AI technology and tools that can help solve them. This course links common business needs to practical AI-based solutions, so you can build or buy the best AI systems for your organization. Instructor Doug Rose explains how AI can automate customer service, including phone, online chat, and even in-person interactions. He shows how business logistics can benefit from automated decision-making and data retrieved from IoT devices. He also discusses machine learning for making better predictions for sales, purchasing, and many other aspects of your business. Along the way, Doug reviews top AI tools, including TensorFlow, Amazon Web Services, and Microsoft Azure. By taking this course, you can leverage the untapped potential of artificial intelligences to take your business to the next level.

This course was created by Doug Rose. We are pleased to offer this training in our library.

Learning objectives

• Natural language processing
• Automating customer service
• Building neural networks
• Classifying customers
• Clustering purchases
• Automated speech recognition
• Responding with virtual agents
• Making automated decisions
• Managing IoT devices
• Building machine learning platforms
• Making accurate predictions
• Reviewing the top machine learning tools