Course Description:-

INTRODUCTION:

Certified Data Science Training Course:

• In this course on Certified Data Science Training using R, SAS and Excel, you will learn Data Analytics using Excel, SAS and R programming.
• The course starts from scratch and hence a beginner can also take and enjoy this course on Certified Data Science Training using R, SAS and Excel.

Certified Data Science Training requirements:

• Basic knowledge of statistical reasoning will be helpful
• Passion to learn about R- Programming, Excel and SAS
• Computer with Internet connection

What am I going to get from this Certified Data Science Training using R, SAS and Excel course?

• To give the learners the introduction to R programming
• Learn important concepts like regression, Distribution etc using the R Software
• Learn important Advanced Excel concepts using Practical examples.

Certified Data Science Training target audience:

• People from Analytics domain
• Anyone who wants to learn about Business Analytics Using R, Excel and SAS.

Certified Data Science Course Objective:

• To give the participants complete knowledge of Data Science using different tools like excel, SAS and R.

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - 8587999769/9818826705

CURRICULUM

Section 1: Analytic Using Excel

1. Introduction to the Course MS Excel 2010 Advanced
2. Office Button and Paste Function
3. Sparklines, Custom Ribbons and Screenshots
4. Conditional Formatting and Equation Editor
5. Paste Special
6. Logical functions – IF AND OR
7. Arithmetic functions MAX MIN ABS etc
8. COUNT COUNTIF COUNTA COUNTBLANK
9. Cell Information – ISERROR ISBLANK etc
10. CHOOSE Function
11. VLOOKUP Function
12. HLOOKUP Function
13. MATCH & INDEX
14. Database functions – DSUM DAVERAGE DCOUNT
15. OFFSET Function- Understanding basics
16. OFFSET Function – Dynamic nature
17. FORECAST Function
18. One Dimensional Data Tables
19. Two dimensional Data Tables
20. Solver
21. Goal Seek
22. Array Function – Introduction
23. Array Function – Row and Columns
24. Array Function – TRANSPOSE
25. Array Function – FREQUENCY
26. PROPER UPPER LOWER LEFT RIGHT MID
27. FIND CLEAN REPT CONCATENATE
28. Pivot Tables
29. Pivot Table Filter – Slicer
30. Pivot Charts
31. Naming Dynamic Ranges
32. Naming a Cell and a Range
33. Auditing Toolbar
34. Watch Window
35. Group Boxes and Options Button
36. Check Boxes
37. List Boxes and Combo Boxes
38. Scroll Bar and Spinners
39. Text to Columns
40. Grouping Tabs
41. SUBTOTAL Function
42. Hyperlinks
43. Data Validation
44. Random Numbers
45. Custom View
46. Protecting – Worksheet and Workbook
47. Excel 2010 Sparklines
48. Range Charts Type 1
49. Range Charts Type 1- Continued
50. Range Charts Area Type 2
51. Range Charts Area Type 2- Continued
52. Funding Graph
53. Two Axis Graphs
54. Scenario Graphs
55. Scenario Graphs Continued
56. Average Line
57. Bar to Pie Chart
58. Combo Charts
59. Creating Histograms
60. Invert Negatives
61. Scrolling Chart
62. Scrolling Chart Continued
63. Conclusion

Section 2: R Programming - Data Science and Analytics with R

1. Overview and History of R
2. Datatypes and Basic Operations – Part1_1 part 01
3. Datatypes and Basic Operations – Part1_1 part 02
4. Datatypes and Basic Operations – Part1_2 Part 01
5. Datatypes and Basic Operations – Part1_2 Part 02
6. Datatypes and Basic Operations – Part1_2 Part 03_part01
7. Datatypes and Basic Operations – Part1_2 Part 03_part 02 summary
8. Datatypes and Basic Operations – Part2_1
9. Datatypes and Basic Operations – Part2_2
10. ReadingData-1
11. ReadingData-2
12. ReadingData-3
13. ReadingData-4a
14. ReadingData-4b
15. Debugging-1
16. ControlStructures
17. Functions Part 01
18. Functions Part 02
19. ScopingRules1 Part 01
20. ScopingRules1 Part 02
21. ScopingRules2
22. Looping1
23. Looping2
24. Looping3
25. Simulation_part-1
26. Simulation_part-2
27. Plotting1
28. Plotting2
29. Plotting3_part-1
30. Plotting3_part-2
31. Plotting4
32. Plotting5
33. PlottingColors1
34. PlottingColors2
35. Date and TimePart1and 5.Date and TimePart2
36. Date andTimePart3
37. RegEx1
38. RegEx2
39. RegEx3_part-1
40. RegEx3_part-2
41. Classes and Methods1_part-1
42. Classes and Methods1_part-2
43. Classes and Methods2_part-1
44. Classes and Methods2_part-2
45. DebuggingPart2

Section 3: Online Business Analytics using SAS Programming

1. Introduction to Business Analytics Using SAS Part 1
2. Introduction to Business Analytics Using SAS Part 2
3. Introduction to SAS
4. SAS Functionalities
5. Logic Flow How Data is Convert Data to Information
6. Overview of SAS Windows Part 1
7. Overview of SAS Windows Part 2
8. Components of the SAS Language Part 1
9. Components of the SAS Language Part 2
10. Fundamental of SAS
11. Data Types in SAS
12. SAS Library
13. Assigning A Libref
14. Introduction to Creating and Reading Internal and External Data Source
15. Accessing Data from SAS System
16. Agenda
17. The SAS System
18. Reading Raw Data with the Input Statement
19. Modified List Input
20. Important Infile Option
21. Use of the Length Statement
22. Data Step Processing
23. Compilation Phase
24. Introduction to Data Validation and Cleaning
25. Where Statement
26. Logical and Arithmetic Operators
27. LIKE Operators
28. Addition Controlling Data
29. SAS Formats
30. Example Formatting Date Value
31. Introduction to Data Manipulation
32. The Sum Function
33. Group Processing
34. Quiz Answer
35. Creating Variables Conditionally
36. Logical Operators
37. Sub Setting Variables and Observations
38. Do Loop and SAS Arrays
39. Two Dimensional Array Declaration
40. Method of Combining
41. Concatenating with Proc Append Procedure
42. Merging
43. One to Many Merge
44. Final Results
45. Objectives Part 1
46. Objectives Part 2
47. Output Statement
48. Introduction to Data Transformation
49. Other Character Function
50. SUBSTR Function
51. Replacing Text Using SUBSTR
52. Index Function
53. Numeric Function
54. The Round Function Example
55. Date Function
56. INTCK Function
57. INTCK Function Continue
58. MCQ
59. MCQ Continue
60. Introduction to Report Generation
61. SAS System Option
62. The Footnote Statement
63. Assigning Temporary Labels
64. Closing Default Output Destination
65. Creating Customize Report Using PROC Report
66. Class Statement
67. Proc Means vs Proc Summary
68. Producing Frequency Table Using
69. Creating Table and List Format
70. Creating Tabular Report

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address