- Home
- Courses
- Business Intelligence
- IBM Cognos
IBM Cognos Training and Certification Course In Pune
Duration of course: 40 hrs
Best Blended Syllabus for IBM Cognos Training in Pune by a 100% Placement-Oriented Training Institute
Instructor-led IBM Cognos Live Online Training
Don't Wait for IT!
Let's Build a Great Career in IT!
Our Candidate's Placement Record!
Book Your Seat Now ! At just ₹5000!
No Cost Two Easy Installments!
Can’t find a batch you were looking for?
IBM Cognos Course
Best Blended Syllabus for IBM Cognos Training in Pune by a 100% Placement-Oriented Training Institute
- Introduction to data warehousing
- Difference Between OLTP Vs OLAP
- What dimensional modeling ?
- What is dimension ?
- What is fact ?
- Types of schemas in data warehousing
- Star Schema
- Snow flake Schema
- Hybrid Schema
- Slowly changing dimension
- Types of Slowly Changing dimensions
- SCD I
- SCD I
- SCD III
- What is confirmed dimensions ?
- Fact less fact table and types of Facts
- Overview of IBM Cognos BI
- Describe IBM Cognos 10 BI Components
- Describe IBM Cognos 10 BI Architecture at a high level
- Define IBM Cognos 10 Groups and Roles
- Gather requirements
- Examine key modeling recommendations
- Define reporting requirements
- Explore data sources to identify data access strategies
- Create a baseline project
- Examine the IBM Cognos 10 and Framework Manager work flow processes
- Define a project and its structure
- Describe the Framework Manager Environment
- Create a baseline project
- Enhance the model with additional metadata
- Prepare reusable metadata
- Verify the relationships and query item properties
- Identify Reporting Issues
- Describe multi-fact queries and full outer joins are appropriate
- Describe how IBM Cognos 10 uses cardinality
- Identify reporting traps
- Use tools to analyze the model
- Virtual Star Schemas
- Identify the advantages of modeling metadata as a star schema
- Model in layers
- Create aliases to avoid ambiguous joins
- Merge the query subjects to create as view behaviour
- Consolidate metadata
- Create virtual facts to simplify writing queries
- Create a virtual dimensions to resolve fact-to-fact joins
- Create a consolidated modeling layer for presentation purposes
- Consolidate snowflake dimensions with model query subjects
- Simplify facts by hiding unnecessary codes
- Calculations & Filters
- Use calculations to create commonly needed query items for authors
- Use static filters to reduce the data returned
- Use macros and parameters in calculations and filters to dynamically control the data returned
- Implement a time dimension
- Make time based queries simple to author by implementing a time dimension
- Resolve confusion caused by multiple relationships between a time dimension and another table
- Specify Determinants
- Use determinants to specify multiple levels of granularity and prevent double counting
- Create the presentation view
- Identify the dimensions associated with a fact table
- Identify Conformed Vs non conformed dimensions
- Create a star schema groupings to provide authors with logical groupings of query subjects
- Rapidly create a model using the Model Design Accelerator
- Introduction to reporting application
- Examine report studio and its interface
- Explore report types
- Create a simple , sorted, and formatted report
- Explore how data items are added to queries
- Create List reports
- Format, group, and sort list reports
- Describe options for aggregating data
- Create a multi fact query
- Create a report with repeated data
- Focus reports Using Filters
- Create filters to narrow the focus of reports
- Examine detail and summary filters
- Determine when to apply filters on aggregate data
- Create crosstab reports
- Format and sort crosstab reports
- Convert a list to a crosstab
- Create a complex crosstabs using drag and drop functionality
- Create crosstabs using unrelated data items
- Present data graphically
- Create charts containing peer and nested columns
- Present data using new chart type options
- Add context to charts
- Create and reuse custom chart palettes
- Present key data in a single dashboard report
- Focuses reports using prompts
- Identify various prompt types
- Use parameters and prompts to focus data
- Search for prompt types
- Customize prompts to facilitate users choices
- Navigate between pages
- Display users prompt selections in the report
- Implement casting prompts
- Extend reports using Calculations
- Create calculations based on data in the data source
- Add runtime information to the reports
- Create expressions using functions
- Discusses report templates
- Add pages to a report
- Display users prompt selections in the report
- Choose options to handle reports with no available data
- Drill through from one report to another
- Let users navigate from a specific report to a target report
- Pass parameter values to filter the data in drill through targets
- Implement Master Detail relationship
- Analysis studio fundaments
- Define the fundamental terms of analysis studio
- Explain how to insert objects
- Define & create sets
- Identify the work area, overview area, and properties pane
- Tools for investigation in analysis studio
- Employ drilling down and up to different levels of detail
- Apply changes to rows, columns, and measures in the analysis
- Explain how to change the display of data
- Use charts to display data graphically
- Nest data in crosstabs in analysis studio
- Apply depth to rows and columns by nesting data
- Recognize drill behavior in nested rows and columns
- Demonstrate how to swap nested levels
- Build advanced crosstabs in analysis studio
- Demonstrate how to view a complete level of data
- Design a crosstab without retrieving data
- Compare multiple measures
- Apply stacked sets to the crosstab
- Construct an asymmetrical crosstab
- Compose a custom sort
- Focus with filters in analysis studio
- Apply filters using expressions
- Apply filters using context area
- Create top and bottom lists
- Use several techniques to remove rows and columns
- Extend the analysis
- Apply summary calculations measures
- Apply item based calculations
- Practice ranking items
- Demonstrate how to customize the report display
- Introduction to query studio
- Examine query studio
- Open adhoc reports
- Add data to adhoc reports
- Create a report with repeated data
- Examine report types
- Examine charting
- Create reports in query studio
- Create list, grouped list, and crosstab reportso
- Use prompts to specify filter criteria
- Create custom groups
- Format data
- Calculate and sort report data
- Explore and modify reports in query studio
- Run a report in query studio
- Explore run options
- Render reports in HTML, PDF, and CSV format
- Format report elements
- Create report views
- View report outputs
- Explore, Navigate, and create dashboards
- Business Scenario
- What is business insight
- Examine Business Insight interface
- Dashboard content
- Define widgets
- Add report content to dashboard
- Examine Business Insight Advanced
- Business Scenario
- What is business insight advanced
- Explore the user interface
- Design the report layout
- View your data
- Define the report layout
- Create a report
- Business Scenario
- Goal of reporting
- List Report Example
- Crosstab Example
- Chart Report format
- Basic Chart Types
- Pie Chart Example
- Column Chart Example
- Scatter chart Example
- Financial Reports
- Combination Reports
- Same data with multiple business cases
- Create a calculation
- Calculation Example
- Introduction to transformer
- Purpose of transformer
- Difference b/w transformer model Vs Framework Manager Model
- Explore the transformer interface
- How to refresh the cube
- How to publish the cube in cognos connection
- Active Reports
- Introduction to Dash boarding
- Deck and Data Deck
- Static Prompts
- Dynamic Prompts
IBM Cognos Training Completion Certificate
We offer a variety of IBM Cognos Certifications based training
150+
Batches Completed
Industry Oriented Syllabus
Designed By Expert
2000+
Happy Students
Self Assessments
Quizzes, POC
8+
8+ Years Of Experience
Recorded Sessions
1 Year Of Access
Course Benefits
- Pay only after attending one FREE TRIAL OF RECORDED LESSON
- No prerequisite
- Course designed for non-IT as well as IT professionals
- Flexible batch switch is available
- Classroom & Online Training – Can switch from online training to classroom training with nominal fee
- 100% placement calls guaranteed till you get placed
- Working professional as instructor
- Hands-on Experience with Real-Time Projects.
- Proof of concept (POC) to demonstrate or self-evaluate the concept or theory taught by the instructor. 2 – Python POC, 5 – Data Science POC
- Hands-on Experience with Real-Time Projects
- Resume Building & Mock Interviews
- Evaluation after each Topic completion
- Interview Preparation Support
STAY TUNED WITH US
Let's begin a dialogue with our career concealer!
About Course
Training Projects
FAQ
Yes, you can attend demo session before you enroll either we can provide you the recorded lecture so that you can watch it as per your schedule or you can attend live demo lecture either online or offline
Yes, we do provide the placement assistance in which how we work on real time projects will be taught,resume preparation and Job openings will also be provided.More than 80% of candidates have changed their profile by getting either promotion or getting new job offers on good package.
Checkout our Telegram Channel for Placement Assistance (Open in Mobile Browser): https://t.me/technogeekssolutions
If you miss classes, you can get recording sessions of the lectures.