SAS BI (Business Intelligence)

Uplatz offers this comprehensive training on SAS BI (Business Intelligence). This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the 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 business analysis tool that allows users to monitor metrics and manage interactive reports. The platform is designed for large enterprises and includes custom dashboards, marketing reports, forecasts, data source connectors, ad hoc analytics 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.

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.

Participants 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.

Certificate of completion

Digital certificate - Included

Certificate of completion

Digital certificate - Included

• SAS BI - Course Syllabus - download

SAS Business Intelligence & Analytics 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 and Data Quality

• 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

• Create and enhance listing and summary reports

• 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

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

Creating an Information Map

• Understanding SAS Information Maps

• 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

Everyone

Passion and determination to achieve your goals!

• SAS Consultant BI
• SAS Developer BI
• SAS Consultant & Analyst
• Corporate Data & Analytics Manager
• SAS Developer
• SAS ETL Developers
• Business Consultant & Analyst
• Data Engineer & Data Scientist
• Data Architect & DW-BI Professional
• Software Programmer
• SAS Specialist & BI Developer

Currently there are no Q&As for this course. Be the first to ask a question.