Bundle Course - SAS BI / Data Integration Studio and SAS Admin
Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate
Uplatz
Summary
- Uplatz Certificate of Completion - Free
Add to basket or enquire
Overview
Uplatz offers this comprehensive bundle course on SAS BI and Data Integration Studio and SAS Admin consisting of a combo of video courses on all topics that are associated with SAS BI-DS and SAS Administration. You will be awarded Course Completion Certificate at the end of the course.
SAS Business Intelligence (BI) is a broad category of application programs and technologies for gathering, storing and, analyzing. SAS is a leader in business analytics. SAS transforms data into insight which can give a fresh perspective on business.
It is software suite which allows you to perform advanced analysis, Business Intelligence, Predictive Analysis, data management to operate effectively in the competitive.
The term Business Intelligence refers collective of tools and techniques used for the collection, integration, analysis and, visualization of raw data.
SAS ADMIN, for IT admin to keep the SAS server hardware and Oss going and for SAS administrators to stick to the SAS software. The essential knowledge to perform the job functions of SAS platform administrator.
The skills and knowledge for the administration of the platform
- To Secure the SAS configuration on each server machine
- Monitor server activity and administer logging
- Establish formal, regularly scheduled backup processes
- Administer repositories and move metadata
- Monitor, log and troubleshoot SAS servers
The SAS BI and SAS Admin course by Uplatz is a complete end-to-end course covering all topics.
Course media
Resources
- Bundle Course - SAS BI and SAS Admin - Course Syllabus - download
Description
BUNDLE COURSE SAS BI (Business Intelligence) AND SAS ADMIN – Course Syllabus
Introduction to 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 types
- Using change management
Designing the Course Data Mart
- 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
- Securing The SAS Configuration
- Secure a SAS platform configuration
- Checking The Status And Operation Of SAS Servers
- Manage metadata repositories
- Identify the properties and functionality of SAS servers
- Configure a SAS Metadata server cluster
- Monitoring, Logging, And Troubleshooting SAS Servers
- Monitor SAS servers
- Administer SAS server logging and modify logging configurations
- Troubleshoot basic SAS server issues
- Backing Up The SAS Environment
- Back up the SAS environment
- Restore the SAS environment
- Administering Users
- Manage connection profiles
- Manage roles
- Register users and groups in the metadata
- Give users access to processing servers and data servers
- Determine when to store passwords in the metadata
- Administering Data Access
- Register libraries and tables in the metadata
- Update table metadata
- Pre-assign a library
- Troubleshoot data access problems
- Use the metadata LIBNAME engine
- Managing Metadata
- Identify how the metadata authorization layer interacts with other security layers
- Identify where, how, and to whom metadata permissions are assigned
- Determine the outcome of metadata authorization decisions
- Use metadata permissions to secure metadata
- Create and use Access Control Templates
- Promote metadata and associated content
Key Topics covered in this course include:
Reviewing the Platform for SAS Business Analytics
- Exploring the platform for SAS
- Business Analytics overview
- Exploring the client tier, middle tier, server tier, and data tier
Administering the SAS Environment
- Overview of administration tasks
Determining the State of the SAS Environment
- Checking the state of SAS servers
- Exploring the metadata server and repositories
- Troubleshooting the metadata server
Monitoring, Logging, and Troubleshooting SAS Servers
- Identifying different types of SAS servers
- Monitoring SAS servers and spawners
- Logging SAS servers and spawners
- Troubleshooting SAS servers
Backing Up the SAS Environment
- Backing up metadata with the Backup Wizard
- Exploring OMABAKUP
- Scheduling backups
- Backing up physical files
Administering Client Applications
- Exploring connection profiles
- Using roles to control access to application
- Functionality
- Exploring SAS folders
Administering Users
- Defining regular users and groups
- Defining administrative users
- Giving users access to servers
Administering Data Access
- Registering libraries
- Tables in the metadata
- Updating table metadata
- Pre-assigning libraries
- Troubleshooting data access
Securing Metadata
- Introduction to metadata security
- Exploring metadata permission
- Exploring predefined ACTs
- Securing content in the folder tree
- Securing content outside the folder tree
- Creating additional ACTs
Moving Metadata
- Replicating an entire repository
- Promoting selected content
Updating the SAS Environment
- Applying hot fixes to the SAS environment
Who is this course for?
Everyone
Requirements
Passion and determination to achieve your goals!
Career path
- Analyst
- Sr. Analyst
- Data Analyst/Consultant
- Data Scientist
- Analytical Manager
- Business Intelligence Architect
- ETL Engineers
- Database Engineers
- Reporting Analysts
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Uplatz Certificate of Completion
Digital certificate - Included
Course Completion Certificate by Uplatz
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
