###### Course Overview

## What is Data Science

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 certification and make your profile stand ahead of the other data scientists.

### Why Certified Data Science

Certified data science 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 enroll 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.

### Course Description

**Section 1 : ****Analytics Using Excel**

__Introduction to the Course MS Excel 2010 Advanced__

This chapter will provide a brief introduction about Microsoft Excel 2010 advanced

__Office Button and Paste Function__

This section gives you step by step procedure of using the paste function in MS Excel and it also lets you know the various other paste options.

__Sparklines, Custom Ribbons and Screenshots__

This section explains what is sparklines, ribbons and how to take screenshots along with examples.

__Conditional Formatting and Equation Editor__

Lets you learn how to use the new equation editing tool in Excel 2010 and highlight the cells using conditional formatting.

__Paste Special__

Here you can learn the step by step procedure of using the paste special option in Excel 2010.

__Logical functions – IF AND OR__

This topic lets you learn how to use Excel’s logical functions IF, AND and OR with few examples.

__Arithmetic functions MAX MIN ABS etc__

In this chapter you will be learning how to use the mathematical functions in Excel 2010.

__COUNT COUNTIF COUNTA COUNTBLANK__

This topic will explain all the different count function in Excel the purpose of it along with their specific criteria and examples for each.

__Cell Information – IFERROR ISBLANK etc__

Here you will learn what is IFERROR, ISBLANK formula is, its syntax, how does it work in Excel 2010 and the examples.

__CHOOSE Function__

This section explains the formula syntax and usage of the CHOOSE function in Microsoft Excel.

__VLOOKUP Function__

In this you will understand how to use Excel’s VLOOKUP function with example

__HLOOKUP Function__

This section describes the formula syntax and usage of the HLOOKUP function in Excel with examples.

__MATCH & INDEX__

This chapter will help you to understand the basics of MATCH and INDEX function in Excel, how and where to use it and how to use MATCH and INDEX function in place of VLOOKUP function.

__Database functions – DSUM DAVERAGE DCOUNT__

This section explains the more complex versions of the basic SUM functions and helps you to learn how to use Excel D functions with few examples.

__OFFSET Function- Understanding basics__

This chapter explains how to use the OFFSET function to return the value of a cell in excel and a basic understanding of it.

__OFFSET Function – Dynamic nature__

This lets you learn how to create and use dynamic range names in Excel using the OFFSET function

__FORECAST Function__

Here you can understand the formula syntax and usage of the FORECAST function in excel along with its function.

__One Dimensional Data Tables__

In this chapter you will learn how to create a one variable data table in Excel 2010 with sample values

__Two dimensional Data Tables__

This section will make you understand how to use two variable data table in Excel 2010.

__Solver__

This chapter gives a brief introduction about the tool called Solver in Excel 2010 and the step by step procedure to use this tool

__Goal Seek__

Here you will understand what is Goal Seek feature in Excel 2010 and using What if analysis command in Excel.

__Array Function – Introduction__

This section gives a quick introduction to arrays and array formulas in Excel 2010

__Array Function – Row and Columns__

Under this section you will learn the array function with examples in detail.

__Array Function – TRANSPOSE__

This section gives you the detail of array formula “TRANSPOSE” in detail and how to use it in Excel 2010.

__Array Function – FREQUENCY__

This explains how to calculate the frequency distributions in Excel 2010

__PROPER UPPER LOWER LEFT RIGHT MID__

This chapter is a quick guide on how to use various text related functions like PROPER UPPER LOWER LEFT RIGHT MID in Excel 2010

__FIND CLEAN REPT CONCATENATE__

Explains these text functions in detail along with examples

__Pivot Tables__

This section explains how to create or delete a pivot table in Excel

__Pivot Table Filter – Slicer__

This chapter explains how to use Slicer to filter Pivot table data in Excel 2010.

__Pivot Charts__

Under this section you will learn how to produce a pivot chart report in Excel 2010.

__Naming Dynamic Ranges__

This section will help you in creating and checking dynamic named ranges using OFFSET function in Excel 2010

