- 2 Live Project
- Self-Paced/ Classroom
- Certification Pass Guaranteed
- The SAS training program in Delhi has been designed to give you comprehensive skills in SAS programming language, various SAS tools, leading statistical techniques that will further help you to become an established SAS programmer. The course includes a series of assignments, case studies and project work to make the learning more effective. The training includes multiple SAS certification training courses like SAS BASE Programmer, SAS Advanced Programmer, and SAS admin course, etc.
- You will also get knowledge of BI domain and the business analytics domain. When you will complete the course from SAS training institute in Delhi, you gain enough confidence to manage spreadsheet and databases with grace using different SAS functions. Some of the highlighting skills include data mining, data analytics, data modeling techniques, predictive analysis, data visualization, and more.
- With the best SAS training institute in Delhi, you will get a chance to master little advanced topics like SAS macros, Machine Learning, PROC SQL, procedure, statistical analysis and decision trees. On the completion of SAS basic and the advanced training in Delhi NCR, you will find yourself more competent to execute the most complex SAS projects at workplaces.
- The core objective of SAS training in Delhi is to help you learn SAS basics and advanced concepts in depth and prepare for the certification exam too.
Learn about predictive analytics techniques using SAS, SAS GUI, data manipulation techniques, data integration, and refining datasets, etc.
Learn about iterative and conditional looping in your SAS program.
Learn how to simplify a complex SAS program using SAS arrays.
With the SAS certification course, learn how to automate repeated complex tasks with the help of MACROS in SAS.
Learn about various SAS tools, SAS programming, and statistical techniques for advanced programming in SAS.
Learn how to implement SQL queries and manage spreadsheets or databases.
Get the basic SAS programming skills that include, logical statements, functions, variables, etc
With the top SAS training institute in Delhi, learn creating datasets, graphs, summary reports, and visuals in SAS.
- According to more than 70 percent of Companies, data analytics has been critical how they make decisions. Most companies believe that they have utilized only 12% of the total available data and most of it goes wasted. Here, the role of SAS programmer comes to the picture that helps in depth analysis of data to make meaningful business decisions ahead after completing course from SAS training institute in Delhi.
- On the completion of SAS certification course, the expected salary of a SAS programmer in USA is taken around $102K and it may vary location to location. Salaries for SAS Developer in India is around 2,66,988, for Lead SAS Programmer, it is 5,49,024, for Senior Software Engineer, it is 10,00,008 at the experienced level. With the SAS training institute in Delhi, you can make your skills more marketable and start applying for leading industries right away.
- You must be wondering what would be the career growth after the SAP training in Delhi. SAS has been the market leader for years and it has a wonderful GUI to help people learn quickly and offers wonderful technical support too.
On the course completion, you get all the required skills and make yourself eligible to get higher salaries.
You may attempt the global certification exams, clear them in the first attempt and gain credentials that are really valued by employers.
The SAS training institute in Delhi helps to drive meaningful insights from the available data in no time and speed up the decision-making process too.
The training will definitely help you to establish yourself as an expert in the SAS domain and achieve your professional goals too.
- SAS is a powerful business analytics platform and helps enterprises to improve their business performance to the superior level. The SAS training in Delhi helps you to get the right skills to manage spreadsheet and databases. The course makes you eligible to apply for leading industries and makes you a good decision-maker too. If you know SQL fundamentals in-depth then it could be an added benefit for you.
- SAS means STATISTICAL ANALYSIS SYSTEM that offers detailed analytics including BI, predictive analytics, data management, multivariate analysis, and more. SAS is the number one technology in business analytics and helps industries to manage their daily work effectively. The main objective of SAS platform is to convert collected data into meaningful insights that may give a completely new direction to businesses.
- SAS has a friendly GUI and it can be used by anyone either he is a technical or non-IT person. To use this software, data must be in excel or SAS format only. With SAS courses online, you will get all the required skills and learn to manage spreadsheets and databases like a pro. Get trained by the most potent SAS training institute in Delhi and make yourself eligible to apply for industry giants today.
- SAS has different job profiles like SAS BASE programmer, SAS Advanced programmer, SAS admin, etc. Our SAS training in Delhi helps you to understand roles and responsibilities for major SAS job profiles.
- With the best SAS training in Delhi, you get a depth idea of major job roles and responsibilities in SAS and prepare yourself for the same.
You should know about SAS basics and advanced concepts in depth
You must have a sound idea of predictive analytics techniques using SAS, SAS GUI, data manipulation techniques, data integration, and refining datasets, etc.
You should know about iterative and conditional looping in your SAS program.
You must know how to simplify a complex SAS program using SAS arrays.
You must know how to automate repeated complex tasks with the help of MACROS in SAS. You should know how to implement SQL queries and manage spreadsheets or databases.
You should know about various SAS tools, SAS programming, and statistical techniques for advanced programming in SAS.
You should know about the basic SAS programming skills that include, logical statements, functions, variables, etc
You should know about creating datasets, graphs, summary reports, and visuals in SAS.
- Microsoft, Walmart, IBM, Facebook, Oracle, and more. These are a few industries who are actively hiring SAS programmers worldwide. The SAS training in Delhi is intended to make you an expert in SAS programming and analytics. You could analyze real-world problems and use SAS to perform advanced data analysis and get optimized results with advanced SAS programming skills.
- With the most prominent SAS training in Delhi, you could make yourself eligible to apply for leading industries and give your best shot at the workplace. Get the best interview tips to clear it in the first attempt and bag attractive salary packages too.
- In the end of SAS training in Delhi, you will get a course completion certificate that is valid proof that you have practical skills in SAS. To get this training certificate, you need to complete one project work too and get evaluated by expert team for your work. Based on your performance, you are awarded with a training certificate.
- It would be great if you can complete your course from SAS training institute in Delhi make yourself more desirable among the crowd. We wish you all the very best for a brighter career ahead with the Croma Campus expert training team!
Why should you learn SAS?
By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy
Course Duration
32 Hrs.Flexible Batches For You
21-Dec-2024*
- Weekend
- SAT - SUN
- Mor | Aft | Eve - Slot
16-Dec-2024*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
18-Dec-2024*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
21-Dec-2024*
- Weekend
- SAT - SUN
- Mor | Aft | Eve - Slot
16-Dec-2024*
- Weekday
- MON - FRI
- Mor | Aft | Eve - Slot
18-Dec-2024*
- 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+
Success Ratio
100%
Corporate Training
For India & Abroad
Job Assistance
100%
BATCH TIMING
As per your requirementFOR QUERIES, FEEDBACK OR ASSISTANCE
Contact Croma Campus Learner Support
Best of support with us
SAS Certification Training Programs
SAS Certification TrainingPrograms
- Data Ananyst is a powerful analytics platform to make discoveries. By using different aspects of computer science, data visualisations, data analytics, statistics, R and Python Programming in data science, you may convert voluminous data into meaningful contents.
- Installation and Working with Python
- Understanding Python variables
- Python basic Operators
- Understanding the Python blocks.
- Python Comments, Multiline Comments.
- Python Indentation
- Understating the concepts of Operators
- Arithmetic
- Relational
- Logical
- Assignment
- Membership
- Identity
- Variables, expression condition and function
- Global and Local Variables in Python
- Packing and Unpacking Arguments
- Type Casting in Python
- Byte objects vs. string in Python
- Variable Scope
- Declaring and using Numeric data types
- Using string data type and string operations
- Understanding Non-numeric data types
- Understanding the concept of Casting and Boolean.
- Strings
- List
- Tuples
- Dictionary
- Sets
- Statements – if, else, elif
- How to use nested IF and Else in Python
- Loops
- Loops and Control Statements.
- Jumping Statements – Break, Continue, pass
- Looping techniques in Python
- How to use Range function in Loop
- Programs for printing Patterns in Python
- How to use if and else with Loop
- Use of Switch Function in Loop
- Elegant way of Python Iteration
- Generator in Python
- How to use nested Loop in Python
- Use If and Else in for and While Loop
- Examples of Looping with Break and Continue Statement
- How to use IN or NOT IN keyword in Python Loop.
- Python Syntax
- Function Call
- Return Statement
- Arguments in a function – Required, Default, Positional, Variable-length
- Write an Empty Function in Python –pass statement.
- Lamda/ Anonymous Function
- *args and **kwargs
- Help function in Python
- Scope and Life Time of Variable in Python Function
- Nested Loop in Python Function
- Recursive Function and Its Advantage and Disadvantage
- Organizing python codes using functions
- Organizing python projects into modules
- Importing own module as well as external modules
- Understanding Packages
- Random functions in python
- Programming using functions, modules & external packages
- Map, Filter and Reduce function with Lambda Function
- More example of Python Function
- Day, Month, Year, Today, Weekday
- IsoWeek day
- Date Time
- Time, Hour, Minute, Sec, Microsec
- Time Delta and UTC
- StrfTime, Now
- Time stamp and Date Format
- Month Calendar
- Itermonthdates
- Lots of Example on Python Calendar
- Create 12-month Calendar
- Strftime
- Strptime
- Format Code list of Data, Time and Cal
- Locale’s appropriate date and time
- What is List.
- List Creation
- List Length
- List Append
- List Insert
- List Remove
- List Append & Extend using “+” and Keyword
- List Delete
- List related Keyword in Python
- List Revers
- List Sorting
- List having Multiple Reference
- String Split to create a List
- List Indexing
- List Slicing
- List count and Looping
- List Comprehension and Nested Comprehension
- What is Tuple
- Tuple Creation
- Accessing Elements in Tuple
- Changing a Tuple
- Tuple Deletion
- Tuple Count
- Tuple Index
- Tuple Membership
- TupleBuilt in Function (Length, Sort)
- Dict Creation
- Dict Access (Accessing Dict Values)
- Dict Get Method
- Dict Add or Modify Elements
- Dict Copy
- Dict From Keys.
- Dict Items
- Dict Keys (Updating, Removing and Iterating)
- Dict Values
- Dict Comprehension
- Default Dictionaries
- Ordered Dictionaries
- Looping Dictionaries
- Dict useful methods (Pop, Pop Item, Str , Update etc.)
- What is Set
- Set Creation
- Add element to a Set
- Remove elements from a Set
- PythonSet Operations
- Frozen Sets
- What is Set
- Set Creation
- Add element to a Set
- Remove elements from a Set
- PythonSet Operations
- Python Errors and Built-in-Exceptions
- Exception handing Try, Except and Finally
- Catching Exceptions in Python
- Catching Specic Exception in Python
- Raising Exception
- Try and Finally
- Opening a File
- Python File Modes
- Closing File
- Writing to a File
- Reading from a File
- Renaming and Deleting Files in Python
- Python Directory and File Management
- List Directories and Files
- Making New Directory
- Changing Directory
- SQL Database connection using
- Creating and searching tables
- Reading and Storing cong information on database
- Programming using database connections
- Installing SMTP Python Module
- Sending Email
- Reading from le and sending emails to all users
- Working With Excel
- Reading an excel le using Python
- Writing to an excel sheet using Python
- Python| Reading an excel le
- Python | Writing an excel le
- Adjusting Rows and Column using Python
- ArithmeticOperation in Excel le.
- Play with Workbook, Sheets and Cells in Excel using Python
- Creating and Removing Sheets
- Formatting the Excel File Data
- More example of Python Function
- Check Dirs. (exist or not)
- How to split path and extension
- How to get user prole detail
- Get the path of Desktop, Documents, Downloads etc.
- Handle the File System Organization using OS
- How to get any les and folder’s details using OS
Introduction To Python
Python Keyword and Identiers
Introduction To Variables
Python Data Type
Control Structure & Flow
Python Function, Modules and Packages
Python Date Time and Calendar
List
Tuple
Dictionary
Sets
Strings
Python Exception Handling
Python File Handling
Python Database Interaction
Contacting user Through Emails Using Python
Reading an excel
Complete Understanding of OS Module of Python
- Data visualization is the graphical way to representation of information and data. By using visual elements like graphs, maps and charts. Data visualization tools provide an accessible easy way to see and understand the data.
- Statistics
- Categorical Data
- Numerical Data
- Mean
- Median
- Mode
- Outliers
- Range
- Interquartile range
- Correlation
- Standard Deviation
- Variance
- Box plot
- Pandas
- Read data from Excel File using Pandas More Plotting, Date Time Indexing and writing to les
- How to get record specic records Using Pandas Adding & Resetting Columns, Mapping with function
- Using the Excel File class to read multiple sheets More Mapping, Filling Nonvalue’s
- Exploring the Data Plotting, Correlations, and Histograms
- Getting statistical information about the data Analysis Concepts, Handle the None Values
- Reading les with no header and skipping records Cumulative Sums and Value Counts, Ranking etc
- Reading a subset of columns Data Maintenance, Adding/Removing Cols and Rows
- Applying formulas on the columns Basic Grouping, Concepts of Aggre gate Function
- Complete Understanding of Pivot Table Data Slicing using iLoc and Loc property (Setting Indices)
- Under sting the Properties of Pivot Table in Pandas Advanced Reading CSVs/HTML, Binning, Categorical Data
- Exporting the results to Excel Joins
- Python | Pandas Data Frame Inner Join
- Under sting the properties of Data Frame Left Join (Left Outer Join)
- Indexing and Selecting Data with Pandas Right Join (Right Outer Join)
- Pandas | Merging, Joining and Concatenating Full Join (Full Outer Join)
- Pandas | Find Missing Data and Fill and Drop NA Appending Data Frame and Data
- Pandas | How to Group Data How to apply Lambda / Function on Data Frame
- Other Very Useful concepts of Pandas in Python Data Time Property in Pandas (More and More)
- NumPy
- Introduction to NumPy Numerical Python
- Importing NumPy and Its Properties
- NumPy Arrays
- Creating an Array from a CSV
- Operations an Array from a CSV
- Operations with NumPy Arrays
- Two-Dimensional Array
- Selecting Elements from 1-D Array
- Selecting Elements from 2-D Array
- Logical Operation with Arrays
- Indexing NumPy elements using conditionals
- NumPy’s Mean and Axis
- NumPy’s Mode, Median and Sum Function
- NumPy’s Sort Function and More
- MatPlotLib
- Bar Chart using Python MatPlotLib
- Column Chart using Python MatPlotLib
- Pie Chart using Python MatPlotLib
- Area Chart using Python MatPlotLib
- Scatter Plot Chart using Python MatPlotLib
- Play with Charts Properties Using MatPlotLib
- Export the Chart as Image
- Understanding plt. subplots () notation
- Legend Alignment of Chart using MatPlotLib
- Create Charts as Image
- Other Useful Properties of Charts.
- Complete Understanding of Histograms
- Plotting Different Charts, Labels, and Labels Alignment etc.
- Introduction to Seaborn
- Introduction to Seaborn
- Making a scatter plot with lists
- Making a count plot with a list
- Using Pandas with seaborn
- Tidy vs Untidy data
- Making a count plot with a Dataframe
- Adding a third variable with hue
- Hue and scattera plots
- Hue and count plots
- Visualizing Two Quantitative Variables
- Introduction to relational plots and subplots
- Creating subplots with col and row
- Customizing scatters plots
- Changing the size of scatter plot points
- Changing the style of scatter plot points
- Introduction to line plots
- Interpreting line plots
- Visualizing standard deviation with line plots
- Plotting subgroups in line plots
- Visualizing a Categorical and a Quantitative Variable
- Current plots and bar plots
- Count plots
- Bar plot with percentages
- Customizing bar plots
- Box plots
- Create and interpret a box plot
- Omitting outliers
- Adjusting the whisk
- Point plots
- Customizing points plots
- Point plot with subgroups
- Customizing Seaborn Plots
- Changing plot style and colour
- Changing style and palette
- Changing the scale
- Using a custom palette
- Adding titles and labels Part 1
- Face Grids vs. Axes Subplots
- Adding a title to a face Grid object
- Adding title and labels Part 2
- Adding a title and axis labels
- Rotating x-tics labels
- Putting it all together
- Box plot with subgroups
- Bar plot with subgroups and subplots
- Well done! What’s next
Data Analysis and Visualization using Pandas.
Data Analysis and Visualization using NumPy and MatPlotLib
Introduction to Data Visualization with Seaborn
- Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. In order to experiment with data through the creation of test environments, data scientists make use of SQL as their standard tool, and to carry out data analytics with the data that is stored in relational databases like Oracle, Microsoft SQL, MySQL, we need SQL.
- 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 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 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
- 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
- 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
- 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
- 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
- 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
- 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
- Cursor declaration and Life cycle
- STATIC
- DYNAMIC
- SCROLL Cursors
- FORWARD_ONLY and LOCAL Cursors
- KEYSET Cursors with Complex SPs
- ACID Properties and Scope
- EXPLICIT Transaction types
- IMPLICIT Transactions and options
- AUTOCOMMIT Transaction and usage
- SAVEPOINT and Query Blocking
SQL Server Fundamentals
SQL Server 2019 Database Design
SQL Tables in MS SQL Server
Data Validation and Constraints
Views and Row Data Security
Indexes and Query tuning
Stored Procedures and Benets
System functions and Usage
Triggers, cursors, memory limitations
Cursors and Memory Limitations
Transactions Management
- This module offers knowledge to introduce you to the basic principles based on statistical methods and procedures followed in data analysis. This course will help you to understand the work process involved with summarizing the data, data storage, visualizing the data results, and a hands-on approach with statistical analysis with python.
- What is Analytics & Data Science
- Common Terms in Data Science
- What is data
- Classication of data
- Relevance in industry and need of the hour
- Types of problems and business objectives in various industries
- How leading companies are harnessing the power of analytics
- Critical success drivers.
- Overview of Data Science tools & their popularity.
- Data Science Methodology & problem-solving framework.
- List of steps in Data Science projects
- Identify the most appropriate solution design for the given problem statement
- Project plan for Data Science project & key milestones based on effort estimates
- Build Resource plan for Data Science project
- Why Python for data science
- Importing Data from various sources (Csv, txt, excel, access etc)
- Database Input (Connecting to database)
- Viewing Data objects - sub setting, methods
- Exporting Data to various formats
- Important python modules Pandas
- Cleansing Data with Python
- Filling missing values using lambda function and concept of Skewness.
- Data Manipulation steps (Sorting, ltering, duplicates, merging, append ing, sub setting, derived variables, sampling, Data type conversions, renaming, formatting.
- Normalizing data
- Feature Engineering
- Feature Selection
- Feature scaling using Standard Scaler/Min-Max scaler/Robust Scaler.
- Label encoding/one hot encoding
- Introduction exploratory data analysis
- Descriptive statistics, Frequency Tables and summarization
- Univariate Analysis (Distribution of data & Graphical Analysis)
- Bivariate Analysis (Cross Tabs, Distributions & Relationships, Graphical Analysis)
- Creating Graphs- Bar/pie/line chart/histogram/ boxplot/ scatter/ densi ty etc.)
- Important Packages for Exploratory Analysis (NumPy Arrays, Matplotlib, seaborn, Pandas etc.)
- Descriptive Statistics
- Sample vs Population Statistics
- Random variables
- Probability distribution functions
- Expected value
- Normal distribution
- Gaussian distribution
- Z-score
- Spread and Dispersion
- Correlation and Co-variance
- Concept of model in analytics and how it is used
- Common terminology used in Analytics & Modelling process
- Popular Modelling algorithms
- Types of Business problems - Mapping of Techniques
- Different Phases of Predictive Modelling
- Need for structured exploratory data
- EDA framework for exploring the data and identifying any problems with the data (Data Audit Report)
- Identify missing data
- Identify outliers’ data
- Imbalanced Data Techniques
- Data Preparation
- Feature Engineering
- Feature Scaling
- Datasets
- Dimensionality Reduction
- Anomaly Detection
- Parameter Estimation
- Data and Knowledge
- Selected Applications in Data Mining
Introduction to Data Analytics
Accessing/Importing and Exporting Data
Data Manipulation Cleansing - Munging Using Python Modules
Feature Engineering in Data Science
Data Analysis Visualization Using Python
Introduction to Statistics
Introduction to Predictive Modelling
EDA (Exploratory Data Analysis)
Data Pre-Processing & Data Mining
- Excel is one of the most popular data analysis tool, to help visualize and gain insights from your data. Analytics with Excel helps you to boost your Microsoft Excel skills.
- 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
- 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
- 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 Report 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
Understanding Concepts of Excel
Ms Excel Advance
MIS Reporting & Dash Board
- 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]
- Introduction to SPSS:
Data Analysis with SPSS: General Aspects, Workflow, Critical Issues
SPSS: General Description, Functions, Menus, Commands
SPSS File Management
- Input and Data Cleaning:
Defining Variables
Manual Input of Data
Automated Input of Data and File Import
- 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
- 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
- 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
- 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.
- 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
- 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
- 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
- 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.
- 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.
- 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.
- 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
- 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
- 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
- Power BI Desktop:
Power BI Desktop
Extracting data from various sources
Workspaces in Power BI
Data Transformation
Measures and Calculated Columns
Query Editor
- 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):
- 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
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
- 2 Live Project
- Self-Paced/ Classroom
- Certification Pass Guaranteed
- This Tableau course is for anyone who works with data regardless of technical or analytical background. Users can create and distribute interactive and shareable dashboards, that depict large volumes of data into easily readable graphs and charts.
- Our Tableau Training is designed to help you prepare for the Tableau Desktop Certified Associate Certification examination by providing you rich hands-on training on various Tableau tools.
- In this program you will learn :
Data Preparation using Tableau Prep.
Data Connection with Tableau Desktop.
Basic Visual Analytics.
Calculations in Tableau.
Advanced Visual Analytics.
Level of Detail (LOD) Expressions in Tableau.
Geographic Visualizations in Tableau.
Advanced charts in Tableau.
Dashboards and Stories.
Get Industry Ready.
Exploring Tableau Online.
- Data Preparation using Tableau Prep:
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
- Data Connection with Tableau Desktop:
Features of Tableau Desktop
Connect to data from File and Database
Types of Connections
Joins and Unions
Data Blending
Tableau Desktop User Interface
- Basic Visual Analytics:
Visual Analytics
Basic Charts Bar Chart, Line Chart, and Pie Chart
Hierarchies
Data Granularity
Highlighting
Sorting
Filtering
Grouping
Sets
- Calculations in Tableau:
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
- 2 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.
- Overview:
History of R
Advantages and disadvantages
Downloading and installing
How to find documentation
- 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
- 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
- Getting data into the R environment:
Built-in data
Reading data from structured text files
Reading data using ODBC
- 2 Live Project
- Self-Paced/ Classroom
- Certification Pass Guaranteed
- In this course, you will gain advanced understanding of the Excel environment and have the ability to guide others to the proper use of the program’s features. You will learn to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. You will learn to customize Excel environments to meet project needs and to enhance the productivity. Become an expert in managing custom business templates, multiple-axis financial charts, amortization tables, and inventory schedules.
- In this program you will learn:
Presenting and Managing Data in Excel
Manage Workbook Options and Settings
Apply custom data formats and layouts
Create Advanced Formulas
Create advanced charts and tables
MIS Reporting and Dashboards
- Presenting and Managing Data in Excel:
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
- 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
- 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
- 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
- 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:
- 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
- Control Structures: Logical Expressions:
If statements
Else and elseif statements
Logical operators
And. OR, Not. Go to Statements
Switch statements
- Control Structures: Loops:
While loops
For loops
For each loops
do while
do until
Continue
Break
Understanding array pointers
- 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
- 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
- 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
- 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
- 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
- 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
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?Phone (For Voice Call):
+91-971 152 6942WhatsApp (For Call & Chat):
+91-8287060032Projects
Batch Request
SELF ASSESSMENT
Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals
FAQ's
SAS Training in Delhi is offered by Croma Campus. We’re a leading SAS Training Institute in Delhi. We provide the most learning environment for the major technical course at an affordable price. The best SAS Training in Delhi offered by the best technical IT training. We provide basic and advanced level SAS Training in Delhi with proper practical knowledge.
Our sturdy associations with prime organizations like HCL, Wipro, Dell, Birlasoft, TechMahindra, TCS, IBM, etc. make the U.S.A. capable to put our students in prime MNCs across the world.
Croma Campus in Delhi mentored more than 4000+ competitors with SAS Training in Delhi at a truly sensible charge. The course educational program is redone according to the prerequisite of applicants/corporates.
SAS Training Institute in Delhi included some important courses like SAS Programming, SAS Macro Language, SAS SQL, SAS Advanced Programming etc.
For details information & FREE demo class call us on +91-9711526942 or write to us info@cromacampus.com
Address: - G-21, Sector-03, Noida (201301)
- - Build an Impressive Resume
- - Get Tips from Trainer to Clear Interviews
- - Attend Mock-Up Interviews with Experts
- - Get Interviews & Get Hired
If yes, Register today and get impeccable Learning Solutions!.
Training Features
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 Case Studies
Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.
Assignment
Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.
Lifetime Access
Get Unlimited access of the course throughout the life providing the freedom to learn at your own pace.
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
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
- Training Certificate is Govern By 12 Global Associations.
- Training Certificate is Powered by “Wipro DICE ID”
- Training Certificate is Powered by "Verifiable Skill Credentials"