• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
Job Meter = High

SAS BI (Business Intelligence)

15 Hours
Self-paced Training (pre-recorded videos)
USD 17 (USD 140)
Save 88% Offer ends on 30-Jun-2024
SAS BI (Business Intelligence) course and certification
185 Learners

About this Course
SAS Business Intelligence & Analytics is a software by SAS that provides analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization.

SAS Business Intelligence is a cloud-based enterprise analysis tool that helps users monitor metrics and manage interactive reports. Designed for large businesses, the platform's features include customizable dashboard, marketing reports, forecasting, data source connectors, ad-hoc analysis and more.

SAS BI features help improve key processes and data, as well as identify and monitor trends in corporate, competitor market performance and improving quality of data. SAS BI consists 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.

SAS Business Intelligence is a cloud-based enterprise analysis tool that helps users monitor metrics and manage interactive reports. Designed for large businesses, the platform’s features include customizable dashboard, marketing reports, forecasting, data source connectors, ad-hoc analysis and more. SAS Business Intelligence comes with additional features such as statistical simulation, association discovery, web services, multiple data sources, metadata management and more. Support is extended via documentation, phone and email and pricing is available on request.

SAS Business Intelligence’s data visualization module enables users to perform automated analysis and create interactive visuals facilitating business performance. It lets teams spot corrections and make improvements based on risk assessments. Additionally, the solution’s collaboration module helps multiple users work on the same project through Microsoft Office applications such as Outlook, Powerpoint and Excel. Additionally, the product enables businesses to build report charts/graphs and enhance business knowledge and productivity across processes.

In general, Business intelligence or BI is a set of processes, strategies, solutions, technologies, and systems for data collection, analysis and management. It aims to generate business insights that aid in executive decisions and strategic planning.

In essence, SAS BI is a set of enterprise business intelligence tools developed by SAS (apps for small and midsize businesses are available). These tools are further segregated into specific purposes, such as: fraud & security intelligence, supply chain intelligence, customer intelligence, decision management, data management and risk management.

Business intelligence in SAS products are also packaged by industry, such as for automotive, banking, consumer goods, defense & security, healthcare and utilities.

The SAS Intelligence Platform is comprised of the following software packages:
a) SAS BI Server
b) SAS Enterprise BI Server
c) SAS Data Integration Server
d) SAS Enterprise Data Integration Server
e) SAS Intelligence Storage

Business intelligence in SAS comes in many forms and bundled by product or solution. Likewise, SAS packages vertical BI tools for different industries. The main business intelligence and analytics features include:

  • Visual Data Exploration

  • Easy Analytics

  • Interactive Reporting & Dashboards

  • Collaboration

  • Mobile Apps

----------------------------------------------------------------------------------------------------------------

Uplatz provides this comprehensive training on SAS Business Intelligence with focus on practical implementation of SAS BI. This SAS BI training provides a comprehensive, hands-on overview of the platform for SAS Business Analytics applications, including the Integration applications.

Learn how to access, analyze, and report on different types of data using Microsoft Office products and SAS. Participant will Also learn how to view dashboards and analyze information using a web-based portal interface,view and build reports from a Web browser, understand the basics of the data preparation and system administration functions.

This SAS BI training provides in-depth demonstration of how to access and build reports as well as analyze data using several of the information consumer applications in the platform for SAS Business Analytics. The participants will also learn how to identify types of reports create and share reporting presentations, interact with multidimensional data, access SAS data sources, and work with SAS analyses.

Master SAS BI & Analytics suite with deep insights into SAS Enterprise Guide, SAS Visual Analytics, SAS Office Analytics.

----------------------------------------------------------------------------------------------------------------


Course Objectives

·       Prepare for SAS BI Certification Exam
·       Understanding SAS Business Intelligence & Analytics
·       SAS Enterprise Guide
·       SAS Management Console
·       SAS Data Integration Studio and Data Quality
·       SAS Web Report Studio and SAS BI OLAP Cube Studio
·       SAS Add-In for Microsoft Office
·       SAS Information Map Studio
·       SAS Stored Process
·       SAS BI Content Developer
·       Repository Types in SAS BI
·       Designing & Building Data Mart and OLAP Cube in SAS BI
·       SAS BI Transformations
·       Job Scheduling
·       Building SAS Business Intelligence Applications

----------------------------------------------------------------------------------------------------------------

Target Audience

·       SAS Consultants & Analysts
·       Corporate Data & Analytics Managers
·       SAS Developers & SAS DI Developers
·       Beginners aspiring for a career in Business Intelligence & Analytics
·       SAS ETL Developers
·       Business Consultants & Analysts
·       Data Engineers & Data Scientists
·       Data Architects & DW-BI Professionals
·       Software Programmers
·       SAS Specialists & BI Developers
·       Anyone interested to learn SAS BI & Analytics solution


