Data Science and Machine Learning using R

Data Science and Machine Learning using R​
Course duration:

55 hours | 2 months (Live online/classroom training + Projects + assignment/case studies + Interview preparation)

Training Mode:​

Online & Classroom

Course Fees:
  • Group training – INR 20000 | USD 550 (Other countries)
  • Individual training – INR 32000 | USD 750 (Other countries)
Pre-requisites for Data Science and Machine Learning course:

To attend this course candidates must have good understanding of basic and advance R, dplyr, ggplot2 and basic statistics.

Certification:

At end of our course, you will be work on various projects and assignmetns. Once you completed your assigned projects with expected results we will issue “Data Science and Machine Learning using R” Certificate.

Syllabus - program of study:

MODULE 1: Advanced File Tasks
  • A look at some important administrative features which are useful for managing and controlling Excel files.
  • Saving and File Management
  • File Properties
  • File Accessibility and Compatibility
MODULE 2: Working with Functions and Formulas
  • Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.
  • Formulas with Absolute References
  • Autosum Functions (SUM & AVERAGE)
  • IF and Nested Functions
  • Working with Named Ranges
  • Array Functions (SUMIF & AVERAGEIF)
  • Formula Auditing
  • Text Functions

MODULE 3: Managing Tables in Microsoft Excel:

  • Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.
  • Creating Excel Tables
  • Working with Records and Filters
  • Advanced Filters

MODULE 4: Data Tools in Excel:

  • Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.
  • Text to Columns
  • Flash Fill
  • Remove Duplicates
  • Data Validation
  • Consolidate

MODULE 5: Grouping & Outlining and Subtotals:

  • Useful Excel functions to summarize a spreadsheet making the data easier to identify and explain.
  • Outlining and Grouping Data
  • Using the Subtotals Tool

MODULE 6: What-If Analysis

  • Tools designed to help with forecasting and finding solutions to complicated problems involving your spreadsheet's data and formulas
  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver

MODULE 7: PivotTables

  • Creating Pivot Tables in order to display and summarize large quantities of data effectively.
  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles

MODULE 8: Charting Pivoted Data

  • Introducing Pivot Charts, adding specialist pivot charts to the already excellent Pivot Table feature.
  • Getting Started with PivotCharts Using the PivotChart Tools Tabs
  • Formatting a PivotChart

MODULE 9: Advanced Excel Tasks

  • Here we will look at sharing Excel files along with adding hyperlinks and Custom AutoFill Lists.
  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

MODULE 10: Creating HLOOKUP and VLOOKUP Functions

  • Using the VLOOKUP Function
  • Using the HLOOKUP Function

MODULE 11: Macros in Excel

  • Explore how to create your own Macros and introducing Visual Basic for Applications, the application Macros are created in.
  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Case studies
  • Assignments
  • projects with industry data