Course Details
SAS BI Course Overview
The Business Intelligence
(BI) components allow users with various needs and talent levels to create,
produce, and share their own reports and analysis. Through easy to-use
interfaces, users can obtain their own answers to business questions. In the
meantime, the information technology staff retains control over the quality and
consistency of the data.
SAS BI Course Content
1.)Business User Reporting Applications
- Use the SAS Add-In for Microsoft Office.
- Use SAS Web Report Studio.
- Use SAS Information Delivery Portal.
2.)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.
3.)Creating Information Maps
- Utilize different data sources.
- Use filters and the prompting framework to dynamically subset data.
- Create prefilters to subset the information map data.
4.)Building a SAS BI Dashboard Application
- Build SAS BI Dashboard Components.
- Build advanced SAS BI Dashboard Components.
5.)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
6.)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.
7.)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.
- The Environment Metadata
- Describe the metadata created and used by the SAS Platform.
