Course Description
Dimensional Authoring Fundamentals with IBM Cognos Report Studio is a two-day, instructor-led course. Students will create dynamic reports against multidimensional data sources such as PowerCubes by leveraging best practices with Report Studio. Students will be exposed to multidimensional expressions, functions and prompting techniques.
This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student’s computer screen and offer guidance. A full set of course materials is included and hard copies are sent prior to the class.
Course Outcomes
- To provide an Introduction to Business Intelligence/Analytics.
- To be able to describe the relationship between BI/BA and the associated Cognos studio.
- To provide an Introduction to the Cognos10 (c10) toolset.
- To provide an overview of Report Studio
- To develop a range of skills within Report Studio that will enable the user to create/author reports
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Course Modules
- Discuss and provide an overview of Business Analytics.
- Overview of Cognos 10, covering Cognos Connection, common studio’s and Framework Manager
- Introduction to the Report Studio interface and overview of workshops.
- Utilising and discussing various methods that can be used whilst building your reports.
- Creation of basic reports, introduction to lists, crosstabs and charts within Report Studio.
- Using insertable objects in your report and usage of various tools from within the toolbox. Creation of calculations and review of aggregation methods such as total, average, max, min…etc
- Grouping and sorting your data.
- Utilising dimensional functions to assist with report development against a dimensional data source.
- Creating hard coded and parameterised filters and the creation of prompts and prompt pages.
- Setting up variables, general formatting and conditional formatting.
- Utilising and discussing various methods that can be used whilst building your reports.
- Creation of queries, sql/mdx overview and understanding queries.
- Creation of Profit & Loss/Balance Sheet/Cash Flow report in Report Studio.
- Course Review and Feedback.
- Recap – Q/A and course review/feedback.
Testimonials
The trainers clear and obvious enthusiasm for number crunching, analytics, and teaching others is infectious. He doesn’t waste time, shows exactly what you need to know and is genuinely hilarious.
Every one of my employees had tons of positive stuff to say.
- Benjamin G, MXSG Analysis and Integration Chief, US Air Force
Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.
- Chris, Cirrus Aircraft
Without a doubt one of the best professional development courses I’ve taken. I would highly recommend.
- Blaine Clark, KPERS
