Cognos consultant vs bi consultant

The differences between cognos consultants and bi consultants can be seen in a few details. Each job has different responsibilities and duties. It typically takes 4-6 years to become both a cognos consultant and a bi consultant. Additionally, a bi consultant has an average salary of $96,297, which is higher than the $91,980 average annual salary of a cognos consultant.

The top three skills for a cognos consultant include dashboards, data warehouse and sql server. The most important skills for a bi consultant are dashboards, power bi, and analytics.

Cognos consultant vs bi consultant overview

	Cognos Consultant	BI Consultant
Yearly salary	$91,980	$96,297
Hourly rate	$44.22	$46.30
Growth rate	9%	9%
Number of jobs	33,277	35,224
Job satisfaction	-	-
Most common degree	Bachelor's Degree, 67%	Bachelor's Degree, 64%
Average age	43	43
Years of experience	6	6

Cognos consultant vs bi consultant salary

Cognos consultants and bi consultants have different pay scales, as shown below.

	Cognos Consultant	BI Consultant
Average salary	$91,980	$96,297
Salary range	Between $73,000 And $115,000	Between $74,000 And $125,000
Highest paying City	Portland, OR	San Francisco, CA
Highest paying state	California	Nevada
Best paying company	The News-Review	Slalom
Best paying industry	Finance	Retail

Differences between cognos consultant and bi consultant education

There are a few differences between a cognos consultant and a bi consultant in terms of educational background:

	Cognos Consultant	BI Consultant
Most common degree	Bachelor's Degree, 67%	Bachelor's Degree, 64%
Most common major	Computer Science	Computer Science
Most common college	Massachusetts Institute of Technology	-

Cognos consultant vs bi consultant demographics

Here are the differences between cognos consultants' and bi consultants' demographics:

	Cognos Consultant	BI Consultant
Average age	43	43
Gender ratio	Male, 72.9% Female, 27.1%	Male, 77.6% Female, 22.4%
Race ratio	Black or African American, 8.4% Unknown, 4.9% Hispanic or Latino, 9.6% Asian, 25.3% White, 51.6% American Indian and Alaska Native, 0.2%	Black or African American, 8.4% Unknown, 4.9% Hispanic or Latino, 9.5% Asian, 25.0% White, 51.9% American Indian and Alaska Native, 0.2%
LGBT Percentage	8%	8%

Differences between cognos consultant and bi consultant duties and responsibilities

Cognos consultant example responsibilities.

Manage SSIS jobs for weekly and monthly refresh.
Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
Implement different techniques in DMR cubes development to improve performance on OLAP databases.
Develop, test and maintain ETL procedures employing both ETL tools and custom PL/SQL.
Develop packages and collections using PL/SQL.
Experience in writing shell scripts in Unix.

Bi consultant example responsibilities.

Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
Update existing mapping documents and ETL metadata repository.
Create reports using IDT from more than one data source.
Optimize existing OLAP databases by reducing number of dimensions, attribute hierarchies and calculations, develop SSAS actions and security layer.
Develop different reporting and visualization solutions by utilizing SSRS and PowerView.
Deploy and design cube in SSAS environment incorporating dimensional star schema design.

Cognos consultant vs bi consultant skills

Common cognos consultant skills

Dashboards, 11%
Data Warehouse, 9%
SQL Server, 6%
Drill-Through, 6%
Cognos BI, 5%
Windows XP, 5%

Common bi consultant skills

Dashboards, 12%
Power Bi, 8%
Analytics, 8%
SQL Server, 7%
ETL, 5%
Visualization, 4%