Data Science with Python batch coming up in Bangalore on 11th Nov and in Gurgaon on 18th Nov!
 

SAS Training - Analytics Edge with SAS, Excel & Tableau

SAS certification training a power packed course for analytics beginners and certification aspirants.

This SAS training is for analytics beginners who want to get Global SAS Certification and target job profiles related to SAS Analytics and Reporting and Excel-VBA or Tableau based MIS/BI analyst profiles. In this program candidates will also learn Tableau, one of the most popular data visualization and rapid BI tool. Evolved from our post popular course-SAS Edge, this Excel and SAS training is specially curated for candidates who have no prior knowledge about any BI or data analytics tools.


In addition to Base and Advance SAS (Proc SQL and SAS Macros), this program also covers database concepts using SQL. This power-packed program is best SAS training in Delhi NCR and Bangalore, with flexibility of attending live online SAS training and through self-paced video based mode as well. 


'Analytics Edge' with Excel, Tableau and SAS course duration: 180 hours (At least 72 hours live training + 12 hours video based training + Practice and Self-study, with ~8hrs of weekly self-study) 180 hours (At least 72 hours live training + 12 hours video based training + Practice and Self-study, with ~8hrs of weekly self-study).

Who Should do this course?

Beginner candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Business Management who want to target job profiles based on SAS certification and Reporting skills or Excel-VBA or Tableau based MIS/BI analyst profiles.

SELECT THE COURSE
ENROLL NOW

Combo Deals!

Learn more, save more.
See our combo offers here.

Course Duration 180 hours
Classes 25
Tools SAS, Excel, VBA, Tableau
Learning Mode Live Training
Next Batch18th November, 2018 (Gurgaon)

Introduction to Excel

  • Introduction to Excel Environment
  • Explanation about data calculation in Excel
  • Use of Shortcuts
  • Formatting and Conditional Formatting
  • Working with Formulas - Logical and Text Functions
  • Understanding about Sorting, Filtering and Data Validation
  • Data Analysis using Pivot Tables

Introduction to Charts and Functions

  • Understaing of Mathematical, Statistical Functions
  • Worksheet and Workbook Protection and Security
  • Understanding of Name Ranges
  • Introduction of Charts
  • Introduction of Form Controls
  • Understanding of Data Tools Panel

Dashboard Designing

  • Overview of Dashboards
  • Deciding on Dahsboards
  • Trends and Scenarios using charts
  • Advanced Charting Techniques using Thermometer, Doughnut, Pareto, Panel and Step Chart
  • Designing Sample Dashboard using Form Controls
  • Tips and Tricks to enhance dashboard designing

Introduction to VBA (video-based)

  • Working with VBE (Visual Basic Editor)
  • Introduction to Excel Object Model
  • Understanding of Sub and Function Procedures
  • Key Component of Programming Language
  • Understaing of If, Select Case, With End With Statements
  • Looping with VBA
  • User Defined Function
  • Some Commonly Used Macro Examples
  • Error Handling
  • Object and Memory Management in VBA
  • User Form Controls
  • ActiveX Controls
  • Communicating with Database MS Access through ADO - Exporting/Importing Data

Tableau: Getting started with Tableau

  • What is Tableau? What does the Tableau product suite comprise of? How Does Tableau Work?
  • Tableau Architecture
  • What is My Tableau Repository?
  • Connecting to Data & Introduction to data source concepts
  • Understanding the Tableau workspace
  • Dimensions and Measures
  • Data Types & Default Properties
  • Tour of Shelves & Marks Card
  • Using Show Me!
  • Building basic views
  • Saving and Sharing your work-overview

Tableau: Building Views (Reports) – Basics

  • Date Aggregations and Date parts
  • Cross tab & Tabular charts
  • Totals & Subtotals
  • Bar Charts & Stacked Bars
  • Line Graphs with Date & Without Date
  • Tree maps
  • Scatter Plots
  • Individual Axes, Blended Axes, Dual Axes & Combination chart
  • Edit axis
  • Parts of Views
  • Sorting
  • Trend lines
  • Reference Lines
  • Forecasting
  • Filters
  • Context filters
  • Sets
    • In/Out Sets
    • Combined Sets
  • Grouping
  • Bins/Histograms
  • Drilling up/down – drill through
    • Hierarchies
    • View data
    • Actions (across sheets)

Tableau: Building Views (Reports) – Advanced Maps

  • Explain latitude and longitude
  • Default location/Edit locations
  • Symbol Map & Filled Map
  • Custom Geo Coding

Tableau: Calculated Fields

  • Working with aggregate versus disaggregate data
  • Explain - #Number of Rows
  • Basic Functions (String, Date, Numbers etc)
  • Usage of Logical conditions

