GUIDE ME

Learn how to use SPSS for data management. Enroll today to learn from an SPSS expert.

4.8 out of 5 based on 102358 votes
google4.2/5
Sulekha4.8/5
Urbonpro4.6/5
Just Dial4.3/5
Fb4.5/5

Course Duration

32 Hrs.

Live Project

2 Project

Certification Pass

Guranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

Data Analytics & BI

Speciality

prof trained

200 +

Professionals Trained
batch image

3 +

Batches every month
country image

20+

Countries & Counting
corporate

100+

Corporate Served

  • Our SAS Training course has been structured to provide all the required SAS skills and multiple statistical techniques to help you to become a successful SAS professional. Some of the popular SAS certification courses available with us include SAS certified BASE programmer, and SAS certified advanced programmer, SAS Admin training, etc.
    • Our SAS placement course will help you to learn business analytics skills and BI skills too.

      You will gain enough proficiency in reading spreadsheets, databases, etc.

      Learn skills that include data analytics, data modelling techniques, data mining data visualization, etc.

      Also, you will get a chance to practice SAS analytics skills through real-time projects.

      Some of the examples are SAS Macros Machine learning, SQL Procedures, decision trees, and statistical techniques, etc.

  • We make sure that you would be able to clear your certification exam in the first attempt mostly. So, register for the SAS certification course with the best SAS training institute before it is too late.

SAS Certification Training

About-Us-Course

  • Our major objective of SAS training will help you learn predictive analytics using SAS, learning using SAS GUI, and data manipulation in detail. Some of the objectives of our SAS training include.
    • Learn advanced programming in SAS.

      You can clear SAS programmer certifications and gain credentials that are valid worldwide.

      Learn to automate complex and repetitive tasks and execute ODS statements using SAS.

      Gain in-depth knowledge in integrating and refining datasets, perform conditional or iterative looping, etc.

      Learn to implement SQL queries, SAS graphs, summary reports, deploying data sets, and more.

  • No matter whether you are a fresher or an experienced professional, our SAS training course will help you gain the relevant skills you required. If you are looking to start a career, you can easily gain skills to become a certified professional.

  • Most industries understand that data analytics is an important skill in decision-making. And that’s the reason, there’s a huge demand for professional SAS programmers who could take care of data deeply and companies are ready to pay really attractive paycheck to a skilled professional who can complete their work efficiently.
    • A SAS professional can earn around $102K per annum and even higher after the experience.

      At the experienced level, a senior software engineer can earn Rs. 10, 00,008 in India.

      Build your skills base with the most prominent SAS training institute and

      Make yourself eligible to earn attractive salary packages without any difficulty.

  • One of the best things about SAS is that it has been the market leader for years and it offers an array of statistical functions for people who can learn it quickly. Croma Campus may help you to learn everything in a focused way. You will learn from the beginning till the end step-by-step.
    • We will help you to understand SAS applications through the real-world example.

      Also, salaries are really attractive at the fresher level and as you grow higher in your career.

      There are various SAS certification courses available in the market.

      Prepare yourself to achieve your career goals in the industry.

  • SAS is a powerful business analytics tool and it helps to improve the overall business performance immensely. When you choose us for your training, you will gain all the right skills to work with spreadsheets, databases, and techniques to debug voluminous data.
    • SAS helps in developing powerful analytics solutions to gain valuable insights into their data.

      It helps businesses to manage their data well.

      With the SAS placement course, you will get all the basic and advanced skills.

      SAS helps to convert data into meaningful information that is crucial to any organization.

      Get world-class training where you will understand more than theoretical concepts.

  • After the completion of your certification course, you can choose from a range of job profiles including SAS advanced programmer, SAS admin, SAS BASE programmer, etc. Let discuss some of the common job roles and responsibilities that you will learn through the SAS training course.
    • You should know about predictive analytics skills, SAS GUI, and data manipulation in detail.

      You must have a sound idea of advanced programming in SAS.

      You must know how to automate complex and repetitive tasks.

      You should know about integrating and refining datasets.

      You must know how to implement SQL queries, SAS graphs, summary reports, and more.

  • With SAS basic and advanced training, you not only master the essential skills but know about challenges that you face at the workplace. When you choose us for the course, you are likely to get hired by leading industries like Media, IT Sector, Telecom Sector, Manufacturing Industries, to name a few.
    • You will become eligible to apply for different job roles.

      Microsoft, Walmart, IBM, Facebook, Oracle, and more are some of the companies seeking SAS experts.

      The language is popular across banks, telecoms, healthcare, IT sector, entertainment and more.

      Choose the top SAS training company and enhance your career graph like none.

  • Our SAS certification course has been specially designed to help you clear the SAS BASE certification exam and SAS advanced programmer certification exam. We offer comprehensive training in SAS admin domain too.
    • We will help you to fast-track your career growth effortlessly.

      You will be awarded a course completion training certificate.

      You will work on different real-time projects, assignments, and gain immense expertise in real-world case studies.

      Our training certificate is well recognized in top MNCs like Cisco, IBM, Infosys, Sony, TCS, Genpact, etc.

      Our certificate helps you get attractive salary packages.

Why Should You Learn SAS?

Request more information

By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy

hourglassCourse Duration

32 Hrs.
Know More...
Weekday1 Hr/Day
Weekend2 Hr/Day
Training ModeClassroom/Online
Flexible Batches For You
  • flexible-focus-icon

    15-Feb-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    17-Feb-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    12-Feb-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-focus-icon

    15-Feb-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    17-Feb-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    12-Feb-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
Want To Know More About

This Course

Program fees are indicative only* Know more

Timings Doesn't Suit You ?

We can set up a batch at your convenient time.

Program Core Credentials

Trainer Profiles

Industry Experts

Trained Students

10000+

table

Success Ratio

100%

Corporate Training

For India & Abroad

Job Assistance

100%

BATCH TIMING

As per your requirement

FOR QUERIES, FEEDBACK OR ASSISTANCE

Contact Croma Campus Learner Support

Best of support with us

Phone (For Voice Call)