----------------------------------------------------------------------------------------------------------------

What Is SAS BI Business Intelligence & Analytics ?

SAS BI enables users to use dashboards to monitor key performance indicators that convey how well an organization is performing. Dashboards include graphics, text, colors, and links. 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 Enterprise BI Server and SAS BI Server are software offerings that each comprise a suite of products. These offerings serve as a platform for many SAS solutions, such as SAS Financial Intelligence.

SAS Business Intelligence suite's role is to integrate data spread all over the organization to allow business users to perform self-service reporting and analysis. It influences on the company performance directly - business users focus on what's most important to them (and - therefore - accelerate the time to decision), while IT departments reduce the time wasted on diverse collateral things which don't actually add any value to the company IT systems.

What it means in practice are multiple capabilities, including:

  • statistics,

  • predictive analytics,

  • data mining,

  • text mining,

  • and forecasting

----------------------------------------------------------------------------------------------------------------

SAS BI Components (Tools and Applications)

SAS Business Intelligence as a whole consists of the two separate elements - Enterprise Business Intelligence and Business Visualization. The first of them is responsible for ensuring that all the capabilities are enabled and easy to use. The second, though, may be considered an addition as it provides a powerful business visualization studio, allowing users to explore the ideas and information in a dynamic and interactive way.

  • SAS Enterprise Guide

  • SAS Data Integration Studio

  • SAS Management Console

  • SAS Web Report Studio

  • SAS OLAP cube Studio

  • SAS Add-in for Microsoft Office

  • SAS Information Map Studio

  • SAS Stored Processes


----------------------------------------------------------------------------------------------------------------

Key Features of SAS Business Intelligence & Analytics

  • easy to customize dashboards and portals

  • advanced business visualizations

  • reporting based on Web and "based on desktops"

  • analytics from outside the office (multiple mobile operating capabilities)

  • integration to Microsoft Office suite as well as to MS SharePoint

  • powerful query and analysis capabilities

  • an intuitive interface for OLAP data storage and exploration

  • advanced metadata management options

  • well flexible deployment capabilities

  • model development and analysis supported with guides and wizards

  • applications development

----------------------------------------------------------------------------------------------------------------


SAS also offers solutions with specific focus. These include:

  • Advanced analytics – features data mining, statistical analysis, forecasting, text analytics, optimization and simulation

  • Customer intelligence – features analytical marketing, customer journey optimization, real-time customer experience

  • Fraud & Security Intelligence – features fraud improper and improper payments, regulatory compliance, public security, cybersecurity

  • Data management – data integration & access, data quality, data preparation for Hadoop, data governance & MDM, event stream processing

  • Decision management – authoring environment, multiple environments, impact analysis, data integration with other SAS systems

  • Personal data protection – single data interface, big data integration, access to audit, risk, monitor reports

  • Risk management – features regulatory risk management, enterprise stress testing, credit risk management, governance & compliance, insurance risk management

  • Solutions for Hadoop – integrates with Hadoop for big data analytics including data scoring, predictive analysis and data visualization

  • Small and midsize business – features scalable and budget-customized plans for small and medium companies

  • Supply chain intelligence – features supply & demand planning, product & process quality, aftermarket service

----------------------------------------------------------------------------------------------------------------

Benefits of SAS BI

  • Apply data-driven information to strategic planning including for supply management, operational processes, forecasting and business development

  • See the big picture of key performance metrics to gauge business health

  • Mine and process data in real time for day-to-day operational insights

  • Discover insights, bottlenecks, inefficiencies and address them

  • Highlight patterns and dimensions to market trends and customer behavior

  • Anticipate, prevent or manage risks

  • Identify fraudulent patterns, track transactional trails and security risks

  • Present visual reports that are digestible to various audience

  • Work closely with other teams using centralized data source, collaboration platform and shared tools

  • Scale features from small business BI tools to enterprise systems

----------------------------------------------------------------------------------------------------------------

SAS Business Intelligence Tools

Business intelligence in SAS are packaged for specific uses and target users. Here are the SAS products in the market today:

  • SAS/STAT – designed for specialized and organizational-wide statistical analysis

  • SAS Analytics Pro – combines SAS, SAS/STAT and SAS/GRAPH features

  • SAS Curriculum Pathways – targets educators and students for K-12 and up

  • SAS Customer Intelligence 360 – features a unified platform for market and customer analysis and powered by predictive analytics

  • SAS Cloud Analytics – cloud-deployed, on-demand access to SAS features

  • SAS Data Management – integrates and manages your various data sources

  • SAS Enterprise Miner – automates operational decision processes with tracking and sharing tools

  • SAS Grid Manager – manages your grid computing environment for efficient processing and workload balance

  • SAS Visual Analytics – features self-service analytics, visual data discovery and interactive reporting

  • SAS Visual Statistics – generates predictive and descriptive models for insight discovery

  • Foundation Tools – provides the integrated infrastructure for SAS products