Tableau: Table calculations

  • Explain scope and direction
  • Percent of Total, Running / Cumulative calculations

Tableau: Parameters

  • Create What-If analysis
  • Using Parameters in
    • Calculated fields
    • Bins
    • Reference Lines
    • Filters/Sets
  • Display Options (Dynamic Dimension/Measure Selection)

Tableau: Building Interactive Dashboards- (Building & Customizing)

  • Combining multiple visualizations into a dashboard (overview)
  • Making your worksheet interactive by using actions
    • Filter
    • URL
    • Highlight

Tableau: Working with Data

  • Multiple Table Join
  • Data Blending
  • Difference between joining and blending data, and when we should do each
  • Working with the Data Engine / Extracts
  • Toggle between to Direct Connection and Extracts

Introduction to the Analytics world and SAS role

Analytics World

  • Introduction to Analytics
  • ETL CONCEPT and role of SAS in ETL
  • SAS in advanced analytics
  • SAS Certification: Induction and walk through

Getting Started with SAS

  • SAS software installation
  • Introduction to SAS, GUI
  • Different components of SAS language
  • All SAS programming windows
  • Concept of SAS Libraries and Creating Libraries
  • Variable Attributes - (Name, Type, Length, Format, In format, Label)
  • Importing Data and Entering data manually

Understanding Datasets

  • Descriptor Portion of a Dataset (Proc Contents)
  • Data Portion of a SAS Dataset
  • Variable Names and Values
  • SAS Data Libraries

SAS: Accessing the Data

Understanding Data Step processing

  • Data Step and Proc Step
  • Data step execution
  • Compilation and execution phase
  • Input buffer and concept of PDV

Importing Raw Data files

  • Column Input and List Input and Formatted methods
  • Delimiters, Reading missing and non standard values
  • Reading one to many and many to one records
  • Reading Hierarchical files
  • Creating raw data files and put statement
  • Formats / Informat

Importing and Exporting Data (Fixed Format / Delimited)

  • Import Wizard
  • Proc Import / Delimited text files
  • Proc Export / Exporting Data from SAS
  • Datalines / Cards
  • Atypical importing cases (mixing different style of inputs)
    • Reading Multiple Records per Observation
    • Reading “Mixed Record Types”
    • Sub-setting from a Raw Data File
    • Multiple Observations per Record
    • Reading Hierarchical Files
  • Importing Tips

SAS: Data Understanding, Managing and Manipulation

Understanding and Exporing Data

  • Introduction to basic Procedures - Proc Contents, Proc Print
  • Operators and Operands
  • Conditional Statements (Where, If, If then Else, If then Do and select when)
  • Difference between WHERE and IF statements and limitation of WHERE statements
  • SAS Labels, Commenting
  • SAS System Options (OBS, FSTOBS, NOOBS etc…)

Data Manipulation

  • Proc Sort - with options / De-Duping
  • Accumulator variable and By-Group processing
  • Explicit Output Statements
  • Nesting Do loops
  • Do While and Do Until Statement
  • Array elements and Range

Combining Datasets (Appending and Merging)

  • Concatenation
  • Interleaving
  • Proc Append
  • One To One Merging
  • Match Merging
  • IN = Controlling SAS merge and Indicator

SAS: Functions

  • General form of SAS Functions
  • Arithmetic Functions
  • Date and Time Functions
  • Text Manipulation Functions
  • Nested Functions

SAS: Data Analysis and Reporting

  • Proc Freq
  • Proc Format for user defined formats
  • Proc Means
  • Proc Summary
  • Proc tabulate
  • Proc report
  • Concept of the Output Delivery System
  • Using ODS Statements to save data on external destination

Advance SAS - Data Mining with Proc SQL

  • Introduction to Proc SQL
  • Basics of General SQL language
  • Creating table and Inserting Values
  • Retrieve & Summarize data
  • Group, Sort & Filter
  • Using Joins (Full, Inner, Left, Right and Outer)
  • Reporting and summary analysis
  • Concept of Indexes and creating Indexes (simple and composite)
  • Connecting SAS to external Databases
  • Implicit and Explicit pass through methods

Advanced SAS - SAS Macros

  • Global and Local Variables
  • Macro Parameters and Variables
  • Different types of Macro Creation
  • Defining and calling a macro
  • Using call Symput and Symget
  • Macros options (mprint symbolgen mlogic merror serror)

Working smartly with SAS

Debugging SAS

  • How to read log file efficiently
  • Tips to debug code

