4.8

Description

Tekslate’s SAS BI training will help you master the advanced analytics and reporting features using SAS Business Intelligence platform. It provides in-detailed knowledge on how to use SAS OLAP Cube Studio, SAS BI Management Console, SAS Data Integration, SAS Web Report Studio, etc. You will also get an opportunity to work on two real-time SAS BI projects under the guidance of a certified and professional trainer which will help in clearing the SAS BI Certification Exam.

Key Features

  • 30 hours of Instructor Led SAS BI Training
  • Lifetime Access to Recorded Sessions
  • Practical Approach
  • 24/7 Support
  • Expert & Certified Trainers
  • Real World use cases and Scenarios
Trusted By Companies Worldwide

Course Overview

After the successful completion of SAS BI training at Tekslate, the participant will be able to

  • Design and develop a Data Mart in SAS BI.

  • Build a SAS BI Dashboard application.

  • Build an OLAP Cube in SAS BI.

  • Get an overview of SAS BI management console, and SAS data integration.

  • Gain knowledge of Business User reporting applications, Advanced reporting techniques, and roles.

  • Utilize multidimensional (OLAP) data sources.

  • Currently, there are numerous job opportunities available for SAS BI developers around the world.

  • There is a high market demand for Certified SAS BI Developers and they are being offered with high salary packages.

  • On average, a Certified SAS BI developer earns 106,095 USD per annum.

The following job roles will get benefited from learning this course:

  • Administrators

  • Business Intelligence Professionals

  • Project Managers

  • Project Architects

  • Software Developers

  • Aspirants looking for a career in this field.

 

There are no specific prerequisites for learning SAS BI course. Anyone who is interested in learning this course can join this training.

We will provide two real-time projects under the guidance of a professional trainer, who will explain you on how to acquire in-depth knowledge on all the concepts involved in these projects.

Course Curriculum

 

SAS Enterprise Guide

SAS Data Integration Studio (ETL)

SAS Management Console

SAS Web Report Studio

SAS OLAP Cube Studio

SAS Add-In for Microsoft Office

SAS Information Map Studio

SAS stored process

 

What Is Business Intelligence?

Navigating in SAS BI Data Integration Studio

Working under Change Management

What Is Change Management?

Repository Types in SAS BI

Using Change Management

Planning a Data Warehouse, Exercises

 

Review of the Case Study

Define the Source Data

What are the Target Tables in SAS BI

Load the Target Tables

Exercises

 

What Is OLAP

Building an OLAP Cube in SAS BI

Solutions to Exercises

 

Defining Slowly Changing Dimensions in SAS BI

How to use SAS BI SCD Type 2 Loader Transformation

Using the Fact Table Lookup Transformation

Scheduling SAS Data Integration Studio Jobs

 

SAS and Data Quality

SAS BI Data Validation Transformation

Apply Lookup Standardization Transformation (Self-Study)

Create Match Code Transformation (Self-Study)

Administering SAS® BI Data Integration Studio

Setup Tasks for SAS® BI Data Integration Studio

 

Introduction to the SAS® Enterprise Intelligence Platform

SAS BI Overview

Who are SAS Business Intelligence Information Consumers

 

Introduction to OLAP Cubes

Introduction to Online Analytical Processing

Overview of SAS OLAP Cube Studio

Registering Metadata

Exercises

 

Working with SAS OLAP Cubes Derived from Detail Tables

Creating a SAS OLAP Cube from a Detail Table

Generating Aggregations in SAS BI cube Using Cross-Dimensional Tuning

Setting Permissions Using SAS Management Console

Viewing a SAS OLAP Cube with SAS Enterprise Guide

Exercises

 

Working with SAS OLAP Cubes Derived from Star Schemas

Creating a SAS  OLAP Cube from a Star Schema

Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java

Solutions to Exercises

 

Monitoring and Tuning a SAS OLAP Cube

Building an Information Map from a SAS OLAP Cube

Creating a Report with SAS Web Report Studio

Exercises

Appendix A Working with SAS OLAP Cubes Derived from Summary Tables

Creating a SAS OLAP Cube from a Summary Table

Viewing a SAS OLAP Cube with Microsoft Excel

Appendix B SAS®9 Business Intelligence Training

SAS BI Content Developer

 

Introduction

SAS BI Java Applications

SAS BI Windows Applications

SAS BI Web Browser Applications

 

Overview of the SAS Management Console

Introduction to the SAS BI Management Console

How the SAS BI Management Console Works

Introduction to the SAS BI Management Console Plug-Ins

Working with the User Interface

 

Using SAS Data Integration Studio

SAS Data Integration Studio Overview

SAS Data Integration Studio Interface

Adding Library Definitions

Using the Source Designer

Using the Target Designer

Using the Process Designer

Exercises

 

Using SAS OLAP Cube Studio

Overview of SAS OLAP Cube Studio

SAS OLAP Cube Studio Interface

 

Using the SAS BI Add-In for Microsoft Office

Overview of the SAS BI Add-In for Microsoft Office

Using the SAS BI Add-In for Microsoft Office Exercises

 

Using SAS Enterprise Guide

Investigating the Features of SAS Enterprise Guide

Exploring SAS Enterprise Guide

 

Using SAS Information Map Studio

Overview of the SAS Information Map Studio

Using SAS Information Map Studio

Exercises

 

Using SAS Web Report Studio

Overview of SAS Web Report Studio

Using SAS Web Report Studio

Exercises

FAQ's

We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth. 

We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.

Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.

We provide all the training sessions LIVE using either GoToMeeting or WebEx, thus promoting one-on-one trainer student Interaction.

Live training uncovers distinct benefits as they are mighty to reach your desired audience converting your prospects into customers in less time. Pre-recorded videos offer plenty of advantages for entrepreneurs to educate entertain and inspire your audience as long as you want.

You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.

Yes. We provide the course materials available after course completion.

There exist some discounts for weekend batches and group participants if the joiners are more than 2.

If you are enrolled in classes and have paid fees but want to cancel the registration for any reason, we will attain you in 48 hours will be processed within 30 days of prior request.

Certifications

SAS BI Certification Exam assesses the candidate’s knowledge and technical skills for working in a business analytics platform and also helps to acquire a better job in his/her career.

The Popular SAS BI Certification Exams available are listed below:

SAS® Certified BI Content Developer for SAS®9

SAS® Certified Visual Business Analyst

Tekslate helps you with required training, proper guidance, and makes you work on projects and assignments which include major applications of SAS BI in real-world industries.

Through this, you will be able to clear your SAS BI Certification Exam in your first submit itself.