Course curriculum
-
1
Module 01: Course Introduction
- Segment - 01 - Introduction
- Segment - 02 - About RA
- Segment - 03 - Recommendations
- Segment - 04 - Why R
- Segment - 05 - Shiny
- Segment - 06 - Application Dynamics
- Segment - 07 - Supply Chain Applications
- Segment - 08 - Curriculum
-
2
Module 02: Welcome to the World of R
- Segment - 09 - Welcome to the World of R
- Segment - 10 - What is R Statistical Language
- Segment - 11 - How to Install R
- Segment - 12 - How to Install R Studio
- Segment - 13 - A Walk Through Tutorial
- Segment - 14 - Setup Your Project
- Segment - 15 - Install Packages
- Segment - 16 - Summary
-
3
Module 03: R Programming Fundamentals
- Segment - 17 - Introduction
- Segment - 18 - Different Data Structures and Types in R
- Segment - 19 - Do Arithmetic Calculations in R and Write Functions
- Segment - 20 - Creating a List
- Segment - 21 - Importing Data in R and Basic Exploration
- Segment - 22 - Selecting Data in Dataframe
- Segment - 23 - If Else Function
- Segment - 24 - Conditions
- Segment - 25 - Functions With Conditions
- Segment - 26 - For Loops
- Segment - 27 - Applying a Function Inside a For Loop
- Segment - 28 - For Loop on a Dataframe
- Segment - 29 - Applying the Function on a Dataframe
- Segment - 30 - Assignment
- Segment - 31 - Assignment Section 4 Answer Part 1
- Segment - 32 - Assignment Section 4 Answer Part 2
- Segment - 33 - Summary
-
4
Module 04: Manipulation on Dataframe
- Segment - 34 - Introduction
- Segment - 35 - Introduction to Dplyr
- Segment - 36 - Investigate With Dplyr
- Segment - 37 - Unique Invoices
- Segment - 38 - Average Invoice Value Per Country
- Segment - 39 - Average Number of Items with in an Invoice
- Segment - 40 - Joining
- Segment - 41 - Changing Date Time to Date
- Segment - 42 - Pivot Wider
- Segment - 43 - Pivot Longer
- Segment - 44 - Separate and Paste
- Segment - 45 - Putting it All Together
- Segment - 46 - Assignment New York Airlines
- Segment - 47 - Assignment Question 1 Answer
- Segment - 48 - Assignment Question 2 and 3 Answer
- Segment - 49 - Assignment Question 4,5 and 6
- Segment - 50 - Assignment Question 7
- Segment - 51 - Summary
-
5
Module 05: Shiny Bascis
- Segment - 52 - Introduction
- Segment - 53 - Installing Packages
- Segment - 54 - First Shiny Applications
- Segment - 55 - Our First UI
- Segment - 56 - Input and Output
- Segment - 57 - R Activity in Application
- Segment - 58 - Fibonacci Assignment
- Segment - 59 - Fibonacci Sequence Assignment
- Segment - 60 - Declarative and Imperative Programming
- Segment - 61 - Getting Unique Identifiers
- Segment - 62 - Overview
- Segment - 63 - User Interface
- Segment - 64 - App Structure
- Segment - 65 - Date Reactivity
- Segment - 66 - Country and SKU Reactivity
- Segment - 67 - Lineplot
- Segment - 68 - Application Running
- Segment - 69 - Datatables
-
6
Module 06: Preparing for Inventory Algorithm
- Segment - 70 - Inventory Algorithm Introduction
- Segment - 71 - Inventory Applications
- Segment - 72 - Database for Inventory
- Segment - 73 - MySQL Server
- Segment - 74 - Installation
- Segment - 75 - Initializing Database
- Segment - 76 - Preparing for Database
- Segment - 77 - Preparing the Data
- Segment - 78 - Filtering Stocks
- Segment - 79 - Sending Stock and Sales
- Segment - 80 - Algorithm Assumptions
- Segment - 81 - Purchase Orders
- Segment - 82 - Connect to Database
- Segment - 83 - Fetching Real Time Data
-
7
Module 07: Inventory Algorithm
- Segment - 84 - Creating a Unique Key
- Segment - 85 - Parsing Dates
- Segment - 86 - Seasonality
- Segment - 87 - Defining Seasonality
- Segment - 88 - Calculation of Beginning and Ending Inventory
- Segment - 89 - Beginning and Ending Inventory
- Segment - 90 - Calculating Stock Status
- Segment - 91 - Total Requested and Current Stock
- Segment - 92 - ABC Analysis
- Segment - 93 - Classifications
- Segment - 94 - Inventory Policies
- Segment - 95 - Inventory Calculations
- Segment - 96 - Adjusting for Seasonality
- Segment - 97 - Service Level
- Segment - 98 - Reordering Quantity
- Segment - 99 - Finalizing Algorithm
- Segment - 100 - Last Stock on Hand Date
- Segment - 101 - Sending Algorithm to Database
-
8
Module 08: Inventory Application
- Segment - 102 - Applicant Section Introduction
- Segment - 103 - What Should be in an Inventory App
- Segment - 104 - Key Input
- Segment - 105 - Mango Stocks User Interface
- Segment - 106 - Managing User Input
- Segment - 107 - Barplot 1
- Segment - 108 - Pivots
- Segment - 109 - Inventory Turns and Margin
- Segment - 110 - Top Sales-Top Revenue
- Segment - 111 - Ranking
- Segment - 112 - Pie Chart and Downloading files
- Segment - 113 - Finalizing Tab 1
- Segment - 114 - Tab 3
- Segment - 115 - Alarms Exp
- Segment - 116 - Alarms
- Segment - 117 - Alarms Page
- Segment - 118 - Categories Tab
- Segment - 119 - Overview of Categories Page
- Segment - 120 - Size and Color Tab
- Segment - 121 - Application Overview
-
9
Module 09: Development
- Segment - 122 - Deployment Introduction
- Segment - 123 - Scheduling the Algorithm
- Segment - 124 - Debugging
- Segment - 125 - Debugging Part 1
- Segment - 126 - Verifying Output
- Segment - 127 - Azure Account
- Segment - 128 - Deploying a Virtual Machine
- Segment - 129 - Setting Up Server
- Segment - 130 - Rstudio Server
- Segment - 131 - Essential Libraries
- Segment - 132 - Shiny Server
- Segment - 133 - Remote Database
- Segment - 134 - Is Every thing Working
- Segment - 135 - Sudo Package Install
- Segment - 136 - Shiny App Running
-
10
Module 10: SQL Server
- Segment - 137 - SQL Server Introduction
- Segment - 138 - Setting up Virtual Machine
- Segment - 139 - Connecting to New Virtual Machine
- Segment - 140 - Installing Libraries
- Segment - 141 - MySQL Configuration
- Segment - 142 - Creating Database
- Segment - 143 - Final Message
- Segment - 144 - Success