Efficient SAS Programming

  • Code optimization and Efficient SAS Programming Techniques
  • Saving CPU Time, I/ O processing time
  • Disk Space Saving Measures
  • Memory saving tips

List of Procedures covered

  • Proc Import
  • Proc Export
  • Proc Contents
  • Proc Datasets
  • Proc Copy
  • Proc Delete
  • Proc Print
  • Proc Append
  • Proc Sort
  • Proc Format
  • Proc Transpose
  • Proc Means
  • Proc Summary
  • Proc Freq
  • Proc Tabulate
  • Proc Report
  • Proc Options
  • Proc SQL

Introduction to MS SQL

  • What is SQL – A Quick Introduction

  • Getting started
    Understanding basic database concepts
    Introduction to MS SQL Server Management Studio
    Utilizing the Object Explorer

  • Understanding basic RDBMS concepts
    Schema –Meta Data –ER Diagram
    Looking at an example Database design
    Data Integrity Constraints & types of Relationships (Primary and foreign key)
    Basic concepts – Queries, Data types & NULL Values, Operators and Comments in SQL

SQL: Working with Select, DDL and DML commands

  • Data based objects creation (DDL Commands)
    Creating, Modifying & Deleting Tables
    Drop & Truncate statements – Uses & Differences
    Alter Table & alter Column statements
  • Data manipulation (DML Commands)
    Insert, Update & Delete statements
    Select statement – Where, Group By, Order by & Having clauses
  • Working with Select statement
    Union and Union All – Use & constraints
    Intersect and Except statements
    Joins & Aliases
    Accessing data from Multiple Tables
    Inline and sub-queries
    SQL Functions – Number, Text, Date, etc
    SQL Keywords – Top, Distinct, Null, etc
    SQL Operators, Use of wildcards, etc
  • Optimizing your work
    Sub-queries vs. Temp Tables vs. Joins
    Optimizing for Composite keys & Non-numeric Primary keys

Case Study on Gantt Charting using Conditional Formatting and Logical Function

Exercise workbooks on Basic & Advanced Excel Functions, Pivot tables etc

Sample Sales Dashboard

2 Case studies on consolidating data from different workbooks into Excel

Access to 72 hours instructor led live classes of 24x3 hours each, spread over 12 weekends

Video recordings of the class sessions for self study purpose

Weekly assignment, reference codes and study material in PDF format

Module wise case studies/ projects

Specially curated study material and sample question for SAS Global Certification

Career guidance and career support post the completion of some selected assignments and case studies

What if I miss a class?

Don’t worry. You will always get a recording for the class in your Learning Management System (LMS) account. Have a look at that and reach out to the faculty in case of doubts. All our live classes are recorded for self-study purpose and future reference, and these can also be accessed through our LMS. Hence, in case you miss a class, you can refer to the video recording and then reach out to the faculty during their doubts clearing time or ask your question in the beginning of the subsequent class.

You can also repeat any class you want in the next one year after your course completion. Batch change policies will however, apply in this case.

Please note that incase you are not able to complete your course within one year of course validity, due to reasons at your end, limited support might be available post the completion of one year.

For how long are the recordings available to me?

1 year post your course completion. If needed, you can also repeat any number of classes you want in the next one year after course completion. Batch change policies will however, apply in this case.

In case required because any genuine reasons, the recordings access can be extended further for upto 1 year post the completion of one year validity. Please note that given the constant changes in the Analytics industry, our courses continue to be upgraded and hence old courses might no longer hold relevance. Hence, we do not promise lifetime access just for marketing purposes. 

Can I download the recordings?

No. Our recordings can be accessed through your account on LMS or stream them live online at any point of time though.

Recordings are integral part of AnalytixLabs intellectual property by Suo Jure. The downloading/distribution of these recordings in anyway is strictly prohibited and illegal as they are protected under copyright act. Incase a student is found doing the same, it will lead to an immediate and permanent suspension in the services, access to all the learning resources will be blocked, course fee will be forfeited and the institute will have all the rights to take strict legal action against the individual.

What if I share my LMS login details with a friend?

The sharing of LMS login credentials is unauthorized, and as a security measure, if the LMS is accessed by multiple places, it will flag in the system and your access to LMS can be terminated.

Will I get a certificate in the end?

Yes. All our course are certified. As part of the course, students get weekly assignments and module-wise case studies. Once all your submissions are received and evaluated well, the certificate shall be awarded.

Please note that incase you are not able to complete the course within the one year validity, AnalytixLabs might hold a mock interview/viva, apart from your submissions, before issuing the certificate.

Do you help in placements?

