Complete Cognos Training Course for a Dream IT Job

Complete Cognos Training Course for a Dream IT Job, available at $79.99, has an average rating of 4.34, with 52 lectures, based on 789 reviews, and has 12042 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful 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.

Enroll now: Complete Cognos Training Course for a Dream IT Job

Summary

Title: Complete Cognos Training Course for a Dream IT Job

Price: $79.99

Average Rating: 4.34

Number of Lectures: 52

Number of Published Lectures: 52

Number of Curriculum Items: 52

Number of Published Curriculum Objects: 52

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

IBM Cognosis 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Syllabus Outline

Chapter 2: SQL Server 2019 Download, Installation and Configuration

Lecture 1: Download SQL Server 2019

Lecture 2: SQL Server 2019 Installation

Lecture 3: SQL Server Management Studio Download

Lecture 4: SQL Server Management Studio Installation

Lecture 5: Add/Restore Sample Database

Lecture 6: SQL Server Management Studio Configuration

Lecture 7: Test Database Connectivity

Lecture 8: SQL Server Lab

Chapter 3: IBM Cognos BI Server Installation

Lecture 1: IBM Cognos Software Usage and Guidelines

Lecture 2: Cognos BI Server Installatioin

Chapter 4: Cognos Framework Manager Installation, Configuration and Use/Development

Lecture 1: Introduction to Framework Manager

Lecture 2: Framework Manager Installation

Lecture 3: Framework Manager Configuration

Lecture 4: Launch Framework Manager, Create a Model & Data Source Connection

Lecture 5: Import Metadata & Folder Structure

Lecture 6: Relationships & Cardinalities, Create & Publish Package

Chapter 5: Cognos Connection

Lecture 1: Introduction

Lecture 2: Cognos Connection Interface Deep Dive

Chapter 6: Report Studio

Lecture 1: Introduction to Report Studio

Lecture 2: Exciting World of Report Development

Lecture 3: Lets Create Reports

Lecture 4: Report Formatting – How to Improve Look-n-Feel or Reports

Lecture 5: Data Sorting

Lecture 6: Grouping & Sectioning

Lecture 7: Calculations

Lecture 8: Report Studio Deep Dive

Lecture 9: Filters

Lecture 10: Cross Tab Reporting

Lecture 11: Visualization/Charting

Lecture 12: Prompts: Text Box Prompts

Lecture 13: Prompts: Value Prompts

Lecture 14: Prompts: Select & Search Prompts

Lecture 15: Prompts: Date Prompts

Lecture 16: Prompts: Cascading Prompts

Lecture 17: Date related Functions

Lecture 18: Arithmetic Functions

Lecture 19: Additional Useful Functions

Lecture 20: Master Detail Reports

Lecture 21: Drill-Through Reporting

Lecture 22: Report Bursting

Lecture 23: Complex Reporting

Lecture 24: Query Joins

Lecture 25: Unions

Chapter 7: Administration

Lecture 1: Introduction

Lecture 2: Security

Lecture 3: Data Source Connections

Chapter 8: Job Search & Next Steps

Lecture 1: Landing a Job – Resume

Lecture 2: Resume Must Haves!

Lecture 3: Job Search

Lecture 4: Job Applications and Follow Ups

Instructors

Faran Khan
Business Intelligence Architect

Rating Distribution

1 stars: 20 votes

2 stars: 15 votes

3 stars: 70 votes

4 stars: 279 votes

5 stars: 406 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!