COURSE OBJECTIVE:
After completing this course, learners should be able to: • Describe the data modeling workflow, including identifying sources, enriching the module, and testing it. • Navigate the Cognos Analytics v12 Data Modules user interface and upload a source file. • Demonstrate how to create, edit, and optimize relationships in Cognos Analytics v12, including utilizing the Null Safe option and configuring cardinality for accurate data integration. • Organize data modules by hiding, renaming, or removing fields. • Use SQL to create a new table by writing and validating a custom query. • Configure custom sorting for a specified column and validate its application in reports or dashboards. • Utilize the Enhanced Expression Editor to create a custom calculation combining fields from two tables. • Design a navigation path and validate functionality in dashboards. • Configure row-level security filters, assign permissions, and utilize security definitions. • Configure advanced data module functionalities, including column dependencies, bridge tables, and summary tables. • And more
TARGET AUDIENCE:
This course is intended for data professionals, business analysts, and technical users who are involved in data preparation, reporting, and business intelligence within their organization.
COURSE PREREQUISITES:
Participants should have the following skills: • An understanding of your organization's business intelligence process and reporting needs • Experience using basic Windows functionality • An understanding of Cognos reporting
COURSE CONTENT:
• Course Introduction • Unit 1: Data Modeling in Cognos Analytics v12 • Unit 2: Creating Data Modules • Unit 3: Managing Relationships • Unit 4: Reviewing and Organizing Data Modules • Unit 5: Advanced Features and Performance Optimization • Unit 6: Customizing Data Modules with Filters and Calculations • Unit 7: Grouping Data and Creating Navigation Paths • Unit 8: Organizing and Sharing Data Modules • Unit 9: Advanced Functionality in Data Modules
FOLLOW ON COURSES:
Not available. Please contact.