At a Glance

Name: Visualizing Data with Excel Spreadsheets & Cognos Dashboards
Price: Free CAD
Rating: 4.9 (20 reviews)
Author: sandip_saha_joy, skills_network_team, stephen_ryan

Build in-demand data visualization skills employers need using Excel and IBM Cognos Analytics... without writing a single line of code!

According to Harvard Business School, data visualization is among the top five essential skills for data science. Data professionals, data analysts, and data scientists who can use Excel and Cognos for data visualization are in demand! This course gives you the essential data visualization skills in these applications you need to catch an employer's eye in just 4 weeks.

During this course, you’ll learn how to unlock the power of data visualization using Excel and IBM Cognos Analytics. You’ll learn how to create stunning dashboards and tell compelling data stories without writing a single line of code.

You’ll look at:

How to create basic charts in Excel:
Line charts
Pie charts
Bar charts
How to create advanced visualizations with:
Treemaps
Scatter charts
Histograms
Filled map charts
Sparklines
How to use Excel's PivotChart feature
How to bring multiple visualizations together in an interactive Excel dashboard.

You’ll then discover the capabilities of business intelligence (BI) tools like Cognos Analytics and learn how they’re used to craft interactive dashboards that bring your data to life.

Additionally, throughout the course, you’ll get lots of hands-on practice and build a portfolio of data visualizations and interactive dashboards that showcase your skills. By the end, you’ll then have job-ready skills in using Excel and Cognos for data analysis you can talk about in interviews.

If you want to build essential skills in Excel and Cognos that businesses are looking for, enroll now and get ready to add new competencies to your resume!

Course Syllabus

Module 1: Visualizing Data Using Spreadsheets
Module 2: Creating Visualizations and Dashboards with Spreadsheets
Module 3: Creating Visualizations and Dashboards with Cognos Analytics
Module 4: Final Project

Learning Objectives

Use Excel features to create charts and pivot charts
Create advanced charts and visualizations
Create visualizations in Cognos Analytics
Build an interactive dashboard

Prerequisites

This is a beginner-friendly introduction to data analysis, therefore no prior programming experience is necessary. However, basic knowledge of using a computer, navigating files and folders, and using basic software applications is recommended.

Offered By: IBMSkillsNetwork

Visualizing Data with Excel Spreadsheets & Cognos Dashboards

At a Glance

Course Syllabus

Learning Objectives

Prerequisites

This is part of the following learning path

Offered By: IBMSkillsNetwork

Visualizing Data with Excel Spreadsheets & Cognos Dashboards

At a Glance

Course Syllabus

Learning Objectives

Prerequisites

This is part of the following learning path

Stay Ahead in AI – Subscribe to Our Newsletter