SAS BI

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.
• 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

• 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.