SAS Advanced Programming
process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects.
Description
As a SAS (Statistical Analysis System) programmer, you are an IT professional who focuses on data collection and analysis. SAS programmers aggregate data and manipulate it for the purpose of analyzing current projects and productivity, as well as predicting future trends and needs.
Did you know?
SAS (previously "Statistical Analysis System") is a statistical software suite developed by SAS Institute for data management, advanced analytics, multivariate analysis, business intelligence, criminal investigation, and predictive analytics.
Why learn MicroStrategy
MicroStrategy provides a single, cohesive offering that empowers both IT professionals and business users to fully harness the power of their data. MicroStrategy is the only analytics platform on the market that combines enterprise-grade performance, scalability, and security with easy-to-use interfaces and workflows.
Course Objective
SAS is not A programming language. The system uses many parts that might be considered languages, but it not really one language, rather more of a collection of interconnected tools.
How will I perform the practical sessions in Online training?
When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques.
MicroStrategy 9.3 Online Training
Introduction
- Business Intelligence
- OLAP
- Architecture of OLAP
- What are Different Types of OLAP’s
- Introduction of BI tools
- Database Overview
Introduction of MicroStrategy
- MicroStrategy Desktop
- MicroStrategy Architecture
- MicroStrategy Web
- MicroStrategy Servers
- Administration
- Folder Structure
- My Personal Objects
- Public Object
- Schema Object
- Metadata
- Report View
- Data – Export
- AutoStyles
- Custom Groups
- Facts
- Tables
- Update Schema
Lab Setup
- MicroStrategy: Installation
MicroStrategy Desktop: Reporting Essentials
- Introduction to MicroStrategy Business Intelligence
- Introduction to MicroStrategy Desktop
- Creating and Saving Reports in Desktop
- Report Manipulations in Desktop
- Data Manipulations
- Style Manipulations
- Creating and Saving Basic Report Filters
- Creating, Formatting and Saving Basic Metrics
- MicroStrategy OLAP Services in Desktop
- Report Objects
- View Filters
- Derived Metrics
- Creating and Saving Basic Prompts and Searches
MicroStrategy Desktop: Advanced Reporting
- Introduction to Advanced Reporting
- Advanced Metrics
- Advanced Filters
- Consolidations and Custom Groups
- Advanced Prompts
- Advanced OLAP services
- Drill Maps
- Report Data Options
- Report Developer Tools
>MicroStrategy Architect: Project Design
- Introduction to MicroStrategy Architect
- The Logical Data Model
- The physical Warehouse Schema
- Advanced Data Modeling and Schema Design
- Introduction to Project Creation in MicroStrategy Architect
- Creating MicroStrategy Facts
- Creating MicroStrategy Attributes
- Creating MicroStrategy Hierarchies
- Project configuration Workshop
>MicroStrategy Web
- Connect to MSTR Web
- Configure I-Server and Create Reports
- Create Objects (Filter, Prompts) using Web
MicroStrategy Report Services Documents
- Creating a Document using existing report
- Create Dashboards – Workshop
MicroStrategy Administrator
- Basic Administration tasks
- User Management
- Roles and Security Management, Project Access
- MicroStrategy Security Filters
Prepare for Certification
Our training and certification program gives you a solid understanding of the key topics covered on the Oreilly’s Python Certification. In addition to boosting your income potential, getting certified in Python demonstrates your knowledge of the skills necessary to be a successful Python Developer. The certification validates your ability to produce reliable, high-quality results with increased efficiency and consistency.