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): ·
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 Special Topics in
Reporting: ·
Key Formulas ·
Data transformation techniques Most recent record in transactional data Transactional to columnar approach Dynamic sorting / grouping Top N ·
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 ·
Report Specfications ·
Viewing SQL Code ·
Help / F1 ·
Database Fundamentals SQL Joins Cross Products ·
Join Queries History (two rows) ·
Join Queries Outer Joins ·
Unions Queries ·
Modeling Unions - Fake Double Outer Join ·
OLAP / Cubes ·
Drill Down ·
Slicers Dimensional
Reporting:
What
is OLAP / Dimensionally Modelled data?
Tools
for Dimensional Reporting
Analysis
Studio
Query
Studio
Report
Studio
Dimensional
vs. Relational reporting
Calculations
Filters
/ Slicers
Tree
Prompts 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 | ||
|
|||