DATA SCIENCE AND ANALYSIS
EXPERT Training Course

Data Science otherwise known as business intelligence has created a widespread impact across various sectors. In areas like healthcare, education, security, sports, energy and science.

This data science syllabus includes a comprehensive curriculum which is designed on the basis of what most industries want from data science professionals. The data science syllabus is suitable for beginners, working professionals, or someone who wants to switch over to a career in data science.

SGL’s data science modules are a complete roadmap for you to prepare yourself for a great career. This course is also open to beginners without any prior knowledge of data science or coding experience. 

Course Content

·         Programming with R

·         Programming With Python

·         Data Analysis With Microsoft Excel

Data Science with R

Gain the career-building R skills you need to succeed as a data scientist. No prior coding experience required. Through interactive exercises, you’ll get hands-on with some of the most popular R packages.

In this introduction to R course, you’ll master the basics of this widely used open source language—including vectors, factors, lists, and data frames. With the coding skills you’ll gain in this course, you’ll be ready to undertake your own data analysis in R.

Course outline

  • Introduction to Business Analytics

  • Introduction to R Programming

  • Data Structures
  • Data Visualization
  • Statistics for Data Science – I
  • Statistics for Data Science – II
  • Regression Analysis

  • Classification

  • Clustering
  • Association

Data Science With Python

Python is a general-purpose programming language that is becoming ever more popular for data science. Companies worldwide are using Python to harvest insights from their data and gain a competitive edge. Unlike other Python tutorials, this course focuses on Python specifically for data science. In our Introduction to Python course, you’ll learn about powerful ways to store and manipulate data, and helpful data science tools to begin conducting your own analyses

Python is the most important and necessary topic that every data scientist should have knowledge about. In this section, our instructors will take you through the basics of Python and areas where it can be used. You will learn how to use some of the current tools such as Numpy, Pandas, and Matplotlib.

Course outline

  • Introduction to Python: What Is Python, Installing Python, IDLE & Python Shell
  • Variables and Assignment Statements
  • Built-in Functions
  • User-Defined Functions
  • Conditional Logic: if, else, and elif Statements
  • Loops
  • Lists
  • Strings
  • File Input/Output
  • Internet Data: API
  • Data Structures: Tuple, Lists of Lists, Dictionary, JSON & XML
  • Object Oriented Programming (OOP): Principles of OOP
  • Python Web Development using Django
  • Introduction to Data Analysis
  • Python for Data Analysis using NumPy
  • Python for Data Analysis using Pandas
  • Introduction to Data Visualization
  • Python for Data Visualization using Matplotlib
  • SQL
  • Microsoft Excel
  • Working with CSV Files
  • Data Mining
  • Web Scraping using Beautiful Soup
  • Project

 

Data Analytics Using Microsoft Excel: Beginner, Intermediate and Advanced Training Course

Excel is the world’s most popular data analysis tool. Companies and institutions worldwide use it to transform mountains of raw data into clear insights. Strong Excel skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks. In this course, you’ll develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow.

Course outline

Microsoft Office Excel: Beginner (Proficiency Level)

Course Objectives: 

This Microsoft Excel Level 1 training organized by SGL technologies will introduce you to the features and power of Microsoft Excel, giving you a solid footing in a professional course that you will find very useful in your career and in your daily activities.

Course Content: 

• Getting Started with Excel

• Identify the Elements of the Excel Interface

• Navigate and Select Cells in Worksheets

• Customize the Excel Interface

• Create a Basic Worksheet

• Performing Calculations in an Excel Worksheet

• Create Formulas in a Worksheet

• Insert Functions in a Worksheet

• Reuse Formulas

• Modifying an Excel Worksheet

• Edit Worksheet Data

• Find and Replace Data

• Manipulate Worksheet Elements

• Modifying the Appearance of a Worksheet

• Apply Font Properties

• Add Borders and Colors to Cells

• Align Content in a Cell

• Apply Number Formatting

• Apply Cell Styles

• Managing an Excel Workbook

• Manage Worksheets

• View Worksheets and Workbooks

• Printing Excel Workbooks

• Define the Page Layout

• Print a Workbook

Microsoft Office Excel: Intermediate (Specialist Level)

Course Objectives: 

This Intermediate level will expand your knowledge of Microsoft Excel greatly. Microsoft Excel level 2 has many capacities and there are lots to learn which many professionals who thought they knew much about Excel are not even aware of. 

Course Content:

• Calculating Data with Advanced Formulas

• Apply Cell and Range Names

• Calculate Data Across Worksheets

• Use Specialized Functions

• Analyze Data with Logical and Lookup Functions

• Organizing Worksheet and Table Data

• Create and Modify Tables

• Format Tables

• Sort or Filter Data

• Use Functions to Calculate Data

• Presenting Data Using Charts

• Create a Chart

• Modify Charts

• Format Charts

• Analyzing Data Using PivotTables, Slicers, and PivotCharts

• Create a PivotTable Report

• Filter Data Using Slicers

• Analyze Data Using PivotCharts

• Inserting Graphic Objects

• Insert and Modify Pictures and ClipArt

• Draw and Modify Shapes

• Illustrate Workflow Using SmartArt Graphics

• Layer and Group Graphic Objects

• Customizing and Enhancing the Excel Environment

• Customize the Excel Environment

• Customize Workbooks

• Manage Themes

 

• Create and Use Templates 

Microsoft Office Excel: Advanced (Expert Level)

 Course Objectives:

The Microsoft Excel Advanced level course will extend your basic and intermediate knowledge of Excel, and develop more skills and knowledge that you need to produce worksheets as you require them. 

Course Content

Lesson 1: Streamlining Workflow

•  Update Workbook Properties

•  Create a Macro

•  Edit a Macro

•  Apply Conditional Formatting

•  Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

•  Protect Files

•  Share a Workbook

•  Set Revision Tracking

•  Review Tracked Revisions

•  Merge Workbooks

•  Administer Digital Signatures

•  Restrict Document Access

Lesson 3: Auditing Worksheets

•  Trace Cells

•  Troubleshoot Invalid Data and Formula Errors

•  Watch and Evaluate Formulas

•  Create a Data List Outline

Lesson 4: Analyzing Data

•  Create a Trendline

•  Create Spark-lines

•  Create Scenarios

•  Perform a What-If Analysis

•  Perform a Statistical Analysis with the Analysis Tool-Pack

Lesson 5: Working with Multiple Workbooks

•  Create a Workspace

•  Consolidate Data

•  Link Cells in Different Workbooks

•  Edit Links

Lesson 6: Importing and Exporting Data

•  Export Excel Data

•  Import a Delimited Text File

•  Import and Export XML Data

Lesson 7: Integrating Excel Data with the Web

•  Publish a Worksheet to the Web

•  Import Data from the Web

•  Create a Web Query

Interested in this course?

JOIN NOW