Course Description:-
Data Science has becoming the most upcoming field in the 21st century and it has millions of job openings. Companies have moved towards digital enterprise in the past few years. This has led to the increased flow of data into an organization. As a result companies are in need of skilled persons to manage and leverage these data and turn it into a profitable asset for the business. In order to make yourself more competent get a data science using SAS certification and make your profile stand ahead of the other data scientists.
Why Certified Data Science using SAS training?
Certified data science using SAS course will help to improve your knowledge, start your career and increase your revenue. This course will help you to analyze data to gain better knowledge, develop new strategies and prepare actionable business intelligence.
Course Objectives
At the end of this course you will be able to
- Describe the stages of analytics life cycle
- Use a variety of statistical tools and techniques to analyze data
- Use such tools to explore data
- Design, model and manage databases in an effective way
- Deliver new insights and competitive intelligence
- Use the SAS software with ease
Pre Requisites for taking this course
To enrol in this course you should have some basic knowledge of statistics and programming. Individuals with good mathematical skills can find the course more interesting.
Target audience for this course
This certification course is for those who want to learn the advanced knowledge and skills which are needed to work as a data scientist. This course is also useful for professionals from different fields who are seeking a way to leverage the massive amount of data that they collect. Others who could be benefited from this course includes data analysts, data engineers, computer scientists, database administrators and statisticians.
Benefits of online course:
1. High Quality Content
2. Learn Anywhere Anytime & at Your Pace
3. 24X7 Customer Support
4. Complete Student Support throughout the Program
5. Online Video Training Material
6. Lifetime course access
For any query call/miss call -
Mob -+918587999769/9818826705
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
51 Creating Histograms
59 Invert Negatives
60 Scrolling Chart
61 Scrolling Chart Continued
62 Conclusion
Section 2: Online Business Analytics using SAS Programming
63 Introduction to Business Analytics Using SAS Part 1
64 Introduction to Business Analytics Using SAS Part 2
65 Introduction to SAS
66 SAS Functionalities
67 Logic Flow How Data is Convert Data to Information
68 Overview of SAS Windows Part 1
69 Overview of SAS Windows Part 2
70 Components of the SAS Language Part 1
71 Components of the SAS Language Part 2
72 Fundamental of SAS
73 Data Types in SAS
74 SAS Library
75 Assigning A Libref
76 Introduction to Creating and Reading Internal and External Data Source
77 Accessing Data from SAS System
78 Agenda
79 The SAS System
80 Reading Raw Data with the Input Statement
81 Modified List Input
82 Important Infile Option
83 Use of the Length Statement
84 Data Step Processing
85 Compilation Phase
86 Introduction to Data Validation and Cleaning
87 Where Statement
88 Logical and Arithmetic Operators
89 LIKE Operators
90 Addition Controlling Data
91 SAS Formats
92 Example Formatting Date Value
93 Introduction to Data Manipulation
94 The Sum Function
95 Group Processing
96 Quiz Answer
97 Creating Variables Conditionally
98 Logical Operators
99 Sub Setting Variables and Observations
100 Do Loop and SAS Arrays
101 Two Dimensional Array Declaration
102 Method of Combining
103 Concatenating with Proc Append Procedure
104 Merging
105 One to Many Merge
106 Final Results
107 Objectives Part 1
108 Objectives Part 2
109 Output Statement
110 Introduction to Data Transformation
111 Other Character Function
112 SUBSTR Function
113 Replacing Text Using SUBSTR
114 Index Function
115 Numeric Function
116 The Round Function Example
117 Date Function
118 INTCK Function
119 INTCK Function Continue
120 MCQ
121 MCQ Continue
122 Introduction to Report Generation
123 SAS System Option
124 The Footnote Statement
125 Assigning Temporary Labels
126 Closing Default Output Destination
127 Creating Customize Report Using PROC Report
128 Class Statement
129 Proc Means vs Proc Summary
130 Producing Frequency Table Using
131 Creating Table and List Format
132 Creating Tabular Report
