Creating Business Intelligence for Your Organisation: Fast Track - SBAFT
This intensive training course provides accelerated learning for those learners who will build reports, analyses, and dashboards for consumption by business users and other information consumers in their organisation. This course is for individuals who are comfortable with learning large amounts of information in a short period of time. The Creating Business Intelligence for Your Organisation 1: Essentials and Creating Business Intelligence for Your Organisation 2: Additional Topics courses are available to provide the same type of information in a much more detailed approach over a longer period of time.
Duration
5 days -  Classroom |
Learn how to
- 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.
Who should attend
Business analysts
Prerequisites
No SAS experience or programming experience is required, although you should have some computer experience. Specifically, you should
- be able to log on and off a computer and use a keyboard or mouse
- have some experience using Microsoft Word and Microsoft Excel (specifically, you should be able to open and save documents, use the menus and toolbars to accomplish tasks, and navigate Word documents and Excel spreadsheets)
- know how to use a Web browser to access information.
Course Contents
Introduction
- 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 SAS Web Report Studio
- exploring the SAS Information Delivery Portal
- 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 platform administrator
- understanding SAS Data Integration capabilities
Creating an Information Map
- understanding SAS information maps
- utilising 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
Utilising Advanced Techiques 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
Learning More
- SAS resources
- beyond this course
Appendices
- advanced prompting considerations
- creating stored processes without using SAS Enterprise Guide
Software Addressed
This course addresses the following software product(s): Platform for SAS Business Analytics, SAS Information Map Studio.