__Naming a Cell and a Range__

In this section you will learn how to name a cell or a cell range in Excel 2010 with example.

__Auditing Toolbar__

This lets you know how to use auditing toolbar to investigate spreadsheets in Excel

__Watch Window__

Here you can learn how to use watch window to inspect, audit or confirm formula calculations and results in larger worksheet

__Group Boxes and Options Button__

This is an tutorial on how to add group box or a frame control to a worksheet

__Check Boxes__

This topic lets you to learn how to create and use a check box in worksheet. It also lets you to know how to insert multiple check boxes

__List Boxes and Combo Boxes__

In this section you will learn how to use list box and combo box in a worksheet in Excel 2010

__Scroll Bar and Spinners__

This topic lets you learn how to add a scroll bar or a spin button to a worksheet in Excel

__Text to Columns__

You can learn how to use combinations of text functions to extract from one cell and copy it into other cells

__Grouping Tabs__

In this chapter we will learn the step by step process to group and ungroup worksheets in Excel 2010

__SUBTOTAL Function__

This chapter tells you how to use SUBTOTAL function syntax in Excel and mentions its arguments

__Hyperlinks__

Here we will learn how to use and stop automatics hyperlinks and how to use special characters in hyperlinks in Excel 2010

__Data Validation__

In this section we will see how to add data validation in Excel sheets

__Random Numbers__

This tutorial lets you understand how to use the Excel RAND function with its syntax and few examples

__Custom View__

This topic tells you how to use custom view to save specific display settings and filter data and columns

__Protecting – Worksheet and Workbook__

Here you will learn how to password protect your worksheet or workbook elements

__Excel 2010 Sparklines__

It explains what is sparklines and how to use them

__Range Charts Type 1__

In this section you will learn how to create a chart and customize it

__Range Charts Type 1- Continued__

The various types of charts are explained with examples

__Range Charts Area Type 2__

This helps you to create type 2 charts and customize it

__Range Charts Area Type 2- Continued__

Type 2 charts are explained with examples in this section

__Funding Graph__

Creating a budget graph in excel can be learnt in this chapter

__Two Axis Graphs__

This will show you how to create a two axis graph in Excel 2010

__Scenario Graphs__

Here you will understand how to evaluate scenarios with Excel using Graphs

__Scenario Graphs Continued__

The formation of scenario graphs is explained with examples

__Average Line__

This section tells you how to add average line chart in excel

__Bar to Pie Chart__

Lets you learn to create bar and pie charts in Excel 2010

__Combo Charts__

This chapter explains how to create a combination chart and how to represent data in a combination chart

__Creating Histograms__

You will know how to use the histogram tool in excel and how to present your data in Histogram

__Invert Negatives__

Here you will learn how to change positive numbers into negative in excel and how the negative values can be converted into chart

__Scrolling Chart__

Gives step by step guide to create a scrolling chart in Excel 2010

__Scrolling Chart Continued__

Examples of scrolling chart is given in this section

**Section 2: ****Online Business Analytics Using SAS Programming**

__Introduction to Business Analytics Using SAS__

This section gives a brief introduction about business analytics using SAS

__Introduction to SAS__

Under this section you will learn what is SAS and general information about SAS

__SAS Functionalities__

This section helps you to learn the new features and functionalities of SAS.

__Logic Flow How Data is Convert Data to Information__

This section is an introduction to SAS data steps

__Overview of SAS Windows__

Under this chapter the four main windows of SAS are explained with screenshots

__Components of the SAS Language__

This gives the introduction to SCL with its statements, functions, CALL routines, operators, expressions and variables

__Fundamental of SAS__

This chapter contains the overview of the SAS procedures and SAS programming statements.

__Data Types in SAS__

This section is a guide to basic data types in SAS.

__SAS Library__

This section is a tutorial on what is SAS library and how to create own SAS library

__Introduction to Creating and Reading Internal and External Data Source__

Here we will learn how to connect to our data using SAS

__Accessing Data from SAS System__

This chapter explains the SAS workspace server accessing data over a shared file system

__Agenda__

