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