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.
Offered By
IBMAbout this Course
181,064 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
What you will learn
Basic Excel features to create charts and pivot charts
The important role charts play in telling a data-driven story
About creating advanced charts and visualizations
About the basics of dashboarding
Skills you will gain
- Microsoft Excel
- Data Analysis
- Data Visualization (DataViz)
- IBM Cognos Analytics
- Dashboard
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Beginner Level
Basic familiarity with using spreadsheet software like Excel.
Approx. 9 hours to complete
English
Subtitles: Arabic, French, Portuguese (European), Vietnamese, Russian, English, Spanish
Offered by
IBM
IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.
Syllabus - What you will learn from this course
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
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
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
2 hours to complete
Final Project
Congratulations! You have now completed the modules for this course. In this module, 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
Reviews
TOP REVIEWS FROM DATA VISUALIZATION AND DASHBOARDS WITH EXCEL AND COGNOS
by AOApr 9, 2021
As an aspiring data analyst, this course gave me more information about what I am currently doing and after finishing this course I have learned a lot and gave me more interest to learn more.
by BFJan 20, 2022
Familiarity with the powerful Cognus program was very good. If you continue this course, good things will surely happen to you. This was the third course I took and it was really great
by ATAug 13, 2021
This course was not easy, I have never used IBM Cognos before. I was nervous logging into it and making sure I am doing it right. I end up using 2 monitors to see what I am doing.
by GFSep 12, 2021
i was impressed by cognos and in general the way you get into things with this course. i really like the approach methodology. final assignment was very interesting also.
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Certificate?
More questions? Visit the Learner Help Center.
