SAS Business Intelligence Online Training Course:
SAS BI Overview:
SAS BI (Business intelligence) has analytic capabilities like statistics, forecasting,reporting, data mining, optimization and predictions. They help improve key processes and data analysis, as well as recognize and monitor trends in corporate, adversary market performance and improving quality of data.
SAS BI (Business intelligence) has analytic capabilities like statistics, forecasting,reporting, data mining, optimization and predictions. They help improve key processes and data analysis, as well as recognize and monitor trends in corporate, adversary market performance and improving quality of data.
Training Objectives of SAS BI:
The main purpose of the SAS BI is a wide range category of application programs and technologies for analysing,gathering, storing and providing access to data to helps corporate users make a better business decisions. It utilize less time for responding requests and for business users to view the information. It is an integrated, robust and flexible presentation layer for SAS Analytic s with complete scope and is offered by SAS BI. All these are cohesive within the context of business for quick and better decision making.
The main purpose of the SAS BI is a wide range category of application programs and technologies for analysing,gathering, storing and providing access to data to helps corporate users make a better business decisions. It utilize less time for responding requests and for business users to view the information. It is an integrated, robust and flexible presentation layer for SAS Analytic s with complete scope and is offered by SAS BI. All these are cohesive within the context of business for quick and better decision making.
SAS Bi Online Training Course Content:
Duration: 4-5 weeks
SAS BI Online Training
- SAS BI Tools & Applications
- 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 proess
SAS DI Content Developer
- Chapter 1 SAS9 Enterprise Intelligence Platform and SAS® Data Integration Studio 1-1
- What Is Business Intelligence?
- Navigating in SAS Data Integration Studio
- Chapter 2 Working under Change Management
- What Is Change Management?
- Repository Types
- Using Change Management
Designing the Course Data Mart
- Planning a Data Warehouse
- Exercises
Building a Data Mart
- Review of the Case Study
- Define the Source Data
- Define the Target Tables
- Load the Target Tables
- Exercises
Building an OLAP Cube
- What Is OLAP
- Building an OLAP Cube
- Solutions to Exercises
Transformations for Slowly Changing Dimensions (Self-Study)
- 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
- Data Validation Transformation
- Apply Lookup Standardization Transformation (Self-Study
- Create Match Code Transformation (Self-Study)
- Chapter 10 Administering SAS® Data Integration Studio
- Setup Tasks for SAS Data Integration Studio
SAS OLAP CUBE STUDIO 9.1
Chapter 1
Chapter 1
- Introduction to the SAS Enterprise Intelligence Platform
- SAS Business Intelligence Overview
- Business Intelligence Information Consumers
Chapter 2
- Introduction to OLAP Cubes
- Introduction to Online Analytical Processing
- Overview of SAS OLAP Cube Studio
- Registering Metadata
- Exercises
Chapter 3
- Working with SAS OLAP Cubes Derived from Detail Tables
- Creating a SAS OLAP Cube from a Detail Table
- Generating Aggregations Using Cross-Dimensional Tuning
- Setting Permissions Using SAS Management Console
- Viewing a SAS OLAP Cube with SAS Enterprise Guide
- Exercises
Chapter 4
- Working with SAS OLAP Cubes Derived from Star Schemas
- Creating an OLAP Cube from a Star Schema
- Viewing a SAS OLAP Cube with SAS Web OLAP Viewer for Java
- Solutions to Exercises
Chapter 5
- 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 SAS9 Business Intelligence Training
- SAS BI Content Developer
Chapter 6
- Overview of the SAS Business Intelligence Applications
- Introduction
- SAS BI Java Applications
- SAS BI Windows Applications
- SAS BI Web Browser Applications
Chapter 7
- Overview of the SAS Management Console
- Introduction to the SAS Management Console
- How the SAS Management Console Works
- Introduction to the SAS Management Console Plug-Ins
- Working with the User Interface
Chapter 8
- Using SAS Data Integration Studio
- SAS Data Integration Studio Overview
- The SAS Data Integration Studio Interface
- Adding Library Definitions
- Using the Source Designer
- Using the Target Designer
- Using the Process Designer
- Exercises
Chapter 9
- Using SAS OLAP Cube Studio
- Overview of SAS OLAP Cube Studio
- SAS OLAP Cube Studio Interface
Chapter 10
- Using the SAS Add-In for Microsoft Office
- Overview of the SAS Add-In for Microsoft Office
- Using the SAS Add-In for Microsoft Office
- Exercises
Chapter 11
- Using SAS Enterprise Guide
- Investigating the Features of SAS Enterprise Guide
- For Your Information v
- Exploring SAS Enterprise Guide
Chapter 12
- Using SAS Information Map Studio
- Overview of the SAS Information Map Studio
- Using SAS Information Map Studio
- Exercises
Chapter 13
- Using SAS Web Report Studio
- Overview of SAS Web Report Studio
- Using SAS Web Report Studio
- Exercise.
Contact Us:
PH: +(720)-463-3800
Resource: Online-training-sas.com
