Back to Catalog

Visualizing Data with Excel Spreadsheets & Cognos Dashboards

Premium
Beginnercourse

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

Language

  • English

Topic

  • Data Visualization

Industries

  • Data Visualiation

Skills You Will Learn

  • Microsoft Excel, Data Visualization, Data Analysis, IBM Cognos, Spreadsheet, Business Intelligence

Offered By

  • IBMSkillsNetwork

Estimated Effort

  • 4 weeks

Platform

  • SkillsNetwork

Last Update

  • December 6, 2024
About this course
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.   

Instructors

Sandip Saha Joy

Cognitive Data Scientist

An aspiring data scientist who enjoys connecting the dots: be it ideas from different disciplines, people from different teams, or applications from different industries. Have an academic background in computing science and strong technical skills in computer vision, machine learning and data science.

Read more

IBM Skills Network Team

Administrator

IBM Skills Network

Read more

Stephen Ryan

Instructional Designer - SkillUp Technologies

I am an ex-Microsoft Certified Trainer and Systems Engineer who now spends his time providing learning content for online learning platforms. My background is in TCP/IP networks and client and server network operating systems.

Read more