----------------------------------------------------------------------------------------------------------------

SAS BI (Business Intelligence)

Course Details & Curriculum
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

 
SAS BI training aims to touch upon the following topics:
 
Base SAS
  • Navigate the SAS windowing environment

  • Read various types of data into SAS data sets

  • Validate and clean SAS data sets

  • Create SAS variables and subset data

  • Combine SAS data sets

  • Create and enhance listing and summary reports

  • Control SAS data set input and output

  • Combine SAS data sets

  • Summarize read and write different types of data

  • Perform DO loop and SAS array processing

  • Transform character numeric and date variables

 
Creating Business Intelligence using SAS Reports
  • Use several of the business user applications in the platform for SAS Business Analytics

  • Create and Exploit dynamic value selection

  • Build advanced information maps using SAS Information Map Studio

  • Create advanced SAS BI Dashboard applications

  • Produce advanced stored processes able to create dynamic data sources

  • Build Schedule and distribute advanced reports

  • Consolidate information into a business reporting application

  • Describe the online analytical processing capabilities available in the SAS platform

  • Explore the basic functionality of the SAS integration with JMP

  • Examine the types of metadata created in the SAS platform

 
Creating Business Intelligence for your Organization
  • Exploring the platform for SAS Business Analytics

  • introducing the course environment and scenario

 
Introducing the Business User Reporting Applications
  • Defining the business user role and reporting applications

  • Exploring the SAS Add In for Microsoft Office

  • Exploring the SAS Web Report Studio

  • Defining the interaction between the business user and the business analyst

 
Introducing Advanced Reporting Techniques and Roles
  • Defining the business analyst role and applications

  • Modifying an existing information map

  • Creating a new SAS BI Dashboard indicator

  • Creating data sources for reporting and analysis

  • Defining the interaction between the business analyst and the paltform administrator

  • Understanding SAS Data Integration capabilities

 
Creating an Information Map
  • Understanding SAS Information Maps

  • utilizing different data sources

  • Exploiting dynamic subsetting of data

  • Creating prefilters to subset the information map

  • Using the Information Map LIBNAME Engine

  • Creating information maps programmatically self-study

 
Building a SAS BI Dashboard Application
  • Understanding SAS BI Dashboard

  • Building the SAS BI Dashboard components

  • Building advanced SAS BI Dashboard components

 
Building Stored Processes
  • Understanding SAS Stored Process concepts

  • Creating a stored process from a SAS Enterprise Guide project

  • Creating a stored process from a SAS program

  • Creating stored process parameters

  • Creating a stored process to provide a dynamic data source

 
Utilizing Advanced Techniques with SAS Reports
  • Building advanced reports with SAS Web Report Studio

  • Creating and using SAS report templates

  • Linking reports in SAS Web Report Studio

  • Scheduling and distributing SAS Reports

  • Building SAS Reports with SAS Enterprise Guide

  • Creating Shared Prompts

 
Consolidating Information into a Business Reporting Application
  • Creating the business reporting application

 
Introducing Multidimensional Data Sources
  • Understanding online analytical processing concepts

  • Building an OLAP cube with SAS OLAP Cube Studio

  • Building an information map from a SAS OLAP cube

 
Introducing SAS Visual BI
  • Introduction to SAS Visual BI

  • Exploring the SAS integration with JMP

 
Examining the Environment Metadata
  • Reviewing the platform for SAS Business Analytics

  • Reviewing the course environment

----------------------------------------------------------------------------------------------------------------
Certification
SAS Certified BI Content Developer for SAS 9 (A00-270) Certification

The official SAS BI certification exam is SAS Certified BI Content Developer for SAS 9 (A00-270) Certification exam.

The SAS Certified BI Content Developer for SAS 9 credential is globally recognized for validating SAS BI Content Developer knowledge. With the SAS Certified BI Content Developer Certification credential, you stand out in a crowd and prove that you have the SAS BI Content Developer knowledge to make a difference within your organization. The SAS Certified BI Content Developer for SAS 9 Certification (A00-270) exam will test the candidate's knowledge on following areas.

 

SAS A00-270 Exam Summary:

  • Exam Name: SAS Certified BI Content Developer for SAS 9

  • Exam Code: A00-270

  • Exam Duration: 120 minutes

  • Exam Questions: 60-65 multiple-choice and short-answer questions

  • Passing Score: 70%

  • Negative Marking: No

  • Exam Price: $180 (USD)

 

SAS A00-270 Exam Topics:

  • Information Consumer Reporting Applications

  • Data Management

  • Creating Information Maps

  • Building a SAS BI Dashboard Application

  • Building Stored Processes

  • Utilizing Multidimensional (OLAP) Data Sources

 

----------------------------------------------------------------------------------------------------------------



Didn't find what you are looking for?  Contact Us