Complete Cognos Training Course for a Dream IT Job
What you'll learn
- This course is designed to make you an expert Report Developer. You will be able to accomplish following with ease:
- Create Sophisticated Single and Multi-Dimensional Reports
- Dash-boarding and Amazing Charts
- Report Formatting, Prompts & Filters
- Master Detail and Drill-Through Reporting
- Conditional Statements
- Data Modeling and packages
- SQL Queries
- Install, Configure and Use IBM Cognos Server and Framework Manager
- Install, Configure and Use SQL Server Management Studio
Requirements
- Willingness to Learn Business Intelligence Technology
Description
IBM Cognos is one of the largest and successful business intelligence software used for report development. If you want to start your career in Business Intelligence and have little or no knowledge of reporting or Technology, then I can help. In this course you will learn everything from installing a database to creating reports and all that goes between these two points. I have also included a module on successfully finding a Cognos Business Intelligence Job which will definitely help you to get to your dream IT job.
I have been teaching Cognos in a classroom environment in New York City for the past 10 years. It is important to note that close to 90% of my students got jobs and are enjoying their successful careers in Business Intelligence. Over 75% of these student had zero prior knowledge of Cognos or IT except Internet surfing. I want you to imagine yourself in that role – It will be a great journey indeed.
Please note that this course does not offer free Cognos software as it's sale is managed by IBM/Cognos. Cognos Analytics trial version, for report development purposes, is available at IBM site.
Following is the list of topics I will cover in this course
Module 0 – Introduction to Cognos
· What is Cognos and It’s use
· A Brief History of the Company
· Business Intelligence Market Place and Key Players/Software
· How they compare against Cognos
· Future Growth outlook of Business Intelligence
Module 1 – Microsoft SQL Server 2019
· Download and Install SQL Server 2019
· Download and Install SQL Server Management Studio
· Configuration
· Writing SQL Queries
· Restoring Database
· Creating New Database
Module 2 – Cognos Installation
· Installation
· Server Configuration
· Log files
· Content-store Configuration
· Running Cognos Service
Module 3 – Cognos Framework Manager
· Installation & Configuration
· Data Source Connections
· Import Metadata
· Table Relationships
· Name Spaces
· Query Subjects & Items
· Function & Calculations
· Create & Publish Package
Module 4 – Cognos Connection
· Introduction
· Interface Deep-Dive
Module 5 – Cognos Report Studio
· Create Simple Reports
· Multi-Dimensional Reporting
· Charting
· Report Formatting
· Function & Calculated measures
· Master Detail Reporting
· Drill-Through Reporting
· Prompts & Filters
· Conditional Statements
· Parameters
· Dash-boarding
Module 5 – Cognos Administration
· Introduction
· Management
· Security
· Data Sources
· More
Module 6 – Landing your Dream Job
· Resume
. Resume Must Haves!
· Where to Look
· What to Look
· Applying & Follow up
· Next Steps
Who this course is for:
- Anyone interested in business intelligence and data analytics without having programming background including professionals in Management business, Finance, and marketing. Also People with legacy technical skills who want to learn new technology. Additionally, College students who want a career in IT, but did not take IT classes during school years. - Any individual who wants to get an IT job with little to no IT experience.
Instructor
- 4.5 Instructor Rating
- 881 Reviews
- 16,381 Students
- 2 Courses
A senior executive with more than twenty five years of broad-based management experience in Business Intelligence (IBM Cognos, SAP BO, MS PowerBI), Enterprise Information Integration (EII), Quality Assurance and process re-engineering. He has developed and delivered very complex technical architectures to financial firms across USA including large Banks, Brokerage Houses and Insurance Companies. He has Travelled across Americas to ensure clients are satisfied with their Cognos deployments. He has trained client employees on Cognos via in-class room as well as online sessions.
Mr Khan earned his MBA in Finance from Pace University of New York and BBA in Computer Information Systems from City University of New York. He started his professional career in IT from Deutsche Bank (New York) in 1996. He has been teaching Cognos in New York Metropolitan area for the past 12 years with high degree of success – Over 90% of his students are enjoying successful careers in Business Intelligence.