ArchiTech IT

Course information

SAS BI ONLINE TRAINING: LEO SOFT IT 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

SAS Enterprise Business Intelligence (BI) is a suite of applications that allows you to prepare and display data. Here is a quick overview to help you learn the SAS BI product names and purposes

Dashboards are created, maintained, and viewed through an easy-to-use Web-based interface, such as the SAS Information Delivery Portal. All content is displayed in a role-based, secure, customizable, and extensible environment. SAS BI Dashboard is part of the SAS software offering, SAS® Enterprise BI Server.

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

The SAS system. SAS stands for the Statistical Analysis System, a software system for data analysis and report writing. SAS is a group of computer programs that work together to store data values and retrieve them, modify data, compute simple and complex statistical analyses, and create reports.

Overview:
SAS BI (Business intelligence) has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help improve key processes and data, as well as identify and monitor trends in corporate, competitor market performance and improving quality of data.
Training Objectives of SAS BI:
The main objectives of the SAS BI is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data to help enterprise users make better business decisions. It consumes less time for responding requests and for business users to view the information. It is an integrated, flexible and robust presentation layer for SAS Analytics with full breadth is also offered by SAS BI. All these are integrated within the context of business for better and quick decision making.
Target Students / Prerequisites:
Students must have technical Skills and some experience on Microsoft Word and Microsoft Excel. Student must know how to use a Web browser to access the information.
Overview of SAS 9 Enterprise Intelligence Platform and SAS Data Integration Studio
Business Intelligence overview
Business Intelligence Information Consumers
Navigating in SAS Data Integration Studio
Change Management
What is change management?
Repository 
Using change management
Designing the Course Data Martbr/> Planning a data warehouse
Building a Data Mart
Defining the source data
Defining the target tables
Loading the target tables
Creating Reports
Report Transformations
Using the Transformation Generator Wizard
SAS Data Integration Studio and stored -processes Transformations for Slowly Changing Dimensions
Defining slowly changing dimensions
Using the SCD Type 2 Loader transformation
Using the Fact Table Lookup transformation
Job Scheduling
Scheduling SAS Data Integration Studio jobs SAS Data Integration Studio and Data Quality
SAS and Data Quality
Using the Data Validation transformation
Using the Apply Lookup Standardization transformation
Using the Create Match Code transformation
SAS/Enterprise Guide
Introduction
Starting SAS Enterprise Guide
SAS Enterprise Guide windows
Basic elements of SAS Enterprise Guide
Entering data
Creating a list report
Producing a frequency report
Creating a scatter plot
Adding a note to the project
Saving the project
Reading Data from Files
Opening a SAS data set from your local computer
Opening a SAS data set stored in a SAS library
Opening a Microsoft Excel file
Creating Reports
Creating a simple report
Changing titles and footnotes
Changing column labels and formatting values
Defining your own formats
Creating a grouped report
Selecting a style for the report
Working with Data in the Query Builder
Opening the Query Builder
Selecting columns
Creating a new column
Ordering and removing columns
Filtering data
Sorting the data rows
Joining Two Data Files Together
Opening the two data files to be joined
Joining tables
Filtering the data
Modifying the type of join