This section helps you to create your agenda using SAS

__The SAS System__

Helps you to learn the basic SAS and enables you to learn the features.

__Reading Raw Data with the Input Statement__

Lets you know how to use the INPUT statement in SAS for reading the raw data

__Modified List Input__

This chapter tells you how to use modified list input in SAS

__Important Infile Option__

This topic contains the syntax, arguments and details of the Infile option

__Use of the Length Statement__

Helps to set the Length of the character variable using LENGTH statement

__Data Step Processing__

Includes the step by step processing of data in SAS

__Introduction to Data Validation and Cleaning__

This chapter gives an introduction to Data validation and cleaning in SAS

__SAS Operators__

Gives a brief introduction to various SAS operators and functions including arithmetic, comparison, logical operators and other functions.

__Addition Controlling Data__

This tells you how to manipulate data in SAS

__SAS Formats__

This chapter gives an introduction to SAS formats and informats along with an date example of Informat statement

__Introduction to Data Manipulation__

This chapter lets you learn about data manipulations and transformations. It also includes creating sub sets of data

__The Sum Function__

This section lets you know how to use the SUM function in SAS

__Creating Variables Conditionally__

Here you will learn how to create and recode variables in SAS data file

__Using Arrays in SAS__

This section serves as an introduction to arrays in SAS, its functions and operators along with examples.

__Method of Combining__

This section will help you to understand the method for combining SAS data sets

__Concatenating with Proc Append Procedure__

This chapter serves as a complete guide for the APPEND statement, understanding and using the APPEND procedure.

__Merging__

This chapter shows you how to merge two data sets in SAS and includes one to one merge and one to many merge with examples.

__Final Results__

This topic lets you understand about the output delivery system (ODS) in SAS and the ODS RESULTS statement.

__Objectives__

This section explains the major objectives of SAS

__Introduction to Data Transformation__

This topic explains how a new variable is created through data transformation

__SAS Functions__

This chapter explains the basic SAS functions with examples for each. It includes Character function, SUBSTR, Index, numeric, round function, date function and others.

__MCQ__

This section contains a lot of multiple choice questions regarding SAS

__Introduction to Report Generation__

In this chapter you will learn how to generate reports using SAS and what are the commands to be used

__SAS System Option__

This section explains what you need to know about SAS system option

__The Footnote Statement__

Under this chapter you will know how to use the Footnote statement in SAS

__Assigning Temporary Labels__

This section lets you know how to temporarily assign labels and formats within a PROC step

__Closing Default Output Destination__

Here you will learn how to understand and customize the SAS output

__Class Statement__

Under this topic you will understand what is a class statement and its variables

__Proc Means vs Proc Summary__

You will learn the meaning of PROC MEANS and PROC SUMMARY and the differences between the two in this chapter

__Producing Frequency Table Using__

Here we will learn what command to be used to produce frequency table in SAS

__Creating Table and List Format__

The step by step procedure in creating various kind of tables and formatting procedure is explained in detail with examples

__Creating Tabular Report__

In this chapter you will learn what command should be used to produce reports of table in SAS

### FAQs General Questions

**What are the career benefits in this course ?**

Certified data scientists have a chance to get a higher salary and can have a better growth in their career. Data science jobs are more in demand these days and so there is a tremendous increase in salary for certified data scientists.

**What are the learning benefits of this course from educba ?**

People who undertake this course will become an expert in all the basic concepts of SAS and Excel. At the end of this course they will be able to work with SAS and Excel easily and perform it better than before which will help you in taking smart decisions.

### Testimonials

**Dominick**

This course was very good and helped to learn everything about data science. This is a good course for beginners as well as professionals to learn all the basic concepts of SAS and Excel.

**Claes**

This course is a must for beginners who wanted to become a data scientist or data analyst. The flow of the course is very good. It contains explanations which are easy to understand and also provides many examples for easy learning.

Where do our learners come from? |

Professionals from around the world have benefited from eduCBA’s Oracle SOA Suite 11g Comprehensive courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Hong Kong, Singapore, Australia, New Zealand, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |