Menu
or
All Courses
INR USD

SAS BI

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

Why this course ?

Business Intelligence and Analytics. SAS Enterprise Business Intelligence. Use the business intelligence capabilities of the platform for SAS Business Analytics to create a comprehensive and easy-to-use environment for reporting and analysis.


Course Features

  • Instructor Live Sessions

    30hrs of Online Live Instructor-led Classes. Weekend class:10 sessions of 3 hours each and Weekday class:15 sessions of 2 hours each.
  • Real-life Case Studies

    Live project based on any of the selected use cases on the above selected Domain.
  • Assignments

    Each class will be followed by practical assignments which can be completed before the next class.
  • Lifetime Access

    You get lifetime access to the Learning Management System (LMS). Class recordings and presentations can be viewed online from the LMS.
  • 24 x 7 Expert Support

    We have 24x7 online support team available to help you with any technical queries you may have during the course.
  • Certification

    Towards the end of the course, you will be working on a project. Covalent certifies you as an course Expert based on the project.

Course Curriculum

Download
  • SAS BI Course Content

    SAS Base & Advanced Course:- 

    • Getting Started with SAS
    • Working with SAS syntax
    • Getting Familiar with SAS dataset
    • Reading SAS datasets
    • Reading SAS datasets
    • Reading Excel worksheets
    • Reading Delimited Raw data files
    • Validating and cleaning data
    • Manipulating data
    • Combining SAS Datasets
    • Enhancing Report (ODS systems)
    • Summary Reports
    • Controlling Input and Output
    • Summarizing Data
    • Reading Raw Data Files
    • Data Transformations
    • Processing Data iteratively
    • Restructuring a Data set
    • TRANSPOSE Procedure

    SQL Procedure:

    • Introduction to SQL procedure
    • Basic Queries
    • Displaying Query Results
    • Sub queries
    • SQL Joins
    • Set Operators
    • Creating Tables and views
    • Interfacing SQL with Macro Language
    • Managing Tables
    • Use of SQL in Clinical Trials

    Macro language (SAS Macro)

    • Macro Variables
    • Macro definitions
    • Data Step and SQL Procedure
    • Macro Programs
    • Use of Macro language in Clinical Research

    SAS Enterprise Guide

    • Introduction
    • Reading Data from Files
    • Creating Reports
    • Working with Data in the Query Builder
    • Joining Two Data Files Together

     

    Free sessions :

    SQL

    EXCELL

     

    SAS BI: 

    Prepare Data:

    • Your data may be in a relational database (Oracle, Teradata, MySQL, etc.). The data is then placed in OLAP cubes, information maps, or in some cases a SAS dataset so it can be viewed in the BI toolset.
    • Some users create their extract transform load (ETL) process in SAS Data Integration (DI) Studio, which is another SAS product.

    SAS OLAP Cube Studio 

    • Build OLAP cubes, which are based on MDX code. OLAP cubes allow summarization of huge datasets so users can quickly view and drill-down to desired information. This post contains an overview of building a cube in SAS OLAP Studio.

    SAS Information Map Studio 

    • Build information maps from RDBMS (Oracle, Teradata, and DB2), SAS datasets and OLAP cubes. Information maps allow you to join data, rename variables, and set the data into business friendly view. 

    Display and Use Data: 

    Once your data is prepared it can be accessed in various ways.

    • SAS Web Report Studio
    • Create reports from OLAP Cubes, Info Maps, or SAS datasets. Simple, easy to use interface that allows end-users to quickly review reports and drill-down to other reports. 

    SAS Add-In for Microsoft Office

    • In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets. Mix SAS data with the data from Excel spread sheets.
    • In MS Office/PowerPoint – create reports from cubes, information maps, or datasets. Not as much flexibility as with MS Excel, but you can easily create report that you can share with other applications.
    • Possible to create data in MS Excel that you can save to the server and then use in other BI Tools. This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure. 

    SAS BI Dashboard

    • Use the summarized data to create dials, maps, and even moving indicators. 

    SAS Information Delivery Portal 

    • Combine all your Web Report Studio reporting, stored processes, and publication channels, and even external web sites in one location. The portal allows a jumping off point. 

     

    Helpers:

    • SAS Enterprise Guide 
    • Connect to SAS datasets, RDBMS, and even Excel spread sheets. Create stored processes to use and display data.
    • Create reports and more from OLAP Cubes, Info Maps, or SAS datasets.
    • Also create reports that can be shared as a stored process for the other SAS tools.
    • SAS Prompt Framework
    • Used with stored processes and with SAS Enterprise Guide. Prompts allow you to prompt or ask questions of the users and return data based on the choices
    • SAS Stored Processes
    • Write SAS programs that can move data around, create reports, or just ensure prompts are available in information maps.

     

    Administration:

    • SAS Management Console 
    • Allows you to administer the system and control data access.

Projects

  • SAS BI Projects

    SAS BI Real Time Projects

FAQ's

  • Can I attend a demo session before enrollment?

    Yes

  • What if I miss a class ?

    If you miss a class we can provide recording video for particular session and same session you have to attend another batch also

  • Will I get placement Assistance ?

    Yes

  • Do I receive a certificate for training ?

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.
  • what support is available after the training?

    Doubts clarification up to getting a job

    Resume preparation

    Malk interviews

    Placement Assistance

  • What Features do you provide?

    • Led sessions with corporate trainers
    • Course Material
    • Real time projects with industry experts
    • Day wise Assignments (Tasks)
    • Lab facilities
    • Placement assistance
    • Resume preparation
    • Software installation
    • Doubts  clarifications

Certifications

  • Course Completion Certificate

    • Once you are successfully through the course you will be awarded with Covalent's Training certificate.
    • Covalent certification has industry recognition and we are the preferred training partner for many MNCs.

Videos

SAS BI Demo video first class
SAS BI Demo video second class

Reviews

Rishikesh

SAS Developer

Hi Friends, I have taken SAS BI Real Time Training in Covalent Technologies. They have given with real time project which is more helpful for us. Faculty and Management helped a lot. They also helped me to upload the resume in naukri and also explained how to face interviews. They also conducted mock interviews.Thank you Covalent Technologies.

readmore...

Enroll Now

© 2018 Covalent Technologies All rights reserved

Drop us a Query

Drop us a Query

Call us on

IN: 91-9848733309
IN: +91-9676828080