What will you learn in Data Visualization and Dashboards with Excel and Cognos Course
Create effective data visualizations using Excel and IBM Cognos Analytics.
Understand visualization best practices and how to choose the right chart type.
Develop dashboards for communicating insights to stakeholders.
Use storytelling techniques to present data in compelling, impactful ways.
Program Overview
Module 1: Introduction to Data Visualization
⏱️ 1 week
Topics: Importance of visualization, chart types, design principles
Hands-on: Analyze bad vs good visualizations and select the right chart types
Module 2: Creating Visuals with Excel
⏱️ 1 week
Topics: Excel charting tools, formatting, conditional formatting, pivot charts
Hands-on: Build interactive charts and visuals using Excel datasets
Module 3: Building Dashboards in Excel
⏱️ 1 week
Topics: Dashboard design, layout, filters, slicers
Hands-on: Create a functional Excel dashboard with multiple views
Module 4: Introduction to IBM Cognos Analytics
⏱️ 1 week
Topics: Cognos interface, creating visualizations, uploading data
Hands-on: Build a dashboard using IBM Cognos Analytics platform
Module 5: Telling Stories with Data
⏱️ 1 week
Topics: Data narrative, insight communication, storytelling best practices
Hands-on: Prepare a dashboard report that communicates a clear insight story
Get certificate
Job Outlook
Data visualization skills are in high demand across roles in business analysis, marketing, finance, and data science.
Proficiency in Excel and BI tools like Cognos is highly sought after.
Entry-level roles like Business Analyst, Data Analyst, or Reporting Specialist offer salaries ranging from $60K–$100K+.
Visualization capabilities are essential for managerial and data storytelling roles.
Specification: Data Visualization and Dashboards with Excel and Cognos
|
