SAS Business Intelligence
About This Course
Introduction
SAS Business Intelligence Training
SAS Business Intelligence is a software suite of applications developed by the SAS Institute for business intelligence, predictive analysis, data management, multi vibrate analysis and advanced analytics. It allows to create, develop and display data. It consists of two different components- business virtualization and enterprise business intelligence. These two components are responsible for ensuring capabilities and powerful business visualization studio. It helps the user to explore new ideas and information in an interactive and dynamic way. It also boosts data consistency and streamlines the administration.
Course Objectives
What you’ll learn in SAS Business Intelligence Training Course?
- Learn and execute advanced reporting techniques.
- To create user-friendly business applications.
- SAS BI Application Dashboard creation.
- Learn about data and information, maps to build them.
- Learn to use the advanced methods with the help of SAS reports.
- Creation of stored processes.
- Using SAS Guide projects to execute the stored processes.
- Exploit data in Multidimensional ways.
- Creation of dynamic stored processes for the usage of users for elements.
What are the pre-requisites to learn SAS Business Intelligence Course?
Working Experience of Microsoft Office, Ability to Access Information from a Web Browser
Course Curriculum
Module 1: Overview Of Business Intelligence And Data Integration
Topics: Business Intelligence Overview, Navigating in SAS Data Integration Studio, Business Intelligence Information Consumers, Introduction to Change Management, Using Change Management, Repository Types
Module 2: Designing The Course Data Mart
Topics: Building a Data Mart, Planning a Data Warehouse, Defining the Target Tables, Defining the Source Data, Loading the Target Tables
Module 3: Creating Reports
Topics: Using the Transformation Generator Wizard, Report Transformations, Using the SCD Type 2 Loader Transformation, Defining Slowly Changing Dimensions, SAS Data Integration Studio and Stored, Using the Fact Table Lookup Transformation
Module 4: Job Scheduling
Topics: SAS Data Integration Studio and Data Quality, Scheduling SAS Data Integration Studio Jobs, Using the Data Validation Transformation, SAS and Data Quality, Practicing the Create Match Code Transformation, Using the Apply Lookup Standardization Transformation
Module 5: SAS Or Enterprise Guide
Topics: Introduction, SAS Enterprise Guide Windows, Starting SAS Enterprise Guide, Creating a List Report, Entering Data, Basic Elements of SAS Enterprise Guide, Creating a Scatter Plot, Producing a Frequency Report, Adding a Note to the Project, Saving the Project
Module 6: Reading Data From Files
Topics: Opening a SAS Data Set Stored in A SAS Library, Opening a SAS Data Set from Your Local Computer, Opening a Microsoft Excel File
Module 7: Creating Reports
Topics: Changing Titles and Footnotes, Creating A Simple Report, Defining Your own Formats, Changing Column Labels, Selecting a Style for the Report, Creating a Grouped Report, Changing Formatting Levels
Module 8: Working With Data In The Query Builder
Topics: Selecting Columns, Opening The Query Builder, Filtering Data, Ordering And Removing Columns, Creating A New Column, Sorting The Data Rows,
Module 9: Connecting Two Data Files Together
Topics: Joining Tables, Opening the Two Data Files to Be Connected, Modifying the Type of Join, Filtering the Data