SAS BI Online Training
0 STUDENTS ENROLLED
SAS BI Course Content
1.Data Integration Studio
- Using SAS Data Integration Studio
- SAS Data Integration Studio Overview
- The SAS Data Integration Studio Interface
- Adding Library Definitions
- Using the Source Designer
- Using the Target Designer
- Using the Process Designer
- Exercises
- Explain and work on the Extract and Summary Statistics transformation.
- Explain and work on the Loop transformations.
- Investigate where status handling is available.
- Explain and work on the Data Validation transformation.
- Explain and work on the Rank, Transpose, Append, List and Sort transformations.
- Explain and work on the Apply Lookup Standardization transformation.
- Define the Concept of a Checkpoint.
- Describe features of the New Tables wizard.
- Explain SAS packages.
- Explain importing and exporting of relational metadata.
- Explain components of SQL Join’s Designer window.
- Investigate mapping and propagation.
- Work with performance statistics.
- Generate reports on metadata for tables and jobs.
- Define Impact and Reverse Impact Analysis.
- Explain reasons to use the Table Loader transformation.
- Explain various load styles provided by the Table Loader transformation.
- Explain various types of keys and how to define in SAS Data Integration Studio.
- Explain indexes and how to define in SAS Data Integration Studio.
- Explain Table Loader options for keys and indexes.
- List the functions of the SCD Type 2 transformation.
- Work on business keys, surrogate and retained keys.
- Detect and track changes.
- Explain the Lookup transformation
- Explain the types of job deployment available for SAS Data Integration Studio Jobs.
- Provide an overview of the scheduling process.
- Explain the types of scheduling servers.
- Explain the Schedule Manager in SAS Management Console.
- List the applications that can be used to create and execute stored processes.
- Describe deployment of SAS Data Integration Studio jobs as a SAS Stored Process.
- Import SAS code.
2.Management Console
- Overview of the SAS Management Console
- Introduction to the SAS Management Console
- How the SAS Management Console Works
- Introduction to the SAS Management Console Plug-Ins
- Working with the User Interface
3.Business User Reporting Applications
- Use the SAS Add-In for Microsoft Office.
- Use SAS Web Report Studio.
- Use SAS Information Delivery Portal.
4.Advanced Reporting Techniques and Roles
- Modify an existing SAS Information Map.
- Create a New SAS BI Dashboard Indicator.
- Create data sources for reporting and analysis.
- Interpret permissions and file structures defined in metadata by the platform administrator.
5.Creating Information Maps
- Utilize different data sources.
- Use filters and the prompting framework to dynamically subset data.
- Create profilers to subset the information map data.
6.Building a SAS BI Dashboard Application
- Build SAS BI Dashboard Components.
- Build advanced SAS BI Dashboard Components.
7.Building Stored Processes
- Create a stored process from a SAS Enterprise Guide Project.
- Create a stored process from a SAS Program.
- Add prompts to a stored process.
- Create a stored process to provide a dynamic data source.
- Define the macro variables generated for each prompt type.7
8.Utilizing Advanced Techniques with SAS Reports
- Build advanced reports with SAS Web Report Studio.
- Create and use SAS report templates.
- Link reports in SAS Web Report Studio.
- Schedule and distributing SAS Reports.
- Build SAS reports with SAS Enterprise Guide.
- Create shared prompts.
9.Utilizing Multidimensional (OLAP) Data Sources
- Apply Online Analytical Processing concepts.
- Build an OLAP cube with SAS OLAP Cube Studio.
- Build an information map from a SAS OLAP Cube.
- Working with SAS OLAP Cubes Derived from Star Schemas
- Creating an OLAP Cube from a Star Schema
Course Reviews
No Reviews found for this course.
Write a Review