We follow a comprehensive and a self-sustaining system to help our students with placements. This is a win-win situation for our candidates and corporate clients. As a pre-requisite for learning validation, candidates are required to submit the case studies and project work provided as a part of the course (flexible deadline). Support from our side is continuous and encompasses help in profile building, CV referrals (as and when applicable) through our ex-students, HR consultants and companies directly reaching out to us.

We will provide guidance to you in terms of what are the right profiles for you based on your education and experience, interview preparation and conducting mock interviews, if required. The placement process for us doesn’t end at a definite time post your course completion, but is a long relationship that we will like to build.

To avoid any kind of ambiguity, we strongly suggest that you go through our course brochures.

Please also note that incase you are unable to complete the course in the one year course validity period, we might not be able to assist with placements. The discussion you would have had with our counsellors/faculty at the time of registration is also basis the profile you hold at that time. Incase your course has got delayed due to reasons at your end, this might effect the profile, in which case it might be difficult for us to assist in placements.

Do you guarantee placements?

No institute can guarantee placements, unless they are doing so as a marketing gimmick! It is on a best effort basis.

In professional environment, it is not feasible for any institute to do so, except for a marketing gimmick. For us, it is on a best effort basis but not time – bound – in some cases students reach out to us even after 3 years for career support.

Do you have a classroom option?

Yes we have classroom option for Delhi-NCR candidates. However, most of our students end up doing instructor led live online classes, including those who join classroom in the beginning. Based on the student feedback, the learning experience is same both in classroom and instructor led live online fully interactive mode.

How do I attend the online classes? Are they interactive or self-paced?

We provide both the options and for instructor led live online classes we use the gold standard platform used by the top universities across the globe. These video sessions are fully interactive and students can chat or even ask their questions verbally over the VoIP in real time to get their doubts cleared.

What do I need to attend the online classes?

To attend the online classes, all you need is a laptop/PC with a basic internet connection. Students have often shared good feedback of attending these live classes through their data card or even their mobile 3G connection, though we recommend a basic broadband connection.

For best user experience, a mic-headphone is recommended to enhance the voice quality, though the laptop’s in-built mic works fine and you can ask your question over the chat as well.

How can I reach out to someone if I have doubts post class?

Through the LMS, students can always connect with the trainer or even schedule one-to-one time over the phone or online. During the course we also schedule periodic doubts-clearing classes though students can also ask doubts of a class in the subsequent class.

LMS also has a discussion forum where a lot of your doubts might get easily answered.

Incase you are having a problem still, repeat the class and schedule one-to-one time with the trainer.

What is your refund policy?

  • Instructor Led Live online or Classroom - Within 7 days of registartion date and latest 3 days before batch start
  • Video-based - 2 days

Can I pay in installments?

Yes. While making the fee payment, most of the courses have the installment option.

I am having difficulty coping up with my classes. What can I do?

For all the courses, we also provide the recordings of each class for their self-reference as well as revision in case you miss any concept in the class. In case you still have doubts after revising through the recordings, you can also take one-to-one time with the faculty outside classes during. Furthermore, if students want to break their courses in different modules, they get one year time to repeat any of the classes with other batches.

What are the system requirements for the software?

There is no particular system requirement for this course since the tools required for this course (Excel, SAS and Tableau) can easily be installed on almost every laptop with basic configuration available these days. However, if possible, it is recommended to have 64-bit operating system.

For Tableau, please note that Tableau doesn't have a learning version. Hence, you can choose among the following versions to install:

  • Tableau Public - Free though it has constraints like not being able to connect to SQL servers etc Hence, it is useful, free and doesn't constraint your learning at all
  • Tableau Desktop - Only a 14 day trial version is available from Tableau's website. If you have a valid student id (graduate/postgraduated). then you can get a free key which is valid for one year

I took the Data Science course from AnalytixLabs in May 2016 and finally have an offer in hand in a Big 4 company. Two things I would like to highlight my review on - Training Course & Placement Assistance. I took the online training course although I was a bit skeptical about it. Ultimately I found this more convenient as training sessions are live, highly interactive and well structured. Training was comprehensive covering basics as well as advanced topics. Finally extensive case studies to get hands-on exposure to real world problems. Talking about placement assistance - they help in understanding your career ambitions and build your profile. I got 3 offers after completing the course and I can say that opportunities would come to you, but it still needs your own hard work and dedication to make it through. Don't pursue this course just for a certificate, pursue it to learn something new and you will do wonders! Finally, a word of thanks to Sumeet sir as well for his guidance throughout - I can say I found a great mentor over here. Cheers team Alabs!


Sanchit Gupta
(Consultant, KPMG)

Change the course of your career

Over 6000 learners and hundreds making right choice every month!
Course Brochure
Student Reviews
Upcoming Batches