Education
Education is an integral part of PROPHIX's overall implementation framework. Ensuring superior knowledge transfer to facilitate client ownership over the financial process is paramount to ensuring your long-term success. To provide this service, each educational session is personalized, with only members from your organization in attendance.
PROPHIX for SQL Server: Administrator Training Agenda
Course Objective: The PROPHIX Administrator is a three (3) day course. The course objective is to demonstrate and teach all administrative and end-user functionality of PROPHIX. The course is designed to be entirely interactive with every function of PROPHIX having a hands-on component. Any person completing this course and retaining the knowledge will be a PROPIX Administrator. A detailed course agenda can be seen below.
Delivery Method:
Group-Live
Prerequisite:
No prerequisite or advance preparation required.
Pre-course readings:
- P4SS 5.1 User Manual
- PROPHIX for SQL Server Architecture Overview
- P4SS Installation and Configuration Guide
- Modeling Currency
Course Level: Basic
24 CPE Credits
DAY 1:
Introduction and Overview
PROPHIX for SQL Server Training
1) New Model Wizard:
- Creating and defining cubes
- Shared/private dimensions
- Time Definitions
- Parent-Child vs. Level-based dimensions
2) Model Manager
- Adding/deleting dimension members
- Creating named sets
- Member properties
- Creating calculated versions
- Account formulas and attributes
- Cross-dimensional calculations via MDX
3) Data Connectors
- Creating connections to ODBC/SQL/text sources
- Creating relational data views
4) Process Manager
- Importing dimensions
- Importing data
- Processing cubes
- Data transformation processes
- Allocations
5) Document Explorer navigation
6) Practice and reinforcement of learning concepts
DAY 2
1) OLAP data analysis:
- OLAP navigation
- Understanding dynamic members
- Creating data views
2) Template Designer:
- Formatting budgeting templates and reports
- Charting
- Dimensional groupings
- Read/Write templates
3) Report Binders:
- Importing Word/Excel documents
- Creating report binders
- Report distribution
4) Practice and reinforcement of learning concepts
DAY 3
1) Security Manager:
- Creating groups/roles
- Assigning read/write access to data cubes
2) Workflow Manager:
- Workflow explained
- Creating workflow projects, activities & tasks
- Workflow process exercise
3) Installation and database configuration
4) PROPHIX Administration Console:
- Creating OLAP Connection
- Setting Admin users
- Process Manager Service
- Email settings
- Import share setting
5) Practice and reinforcement of learning concepts
Proposed dates for 2010
May 24-26 (Monday-Wednesday)
June 21-23 (Monday-Wednesday)
July 26-28 (Monday-Wednesday)
August 23-25 (Monday-Wednesday)
September 27-29 (Monday-Wednesday)
October 25-27 (Monday-Wednesday)
November 22-24 (Monday-Wednesday)
Locations:
Toronto
Chicago
Los Angeles
Registration and Information:
Please contact Eric X.V. Nguyen
Director Educational Services
Email: enguyen@prophix.com
Phone: (905) 279-8711 x.273
For more information regarding administrative policies such as complaint and refund, please contact Eric X.V. Nguyen at 905-279-8711 x.273
PROPHIX Software is registered with National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be addressed to the National Registry of CPE Sponsors, 150 Fourth Avenue North, Suite 700, Nashville, TN, 37219-2417
READ MORE
- Case Studies
- Read how other companies are successfully using PROPHIX to enhance their business and improve efficiency
- ERP Interfaces
- PROPHIX interfaces seamlessly into hundreds of ERP systems
- PROPHIX Solutions Overview
- At a glance view of the award-winning PROPHIX Solutions


