Griffin-Schruers, incorporated |
|||
The following are examples of the topics covered in our various classes: |
|||
|
Impromptu: ·
Databases, SQL, Joins
·
List Reports - Wizard / Manual
·
Sorting ·
Grouping ·
Aggregation and Association ·
Calculations and Formulas ·
Filters ·
Prompts ·
Other templates: Crosstabs,
Charts, etc. ·
Frames / Objects ·
Nesting Objects ·
Conditional Formatting ·
Drill Through ·
Subreports Report Studio (ReportNet
1.1): ·
Packages / Cognos Connection ·
List Reports - Wizard / Manual ·
Sorting ·
Grouping ·
Sectioning ·
Aggregation and Association ·
Calculations and Formulas ·
Filters ·
Prompts ·
Crosstabs, Charts, etc. ·
Objects and Structure
·
Nesting Objects ·
Conditional Formatting ·
Drill Through Report Studio (C8)
Beginner/Intermediate with light touches to Advanced: ·
Packages / Cognos Connection ·
List Reports - Wizard / Manual
·
Sorting ·
Grouping ·
Sectioning ·
Aggregation and Association ·
Calculations and Formulas ·
Filters ·
Prompts ·
Crosstabs, Charts, Maps, etc. ·
Objects and Structure
·
Nesting Objects ·
Master-Detail Relationships ·
Conditional Formatting ·
Drill Through ·
Drill Down
Query Studio: ·
Simple queries
·
Insert Data Menu ·
Edit Data Menu ·
Change Layout Menu ·
Run Report Menu ·
Manage File Menu ·
Automatic Aggregation ·
Sorting
·
Grouping
·
Calculations ·
Filters ·
Totals/Summaries ·
Formatting ·
Charts ·
Pivots ·
Custom grouping Analysis Studio: ·
Basic navigation ·
Drill up/down
·
Context Explorer ·
Nesting ·
Noding ·
Context Filtering ·
Traditional filters ·
Button Survey Top N Swap Rows / Columns Suppress Zeroes Sorting Aggregate Display options ·
Calculations ·
Custom Subsets ·
Menus ·
Saving Reports Framework Manager: ·
Databases, SQL, Joins
·
FM Windows
·
Object Survey
·
Database Connections ·
New Framework Wizard ·
Relationships (Joins) ·
Aliasing query items ·
New Framework Manual ·
Copying vs. Shortcutting vs. New Query Items ·
Publishing Packages ·
Developer / Business Views ·
Dimensional Hierarchies ·
Star Schemas ·
Cube Datasources / Modeling a Cube / Publishing a Cube
Special Topics in
Reporting (Advanced; assumes
immersion in Report Studio): ·
Key Formulas ·
Data transformation techniques Most recent record in transactional data Transactional to columnar approach Dynamic sorting / grouping Top N Advanced Sorting ·
Prompt page creation flow ·
Page Sets ·
Summary Only report techniques Box Type Formula ·
Conditional display of objects ·
Layout Component References ·
Hyperlinks / Images / HTML / Tooltips ·
Bookmarks / Table of Contents ·
Database Fundamentals SQL Joins Cross Products ·
Query Management Pass Through Queries Join Queries Join Queries Outer Joins Union Queries Modeling Unions - Fake Double Outer Join Manual SQL ·
Report Specifications ·
Viewing SQL Code ·
Help / F1 ·
Errors and Troubleshooting Dimensional
Reporting:
What
is OLAP / Dimensionally Modeled data?
Tools
for Dimensional Reporting
Analysis
Studio
Query
Studio
Report
Studio
Dimensions,
Levels, Hierarchies and Members
Dimensional
vs. Relational reporting
Dimensional
Report Design
Calculations Traditional Functions Dimensional Functions Family Functions
Filters
/ Slicers
Tree
Prompts
Context
Page
breaks
Report
Templates
Transformer/PowerPlay ·
Drill-down / Dimension Viewer / Dimension Line / Measures
/ Nesting ·
Business Requirements and Definitions ·
Model Plans ·
Transformer Application Survey ·
Connecting to Data Sources - Wizard ·
Connecting to Data Sources - Manual ·
Levels, Dimensions and Hierarchies ·
Categories ·
Alternate Drill Paths ·
Category Viewer ·
Special Categories ·
Date Dimensions ·
Manual modification of Levels, Dimensions and Hierarchies ·
Relative and Non-standard Time ·
Multiple Data Sources ·
Scope and Association ·
Measures ·
Allocation ·
Sub-dimensions ·
Cube Customization ·
Cube Groups ·
Drill Through PowerPlay ·
Drill-down ·
Dimension Viewer ·
Measures ·
Nesting ·
Different Display Views ·
Button Survey (Sort, Swap, Rank, Supress Zeroes, 80/20) ·
Format Options ·
Calculations ·
Explorer ίΰ
Reporter modes ·
Custom groups Cognos Connection
Portal - User: ·
Navigating the portal ·
Running reports ·
Report properties ·
Scheduling Reports ·
Report Output Types ·
Folder creation ·
Other modules/functionality Cognos Connection
Portal Admin: ·
Detailed Cognos System architecture overview ·
Directory setting up security ·
Directory setting up database connections ·
Directory contact lists ·
Directory printers ·
Drill-through definitions ·
Portal Administration ·
Capabilities ·
Schedule Management ·
Server Administration ·
Content Administration (Import
/ Export report migration) ·
Logging ·
Portal Pages ·
Common troubleshooting tips ·
Security configuration (as appropriate) ·
Hardware, software and network topologies (as
appropriate) ·
Dataflows, memory, processing and communication bandwidth
implications (as appropriate) ·
Recommended maintenance
(as appropriate) ·
Page creation (as appropriate)
|
|||
 |
|||
| Home | More Info | ||
|
|||