Offered By

IBM

About this Course

188,731 recent views

This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel. Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data. Continue to gain valuable experience by becoming familiar with the popular analytics tool - IBM Cognos Analytics - to create interactive dashboards.
By completing this course, you will have a basic understanding of using spreadsheets as a data visualization tool. You will gain the ability to effectively create data visualizations, such as charts or graphs, and will begin to see how they play a key role in communicating your data analysis findings. All of this can be accomplished by learning the basics of data analysis with Excel and IBM Cognos Analytics, without having to write any code. By the end of this course you will be able to describe common dashboarding tools used by a data analyst, design and create a dashboard in a cloud platform, and begin to elevate your confidence level in creating intermediate level data visualizations. 

Throughout this course you will encounter numerous hands-on labs and a final project. With each lab, gain hands-on experience with creating basic and advanced charts, then continue through the course and begin creating dashboards with spreadsheets and IBM Cognos Analytics. You will then end this course by creating a set of data visualizations with IBM Cognos Analytics and creating an interactive dashboard that can be shared with peers, professional communities or prospective employers.

This course does not require any prior data analysis, or computer science experience. All you need to get started is basic computer literacy, high school level math, access to a modern web browser such as Chrome or Firefox, the ability to create a Microsoft account to access Excel for the Web, and a basic understanding of Excel spreadsheets.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Basic familiarity with using spreadsheet software like Excel.

Approx. 10 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

Skills you will gain

Microsoft ExcelData AnalysisData Visualization (DataViz)IBM Cognos AnalyticsDashboard

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Basic familiarity with using spreadsheet software like Excel.

Approx. 10 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

Instructors

Instructor rating

4.63/5 (55 Ratings)

Offered by

IBM

IBM offers a wide range of technology and consulting services; a broad portfolio of middleware for collaboration, predictive analytics, software development and systems management; and the world's most advanced servers and supercomputers. Utilizing its business consulting, technology and R&D expertise, IBM helps clients become "smarter" as the planet becomes more digitally interconnected. IBM invests more than $6 billion a year in R&D, just completing its 21st year of patent leadership. IBM Research has received recognition beyond any commercial technology research organization and is home to 5 Nobel Laureates, 9 US National Medals of Technology, 5 US National Medals of Science, 6 Turing Awards, and 10 Inductees in US Inventors Hall of Fame.

Syllabus - What you will learn from this course

Week

Week 1

2 hours to complete

Visualizing Data Using Spreadsheets

In this module, you will be introduced to the basics of charts and the Excel functions that are used to create basic charts and pivot chart visualizations. By learning how to manipulate these features and creating visualizations, you will begin to understand the important role charts play in telling a data-driven story.

2 hours to complete

5 videos (Total 24 min), 2 readings, 2 quizzes

5 videos

Course Intro Video3m

Introduction to Charts4m

Interview: Using Visualizations to Tell a Data Story3m

Creating Basic Charts in Excel (Line, Pie, and Bar Charts)5m

Using the Excel PivotChart Feature 6m

2 readings

Optional Hands-on Labs40m

Summary and Highlights10m

2 practice exercises

Practice Quiz15m

Graded Quiz 20m

Week

Week 2

2 hours to complete

Creating Visualizations and Dashboards with Spreadsheets

In this module, you will learn about creating advanced charts and visualizations and learn about the basics of dashboarding and how to create a simple dashboard using a spreadsheet.

2 hours to complete

5 videos (Total 31 min), 2 readings, 4 quizzes

5 videos

Creating Treemaps, Scatter Charts, and Histograms7m

Creating Filled Map Charts and Sparklines 6m

Introduction to Dashboarding3m

Creating a Simple Dashboard using Excel7m

Interview: Using Dashboards to Present Data Results5m

2 readings

Summary and Highlights10m

4 practice exercises

Practice Quiz10m

Graded Quiz 15m

Practice Quiz8m

Graded Quiz 10m

Week

Week 3

3 hours to complete

Creating Visualizations and Dashboards with Cognos Analytics

In this module, you will be introduced to another dashboarding solution called Cognos Analytics. After registering with Cognos Analytics, you will then explore the platform capabilities by creating visualizations, building a simple dashboard, and discovering its advanced features.

3 hours to complete

4 videos (Total 13 min), 1 reading, 2 quizzes

4 videos

Cognos Analytics: Introduction and How to Sign Up1m

Navigating in Cognos Analytics3m

Creating a Simple Dashboard in Cognos4m

Advanced Capabilities in Cognos Analytics Dashboards3m

1 reading

Summary and Highlights10m

2 practice exercises

Practice Quiz15m

Graded Quiz 15m

Week

Week 4

2 hours to complete

Final Project

Congratulations! You have now completed the modules for this course. This week, you will complete the final assignment that will be graded by your peers. In the first part of the final assignment, you will use provided sample data to create some visualizations using Excel for the web. In the second part of the final assignment, you will create some visualizations and add them to a dashboard using Cognos Analytics.

2 hours to complete

2 readings

2 readings

Congratulations and Next Steps10m

Course Credits and Acknowledgements1m

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Data Visualization and Dashboards with Excel and Cognos