+91-971 152 6942

WhatsApp (For Call & Chat)

+91-8287060032

SAS Certification Training Programs

SAS Certification TrainingPrograms

BI And Visualization
Data Analytics Certification Training
30k LearnersWeekend/WeekdayLive Class
  • 5 Live Project
  • Self-Paced/ Classroom
  • Certification Pass Guaranteed

  • Understanding Concepts of Excel
    • Creation of Excel Sheet Data

      Range Name, Format Painter

      Conditional Formatting, Wrap Text, Merge & Centre

      Sort, Filter, Advance Filter

      Different type of Chart Creations

      Auditing, (Trace Precedents, Trace Dependents)Print Area

      Data Validations, Consolidate, Subtotal

      What if Analysis (Data Table, Goal Seek, Scenario)

      Solver, Freeze Panes

      Various Simple Functions in Excel(Sum, Average, Max, Min)

      Real Life Assignment work

  • Ms Excel Advance
    • Advance Data Sorting

      Multi-level sorting

      Restoring data to original order after performing sorting

      Sort by icons

      Sort by colours

      Lookup Functions

      • Lookup
        • VLookup
          • HLookup

            Subtotal, Multi-Level Subtotal

            Grouping Features

            • Column Wise
              • Row Wise

                Consolidation With Several Worksheets

                Filter

                • Auto Filter
                  • Advance Filter

                    Printing of Raw & Column Heading on Each Page

                    Workbook Protection and Worksheet Protection

                    Specified Range Protection in Worksheet

                    Excel Data Analysis

                    • Goal Seek
                      • Scenario Manager

                        Data Table

                        • Advance use of Data Tables in Excel
                          • Reporting and Information Representation

                            Pivot Table

                            • Pivot Chat
                              • Slicer with Pivot Table & Chart

                                Generating MIS Report In Excel

                                • Advance Functions of Excel
                                  • Math & Trig Functions

                                    Text Functions

                                    Lookup & Reference Function

                                    Logical Functions & Date and Time Functions

                                    Database Functions

                                    Statistical Functions

                                    Financial Functions

                                    Functions for Calculation Depreciation

                                Get full course syllabus in your inbox

                                • SQL Server Fundamentals
                                  • SQL Server 2019 Installation

                                    Service Accounts & Use, Authentication Modes & Usage, Instance Congurations

                                    SQL Server Features & Purpose

                                    Using Management Studio (SSMS)

                                    Conguration Tools & SQLCMD

                                    Conventions & Collation

                                • SQL Server 2019 Database Design
                                  • SQL Database Architecture

                                    Database Creation using GUI

                                    Database Creation using T-SQL scripts

                                    DB Design using Files and File Groups

                                    File locations and Size parameters

                                    Database Structure modications

                                • SQL Tables in MS SQL Server
                                  • SQL Server Database Tables

                                    Table creation using T-SQL Scripts

                                    Naming Conventions for Columns

                                    Single Row and Multi-Row Inserts

                                    Table Aliases

                                    Column Aliases & Usage

                                    Table creation using Schemas

                                    Basic INSERT

                                    UPDATE

                                    DELETE

                                    SELECT queries and Schemas

                                    Use of WHERE, IN and BETWEEN

                                    Variants of SELECT statement

                                    ORDER BY

                                    GROUPING

                                    HAVING

                                    ROWCOUNT and CUBE Functions

                                • Data Validation and Constraints
                                  • Table creation using Constraints

                                    NULL and IDENTITY properties

                                    UNIQUE KEY Constraint and NOT NULL

                                    PRIMARY KEY Constraint & Usage

                                    CHECK and DEFAULT Constraints

                                    Naming Composite Primary Keys

                                    Disabling Constraints & Other Options

                                • Views and Row Data Security
                                  • Benets of Views in SQL Database

                                    Views on Tables and Views

                                    SCHEMA BINDING and ENCRYPTION

                                    Issues with Views and ALTER TABLE

                                    Common System Views and Metadata

                                    Common Dynamic Management views

                                    Working with JOINS inside views

                                • Indexes and Query tuning
                                  • Need for Indexes & Usage

                                    Indexing Table & View Columns

                                    Index SCAN and SEEK

                                    INCLUDED Indexes & Usage

                                    Materializing Views (storage level)

                                    Composite Indexed Columns & Keys

                                    Indexes and Table Constraints

                                    Primary Keys & Non-Clustered Indexes

                                • Stored Procedures and Benets
                                  • Why to use Stored Procedures

                                    Types of Stored Procedures

                                    Use of Variables and parameters

                                    SCHEMABINDING and ENCRYPTION

                                    INPUT and OUTPUT parameters

                                    System level Stored Procedures

                                    Dynamic SQL and parameterization

                                • System functions and Usage
                                  • Scalar Valued Functions

                                    Types of Table Valued Functions

                                    SCHEMABINDING and ENCRYPTION

                                    System Functions and usage

                                    Date Functions

                                    Time Functions

                                    String and Operational Functions

                                    ROW_COUNT

                                    GROUPING Functions

                                • Triggers, cursors, memory limitations
                                  • Why to use Triggers

                                    DML Triggers and Performance impact

                                    INSERTED and DELETED memory tables

                                    Data Audit operations & Sampling

                                    Database Triggers and Server Triggers

                                    Bulk Operations with Triggers

                                • Cursors and Memory Limitations
                                  • Cursor declaration and Life cycle

                                    STATIC

                                    DYNAMIC

                                    SCROLL Cursors

                                    FORWARD_ONLY and LOCAL Cursors

                                    KEYSET Cursors with Complex SPs

                                • Transactions Management
                                  • ACID Properties and Scope

                                    EXPLICIT Transaction types

                                    IMPLICIT Transactions and options

                                    AUTOCOMMIT Transaction and usage

                                Get full course syllabus in your inbox

                                • Introduction to Power BI
                                  • Overview of BI concepts

                                    Why we need BI

                                    Introduction to SSBI

                                    SSBI Tools

                                    Why Power BI

                                    What is Power BI

                                    Building Blocks of Power BI

                                    Getting started with Power BI Desktop

                                    Get Power BI Tools

                                    Introduction to Tools and Terminology

                                    Dashboard in Minutes

                                    Interacting with your Dashboards

                                    Sharing Dashboards and Reports

                                • Power BI Desktop
                                  • Power BI Desktop

                                    Extracting data from various sources

                                    Workspaces in Power BI

                                • Power BI Data Transformation
                                  • Data Transformation

                                    Query Editor

                                    Connecting Power BI Desktop to our Data Sources

                                    Editing Rows

                                    Understanding Append Queries

                                    Editing Columns

                                    Replacing Values

                                    Formatting Data

                                    Pivoting and Unpivoting Columns

                                    Splitting Columns

                                    Creating a New Group for our Queries

                                    Introducing the Star Schema

                                    Duplicating and Referencing Queries

                                    Creating the Dimension Tables

                                    Entering Data Manually

                                    Merging Queries

                                    Finishing the Dimension Table

                                    Introducing the another DimensionTable

                                    Creating an Index Column

                                    Duplicating Columns and Extracting Information

                                    Creating Conditional Columns

                                    Creating the FACT Table

                                    Performing Basic Mathematical Operations

                                    Improving Performance and Loading Data into the Data Model

                                • Modelling with Power BI
                                  • Introduction to Modelling

                                    Modelling Data

                                    Manage Data Relationship

                                    Optimize Data Models

                                    Cardinality and Cross Filtering

                                    Default Summarization & Sort by

                                    Creating Calculated Columns

                                    Creating Measures & Quick Measures

                                • Data Analysis Expressions (DAX)
                                  • What is DAX

                                    Data Types in DAX

                                    Calculation Types

                                    Syntax, Functions, Context Options

                                    DAX Functions

                                    • Date and Time
                                      • Time Intelligence
                                        • Information
                                          • Logical
                                            • Mathematical
                                              • Statistical
                                                • Text and Aggregate

                                                  Measures in DAX

                                                  Measures and Calculated Columns

                                                  ROW Context and Filter Context in DAX

                                                  Operators in DAX - Real-time Usage

                                                  Quick Measures in DAX - Auto validations

                                                  In-Memory Processing DAX Performance

                                              Get full course syllabus in your inbox

                                              • Introduction To Python
                                                • Installation and Working with Python

                                                  Understanding Python variables

                                                  Python basic Operators

                                                  Understanding the Python blocks.

                                              • Python Keyword and Identiers
                                                • Python Comments, Multiline Comments.

                                                  Python Indentation

                                                  Understating the concepts of Operators

                                                  • Arithmetic
                                                    • Relational
                                                      • Logical
                                                        • Assignment
                                                          • Membership
                                                            • Identity
                                                          Get full course syllabus in your inbox
                                                          BI And Visualization
                                                          SPSS Certification Training
                                                          30k LearnersWeekend/WeekdayLive Class
                                                          • 2 Live Project
                                                          • Self-Paced/ Classroom
                                                          • Certification Pass Guaranteed

                                                          • Our Social Science Statistics Certificate provides the skills necessary to gather, analyze, and assess data for activities like making policy decisions, answering cultural questions, studying behavioral changes, and informing business decisions. This ten course program – including six required courses and four electives – cover the principal statistical concepts used to design, sample, collect, interpret, and present data as it applies to behaviors of groups of people in their environment and special situations.
                                                          • In this program you will learn:
                                                            • Introduction to SPSS

                                                              Input and Data Cleaning

                                                              Data Import [Excel File]

                                                              Data Import [Text Data / CSV Data]

                                                              Scales

                                                              Data Manipulation

                                                              Visualisation in SPSS

                                                              Descriptive analysis of data

                                                              What is Significance

                                                              Statistical Tests

                                                              Correlation

                                                              Regression

                                                              Sampling

                                                              Tables

                                                              Multivariate Analysis [Factor Analysis]

                                                              Multivariate Analysis [Cluster Analysis]

                                                          Get full course syllabus in your inbox

                                                          • Introduction to SPSS:
                                                            • Data Analysis with SPSS: General Aspects, Workflow, Critical Issues

                                                              SPSS: General Description, Functions, Menus, Commands

                                                              SPSS File Management

                                                          Get full course syllabus in your inbox

                                                          • Input and Data Cleaning:
                                                            • Defining Variables

                                                              Manual Input of Data

                                                              Automated Input of Data and File Import

                                                          Get full course syllabus in your inbox

                                                          • Data Import [Excel File]:
                                                            • Excel Data : Initial Preparation

                                                              Check Cell Range of Data

                                                              Give Variable Names

                                                              Store basic Checks Max Min Mean

                                                              Import into SPSS

                                                          Get full course syllabus in your inbox

                                                          • Data Import [Text Data / CSV Data]:
                                                            • In Notepad or Text Pad

                                                              Check Total No of Rows

                                                              How many Rows Per Case

                                                              How Many Variables

                                                              Import Text File

                                                          Get full course syllabus in your inbox
                                                          BI And Visualization
                                                          SAS Base Certification Training
                                                          30k LearnersWeekend/WeekdayLive Class
                                                          • 2 Live Project
                                                          • Self-Paced/ Classroom
                                                          • Certification Pass Guaranteed

                                                          • This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses You will also learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data.
                                                          • SAS Certification Training is intended to make you an expert in SAS programming and Analytics. You will be able to analyse and write SAS code for real problems, learn to use SAS to work with datasets, perform advanced statistical techniques to obtain optimized results with BASE SAS programming.
                                                          • In this program you will learn :
                                                            • SAS Programming Essentials

                                                              SAS Programming - Data Manipulation Techniques

                                                          Get full course syllabus in your inbox

                                                          • Introduction
                                                            • The SAS programming process.

                                                              Submitting a SAS program

                                                              Using SAS programming tools.

                                                              Understanding SAS syntax.

                                                              Diagnosing and correcting syntax errors

                                                              Mastering fundamental concepts

                                                          • Accessing Data
                                                            • Understanding SAS data.

                                                              Accessing data through libraries.

                                                              Importing data into SAS.

                                                          • Exploring and Validating Data
                                                            • Exploring data.

                                                              Filtering rows.

                                                              Formatting columns.

                                                              Sorting data and removing duplicates.

                                                          • Preparing Data
                                                            • Reading and filtering data.

                                                              Computing new columns.

                                                              Conditional processing.

                                                          • Analyzing and Reporting on Data
                                                            • Enhancing reports with titles, footnotes, and labels.

                                                              Creating frequency reports.

                                                              Creating summary statistics reports.

                                                          • Exporting Results
                                                            • Exporting data.

                                                              Exporting reports.

                                                          • Using SQL in SAS
                                                            • Using Structured Query Language in SAS.

                                                              Joining tables using SQL in SAS.

                                                          Get full course syllabus in your inbox

                                                          • Controlling DATA Step Processing
                                                            • setting up for this course

                                                              understanding DATA step processing

                                                              directing DATA step output

                                                          • Summarizing Data
                                                            • creating an accumulating column

                                                              processing data in groups

                                                          • Manipulating Data with Functions
                                                            • understanding SAS functions and CALL routines

                                                              using numeric and date functions

                                                              using character functions

                                                              using special functions to convert column type

                                                          • Creating Custom Formats
                                                            • creating and using custom formats

                                                              creating custom formats from tables

                                                          • Combining Tables
                                                            • concatenating tables

                                                              merging tables

                                                              identifying matching and nonmatching rows

                                                          • Processing Repetitive Code
                                                            • using iterative DO loops

                                                              using conditional DO loops

                                                          • Restructuring Tables
                                                            • restructuring data with the DATA step

                                                              restructuring data with the TRANSPOSE procedure

                                                          Get full course syllabus in your inbox

                                                          • Placement Guide
                                                            • What is an Interview

                                                              Tips to clear an Interview

                                                              Common Interview questions and answers

                                                              SAS Interview Questions and Answers

                                                              Resume Building Guide

                                                              Career roadmap and certifications

                                                              Attempt for related Global Certification Exam

                                                              Start applying for Jobs

                                                          Get full course syllabus in your inbox
                                                          BI And Visualization
                                                          SAS Adv Certification Training
                                                          30k LearnersWeekend/WeekdayLive Class
                                                          • 2 Live Project
                                                          • Self-Paced/ Classroom
                                                          • Certification Pass Guaranteed

                                                          • This course is for SAS programmers who want to learn advanced techniques within the DATA step and procedures. Further, the course focuses on using the SAS macro facility to design, write, and debug macro programs, with an emphasis on understanding how programs that contain macro code are processed.
                                                          • You will Perform text substitution in SAS code, learn to use macro variables and macro functions, automate and customize the production of SAS code, conditionally or iteratively construct SAS code, write self-modifying, data-driven programs. Moving ahead, you will also learn how to process SAS data using Structured Query Language (SQL).
                                                          • In this program you will learn:
                                                            • SAS Programming Advanced Techniques

                                                              SAS Macro Language Essentials

                                                              SAS SQL Essentials

                                                          Get full course syllabus in your inbox

                                                          • Getting Started
                                                            • Setting up for this course.

                                                              DATA step review.

                                                          • Using Advanced Functions
                                                            • Using a variety of advanced functions.

                                                              Performing pattern matching with Perl regular expressions.

                                                          • Defining and Processing Arrays
                                                            • Defining and referencing one-dimensional arrays.

                                                              Doing more with one-dimensional arrays.

                                                              Defining and referencing two-dimensional arrays.

                                                          • Defining and Processing Hash Objects
                                                            • Declaring hash objects.

                                                              Defining hash objects.

                                                              Finding key values in a hash object.

                                                              Writing a hash object to a table.

                                                              Using hash iterator objects.

                                                          • Using Utility Procedures
                                                            • Creating picture formats with the FORMAT procedure.

                                                              Creating functions with the FCMP procedure.

                                                          Get full course syllabus in your inbox

                                                          • Introduction
                                                            • Why SAS macro

                                                              Setting up for this course.

                                                          • SAS Macro Facility
                                                            • Program flow.

                                                              Creating and using macro variables.

                                                          • Storing and Processing Text
                                                            • Macro functions.

                                                              Using SQL to create macro variables.

                                                              Using the DATA step to create macro variables.

                                                              Indirect references to macro variables.

                                                          • Working with Macro Programs
                                                            • Defining and calling a macro.

                                                              Macro variable scope.

                                                              Conditional processing.

                                                              Iterative processing.

                                                          • Developing Macro Applications
                                                            • Storing macros.

                                                              Generating data-dependent code.

                                                              Validating parameters and documenting macros.

                                                          Get full course syllabus in your inbox

                                                          • Essentials
                                                            • Setting up for this course.

                                                              Overview of SAS Foundation.

                                                              Course logistics.

                                                              Course data files.

                                                              Introducing the Structured Query Language.

                                                              Overview of the SQL procedure.

                                                              Exploring tables.

                                                              Specifying columns.

                                                          • PROC SQL Fundamentals
                                                            • Sub-setting data.

                                                              Presenting data.

                                                              Summarizing data.

                                                              Creating and managing tables.

                                                              Using DICTIONARY tables.

                                                          • SQL Joins
                                                            • Introduction to SQL joins.

                                                              Inner joins.

                                                              Outer joins.

                                                              Complex SQL joins.

                                                          • Subqueries
                                                            • Noncorrelated subqueries.

                                                              Correlated subqueries.

                                                              In-line views.

                                                              Creating views with the SQL procedure.

                                                              Subqueries in the SELECT clause.

                                                              Remerging summary statistics.

                                                          • Set Operators
                                                            • Introduction to set operators.

                                                              The INTERSECT operator.

                                                              The EXCEPT operator.

                                                              The UNION operator.

                                                              The OUTER UNION operator.

                                                          • Using and Creating Macro Variables in SQL
                                                            • Interfacing PROC SQL with the macro language.

                                                              Creating data-driven macro variables with a query.

                                                              Using macro variables in SQL.

                                                          • Accessing DBMS Data with SAS/ACCESS
                                                            • Overview of SAS/ACCESS technology.

                                                              SQL pass-through facility.

                                                              SAS/ACCESS LIBNAME statement.

                                                              PROC Fed SQL.

                                                          Get full course syllabus in your inbox

                                                          • Placement Guide
                                                            • What is an Interview

                                                              Tips to clear an Interview

                                                              Common Interview questions and answers

                                                              SAS Advanced Interview Questions and Answers

                                                              Resume Building Guide

                                                              Career roadmap and certifications

                                                              Attempt for related Global Certification Exam

                                                              Start applying for Jobs

                                                          Get full course syllabus in your inbox
                                                          BI And Visualization
                                                          Microsoft Power BI Training
                                                          30k LearnersWeekend/WeekdayLive Class
                                                          • 2 Live Project
                                                          • Self-Paced/ Classroom
                                                          • Certification Pass Guaranteed

                                                          • Power BI stands tall for users with its significant features like minimal license cost, easy to use operations and high-end product performance. Industry insights specify significant growth in Power BIusers and thus provides a greater number of jobs to the next generations. Microsoft being one among top software providers, with a vision to make this power BI to lead the business intelligence sector started updating with new features to attract more clients in the market.
                                                          • In this program you will learn :
                                                            • Introduction to Power BI

                                                              Power BI Desktop

                                                              Modelling with Power BI

                                                              Data Analysis Expressions (DAX)

                                                              Modelling with Power BI

                                                              Power BI Desktop Visualisations

                                                              Introduction to Power BI Q&A and Data Insights

                                                              Direct Connectivity

                                                              BI and Azure ML Integrating Power

                                                              Publishing and Sharing

                                                              Refreshing Datasets

                                                          Get full course syllabus in your inbox

                                                          • Introduction to Power BI:
                                                            • Overview of BI concepts

                                                              Why we need BI

                                                              Introduction to SSBI

                                                              SSBI Tools

                                                              Why Power BI

                                                              What is Power BI

                                                              Building Blocks of Power BI

                                                              Getting started with Power BI Desktop

                                                              Get Power BI Tools

                                                              Introduction to Tools and Terminology

                                                              Dashboard in Minutes

                                                              Refreshing Power BI Service Data

                                                              Interacting with your Dashboards

                                                              Sharing Dashboards and Reports

                                                          Get full course syllabus in your inbox

                                                          • Power BI Desktop:
                                                            • Power BI Desktop

                                                              Extracting data from various sources

                                                              Workspaces in Power BI

                                                              Data Transformation

                                                              Measures and Calculated Columns

                                                              Query Editor

                                                          Get full course syllabus in your inbox

                                                          • Modelling with Power BI:
                                                            • Introduction to Modelling

                                                              Modelling Data

                                                              Manage Data Relationship

                                                              Optimize Data Models

                                                              Cardinality and Cross Filtering

                                                              Default Summarization & Sort by

                                                              Creating Calculated Columns

                                                              Creating Measures & Quick Measures

                                                          Get full course syllabus in your inbox

                                                          • Data Analysis Expressions (DAX):
                                                            • What is DAX

                                                              Data Types in DAX

                                                              Calculation Types

                                                              Syntax, Functions, Context Options

                                                              DAX Functions

                                                              Date and Time

                                                              Time Intelligence

                                                              Information

                                                              Logical

                                                              Mathematical

                                                              Statistical

                                                              Text and Aggregate

                                                              • Measures in DAX
                                                                • ROW Context and Filter Context in DAX
                                                                  • Operators in DAX -Real-time Usage
                                                                    • Quick Measures in DAX -Auto validations
                                                                      • PowerPivot xVelocity & Vertipaq Store
                                                                        • In-Memory Processing: DAX Performance
                                                                      Get full course syllabus in your inbox
                                                                      BI And Visualization
                                                                      Tableau Certification Training
                                                                      30k LearnersWeekend/WeekdayLive Class
                                                                      • 2 Live Project
                                                                      • Self-Paced/ Classroom
                                                                      • Certification Pass Guaranteed

                                                                      • Data Visualization
                                                                      • Business Intelligence tools
                                                                      • Introduction to Tableau
                                                                      • Tableau Architecture
                                                                      • Tableau Server Architecture
                                                                      • VizQL Fundamentals
                                                                      • Introduction to Tableau Prep
                                                                      • Tableau Prep Builder User Interface
                                                                      • Data Preparation techniques using Tableau Prep Builder tool
                                                                      Get full course syllabus in your inbox

                                                                      • Features of Tableau Desktop
                                                                      • Connect to data from File and Database
                                                                      • Types of Connections
                                                                      • Joins and Unions
                                                                      • Data Blending
                                                                      • Tableau Desktop User Interface
                                                                      Get full course syllabus in your inbox

                                                                      • Visual Analytics
                                                                      • Basic Charts Bar Chart, Line Chart, and Pie Chart
                                                                      • Hierarchies
                                                                      • Data Granularity
                                                                      • Highlighting
                                                                      • Sorting
                                                                      • Filtering
                                                                      • Grouping
                                                                      • Sets
                                                                      Get full course syllabus in your inbox

                                                                      • Types of Calculations
                                                                      • Built-in Functions (Number, String, Date, Logical and Aggregate)
                                                                      • Operators and Syntax Conventions
                                                                      • Table Calculations
                                                                      • Level of Detail (LOD) Calculations
                                                                      • Using R within Tableau for Calculations
                                                                      Get full course syllabus in your inbox

                                                                      • Parameters
                                                                      • Tool tips
                                                                      • Trend lines
                                                                      • Reference lines
                                                                      • Forecasting
                                                                      • Clustering
                                                                      Get full course syllabus in your inbox
                                                                      BI And Visualization
                                                                      R Programming Training
                                                                      30k LearnersWeekend/WeekdayLive Class
                                                                      • 1 Live Project
                                                                      • Self-Paced/ Classroom
                                                                      • Certification Pass Guaranteed

                                                                      • This course is suggested for all those novices and specialists who are keen on working in the analytics industry. R is suitable for all IT professionals like Big data analytics, Business analytics, scientific research, statistical reporting, Econometrics, social science, business intelligence, and business development. Researchers who perform data analysis with higher dimensional graphs. Students who need R for their courses. Prerequisite It is not necessary to have any prior knowledge of R. R is now well thought out to be not just the most popular open-source analytic tool but the most popular analytics tool in the world
                                                                      • In this program you will learn:
                                                                        • Overview :

                                                                          R Programming Basics.

                                                                          Variable types and data structures in base R.

                                                                          Getting data into the R environment.

                                                                          Data frame manipulation.

                                                                          Handling dates in R.

                                                                          Exploratory Data Analysis (Descriptive Statistics).

                                                                          Working with text data.

                                                                          Control flow & functions.

                                                                          Graphics in R Overview.

                                                                          Advanced R graphics.

                                                                          Inferential Statistics.

                                                                          General Linear Regression Models in R.

                                                                      Get full course syllabus in your inbox

                                                                      • Overview:
                                                                        • History of R

                                                                          Advantages and disadvantages

                                                                          Downloading and installing

                                                                          How to find documentation

                                                                      Get full course syllabus in your inbox

                                                                      • R Programming Basics:
                                                                        • Using the R console and R Studio

                                                                          Getting help

                                                                          Learning about the environment

                                                                          Writing and executing scripts

                                                                          Object oriented programming

                                                                          Introduction to vectorised calculations

                                                                          Introduction to data frames

                                                                          Installing and loading packages

                                                                          Working directory

                                                                          Saving your work

                                                                      Get full course syllabus in your inbox

                                                                      • Variable types and data structures in base R:
                                                                        • Variables and assignment

                                                                          Data types

                                                                          Numeric, character, Boolean, and factors

                                                                          Data structures

                                                                          Vectors, matrices, arrays, data frames, lists

                                                                          Indexing, sub-setting

                                                                          Assigning new values

                                                                          Viewing data and summaries

                                                                          Naming conventions

                                                                          Objects

                                                                      Get full course syllabus in your inbox

                                                                      • Getting data into the R environment:
                                                                        • Built-in data

                                                                          Reading data from structured text files

                                                                          Reading data using ODBC

                                                                      Get full course syllabus in your inbox
                                                                      BI And Visualization
                                                                      Microsoft Advance Excel Certification Training
                                                                      30k LearnersWeekend/WeekdayLive Class
                                                                      • 2 Live Project
                                                                      • Self-Paced/ Classroom
                                                                      • Certification Pass Guaranteed

                                                                      • Basic Understanding Menu and Toolbar
                                                                      • Introduction to different category of functions
                                                                      • Creation of Excel Sheet Data
                                                                      • Range Name, Format Painter
                                                                      • Conditional Formatting, Wrap Text, Merge & Centre
                                                                      • Sort, Filter, Advance Filter
                                                                      • Different type of Chart Creations
                                                                      • Auditing, (Trace Precedents, Trace Dependents) Print Area
                                                                      • Data Validations, Consolidate, Subtotal
                                                                      • What if Analysis (Data Table, Goal Seek, Scenario)
                                                                      • Solver, Freeze Panes
                                                                      • Various Simple Functions in Excel (Sum, Average, Max, Min)
                                                                      • Real Life Assignment work
                                                                      Get full course syllabus in your inbox

                                                                      • Manage workbook
                                                                        • Save a workbook as a template,

                                                                          copy macros between workbooks,

                                                                          reference data in another workbook,

                                                                          reference data by using structured references,

                                                                          enable macros in a workbook,

                                                                          display hidden ribbon tabs

                                                                      • Manage workbook review
                                                                        • Restrict editing,

                                                                          protect a worksheet

                                                                          configure formula calculation options

                                                                          protect workbook structure

                                                                          manage workbook versions

                                                                          encrypt a workbook with a password

                                                                      Get full course syllabus in your inbox

                                                                      • Apply custom data formats and validation
                                                                        • Create custom number formats

                                                                          populate cells by using advanced Fill Series options

                                                                          configure data validation

                                                                      • Apply advanced conditional formatting and filtering
                                                                        • Create custom conditional formatting rules

                                                                          create conditional formatting rules that use formulas

                                                                          manage conditional formatting rules

                                                                      • Create and modify custom workbook elements
                                                                        • Create custom color formats,

                                                                          create and modify cell styles,

                                                                          create and modify custom themes,

                                                                          create and modify simple macros

                                                                          insert and configure form controls

                                                                      • Prepare a workbook for internationalization
                                                                        • Display data in multiple international formats

                                                                          apply international currency formats,

                                                                          manage multiple options for Body and Heading fonts

                                                                      Get full course syllabus in your inbox

                                                                      • Apply functions in formulas
                                                                        • Perform logical operations by using AND, OR, and NOT functions;

                                                                          perform logical operations by using nested functions

                                                                          perform statistical operations by using SUMIFS, AVERAGEIFS, COUNTIFS

                                                                          functions

                                                                      • Look up data by using functions
                                                                        • Look up data by using the VLOOKUP function,

                                                                          look up data by using the HLOOKUP function,

                                                                          look up data by using the MATCH function,

                                                                          look up data by using the INDEX function

                                                                      • Apply advanced date and time functions
                                                                        • Reference the date and time by using the NOW and TODAY functions,

                                                                          serialize numbers by using date and time functions

                                                                      • Perform data analysis and business intelligence
                                                                        • Reference the date and time by using the NOW and TODAY functions

                                                                          import, transform, combine, display, and connect to data

                                                                          consolidate data

                                                                          perform what-if analysis by using Goal Seek and Scenario Manager

                                                                          use cube functions to get data out of the Excel data model

                                                                          calculate data by using financial functions

                                                                      • Troubleshoot formulas
                                                                        • Trace precedence and dependence

                                                                          monitor cells and formulas by using the Watch Window

                                                                          validate formulas by using error checking rules,

                                                                          Evaluate formulas

                                                                      • Define named ranges and objects
                                                                        • Name cells,

                                                                          name data ranges,

                                                                          name tables,

                                                                          manage named ranges and objects

                                                                      • Module 5: Create Advanced Charts and Tables
                                                                      • Create advanced charts
                                                                        • Add trendlines to charts,

                                                                          create dual-axis charts,

                                                                          save a chart as a template

                                                                      • Create and manage PivotTables
                                                                        • Create PivotTables,

                                                                          modify field selections and options,

                                                                          create slicers,

                                                                          group PivotTable data,

                                                                          reference data in a PivotTable by using the GETPIVOTDATA function,

                                                                          add calculated fields,

                                                                          format data

                                                                      • Create and manage PivotCharts
                                                                        • Create PivotCharts,

                                                                          manipulate options in existing PivotCharts,

                                                                          apply styles to PivotCharts,

                                                                          drill down into PivotChart details

                                                                      Get full course syllabus in your inbox

                                                                      • Dashboard Background
                                                                      • Dashboard Elements
                                                                      • Interactive Dashboards
                                                                      • Type of Reporting in India
                                                                      • Reporting Analyst
                                                                      • Indian Print Media Reporting
                                                                      • Audit Report
                                                                      • Accounting MIS Reports
                                                                      • HR MIS Reports
                                                                      • MIS Report Preparation Supplier, Exporter
                                                                      • Data Analysis
                                                                      • Costing Budgeting Mis Reporting
                                                                      • MIS Reporting for Manufacturing Company
                                                                      • MIS Reporting for Store and Billing
                                                                      • Product Performance Report
                                                                      • Member Performance Report
                                                                      • Customer-Wise Sales Report
                                                                      • Collections Report
                                                                      • Channel Stock Report
                                                                      • Prospect Analysis Report
                                                                      • Calling Reports
                                                                      • Expenses Report
                                                                      • Stock Controller MIS Reporting
                                                                      • Inventory Statement
                                                                      • Payroll Report
                                                                      • Salary Slip
                                                                      • Loan Assumption Sheet
                                                                      • Invoice Creation
                                                                      Get full course syllabus in your inbox
                                                                      BI And Visualization
                                                                      Microsoft Excel VBA Certification Training
                                                                      30k LearnersWeekend/WeekdayLive Class
                                                                      • 2 Live Project
                                                                      • Self-Paced/ Classroom
                                                                      • Certification Pass Guaranteed

                                                                      • It is estimated that the job opportunities for VBA programmers are set to grow exponentially given the current demand and estimated growth in the number of companies seeking out such individuals. With the VBA (Visual Basic for Applications) training by Croma Campus, learn how to create macros to automate functions and generate graphs and reports.
                                                                      • In this program you will learn:
                                                                        • VBA Basics.

                                                                          Control Structures: Logical Expressions.

                                                                          Control Structures: Loops.

                                                                          Sub-Procedure and Functions.

                                                                          Debugging.

                                                                          Handling Text files, Pictures and charts.

                                                                          VBA forms.

                                                                          Database Connectivity:

                                                                      Get full course syllabus in your inbox

                                                                      • What is VBA:
                                                                        • Overview

                                                                          The History of VBA

                                                                          Why VBA

                                                                          VBA Summary

                                                                      • Available Data Types and Usage
                                                                      • Micro Structure & Basic Macro
                                                                        • Active sheet, Active cell, offset, sheet add, rename, etc.

                                                                      • Options Base and Explicit
                                                                      • Arrays
                                                                        • Static & Dynamic

                                                                          Array functions

                                                                      • Macro with Excel
                                                                      • Basic Macro with daily use
                                                                        • Filter, cut, copy, paste, remove duplication, etc.

                                                                      • Macro with File
                                                                        • File system basics

                                                                          Understanding file permissions

                                                                          Setting file permissions

                                                                          Accessing files

                                                                          Writing to files

                                                                          Deleting files

                                                                          Reading files

                                                                          Examining file details

                                                                          Working with directories

                                                                          Viewing directory content

                                                                      • Form and Activity X Control
                                                                      Get full course syllabus in your inbox

                                                                      • Control Structures: Logical Expressions:
                                                                        • If statements

                                                                          Else and elseif statements

                                                                          Logical operators

                                                                          And. OR, Not. Go to Statements

                                                                          Switch statements

                                                                      Get full course syllabus in your inbox

                                                                      • Control Structures: Loops:
                                                                        • While loops

                                                                          For loops

                                                                          For each loops

                                                                          do while

                                                                          do until

                                                                          Continue

                                                                          Break

                                                                          Understanding array pointers

                                                                      Get full course syllabus in your inbox

                                                                      • Sub-Procedure and Functions:
                                                                        • Subroutine

                                                                          Passing value to sub- procedure

                                                                          Message box

                                                                          VBA Inbuilt functions

                                                                          Passing values in functions

                                                                          Workbook and worksheet functions

                                                                          Keywords

                                                                          Difference between sub-routines and functions

                                                                          Creating own functions in VBA for Excel

                                                                      Get full course syllabus in your inbox
                                                                      HR & Payroll
                                                                      Business Analyst Certification Training
                                                                      40k LearnersWeekend/WeekdayLive Class
                                                                      • 2 Live Project
                                                                      • Self-Paced/ Classroom
                                                                      • Certification Pass Guaranteed

                                                                      • Software Development Life Cycle
                                                                      • Software Development Methodologies Water Fall, Iterative, Agile, etc.
                                                                      • Types of Software Projects Greenfield, Migration, Product Customization, Maintenance etc.
                                                                      • IT Implementation
                                                                      • IT Deployment Environments SAAS, On Premise, Client Server etc.
                                                                      • Software Licensing, Subscription and Sale Models
                                                                      • Project Development Vs Product Development
                                                                      • RUP, DevOps Methodologies
                                                                      • Cloud Service and Deployment Models - Public, Private, Hybrid, Community, IAAS, PAAS,
                                                                      • SAAS
                                                                      Get full course syllabus in your inbox

                                                                      • Activities of an IT Business Analyst
                                                                      • Analysis, Business Analysis, IT Business Analysis defined
                                                                      • Objectives of Business Analysis
                                                                      • Who is an IT Business Analyst
                                                                      • Business Analysis Levels or Views - Process, Project, Enterprise and Industry
                                                                      • Business Analysis Framework and Techniques
                                                                      • IT Business Analysis Software
                                                                      • IT Business Analyst Skills
                                                                      • IT Business Analyst Career Path and Salaries
                                                                      • Meet some real Business Analysts
                                                                      Get full course syllabus in your inbox

                                                                      • What is a Business Process
                                                                      • Critical Analysis of a Business Process
                                                                      • Business Process Analysis Sparx System Framework
                                                                      • Business Process Mapping & Flow charting
                                                                      • As Is To Be Analysis for a Business Process
                                                                      • Business Process Mapping and Modelling Frameworks
                                                                      • Business Process Mapping and Modelling Software
                                                                      • Business Process Re-Engineering & Re-Design
                                                                      • Business Process Automation, Disinter mediation and Re-intermediation
                                                                      • Business Process Simulation
                                                                      Get full course syllabus in your inbox

                                                                      • What is a Requirement
                                                                      • Attributes of Requirements
                                                                      • Importance of Requirements for IT Projects
                                                                      • Types of Requirements: Business, Enterprise, Solution, Stakeholder, Transition
                                                                      • Overview of Requirements Engineering and Management
                                                                      • Requirements Basics: Mapping, Modelling, Traceability Matrix, Tracking
                                                                      • Business Process Re-Engineering & Re-Design
                                                                      • Important Requirement Process Steps: Elicitation, Analysis, Documentation, Validation, Management
                                                                      • Requirement Software Companies - JIRA, Rational Requisite Pro
                                                                      Get full course syllabus in your inbox

                                                                      • Stakeholder Definition
                                                                      • Importance of Stakeholder
                                                                      • Stakeholder Identification Onion Diagram
                                                                      • Stakeholder Identification Wheel
                                                                      • Stakeholder Classification Power Influence Matrix
                                                                      • Stakeholder Engagement Techniques Power/Influence Vs Interest
                                                                      • Stakeholder RACI Chart, its preparation through Visio
                                                                      • Stake Holder Persona
                                                                      • Stakeholder Alignment and Sponsorship
                                                                      • Managing Internal stakeholders
                                                                      • Preparing Stakeholder map through Excel
                                                                      Get full course syllabus in your inbox
                                                                      Need Customized curriculum?

                                                                      Mock Interviews

                                                                      Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.How Croma Campus Placement Process Works?
                                                                      Mock_Cycle
                                                                      Request more information

                                                                      Phone (For Voice Call):

                                                                      +91-971 152 6942

                                                                      WhatsApp (For Call & Chat):

                                                                      +91-8287060032

                                                                      Projects

                                                                      Batch Request

                                                                      SELF ASSESSMENT

                                                                      Learn, Grow & Test your skill with Online Assessment Exam to
                                                                      achieve your Certification Goals

                                                                      right-selfassimage

                                                                      FAQ's

                                                                      In today’s competitive landscape, SAS programming is a great career option for students looking to gain knowledge and get a high-paid job no matter whether you are a fresher or a working professional.

                                                                      The SAS Global Certification Program comes with no expiry date.

                                                                      The average salary for a SAS Programmer in India is Rs 442,563 per year.

                                                                      You can undergo SAS training even if you have passed higher secondary.

                                                                      SAS (Statistical Analysis System) is a software suite developed for predictive analytics, business intelligence, advanced analytics, data management, and multivariate analyses.

                                                                      Career Assistancecareer assistance
                                                                      • - Build an Impressive Resume
                                                                      • - Get Tips from Trainer to Clear Interviews
                                                                      • - Attend Mock-Up Interviews with Experts
                                                                      • - Get Interviews & Get Hired
                                                                      Are you satisfied with our Training Curriculum?

                                                                      If yes, Register today and get impeccable Learning Solutions!.

                                                                      man

                                                                      Training Features

                                                                      instructore

                                                                      Instructor-led Sessions

                                                                      The most traditional way to learn with increased visibility,monitoring and control over learners with ease to learn at any time from internet-connected devices.

                                                                      real life

                                                                      Real-life Case Studies

                                                                      Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.

                                                                      assigment

                                                                      Assignment

                                                                      Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.

                                                                      life time access

                                                                      Lifetime Access

                                                                      Get Unlimited access of the course throughout the life providing the freedom to learn at your own pace.

                                                                      expert

                                                                      24 x 7 Expert Support

                                                                      With no limits to learn and in-depth vision from all-time available support to resolve all your queries related to the course.

                                                                      certification

                                                                      Certification

                                                                      Each certification associated with the program is affiliated with the top universities providing edge to gain epitome in the course.

                                                                      Showcase your Course Completion Certificate to Recruiters

                                                                      • checkgreenTraining Certificate is Govern By 12 Global Associations.
                                                                      • checkgreenTraining Certificate is Powered by “Wipro DICE ID”
                                                                      • checkgreenTraining Certificate is Powered by "Verifiable Skill Credentials"
                                                                      certiciate-images

                                                                      Students Placements & Reviews

                                                                      speaker
                                                                      Vikash Singh Rana
                                                                      Vikash Singh Rana
                                                                      speaker
                                                                      Shubham Singh
                                                                      Shubham Singh
                                                                      speaker
                                                                      Saurav Kumar
                                                                      Saurav Kumar
                                                                      View More arrowicon

                                                                      WHAT OUR ALUMNI SAYS ABOUT US

                                                                      View More arrowicon
                                                                      sallerytrendicon

                                                                      Get Latest Salary Trends

                                                                      ×

                                                                      For Voice Call

                                                                      +91-971 152 6942

                                                                      For Whatsapp Call & Chat

                                                                      +91-8287060032
                                                                      1